I go through this exercise when performing DR tests and we swing over the storage. Here is my cheat sheet:
- create instance owner user db2icrt -a server -s ese -u tsminstance tsminstance su - tsminstance #copy/validate: ~/sqllib/usercshrc ~/sqllib/userprofile ~/.bash_profile #or whatever shell profile to source the db2 env (. ~/sqllib/db2profile) db2set -i tsminstance DB2CODEPAGE=819 db2 update dbm cfg using dftdbpath /instanceDIR db2 catalog database tsmdb1 db2 list database directory # copy/validate db backup stanza vi /opt/tivoli/tsm/client/api/bin64/dsm.sys This message and any attachments (the "message") is intended solely for the addressees and is confidential. If you receive this message in error, please delete it and immediately notify the sender. Any use not in accord with its purpose, any dissemination or disclosure, either whole or partial, is prohibited except formal approval. The internet can not guarantee the integrity of this message. BNP PARIBAS (and its subsidiaries) shall (will) not therefore be liable for the message if modified. Please note that certain functions and services for BNP Paribas may be performed by BNP Paribas RCC, Inc. Unless otherwise provided above, this message was sent by BNP Paribas, or one of its affiliates in Canada, having an office at 1981 McGill College Avenue, Montreal, QC, H3A 2W8, Canada. To the extent this message is being sent from or to Canada, you may unsubscribe from receiving commercial electronic messages by using this link: www.bnpparibas.ca/en/unsubscribe/ <http://www.bnpparibas.ca/en/unsubscribe/>. See www.bnpparibas.ca <http://www.bnpparibas.ca> for more information on BNP Paribas, in Canada.