ADSM-L

[ADSM-L] TSM 6.2.1 ANR2032E RESTORE DB: Command failed - internal ser

2011-11-13 13:43:50
Subject: [ADSM-L] TSM 6.2.1 ANR2032E RESTORE DB: Command failed - internal ser
From: darthlord <tsm-forum AT BACKUPCENTRAL DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 13 Nov 2011 09:02:53 -0800
Hi,

I4m new to TSM 6.2, I4ll appreciate any further assistance to solve some issues 
to RESTORE TSM DB into another server. As we are working into a DRP with TSM 
6.2. We had been getting some TSM Restore DB error messages, and noticed that 
while restore finished no logs were restored at activelog path.

Maybe we are missing some step at the restore procedure. The output for what we 
are running and the errors are as follow:


----ANR2032E RESTORE DB: Command failed - internal server error detected----

# timex dsmserv removedb tsmdb1
ANR7800I DSMSERV generated at 11:08:03 on May 12 2010.

Tivoli Storage Manager for AIX
Version 6, Release 2, Level 1.0

Licensed Materials - Property of IBM

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

ANR7801I Subsystem process ID is 8192118.
ANR0900I Processing options file /home2/tsminst1/tsminst1/dsmserv.opt.
ANR7811I Using instance directory /home2/tsminst1/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR2638W This command will delete all user data and log files, as well as any
backup/restore history for the TSM server database. Are you sure you want your
database and all of its references removed (y or n)?
y
ANR0152I Database manager successfully started.
ANR0366I Database TSMDB1 was removed successfully.

real 2710.02
user 1.12
sys  0.04

#
#
#
#
#
# timex /opt/tivoli/tsm/server/bin/dsmserv format 
dbdir=/opt/tivoli/tsm/inst/tsminst1/tsmdb001,/opt/tivoli/tsm/inst/tsminst1/tsmdb002,/opt/tivoli/tsm/inst/tsminst1/tsmdb003,/opt/tivoli/tsm/inst/tsminst1/tsmdb004
 activelogdir=/tivoli/activelog ARCHLOGDIR=/tivoli/archivelog
ANR7800I DSMSERV generated at 11:08:03 on May 12 2010.

Tivoli Storage Manager for AIX
Version 6, Release 2, Level 1.0

Licensed Materials - Property of IBM

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

ANR7801I Subsystem process ID is 7012592.
ANR0900I Processing options file /home2/tsminst1/tsminst1/dsmserv.opt.
ANR7811I Using instance directory /home2/tsminst1/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR0152I Database manager successfully started.
ANR1380I The buffer pool monitor switch is enabled.
ANR0992I Server's database formatting complete.
ANR0369I Stopping the database manager because of a server shutdown.
ANR2976I Offline DB backup for database TSMDB1 started.
ANR2974I Offline DB backup for database TSMDB1 completed successfully.

real 9064.54
user 1.50
sys  0.40

# timex dsmserv restore db
ANR7800I DSMSERV generated at 11:08:03 on May 12 2010.
Tivoli Storage Manager for AIX
Version 6, Release 2, Level 1.0

Licensed Materials - Property of IBM

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

