Search This Blog

2016-05-11

how-to install the IBM db2 express and the example IBM Cognos GS_DB

DB2 EXAMPLE DB INSTALLATION FOR COGNOS REPORTS

The example db for DB2 should be used in order to utilize the existing Cognos reports for demonstration purposes. This section describes the steps and tasks to be performed in order to install the DB2 product load the example db , export the data into data files and import then into existing nz db.
The following official documentation url has been used for the installation:
http://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.cmd.doc/doc/r0008889.html?lang=en

1. Installation and configuration of db2

This subsection describes the installation and configuration of a db2 intance on a separate Linux host, which is needed in order to load the data of the example data to be later on able to export it to the corresponded Netezza database.

1.1. Dowload the db2 binaries

Download the db2 binaries from the ibm site:
http://www.ibm.com/developerworks/downloads/im/db2/
v10.5_linuxx64_expc.tar.gz
v10.5_linuxx64_nlpack.tar.gz
# root@demo-nz1
mkdir -p /nzscratch/data/pckgs/ibm/db2

1.2. run the prerequisites checker script and install prerequisites

cd /var/pckgs/ibm/db2/expc
sh db2prereqcheck | less
apt-get install lib32stdc++6
apt-get install libpam0g:i386
apt-get install libaio1
sh db2prereqcheck | less
# DBT3533I  The db2prereqcheck utility has confirmed that all installation prerequisites were met.

1.3. configure the db2 response file

Change the following settings in the response file:
** file: /var/pckgs/ibm/db2/expc/db2/linuxamd64/samples/db2expc.rsp
CONFIG_ONLY              = YES ** YES or NO
DB2_INST.UID             = 0                ** Unsigned integer
DB2_INST.GID             = 0                 ** Unsigned integer
DB2_INST.FENCED_USERNAME  = root ** char(8)  no spaces, no upper case letters
DB2_INST.FENCED_GROUP_NAME =  root ** char(30)  no spaces
# eof file:/var/pckgs/ibm/db2/expc/db2/linuxamd64/samples/db2expc.rsp

1.4. apply the db2 license

#root@precise32

export license_file=/var/pckgs/ibm/db2/expc/db2/license/db2expc_uw.lic 
 /opt/ibm/db2/V10.5/adm/db2licm -a $license_file

# --- START STDOUT
LIC1402I  License added successfully.

LIC1426I  This product is now licensed for use as outlined in your License Agreement.  USE OF THE PRODUCT CONSTITUTES ACCEPTANCE OF THE TERMS OF THE IBM LICENSE AGREEMENT, LOCATED IN THE FOLLOWING DIRECTORY: "/opt/ibm/db2/V10.5/license/en_US.iso88591"


# --- STOP  STDOUT

1.5. Run the installation script for the db2

cd /var/pckgs/ibm/db2/expc/

sh db2setup -r /var/pckgs/ibm/db2/expc/db2/linuxamd64/samples/db2expc.rsp

1.6. how-to start and stop the db2 run-time

Use the following commads
# configure first your path
export PATH=$PATH:/opt/ibm/db2/V10.5/bin
export PATH=$PATH:/opt/ibm/db2/V10.5/adm/

db2start
db2stop

1.7. how-to run db2 commands

Use the following commads
# change the current user to the db2inst1 user
su - db2inst1
db2 ?

# to clear the screen
# db2
!clear

# how-to list the database directories
db2 list database directory

1.8. Try to create the sample database

Create the sample database to verify that a db creation could be performed
su - db2inst1

 db2sampl

 Creating database "SAMPLE"...
 Connecting to database "SAMPLE"...
 Creating tables and data in schema "DB2INST1"...

1.9. change the ownershiop of the installation dir

change the ownershiop of the installation dir because the Unix user db2inst1 should have full access to all the installation media
#change the ownershiop of the installation dir
chown -Rv db2inst1:db2iadm1 /var/pckgs/ibm

2. Load the example db2 db ddls and data

Run the loading script
db2inst1@precise32:/var/pckgs/ibm/db2/GS_DB/unix$ sh setupGSDB.sh
Starting script
Operating system : Linux

