restore db problem ANR2032E

[siorellan]

Hi there!
I need to restore a TSM DB on Linux. I created a new server 6.2.1 and I copied the configuration files dsmserv.opt, volhist.dat and devconf.dat in / home/tsminst1/tsminst1. Also i copied the files .DBV on the dir /tsmbackup1/dbbackup_disk.
Then run the command:

<tsminst1@tsm:/home/tsminst1/tsminst1 > /opt/tivoli/tsm/server/bin/dsmserv removedb tsmdb1

and them:

<tsminst1@tsm:/home/tsminst1/tsminst1 > /opt/tivoli/tsm/server/bin/dsmserv restore db source=dbbackup todate=01/26/2012


ANR7800I DSMSERV generated at 10:49:41 on May 12 2010.


Tivoli Storage Manager for Linux/x86_64
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 20606.
ANR0900I Processing options file /home/tsminst1/tsminst1/dsmserv.opt.
ANR0000W dsmserv.c(1146) Unable to open file dsmserv.cat for language es_ES. Using language AMENG for message formatting.
ANR0000W dsmserv.c(1176) Unable to open file dsmserv.cat for language es_ES. Using language
AMENG for message formatting.
ANR7814I Using instance directory /home/tsminst1/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR1636W The server machine GUID changed: old value (), new value (47.62.66.2a.55.14.11.e2.95.9-
4.5c.f3.fc.6b.89.96).
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
ANR4634I Starting point-in-time database restore to date 01/26/2012 11:59:59 PM.
ANR2032E RESTORE DB: Command failed - internal server error detected.
ANR9999D Thread<1> issued message 2032 from:
ANR9999D Thread<1> 0x0000000000c3f466 outMsgf+0x0xb6
ANR9999D Thread<1> 0x000000000049505a AdmRestoreDb+0x0xaba
ANR9999D Thread<1> 0x000000000052a740 admRestoreDatabase+0x0x160
ANR9999D Thread<1> 0x000000000046d04b main+0x0x1b0b
ANR9999D Thread<1> 0x0000003aa6c1d9c4 *UNKNOWN*
ANR9999D Thread<1> 0x000000000046b2c9 *UNKNOWN*





Could not resolve this error code and I have to restore this database urgent.


I hope you can help me.


sorry for the English


Greetings!

 

[Harry_Redl]

Hello,

When you installed the new TSM server - have you initialized it fully? Does the TSM (DB2) instance exist? Anything in the DB2 logs (or system logs). Do you have the same version of the TSM server as the original? Have you copied (have you created) the correct dsm.sys/tsmdbmgr.opt files?

Harry

 

[siorellan]

thanks

Hello Harry, good afternoon.
Indeed the server was operating at 100%, the instance was configured correctly and properly configured DB2. the file Tsmdbmgr.opt was created but I copied the file of the server that I want to restore. The TSM server version was 6.2.1 and I created all routes as they appear both in the configuration files as in dsmserv.opt
I tried more than 10 times with different settings and different versions of TSM, but always appear the same error.
I will send the configuration files to review:


devconf.dat

/* Configuración de dispositivos */
DEFINE DEVCLASS DBBACKUP_DISK DEVT=FILE FORMAT=DRIVE MAXCAP=52428800K MOUNTL=1 DIR=/tsmbackup1/dbbackup_disk SHARE=NO
DEFINE DEVCLASS LTO_CLASS_1 DEVT=LTO FORMAT=DRIVE MOUNTL=DRIVES MOUNTWAIT=60 MOUNTRETENTION=60 PREFIX=ADSM LIBRARY=LTOIVTS3200 WORM=NO DRIVEENCRYPTION=ALLOW
SET SERVERNAME TSMDGAC.DGAC.CL
DEFINE LIBRARY LTOIVTS3200 LIBTYPE=SCSI SERIAL="00L2U78R9698_LL0" SHARED=NO AUTOLABEL=NO RESETDRIVE=NO
DEFINE DRIVE LTOIVTS3200 LTOV-1 ELEMENT=256 ONLINE=Yes WWN="5000E11147A4A001" SERIAL="1068013427"
DEFINE DRIVE LTOIVTS3200 LTOV-2 ELEMENT=257 ONLINE=Yes WWN="5000E11147A4A004" SERIAL="1068013667"
/* LIBRARYINVENTORY SCSI LTOIVTS3200 355BBGL5 4096 101*/
/* LIBRARYINVENTORY SCSI LTOIVTS3200 357BBGL5 4098 101*/
/* LIBRARYINVENTORY SCSI LTOIVTS3200 358BBGL5 4099 101*/
/* LIBRARYINVENTORY SCSI LTOIVTS3200 359BBGL5 4100 101*/
/* LIBRARYINVENTORY SCSI LTOIVTS3200 DGA006L5 4097 101*/
DEFINE PATH TSMDGAC.DGAC.CL LTOIVTS3200 SRCTYPE=SERVER DESTTYPE=LIBRARY DEVICE=/dev/IBMchanger0 ONLINE=YES
DEFINE PATH TSMDGAC.DGAC.CL LTOV-1 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=LTOIVTS3200 DEVICE=/dev/IBMtape0 ONLINE=YES
DEFINE PATH TSMDGAC.DGAC.CL LTOV-2 SRCTYPE=SERVER DESTTYPE=DRIVE LIBRARY=LTOIVTS3200 DEVICE=/dev/IBMtape1 ONLINE=YES
SERVERBACKUPNODEID 1