ANR7801I Subsystem process ID is 22478916.
ANR0900I Processing options file /home2/tsminst1/tsminst1/dsmserv.opt.
ANR7811I Using instance directory /home2/tsminst1/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR1636W The server machine GUID changed: old value (), new value (2e.c0.15.66-
.9b.6d.11.e0.be.18.00.01.05.00.00.00).
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port
1500.
ANR8225I TCP/IP Version 4 administrative driver ready for connection with
clients on port 1505.
ANR0478W Session request refused. Server is running in standalone mode.
ANR4636I Starting roll-forward database restore.
ANR8955I Drive LTO4_1 in library TS3310 with serial number  is updated with the
newly discovered serial number 1310257346.
ANR8955I Drive LTO4_2 in library TS3310 with serial number  is updated with the
newly discovered serial number 1310194253.
ANR4620I Database backup series 11 operation 0 device class LTO_CLASS_1.
ANR8337I LTO volume MXDB40L4 mounted in drive LTO4_1 (/dev/rmt1).
ANR1363I Input volume MXDB40L4 opened (sequence number 1).
ANR1364I Input volume MXDB40L4 closed.
ANR8468I LTO volume MXDB40L4 dismounted from drive LTO4_1 (/dev/rmt1) in
library TS3310.
ANR8337I LTO volume MXDB40L4 mounted in drive LTO4_2 (/dev/rmt0).
ANR1363I Input volume MXDB40L4 opened (sequence number 1).
ANR1364I Input volume MXDB40L4 closed.
ANR4638I Restore of backup series 11 operation 0 in progress.
ANR8468I LTO volume MXDB40L4 dismounted from drive LTO4_2 (/dev/rmt0) in
library TS3310.
ANR0498W Session 2 refused for MXTLANUX001 because restore DB is in progress.
ANR0406I Session 3 started for node $$_TSMDBMGR_$$ (DB2/AIX64) (Tcp/Ip
loopback(60189)).
ANR8337I LTO volume MXDB40L4 mounted in drive LTO4_1 (/dev/rmt1).
ANR0510I Session 3 opened input volume MXDB40L4.
ANR1363I Input volume MXDB40L4 opened (sequence number 1).
ANR4912I Database  full restore in progress and DB Data bytes transferred
67,371,008.
.
.
ANR4912I Database  full restore in progress and DB Data bytes transferred
7,988,051,968.
ANR1364I Input volume MXDB40L4 closed.
ANR0514I Session 3 closed volume MXDB40L4.
ANR0403I Session 3 ended for node $$_TSMDBMGR_$$ (DB2/AIX64).
ANR8468I LTO volume MXDB40L4 dismounted from drive LTO4_1 (/dev/rmt1) in
library TS3310.
ANR0406I Session 4 started for node $$_TSMDBMGR_$$ (DB2/AIX64) (Tcp/Ip
loopback(41323)).
ANR8337I LTO volume MXDB40L4 mounted in drive LTO4_2 (/dev/rmt0).
ANR0510I Session 4 opened input volume MXDB40L4.
ANR1363I Input volume MXDB40L4 opened (sequence number 1).
ANR4912I Database  full restore in progress and DB transaction log bytes
transferred  67,371,008.
.
.
ANR4912I Database  full restore in progress and DB transaction log bytes
transferred  471,597,056.
ANR1365I Volume MXDB40L4 closed (end reached).
ANR4912I Database  full restore in progress and DB transaction log bytes
transferred  486,678,539.
ANR1364I Input volume MXDB40L4 closed.
ANR0514I Session 4 closed volume MXDB40L4.
ANR0403I Session 4 ended for node $$_TSMDBMGR_$$ (DB2/AIX64).
ANR8468I LTO volume MXDB40L4 dismounted from drive LTO4_2 (/dev/rmt0) in
library TS3310.
ANR0406I Session 5 started for node $$_TSMDBMGR_$$ (DB2/AIX64) (Tcp/Ip
loopback(59428)).
ANR0403I Session 5 ended for node $$_TSMDBMGR_$$ (DB2/AIX64).
ANR4637I Roll-forward database restore complete.
\cf1\b Error 2121 collecting the server database creation timestamp.  The server
stops.
ANR2032E RESTORE DB: Command failed - internal server error detected.
ANR9999D Thread<1> issued message 2032 from:
ANR9999D Thread<1>  0x00000001000120fc StdPutMsg
ANR9999D Thread<1>  0x0000000100013804 outMsgf
ANR9999D Thread<1>  0x00000001004678fc admRestoreDatabase
ANR9999D Thread<1>  0x000000010000344c RestoreDb
ANR9999D Thread<1>  0x0000000100000f2c main
\cf0\b0
real 3231.54
user 3.54
sys  3.41