DB2 Version 9 or later detected - using DB2 Version 9 syntax
-------------------------------------------------------------------
Press Enter at the prompts to accept the default value shown
Default values can be specifed in the file GOSalesConfig.sh

2.1. Accept default values

Accept the default values when asked by the script ..
Please enter the name of the database ( or the alias ) to be used for the
-e GOSales sample data (default=GS_DB) :

-------------------------------------------------------------------
This script can create column-organized tables in GS_DB
using v. 10.5 or later.
-e Would you like to create column-organized tables? (Y/N) (Default=N) :

Enter the db2 administration username for creating the database
and importing the data.
If no value is provided, then the local
user will attempt to connect without a password.
-e Please enter the DB2 admin user name : db2inst1

-----------------------------------------------------------

Please confirm the following settings :

Database Name                 : GS_DB
Drop and Recreate database    : Y
Create a 32 K Bufferpool named : GOSALES_BP
Create a 32 K Tablespace named : GOSALES_TS
GOSALES   Grant users/groups  : GOSALES,db2inst1,PUBLIC
GOSALESDW Grant users/groups  : GOSALESDW,db2inst1,PUBLIC
Administration User name      : db2inst1

Import the sample data into the following schemas :
       GOSALES
       GOSALESHR
       GOSALESMR
       GOSALESRT
       GOSALESDW

============================

-----------------------------------------------------------

Please confirm the following settings :

Database Name                      : GS_DB
Column-organized tables            : N
Drop and Recreate database         : Y
DPF environment                    : Y
Create a 32 K Bufferpool named : GOSALES_BP
Create a 32 K Tablespace named : GOSALES_TS
Grant permissions on the GOSALES objects to   : GOSALES,db2inst1,PUBLIC
Grant permissions on the GOSALESDW objects to : GOSALESDW,db2inst1,PUBLIC
DB2 Administration User name  : db2inst1

Import the sample data into the following schemas :
       GOSALES
       GOSALESHR
       GOSALESMR
       GOSALESRT
       GOSALESDW

WARNING: If the database already exists it will be dropped

-e Continue creating the sample data with these settings? (Y/N) Default=Y :

Please wait ...

Starting GOSALES_RUN_SCRIPTS
Creating database

# ---- START STOUD
# OBS !!! provide the admin user name 
DB2 Administration User name  : db2inst1

# ---- START STOUD