Volhist.dat

* Sequential Volume Usage History
* Updated 27/01/12 12:33:23

Operation Date/Time: 2011/10/06 09:59:02

Volume Type: BACKUPFULL
* Location for volume /tsmbackup1/dbbackup_disk/27572030.DBV is: ''
LLA copia de seguridad base de datos: FULL_BACKUP.20120126070027.1
HLA copia de seguridad base de datos: /NODE0000/
Nombre de volumen: "/tsmbackup1/dbbackup_disk/27572030.DBV"
Backup Series: 115
Backup Op: 0
Volume Seq: 1
Device Class Name: DBBACKUP_DISK
ID copia de seguridad base de datos: 0 , 351233
Posición inicial de copia de seguridad base de datos: 0
Bytes de datos totales de copia seguridad base de datos: 0 , 671256587
Bytes de registro totales de copia seguridad base de datos: 0 , 33583115
Número de bloque de registro de copia seguridad base de datos: -1 , -1
**************************************************
Operation Date/Time: 2012/01/26 07:00:27

Volume Type: BACKUPFULL
* Location for volume /tsmbackup1/dbbackup_disk/27572054.DBV is: ''
LLA copia de seguridad base de datos: FULL_BACKUP.20120126070027.2
HLA copia de seguridad base de datos: /NODE0000/
Nombre de volumen: "/tsmbackup1/dbbackup_disk/27572054.DBV"
Backup Series: 115
Backup Op: 0
Volume Seq: 2
Device Class Name: DBBACKUP_DISK
ID copia de seguridad base de datos: 0 , 351234
Posición inicial de copia de seguridad base de datos: 0
Bytes de datos totales de copia seguridad base de datos: 0 , 671256587
Bytes de registro totales de copia seguridad base de datos: 0 , 33583115
Número de bloque de registro de copia seguridad base de datos: -1 , -1
**************************************************
Operation Date/Time: 2012/01/27 07:00:22

Volume Type: BACKUPFULL
* Location for volume /tsmbackup1/dbbackup_disk/27658425.DBV is: ''
LLA copia de seguridad base de datos: FULL_BACKUP.20120127070022.1
HLA copia de seguridad base de datos: /NODE0000/
Nombre de volumen: "/tsmbackup1/dbbackup_disk/27658425.DBV"
Backup Series: 116
Backup Op: 0
Volume Seq: 1
Device Class Name: DBBACKUP_DISK
ID copia de seguridad base de datos: 0 , 352257
Posición inicial de copia de seguridad base de datos: 0
Bytes de datos totales de copia seguridad base de datos: 0 , 671256587
Bytes de registro totales de copia seguridad base de datos: 0 , 16801803
Número de bloque de registro de copia seguridad base de datos: -1 , -1
**************************************************
Operation Date/Time: 2012/01/27 07:00:22

Volume Type: BACKUPFULL
* Location for volume /tsmbackup1/dbbackup_disk/27658449.DBV is: ''
LLA copia de seguridad base de datos: FULL_BACKUP.20120127070022.2
HLA copia de seguridad base de datos: /NODE0000/
Nombre de volumen: "/tsmbackup1/dbbackup_disk/27658449.DBV"
Backup Series: 116
Backup Op: 0
Volume Seq: 2
Device Class Name: DBBACKUP_DISK
ID copia de seguridad base de datos: 0 , 352258
Posición inicial de copia de seguridad base de datos: 0
Bytes de datos totales de copia seguridad base de datos: 0 , 671256587
Bytes de registro totales de copia seguridad base de datos: 0 , 16801803
Número de bloque de registro de copia seguridad base de datos: -1 , -1
**************************************************


dsmserv.opt

COMMMethod TCPIP
TCPPort 1500


DEVCONFIG devconf.dat
VOLUMEHISTORY volhist.dat
TCPADMINPort 1500


MIRRORLOGDirectory /opt/tsmlogmirror
ARCHFAILOVERLOGDirectory /opt/tsmarchlogfailover
ACTIVELOGDirectory /opt/tsmlog
ARCHLOGDirectory /opt/tsmarchlog
ACTIVELOGDirectory /tivoli/archivelog
LANGUAGE AMENG


ACTIVELOGDirectory /home/tsminst1/tsmlog
ARCHLOGDirectory /home/tsminst1/tsmarchlog



I hope you can help me.


Greetings! and Thanks!

 

[Harry_Redl]

Hi,

I do not see any obvious error right now. You said you have initialized the TSM server (the instance you are overwriting now) - have you tried backing up its database (to see if DB backup settings are correct)?
What about rights on all the files? Are they readable for tsminst1 user?
Unlikely but possible - what about missing es_ES language package?

Harry

 

[siorellan]

Thanks Harry, i used the PRM services of IBM. They help me to resolve this puzzle