DB2 backup with TSM

*** this is a short summary, for detailed explanations examine tsm-db2.pdf

##### Examine DB config

db2 list db directory

##### Configure each DB instance to use TSM for backup

db2 update db cfg for TEPS using LOGARCHMETH1 TSM

db2 update db cfg for WAREHOUS using LOGARCHMETH1 TSM

db2 update db cfg for SAMPLE using LOGARCHMETH1 TSM

##### Set correct environment variables.

[root@server1]</>tail -8 /home/db2inst1/.profile

# The following three lines have been added by IBM DB2 instance utilities.

if [ -f /home/db2inst1/sqllib/db2profile ]; then

. /home/db2inst1/sqllib/db2profile

fi

export DSMI_CONFIG=/usr/tivoli/tsm/client/api/bin64/dsm.opt

export DSMI_LOG=/usr/tivoli/tsm/client/ba/bin64

export DSMI_DIR=/usr/tivoli/tsm/client/api/bin64

[root@server1]</>

####### Get password for TSM

/home/db2inst1/sqllib/adsm/dsmapipw

If succeeds, /etc/security/adsm/TSM.PWD file will be created.

###### Test backup using TSM

[root@server1]</>su - db2inst1

[db2inst1@server1]</home/db2inst1>db2 backup db TEPS use tsm

Backup successful. The timestamp for this backup image is : 20170606153438

[db2inst1@server1]</home/db2inst3>

Feel free to communicate by bulent.yucesoy@gmail.com