gernthefish
ADSM.ORG Member
- Joined
- Mar 3, 2005
- Messages
- 139
- Reaction score
- 0
- Points
- 0
We're testing the TSM recovery process and getting an error. The source and destination servers are both running TSM v7.1.5, but the destination server has a different directory structure and instance owner. I didn't remove the old DB or anything, just ran the following:
/opt/tivoli/tsm/server/bin/dsmserv restore db on=dbdirs tod=05/17/2016 tot=08:00:00
From info I found online, I created a dbdir file which contains the path name for the destination host and I also had to create the source directory on the destination server even though it is not being used for the recovery process. I used a copy of the volhist.out file from 5/17 (from the source server). The recovery ran ok but I got errors when trying to start dsmserv:
ANR0152I Database manager successfully started.
ANR0238E A database recovery task is prohibiting activation of TSMDB1 with sqlcode -1117.
ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode.
Segmentation fault (core dumped)
IBM suggested I try the following, but it failed:
[tsma1a@tacoma ~]$ db2stop
06/08/2016 08:29:03 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[tsma1a@tacoma ~]$ db2start
06/08/2016 08:29:22 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[tsma1a@tacoma ~]$ db2 "rollforward db TSMDB1 STOP"
SQL1273N An operation reading the logs on database "TSMDB1" cannot continue
because of a missing log file "S0010375.LOG" on database partition "0" and log
stream "0".
Any suggestions? Should I try removing the DB & logs from the destination server and rerun the recovery? Could having a different directory structure and/or instance user be causing these issues?
Thanks
/opt/tivoli/tsm/server/bin/dsmserv restore db on=dbdirs tod=05/17/2016 tot=08:00:00
From info I found online, I created a dbdir file which contains the path name for the destination host and I also had to create the source directory on the destination server even though it is not being used for the recovery process. I used a copy of the volhist.out file from 5/17 (from the source server). The recovery ran ok but I got errors when trying to start dsmserv:
ANR0152I Database manager successfully started.
ANR0238E A database recovery task is prohibiting activation of TSMDB1 with sqlcode -1117.
ANR0171I dbiconn.c(1844): Error detected on 0:1, database in evaluation mode.
Segmentation fault (core dumped)
IBM suggested I try the following, but it failed:
[tsma1a@tacoma ~]$ db2stop
06/08/2016 08:29:03 0 0 SQL1064N DB2STOP processing was successful.
SQL1064N DB2STOP processing was successful.
[tsma1a@tacoma ~]$ db2start
06/08/2016 08:29:22 0 0 SQL1063N DB2START processing was successful.
SQL1063N DB2START processing was successful.
[tsma1a@tacoma ~]$ db2 "rollforward db TSMDB1 STOP"
SQL1273N An operation reading the logs on database "TSMDB1" cannot continue
because of a missing log file "S0010375.LOG" on database partition "0" and log
stream "0".
Any suggestions? Should I try removing the DB & logs from the destination server and rerun the recovery? Could having a different directory structure and/or instance user be causing these issues?
Thanks