Richard, I have recently moved several TSM servers between AIX systems (without restoring the DBs). Some points of attention:
On a system without TSM, you must first install TSM software. You will also need some tweaking of the DB registry. 1. correct hostname in <instance home dir>/sqllib/db2nodes.cfg 2. /etc/services must contain: DB2_<instance name> 60016/tcp DB2_<instance name>_1 60017/tcp DB2_<instance name>_2 60018/tcp DB2_<instance name>_END 60019/tcp Ports can vary, but must be in sequence 3. Instance "update": /opt/tivoli/tsm/db2/instance/db2iupdt <instance name> 4. As instance owner: ~/sqllib/adm/db2set -g DB2SYSTEM=<hostname> 5. dsm.sys for DBbackups has to be present (location depends on the TSM server version) If you need more details please PM me. Met vriendelijke groet / With kind regards, Paul van Dongen System Expert Vancis BV Science Park 408 1098 XH Amsterdam W: www.vancis.nl T: 020 560 6600 M: 06 4181 4446 E: paul.vandon...@vancis.nl -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: 14 September 2016 13:48 To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery No, DB2 won't start at all. rssymapi2p:/tsmdata/tsmoc/config==>db2start SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". I'm not sure how to state this, but I think there is some configuration in DB2 (that would be in on the boot drive) that points to the TSM database TSMDB1. I think that configuration is missing. For example, I found out about this cmd fighting a db2 problem some time ago. Run on a working TSM system: ./db2ilist tsmuser (our db2 owner) Run on this recovered system: ./db2ilist (no output) Rick -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Lee, Gary Sent: Tuesday, September 13, 2016 3:42 PM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Was db2 running for sure? In previous installs I had to modify the startup script to do a db2start then sleep for 10 secs to get tsm to start correctly fron reboot of the system. This was under redhat linux 6. That was the message I would get. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: Tuesday, September 13, 2016 3:29 PM To: ADSM-L@VM.MARIST.EDU Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery Hello, We have a TSM v7.1.4 instance called TSMOC. Its sole purpose in life is to run Operations Center. It runs on an AIX lpar that's used for some other things. Last Friday the AIX rootvg was lost during a live migration to a new storage system. We decided to recover by installing a mksysb from a partner lpar which had the same AIX version and application version, but NOT TSM. So the lpar got back up and running quickly - only took an hour, but it's missing the TSM install. All the TSM instance files (dsmserv.opt, etc) and DB2 filesystems (data, logs, sqllib, etc) exist with all their data. They weren't lost since they were on a different lun and volume group. We installed TSM v7.1.4 and I then created the AIX db2 instance owner and group. We then tried to start TSM. We got msgs below. ANR7801I Subsystem process ID is 16056324. ANR0900I Processing options file /tsmdata/tsmoc/config/dsmserv.opt. ANR7811I Using instance directory /tsmdata/tsmoc/config. ANR4726I The ICC support module has been loaded. ANR0990I Server restart-recovery in progress. ANR0172I rdbinst.c(3942): Error encountered performing action UPDATE DBM CFG. ANR0162W Supplemental database diagnostic information: -6031:**No State Information Available (-2)**:-6031 (SQL6031N Error in the db2nodes.cfg file at line number "0". Reason code "11". ). ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode. ANR0162W Supplemental database diagnostic information: -1:08001:-1032 ([IBM][CLI Driver] SQL1032N No start database manager command was issued. SQLSTATE=57019 I think I've got to tell db2 about the database that exists on disk. We are going to call support, but figured I'd ask here first! Any thought/comments are appreciated! Rick ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message. -----------------------------------------The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.