DB2 restore using IBM Spectrum Protect Client API fails with SQL2025N

Troubleshooting

Problem

DB2 LAN-free restore via IBM Spectrum Protect Client API fails with following error message:

$ db2 "restore db TESTDB use tsm TAKEN AT 20200920235657 TO /dbdir LOGTARGET /dblog/TESTDB NEWLOGPATH /dblog/TESTDB"
SQL2025N An I/O error occurred. Error code: "30". Media on which this error occurred: "TSM".

Symptom

Only the following errors are logged in the db2diag*.log file during the restore time frame, while no other errors are seen in client, storage agent or server side logs.

..............

2020-09-23-09.29.21.512335+480 E1077683A558 LEVEL: Error
PID : 5767456 TID : 72291 PROC : db2sysc 0
INSTANCE: db2test NODE : 000 DB : TESTDB
APPHDL : 0-2290 APPID: *LOCAL.db2test.200923012406
AUTHID : DB2TEST HOSTNAME: DB2S01
EDUID : 72291 EDUNAME: db2agent (TESTDB) 0
FUNCTION: DB2 UDB, database utilities, sqludMRResponse, probe:988
MESSAGE : SQL2025N An I/O error occurred. Error code: "30". Media on which
this error occurred: "TSM".

..............

Document Location

Worldwide

[{"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":"a8m0z00000006kmAAA","label":"Data Protection (DP)-\u003EDB2"}],"ARM Case Number":"TS004176299","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)"}]

Log InLog in 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 Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Historical Number

Case TS004176299

Was this topic helpful?

Document Information

Modified date:
02 November 2020

UID

ibm16347168

Tips