6.1 restore db procedure

[stevehess]

I'm trying to restore a tsm 6.1 database and I must be missing a step. Thought I'd throw this out there before I call IBM. Here's what I've been able to glean from the manual.
1 install OS (windows 2003 x64) disable UAC - reboot
2 install TSM
3 reboot and log back in with db2user1 account created during tsm install
4 run dsmicfgx and create a new tsm instance
5 stop the windows services for the tsm instance and db2 instance
6 open the db2 command line processor and quit to a command prompt
7 db2idrop server1
8 remove all files from the d:\tsm\db, log, etc directories (and the d:\server1 directory??)
9 restore the volhist, dsmserv.opt, devconfig.out files to d:\tsm\server1
10 create a text file dbdir.txt with database paths "d:\tsm\db"
11 from the server1 directory run "c:\program files\tivoli\tsm\server\dsmserv" restore db on=dbdir.txt

ANR0900I Processing options file D:\tsm\server1\dsmserv.opt.
ANR7800I DSMSERV generated at 17:36:33 on Mar 13 2009.

Tivoli Storage Manager for Windows
Version 6, Release 1, Level 0.0

Licensed Materials - Property of IBM

(C) Copyright IBM Corporation 1990, 2008.
All rights reserved.
U.S. Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corporation.

ANR4726I The ICC support module has been loaded.
ANR1636W The server machine GUID changed: old value (), new value (bf.27.cf.10-
.39.8e.11.de.87.6a.00.15.5d.00.f4.00).
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
1500.
ANR4654I The restore db to most current time can not be done since contents of
the active or archive log directories have been changed. The DB will be
restored to the last full or full plus incremental state.
ANR4620I Database backup series 346 operation 0 device class FILECLASS.
ANR8340I FILE volume D:\TSM\FILES\41101073.DBV mounted.
ANR1363I Input volume D:\TSM\FILES\41101073.DBV opened (sequence number 1).
ANR1364I Input volume D:\TSM\FILES\41101073.DBV closed.
ANR8340I FILE volume D:\TSM\FILES\41101734.DBV mounted.
ANR1363I Input volume D:\TSM\FILES\41101734.DBV opened (sequence number 1).
ANR1364I Input volume D:\TSM\FILES\41101734.DBV closed.
ANR8340I FILE volume D:\TSM\FILES\41101419.DBV mounted.
ANR1363I Input volume D:\TSM\FILES\41101419.DBV opened (sequence number 2).
ANR1364I Input volume D:\TSM\FILES\41101419.DBV closed.
ANR4638I Restore of backup series 346 operation 0 in progress.
ANR2969E Database restore terminated. DB2 sqlcode: -2033. DB2 sqlerrmc: 406.
ANR1794W TSM SAN discovery is disabled by options.

I'll gladly RTFM if someone would point me to TFM. I found the information on the "on=dbdir.txt" parameter in the docs for moving the database. Running dsmicfgx is just a guess. It seems to get farther along...

BTW The webcast mentions a database upgrade guide several times. Anybody know where to find it? Thanks for any help.

 

[Harry_Redl]

Hi,

seen this?

http://publib.boulder.ibm.com/infoc...opic=/com.ibm.itsm.messages.doc/msgs2406.html

Harry

 

[OctavioP]

Hi,

Im getting the same error? were you able to sort your issue out?

 

[stevehess]

Resolved

The answer is in the docs. Unfortunately it's spread out in about 5 different locations.

Run dsmicfgx and create a new tsm instance. This will create some configuration files we needed for the restore (tsmdbmgr.env tsmdbmgr.opt)
Open the db2 command line processor and quit to a command prompt
net stop “tsm server1”
net stop "DB2 - DB2TSM1 - SERVER1"
db2idrop Server1
db2icrt -u db2user1 Server1
set DB2INSTANCE=Server1
db2set -i server1 DB2_VENDOR_INI=d:\tsm\server1\tsmdbmgr.env
db2stop
db2start
set DSMI_CONFIG=d:\tsm\server1\tsmdbmgr.opt
“c:\program files\tivoli\tsm\server\dsmsutil.exe” UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO
A bogus directory is created during the initial instance creation. Remove these files (\server1 in root of any drive).
Remove all files from the d:\tsm\db, log and archlog KEEP files in d:\tsm\server1
Restore/replace the volhist.out, dsmserv.opt, devconfig.out files to d:\tsm\server1
Create a text file dbdir.txt with database paths "d:\tsm\db"
From the server1 directory run "c:\program files\tivoli\tsm\server\dsmserv" restore db on=dbdir.txt

 

[OctavioP]

Thanks, it worked!!

 

[hoyuken]

Combine Volhist 5.3.6 and Volhist 6.1

Stevehess,

I have TSM 5.3.6 and TSM 6.1 servers in Production. As TSM 5.3.6 will decommission very soon. How can I combine both database into TSM 6.1 server?

Please advice

The answer is in the docs. Unfortunately it's spread out in about 5 different locations.

Run dsmicfgx and create a new tsm instance. This will create some configuration files we needed for the restore (tsmdbmgr.env tsmdbmgr.opt)
Open the db2 command line processor and quit to a command prompt
net stop “tsm server1”
net stop "DB2 - DB2TSM1 - SERVER1"
db2idrop Server1
db2icrt -u db2user1 Server1
set DB2INSTANCE=Server1
db2set -i server1 DB2_VENDOR_INI=d:\tsm\server1\tsmdbmgr.env
db2stop
db2start
set DSMI_CONFIG=d:\tsm\server1\tsmdbmgr.opt
“c:\program files\tivoli\tsm\server\dsmsutil.exe” UPDATEPW /NODE:$$_TSMDBMGR_$$ /PASSWORD:TSMDBMGR /VALIDATE:NO
A bogus directory is created during the initial instance creation. Remove these files (\server1 in root of any drive).
Remove all files from the d:\tsm\db, log and archlog KEEP files in d:\tsm\server1
Restore/replace the volhist.out, dsmserv.opt, devconfig.out files to d:\tsm\server1
Create a text file dbdir.txt with database paths "d:\tsm\db"
From the server1 directory run "c:\program files\tivoli\tsm\server\dsmserv" restore db on=dbdir.txt