Troubleshooting
Problem
IBM Spectrum Protect server "dsmserv restore db" fails with following error message:
ANR2970E Database rollforward terminated - Db2 sqlcode -1218 sqlerrmcSymptom
The following operation is performed smoothly until it failed in the last minute.
dsmserv restore db todate=07/21/2022 totime=00:15:32 on=/home/tsminst1/tsminst1/dbdirs.txt activelogdir=/tsminst1/actlog recoverydir=/tsminst1/dbb/RECOVERYDIR s=dbs restorekeys=yes password=PASSWORD prompt=noThe following messages are seen in the restore console:
IBM Spectrum Protect for Linux/x86_64
Version 8, Release 1, Level 12.122Licensed Materials - Property of IBM(C) Copyright IBM Corporation 1990, 2021.
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 49269.
ANR0900I Processing options file /home/tsminst1/tsminst1/dsmserv.opt.
ANR7814I Using instance directory /home/tsminst1/tsminst1.
ANR3339I Default Label in key data base is TSM Server SelfSigned SHA Key.
ANR4726I The ICC support module has been loaded.
ANR8598I Outbound SSL Services were loaded.
ANR8230I TCP/IP Version 6 driver ready for connection with clients on port 1500.
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
ANR4916I Starting point-in-time database restore snapshot to date 07/21/2022 12:15:32 AM.
ANR4591I Selected backup series 67 from 07/21/2022 and 12:15:32 AM as best candidate available for restore database processing.
ANR8955I Drive DRIVE0 in library TS4300 with serial number is updated with the newly discovered serial number aaaaaaaaaa.
ANR8955I Drive DRIVE1 in library TS4300 with serial number is updated with the newly discovered serial number bbbbbbbbbb.
ANR8955I Drive DRIVE2 in library TS4300 with serial number is updated with the newly discovered serial number cccccccccc.
ANR8955I Drive DRIVE3 in library TS4300 with serial number is updated with the newly discovered serial number dddddddddd.
ANR4592I Restore database backup series 67 includes eligible operation 0 with volume XXXX having sequence 100001 and using device class LTO.
ANR4598I Validating database backup information for selected backup series 67 and operation 0 using volume XXXX.
ANR8337I LTO volume XXXX mounted in drive DRIVE0 (/dev/IBMtape0).
ANR1363I Input volume XXXX opened (sequence number 1).
ANR4609I Restore database process found FULL database backup timestamp 20220721001532 from database backup media.
ANR1364I Input volume XXXX closed.
ANR3008I Database backup was written using client API: 8.1.9.0.
ANR4638I Restore of backup series 67 operation 0 in progress.
ANR4897I Database restore of operation 0 will use device class LTO and attempt to use 1 streams.
ANR8592I Session 1 connection is using protocol TLSV12, cipher specification TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, certificate TSM Self-Signed Certificate.
ANR0406I Session 1 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (SSL localhost[127.0.0.1]:47144).
ANR8468I LTO volume XXXX dismounted from drive DRIVE0 (/dev/IBMtape0) in library TS4300.
ANR8337I LTO volume XXXX mounted in drive DRIVE1 (/dev/IBMtape1).
ANR0510I Session 1 opened input volume XXXX.
ANR1363I Input volume XXXX opened (sequence number 1).
ANR4912I Database Restore DB in progress and total bytes transferred 1,073,741,825.......ANR4912I Database Restore DB in progress and total bytes transferred 6,660,420,534,273.
ANR4912I Database Restore DB in progress and total bytes transferred 6,661,494,276,086.
ANR1364I Input volume XXXX closed.
ANR0514I Session 2 closed volume XXXX.
ANR0403I Session 2 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR8592I Session 3 connection is using protocol TLSV12, cipher specification TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384, certificate TSM Self-Signed Certificate.
ANR0406I Session 3 started for node $$_TSMDBMGR_$$ (DB2/LINUXX8664) (SSL localhost[127.0.0.1]:47148).
ANR0403I Session 3 ended for node $$_TSMDBMGR_$$ (DB2/LINUXX8664).
ANR2970E Database rollforward terminated - Db2 sqlcode -1218 sqlerrmc
ANR8468I LTO volume XXXX dismounted from drive DRIVE1 (/dev/IBMtape1) in library TS4300.Document Location
Worldwide
[{"Type":"MASTER","Line of Business":{"code":"LOB69","label":"Storage TPS"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEQVQ","label":"IBM Spectrum Protect"},"ARM Category":[{"code":"a8m3p000000hAaeAAE","label":"Server-\u003EDatabase Restore"}],"ARM Case Number":"TS010068895","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]
To view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use the link to actual document below to access the full document. You will be asked to log on if you are not already logged in. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Was this topic helpful?
Document Information
More support for:
IBM Spectrum Protect
Component:
Server->Database Restore
Software version:
All Versions
Document number:
6609274
Modified date:
12 August 2022
UID
ibm16609274
Manage My Notification Subscriptions