+ [ 0 = 0 ]
+ echo Table row count validation successful.
Table row count validation successful.
+ terminateRunScripts
+ db2 connect reset
+ db2 terminate
+ return 0
+ cleanup 0
+ [ -f /var/pckgs/ibm/db2/GS_DB/unix/../logs//GOSALES_ERROR_LOG.LOG ]
+ exit 0

2.2. Enter the db2inst1 username and pass when prompted

Enter the db2inst1 username and pass when prompted
Enter the db2 administration username for creating the database
and importing the data.
If no value is provided, then the local
user will attempt to connect without a password.
-e Please enter the DB2 admin user name : db2inst1

+ [ 0 = 0 ]
+ echo Table row count validation successful.
Table row count validation successful.
+ terminateRunScripts
+ db2 connect reset
+ db2 terminate
+ return 0
+ cleanup 0
+ [ -f /var/pckgs/ibm/db2/GS_DB/unix/../logs//GOSALES_ERROR_LOG.LOG ]
+ exit 0

2.3. verify installation

The installation script should exit with the exit 0 status.
+ [ 0 = 0 ]
+ echo Table row count validation successful.
Table row count validation successful.
+ terminateRunScripts
+ db2 connect reset
+ db2 terminate
+ return 0
+ cleanup 0
+ [ -f /var/pckgs/ibm/db2/GS_DB/unix/../logs//GOSALES_ERROR_LOG.LOG ]
+ exit 0

2.4. Run the loading script

If errors occur before apply run the following script
# run the following script
db2 -tvsf /var/pckgs/ibm/db2/GS_DB/unix/drop_godb.sql
# and the script
CONNECT TO GS_DB;
UNQUIESCE DATABASE;
QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;
UNQUIESCE DATABASE;
CONNECT RESET;
deactivate db GS_DB;
DROP DATABASE GS_DB;
/var/pckgs/ibm/db2/GS_DB/unix/drop_godb.sql

Labels

perl (41) Cheat Sheet (25) how-to (24) sql server 2008 (13) windows (13) linux (12) oracle (12) sql (12) Unix (11) cmd windows batch (10) mssql (10) cmd (9) script (9) textpad (9) netezza (8) sql server 2005 (8) cygwin (7) meta data mssql (7) metadata (7) code generation (6) Informatica (5) bash (5) cheatsheet (5) energy (5) tsql (5) utilities (5) excel (4) future (4) generic (4) html (4) perl modules (4) programs (4) settings (4) sh (4) shortcuts (4) поуки (4) принципи (4) Focus Fusion (3) Solaris (3) cool programs (3) development (3) economy (3) example (3) freeware (3) fusion (3) git cheat sheet (3) morphus (3) mssql 2005 (3) nuclear (3) nz (3) parse (3) python (3) sftp (3) sofware development (3) source (3) sqlplus (3) table (3) vim (3) .Net (2) C# (2) China (2) GUI (2) Google (2) GoogleCL (2) Solaris Unix (2) ascii (2) awk (2) batch (2) cas (2) chrome extensions (2) code2html (2) columns (2) configuration (2) conversion (2) duplicates (2) excel shortcuts (2) export (2) file (2) free programs (2) informatica sql repository (2) logging (2) mssql 2008 (2) mysql (2) next big future (2) nsis (2) nz netezza cheat sheet (2) nzsql (2) ora (2) prediction (2) publish (2) release management (2) report (2) security (2) single-click (2) sqlserver 2005 (2) sqlserver 2008 (2) src (2) ssh (2) template (2) tools (2) vba (2) video (2) xlt (2) xml (2) youtube videos (2) *nix (1) .vimrc (1) .virmrc vim settings configs (1) BSD license (1) Bulgaria (1) Dallas (1) Database role (1) Dense plasma focus (1) Deployment (1) ERP (1) ExcelToHtml (1) GD (1) GDP (1) HP-UX (1) Hosting (1) INC (1) IT general (1) ITIL management bullshit-management (1) IZarc (1) Java Web Start (1) JavaScript anchor html jquery (1) Khan Academy (1) LINUX UNIX BASH AND CYGWIN TIPS AND TRICKS (1) Linux Unix rpm cpio build install configure (1) Linux git source build .configure make (1) ListBox (1) MIT HYDROGEN VIRUS (1) OO (1) Obama (1) PowerShell (1) Run-time (1) SDL (1) SIWA (1) SOX (1) Scala (1) Services (1) Stacks (1) SubSonic (1) TED (1) abstractions (1) ansible hosts linux bash (1) ansible linux deployment how-to (1) ansible yum pip python (1) apache (1) apache 2.2 (1) application life cycle (1) architecture (1) archive (1) arguments (1) avatar (1) backup (1) bash Linux open-ssh ssh ssh_server ssh_client public-private key authentication (1) bash perl search and replace (1) bash stub (1) bin (1) biofuels (1) biology (1) books (1) browser (1) bubblesort (1) bugs (1) build (1) byte (1) cas_sql_dev (1) chennai (1) chrome (1) class (1) claut (1) cmdow (1) code generation sqlserver (1) command (1) command line (1) conf (1) confluence (1) console (1) convert (1) cool programs windows free freeware (1) copy-paste (1) csv (1) ctags (1) current local time (1) cygwin X11 port-forwarding mintty xclock Linux Unix X (1) cygwin bash how-to tips_n_tricks (1) cygwin conf how-to (1) data (1) data types (1) db2 cheat sheet (1) db2 starter ibm bash Linux (1) debt (1) diagram (1) dictionaries (1) digital (1) disk (1) disk space (1) documentation (1) dos (1) dubai (1) e-cars (1) electric cars (1) electricity (1) emulate (1) errors (1) exponents (1) export workflow (1) extract (1) fast export (1) fexp (1) file extension (1) file permissions (1) findtag (1) firewall (1) for loop (1) freaky (1) functions (1) fusion research (1) german (1) git gitlab issues handling system (1) google cli (1) google code (1) google command line interface (1) gpg (1) ha (1) head (1) helsinki (1) history (1) hop or flop (1) host-independant (1) how-to Windows cmd time date datetime (1) ibm db2 cognos installation example db deployment provisioning (1) ideas (1) image (1) informatica oracle sql (1) informatica repo sql workflows sessions file source dir (1) informatica source files etl (1) install (1) it management best practices (1) java (1) jump to (1) keyboard shortcuts (1) ksh (1) level (1) linkedin (1) linux bash ansible hosts (1) linux bash commands (1) linux bash how-to shell expansion (1) linux bash shell grep xargs (1) linux bash tips and t ricks (1) linux bash unix cygwin cheatsheet (1) linux bash user accounts password (1) linux bash xargs space (1) linux cheat sheet (1) linux cheat-sheet (1) linux cheatsheet cheat-sheet revised how-to (1) linux how-to non-root vim (1) linux ssh hosts parallel subshell bash oneliner (1) london (1) make (1) me (1) metacolumn (1) metadata functions (1) metaphonre (1) method (1) model (1) movie (1) multithreaded (1) mysql cheat sheet (1) mysql how-to table datatypes (1) n900 (1) nano (1) neteza (1) netezza bash linux nps (1) netezza nps (1) netezza nps nzsql (1) netezza nz Linux bash (1) netezza nz bash linux (1) netezza nz nzsql sql (1) netezza nzsql database db sizes (1) non-password (1) nord pol (1) nps backup nzsql schema (1) number formatting (1) nz db size (1) nz table count rows (1) nzsql date timestamp compare bigint to_date to_char now (1) on-lier (1) one-liners (1) one-to-many (1) oneliners (1) open (1) open source (1) openrowset (1) oracle PL/SQL (1) oracle Perl perl (1) oracle installation usability (1) oracle number formatting format-model ora-sql oracle (1) oracle templates create table (1) oracle trigger generic autoincrement (1) oracle vbox virtual box cheat sheet (1) oracle virtual box cheat sheet (1) outlook (1) parser (1) password (1) paths (1) perl @INC compile-time run-time (1) perl disk usage administration Linux Unix (1) perl modules configuration management (1) permissions (1) php (1) picasa (1) platform (1) postgreSQL how-to (1) powerShell cmd cygwin mintty.exe terminal (1) ppm (1) predictions (1) prices (1) principles (1) productivity (1) project (1) prompt (1) proxy account (1) public private key (1) publishing (1) putty (1) qt (1) read file (1) registry (1) relationship (1) repository (1) rm (1) scp (1) scripts (1) scsi (1) search and replace (1) sed (1) sendEmail (1) sh stub (1) shortcuts Windows sql developer Oracle (1) sidebar (1) silicon (1) smtp (1) software procurement (1) sofware (1) sort (1) sql script (1) sql_dev (1) sqlcmd (1) sqlite (1) sqlite3 (1) sshd (1) sshd cygwin (1) stackoverflow (1) stored procedure (1) stub (1) stupidity (1) subroutines (1) svn (1) sysinternals (1) tail (1) tar (1) temp table (1) templates (1) teradata (1) terminal (1) test (1) testing (1) theory (1) thorium (1) time (1) tip (1) title (1) tmux .tmux.conf configuration (1) tmux efficiency bash (1) tool (1) ui code prototyping tips and tricks (1) umask Linux Unix bash file permissions chmod (1) url (1) urls (1) user (1) utility (1) utils (1) vb (1) vim perl regex bash search for string (1) vim recursively hacks (1) vim starter (1) vim-cheat-sheet vim cheat-sheet (1) vimeo (1) visual stuio (1) warsaw (1) wiki (1) wikipedia (1) window (1) windows 7 (1) windows 8 (1) windows programs (1) windows reinstall (1) windows utility batch perl space Windows::Clipboard (1) wisdoms (1) workflow (1) worth-reading (1) wrapper (1) xp_cmdshell (1) xslt (1) youtube (1)

Blog Archive

Translate with Google Translate

My Blog List

VideoBar

This content is not yet available over encrypted connections.