ibm db2 starter

IBM DB2

The version 10.5 documentation URI:
https://www.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.server.doc/doc/t0006839.html

1. INSTALLATION AND CONFIGURATION

Use the following sql agains the repo

su - db2inst1

export PS1=" \u@\h [\d \t] [\w] $ \n\n  "

# configure first your path

export PATH=$PATH:/opt/ibm/db2/V10.5/bin

export PATH=$PATH:/opt/ibm/db2/V10.5/adm/

1.1. basic installer configuration

Run the installer

# to the installer dir

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

# run the installer script

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

1.2. how-to check which files are opened by the installer script

how-to check which files are opened by the installer script

lsof -a -p `pidof db2setup` | less

# or the db2 cmd

lsof -a -p `pidof db2` | less

1.3. how-to install the sample database

Run the following command:

db2sampl --force --verbose

2. MAINTENANCE AND OPERATION

Use the following sql agains the repo

# Remember always to run as the db2 Linux user

su - db2inst1

export PS1=" \u@\h [\d \t] [\w] $ \n\n  "

# configure first your path

export PATH=$PATH:/opt/ibm/db2/V10.5/bin

export PATH=$PATH:/opt/ibm/db2/V10.5/adm/

2.1. how-to connect to a database

run the followign command as the db2inst1 ( the db2 Linux user )

db2 "connect to SAMPLE"

2.2. how-to list all the tables in a database in db2

run the followign command as the db2inst1 ( the db2 Linux user )

db2 "connect to SAMPLE"

db2 "LIST TABLES "

2.3. how-to list the database directories

run the followign command as the db2inst1 ( the db2 Linux user )

 db2 list db directory

2.4. how-to start the db2

run the followign command as the db2inst1 ( the db2 Linux user )

db2start

2.5. how-to stop the db2

run the followign command as the db2inst1 ( the db2 Linux user )

db2stop

3. DEVELOPMENT

# Remember always to run as the db2 Linux user

su - db2inst1

3.1. how-to run a sql script

run the followign command as the db2inst1 ( the db2 Linux user )

db2 -tvsf /var/pckgs/ibm/db2/GS_DB/unix/drop_godb.sql

3.2. how-to drop a db2 database

Run the following sql statemnts

CONNECT TO SAMPLE;

UNQUIESCE DATABASE;

QUIESCE DATABASE IMMEDIATE FORCE CONNECTIONS;

UNQUIESCE DATABASE;

CONNECT RESET;

deactivate db SAMPLE;

UNCATALOG DATABASE SAMPLE ;

DROP DATABASE SAMPLE;

3.3. how-to describe a table

how-to describe a table

db2 -x "DESCRIBE TABLE SYSIBM.TABLES"

3.4. how-to iterate over list of tables in db2

how-to iterate over list of tables in db2

db2 -x "SELECT TABLE_NAME FROM SYSIBM.TABLES" | { while read -r table ; do echo -e "start table: $table \n" ; echo $table ; echo -e "stop table: $table " ; done ; }