ADSM-L

[ADSM-L] tsm/db2 won't start after boot drive crash/recovery

2016-09-13 15:31:46
Subject: [ADSM-L] tsm/db2 won't start after boot drive crash/recovery
From: "Rhodes, Richard L." <rrhodes AT FIRSTENERGYCORP DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Tue, 13 Sep 2016 19:29:18 +0000
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.