IBM Support

Restore DB fails with DB2 sqlcode -1035 error on UNIX system

Troubleshooting


Problem

Tivoli Storage Manager failing restore DB command

Diagnosing The Problem

Command and error:
$ /opt/tivoli/tsm/server/bin/dsmserv restore db

ANR7801I Subsystem process ID is 23880.
ANR7814I Using instance directory /opt/tivoli/tsm/server/tsminst1.
ANR4726I The ICC support module has been loaded.
ANR1636W The server machine GUID changed: old value (), new value (xxx).
ANR8200I TCP/IP Version 4 driver ready for connection with clients on port 1500.
ANR1794W TSM SAN discovery is disabled by options.
ANR4636I Starting roll-forward database restore.
ANR4620I Database backup series 1207 operation 0 device class 3592DEV.
ANR8337I 3592 volume xxxx mounted in drive RMT2 (/dev/rmt/5st).
ANR1363I Input volume xxxx opened (sequence number 1).
ANR1364I Input volume xxxx closed.
ANR4638I Restore of backup series 1207 operation 0 in progress.
ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -1035 error.

Resolving The Problem

ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -1035 error.

The aqlcode is:
SQL1035N The database is currently in use.

From the instance user account, do:
db2stop

Once DB2 has stopped, then do the restore command again:


dsmserv restore db

[{"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Server","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"}],"Version":"6.3;7.1","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Product Synonym

TSM IBM Spectrum Protect

Document Information

Modified date:
17 June 2018

UID

swg21421852

Page Feedback