ADSM-L

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

2011-11-13 14:07:31
Subject: Re: [ADSM-L] TSM 6.2.1 ANR2032E RESTORE DB: Command failed - internal ser
From: Remco Post <r.post AT PLCS DOT NL>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Sun, 13 Nov 2011 19:57:56 +0100
This may be not what you're hoping to hear right now, but, why 6.2.1 and not 
6.2.3 ? Have you checked the changelog/APARs fixed in 6.2.3 to see if there is 
anything relevant?

On 13 nov. 2011, at 18:02, darthlord wrote:

> 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.
> +----------------------------------------------------------------------

-- 
Met vriendelijke groeten/Kind Regards,

Remco Post
r.post AT plcs DOT nl
+31 6 248 21 622