The servers we are working with are:
Main Data Center:
IBM Power 720 # oslevel 6.1.0.0 & TSM for AIX Ver 6, Release 2, Level 1.0 and 
IBM Tape Library TS3200 with 4 LTO5 HH drives.
We split SAN mirrored disks to generate TSM alternate server at DR Data Center, 
so we are running exactly the same version of OS and TSM on both systems. At 
DRDC we are running on an IBM Power 710 with a DAS IBM Tape Library TS3310 with 
2 LTO4 FH.

Devconfig files from my systems are as follow:

Main TSM system:
/* Device Configuration */
DEFINE DEVCLASS LTO_CLASS_1 DEVT=LTO FORMAT=DRIVE MOUNTL=DRIVES MOUNTWAIT=1 
MOUNTRETENTION=1 PREFIX=ADSM LIBRARY=TS3200 WORM=NO DRIVEENCRYPTION=ALLOW
DEFINE DEVCLASS NAS_CLASS_1 DEVT=NAS FORMAT=DRIVE ESTCAPACITY=10485760000K 
MOUNTL=DRIVES MOUNTWAIT=60 MOUNTRETENTION=0 PREFIX=ADSM LIBRARY=TS3200
DEFINE DEVCLASS NAS_CLASS_2 DEVT=NAS FORMAT=DRIVE ESTCAPACITY=2097152K 
MOUNTL=DRIVES MOUNTWAIT=60 MOUNTRETENTION=0 PREFIX=ADSM LIBRARY=N5200LIB
DEFINE SERVER MXTLANUX001 COMMMETHOD=TCPIP HLADDRESS=10.77.48.42 LLADDRESS=1502 
 NODENAME=MXTLAL002 PASSWORD=217fe7badb58f9993ec73e11718de6cfae  
SERVERPASSWORD=217fe7badb58f9993ec73e11718de6cfae
SET SERVERNAME MXTLAL002
SET SERVERPASSWORD 2114d26b1b9915ad79112fa9a99d664be5
DEFINE LIBRARY TS3200 LIBTYPE=SCSI WWN="2004000E1114624F" 
SERIAL="00L4U78P3463_LL0" SHARED=YES AUTOLABEL=YES RESETDRIVE=YES
DEFINE DRIVE TS3200 LTO5-1 ELEMENT=257 ONLINE=Yes WWN="2004000E1114624F" 
SERIAL="1068007521"
DEFINE DRIVE TS3200 LTO5-2 ELEMENT=256 ONLINE=Yes WWN="2001000E1114624F" 
SERIAL="9068005898"
DEFINE DRIVE TS3200 LTO5-3 ELEMENT=259 ONLINE=Yes WWN="200A000E1114624F" 
SERIAL="1068007590"
DEFINE DRIVE TS3200 LTO5-4 ELEMENT=258 ONLINE=Yes WWN="2007000E1114624F" 
SERIAL="1068004193"
/* LIBRARYINVENTORY SCSI TS3200 MXDB01L4 4119 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXDB05L4 4121 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXDB44L4 4131 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXN002L4 4101 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXN003L4 4113 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXN048L4 4123 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXN050L4 4124 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXS003L4 4132 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXS005L4 4139 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXS007L4 4117 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXS008L4 4130 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXSA02L4 4096 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXSC01L4 4135 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXUA49L4 4129 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXUA50L4 4108 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXUP45L4 4115 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXUP48L4 4116 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW002L4 4118 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW008L4 4136 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW035L4 4127 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW036L4 4110 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW037L4 4125 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW039L4 4126 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW042L4 4099 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW043L4 4105 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW045L4 4103 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW046L4 4109 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW047L4 4112 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXW048L4 4111 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWA26L4 4100 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWA28L4 4102 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWA29L4 4106 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWC01L4 4138 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWD01L4 4120 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWD03L4 4104 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWE49L4 4128 101*/
/* LIBRARYINVENTORY SCSI TS3200 MXWE50L4 4098 101*/
DEFINE PATH MXTLAL002 TS3200 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc1 
ONLINE=YES
DEFINE PATH MXTLAL002 LTO5-1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt1 ONLINE=YES
DEFINE PATH MXTLAL002 LTO5-2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt2 ONLINE=YES
DEFINE PATH MXTLAL002 LTO5-3 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt3 ONLINE=YES
DEFINE PATH MXTLAL002 LTO5-4 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt4 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO5-1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt0 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO5-2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt2 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO5-3 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt1 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO5-4 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3200 
DEVICE=/dev/rmt3 ONLINE=YES
SERVERBACKUPNODEID 1


