I found a db2nodes.cfg in the sqllib dir. The sqllib dir is NOT on rootvg so it wasn't lost.
rssymapi2p:/tsmdata/tsmoc/config/sqllib==>cat db2nodes.cfg 0 rssymapi2p 0 The instance was a fully good/running TSM/DB2 system, although all it ever did was run the OC hub. For example, I found out about this cmd fighting a db2 problem some time ago. Running db2ilist returns nothing. ./db2ilist (no output) On other TSM instances db2ilist returns our DB2 owner. The doc you mentioned says to check /etc/services. On a good/running TSM I find these: DB2_tsmuser 60000/tcp DB2_tsmuser_1 60001/tcp DB2_tsmuser_2 60002/tcp DB2_tsmuser_END 60003/tcp They are missing on this system we recovered rootvg. Will try adding them back in. Rick -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Loon, Eric van (ITOPT3) - KLM Sent: Wednesday, September 14, 2016 7:42 AM To: ADSM-L@VM.MARIST.EDU Subject: *EXTERNAL* Re: tsm/db2 won't start after boot drive crash/recovery Hi Richard! Did you check the contents of the db2nodes.cfg file? It should contain the local host name of the TSM server. You should also check if the instance is created successfully using the db2ilist command and also take a look at the following technote: http://www-01.ibm.com/support/docview.wss?uid=swg1IC67141 Kind regards, Eric van Loon Air France/KLM Storage Engineering -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ADSM-L@VM.MARIST.EDU] On Behalf Of Rhodes, Richard L. Sent: dinsdag 13 september 2016 21:29 To: ADSM-L@VM.MARIST.EDU Subject: 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. ******************************************************** For information, services and offers, please visit our web site: http://www.klm.com. This e-mail and any attachment may contain confidential and privileged material intended for the addressee only. If you are not the addressee, you are notified that no part of the e-mail or any attachment may be disclosed, copied or distributed, and that any other action related to this e-mail or attachment is strictly prohibited, and may be unlawful. If you have received this e-mail by error, please notify the sender immediately by return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries and/or its employees shall not be liable for the incorrect or incomplete transmission of this e-mail or any attachments, nor responsible for any delay in receipt. Koninklijke Luchtvaart Maatschappij N.V. (also known as KLM Royal Dutch Airlines) is registered in Amstelveen, The Netherlands, with registered number 33014286 ******************************************************** ----------------------------------------- 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.