DR TSM system:
# cat /opt/tivoli/tsm/server/bin/devconf.out
/* Device Configuration */
DEFINE DEVCLASS LTO_CLASS_1 DEVT=LTO FORMAT=DRIVE MOUNTL=DRIVES MOUNTWAIT=1 
MOUNTRETENTION=1 PREFIX=ADSM LIBRARY=TS3310 WORM=NO DRIVEENCRYPTION=ALLOW
DEFINE DEVCLASS NAS_CLASS_1 DEVT=NAS FORMAT=DRIVE ESTCAPACITY=10485760000K 
MOUNTL=DRIVES MOUNTWAIT=60 MOUNTRETENTION=0 PREFIX=ADSM LIBRARY=TS3310
DEFINE DEVCLASS NAS_CLASS_2 DEVT=NAS FORMAT=DRIVE ESTCAPACITY=2097152K 
MOUNTL=DRIVES MOUNTWAIT=60 MOUNTRETENTION=0 PREFIX=ADSM LIBRARY=N5200LIB
DEFINE SERVER MXTLANUX001 COMMMETHOD=TCPIP HLADDRESS=157.171.7.104 
LLADDRESS=1502  NODENAME=MXTLAL002 PASSWORD=217fe7badb58f9993ec73e11718de6cfae  
SERVERPASSWORD=217fe7badb58f9993ec73e11718de6cfae
SET SERVERNAME MXTLAL002
SET SERVERPASSWORD 2114d26b1b9915ad79112fa9a99d664be5
DEFINE LIBRARY TS3310 LIBTYPE=SCSI WWN="500308c09c3e0004" 
SERIAL="000001310869_LLA" SHARED=YES AUTOLABEL=YES RESETDRIVE=YES
DEFINE DRIVE TS3310 LTO4_1 ELEMENT=256 ONLINE=Yes WWN="500308c09c3e0000" 
SERIAL="1310257346"
DEFINE DRIVE TS3310 LTO4_2 ELEMENT=257 ONLINE=Yes WWN="500308c09c3e0004" 
SERIAL="1310194253"
/* LIBRARYINVENTORY SCSI TS3310 MXDB40L4 4096 101*/
/* LIBRARYINVENTORY SCSI TS3310 MXU002L4 4097 101*/
/* LIBRARYINVENTORY SCSI TS3310 MXUP50L4 4098 101*/
/* LIBRARYINVENTORY SCSI TS3310 MXUP12L4 4099 101*/
/* LIBRARYINVENTORY SCSI TS3310 MXDB35L4 4101 101*/
DEFINE PATH MXTLAL002 TS3310 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/smc0 
ONLINE=YES
DEFINE PATH MXTLAL002 LTO4_1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 
DEVICE=/dev/rmt1 ONLINE=YES
DEFINE PATH MXTLAL002 LTO4_2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 
DEVICE=/dev/rmt0 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO4_1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 
DEVICE=/dev/rmt1 ONLINE=YES
DEFINE PATH MXTLANUX001 LTO4_2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=TS3310 
DEVICE=/dev/rmt0 ONLINE=YES
SERVERBACKUPNODEID 1

Both servers have exactly the same volhist.out file. Path for logs and DB are 
independent filesystems each and we deleted all content on them.

We have run dsmserv restore db procedure with TSM 5.5, without any problem, but 
TSM 6.2.1.

Thank you for your assistance.

PS. Sorry for my english

Gabriel Medina

+----------------------------------------------------------------------
|This was sent by vader_darth_lord AT yahoo DOT com via Backup Central.
|Forward SPAM to abuse AT backupcentral DOT com.
+----------------------------------------------------------------------