Restore TSM DB Failed (6.3.3)

[bigred15]

Hi Guys,

Trying to move across my TSM instance to do a different physical server. Both are TSM 6.3.3.1.

I've tried restoring the database on the new server; however, I get the error below.

ANR1363I Input volume E:\TSMDBBKP\64340737.DSS opened (sequence number 1).
ANR0403I Session 1 ended for node $$_TSMDBMGR_$$ (DB2/NT64).
ANR2971E Database backup/restore/rollforward terminated - DB2 sqlcode -2025
error.
ANR2032E RESTORE DB: Command failed - internal server error detected.
ANR9999D Thread<0> issued message 2032 from:
ANR9999D Thread<0> 000007FEE9A4B4DE outMsgf()+3e
ANR9999D Thread<0> 000007FEE92B8BB6 AdmRestoreDb()+1306
ANR9999D Thread<0> 000007FEE924CA77 admRestoreDatabase()+187
ANR9999D Thread<0> 000007FEE9231322 psPostCleanup()+272
ANR9999D Thread<0> 000007FEE9233501 adsmMain()+f11
ANR9999D Thread<0> 000000013FDA111B main()+9b dsmserv.c:241
ANR9999D Thread<0> 000000013FDA28DA __tmainCRTStartup()+11a crtexe.c:555
ANR9999D Thread<0> 00000000775EF34D BaseThreadInitThunk()+d
ANR9999D Thread<0> 0000000077B82CA1 RtlUserThreadStart()+21


db2diag.log file output:

2013-03-27-11.52.43.456000+660 E140246F460 LEVEL: Warning
PID : 6172 TID : 6336 PROC : db2fmp64.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 6336
FUNCTION: DB2 UDB, Health Monitor, HealthIndicator::update, probe:500
MESSAGE : ADM10502W Health indicator "Table Space Operational State"
("ts.ts_op_status") is in state "Restore pending" on "table space"
"SERVER1.TSMDB1 .USERSPACE1".


2013-03-27-12.02.46.357000+660 I140708F443 LEVEL: Warning
PID : 1368 TID : 1468 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1468 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfDynamicResourceMgr::AdjustResources, probe:100
DATA #1 : <preformatted>
FCM Automatic/Dynamic Resource Adjustment (Channel): 256 will be released; new total will be 768


2013-03-27-12.32.49.787000+660 I141153F443 LEVEL: Warning
PID : 1368 TID : 1468 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1468 EDUNAME: db2sysc
FUNCTION: DB2 UDB, fast comm manager, sqkfDynamicResourceMgr::AdjustResources, probe:100
DATA #1 : <preformatted>
FCM Automatic/Dynamic Resource Adjustment (Channel): 128 will be released; new total will be 640


2013-03-27-12.51.39.616000+660 E141598F410 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvget, probe:907
DATA #1 : TSM RC, PD_DB2_TYPE_TSM_RC, 4 bytes
TSM RC=0x00000088=136 -- see TSM API Reference for meaning.


2013-03-27-12.51.39.616000+660 I142010F347 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluvget, probe:914
MESSAGE : Error during subsequent get call.


2013-03-27-12.51.39.616000+660 E142359F474 LEVEL: Info
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluReadFromVendorDevice, probe:223
DATA #1 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x00000019=25 -- see DB2 API Guide for meaning.
DATA #2 : signed integer, 4 bytes
12587008


2013-03-27-12.51.39.616000+660 I142835F749 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:655
DATA #1 : String, 125 bytes
Vendor error: rc = 25 returned from function sqluvget.
Return_code structure from vendor library C:\TSM\db2\bin\db2tsm.dll:


DATA #2 : Hexdump, 48 bytes
0x00000000173FE618 : 8800 0000 3930 3720 3133 3600 0000 0000 ....907 136.....
0x00000000173FE628 : 0000 0000 0000 0000 0000 0000 0000 0000 ................
0x00000000173FE638 : 0000 0000 0000 0000 0000 0000 0000 0000 ................


2013-03-27-12.51.39.616000+660 I143586F381 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMapVend2MediaRCWithLog, probe:695
MESSAGE : Error in vendor support code at line: 907 rc: 136


2013-03-27-12.51.39.616000+660 E143969F381 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1451
MESSAGE : Media controller -- problem reading from vendor device


2013-03-27-12.51.39.616000+660 E144352F428 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1451
MESSAGE : SQL2025N An I/O error occurred. Error code: "". Media on which this
error occurred: "".


2013-03-27-12.51.39.616000+660 E144782F351 LEVEL: Error
PID : 1368 TID : 1564 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000
EDUID : 1564 EDUNAME: db2med.4108.0 (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqluMCReadFromDevice, probe:1451
DATA #1 : String, 7 bytes
136.TSM


2013-03-27-12.51.39.616000+660 E145135F537 LEVEL: Error
PID : 1368 TID : 4108 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-11 APPID: *LOCAL.SERVER1.130327004332
AUTHID : ADMINISTRATOR
EDUID : 4108 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqludMRResponse, probe:869
MESSAGE : SQL2025N An I/O error occurred. Error code: "136". Media on which
this error occurred: "TSM".


2013-03-27-12.51.40.396000+660 E145674F443 LEVEL: Severe
PID : 1368 TID : 4108 PROC : db2syscs.exe
INSTANCE: SERVER1 NODE : 000 DB : TSMDB1
APPHDL : 0-11 APPID: *LOCAL.SERVER1.130327004332
AUTHID : ADMINISTRATOR
EDUID : 4108 EDUNAME: db2agent (TSMDB1)
FUNCTION: DB2 UDB, database utilities, sqludrsa, probe:800
MESSAGE : Restore Terminated.





Any ideas on this one guys?

Thanks in advance.

Cheers,
bigred

 

[tsm_dude]

Hi,

Have you read the other post about this, a few lines down ? its in BCP/BRP section. It sounds like your devconfig is the issue.
Check that post as lots of useful info.

regards,
tsm_dude

 

[bigred15]

Hey tsm_dude,

Thanks for your prompt reply. I had not seen the other post to be honest, but it doesn't really matter, as I have resolved the issue.

I resolved it by re-running the TSM restore, and this time it worked.

I wish I knew why so I could at least write a proper response for anyone else that comes about this error.

Cheers,

bigred

 

[bhaven41]

Hi,

I am getting the exact error while recovering TSM DB backup to a different server. Can you provide more details - what was done to fix this?

Thanks..


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





MESSAGE : SQL2025N An I/O error occurred. Error code: "". Media on which this
error occurred: "".
MESSAGE : SQL2025N An I/O error occurred. Error code: "136". Media on which
this error occurred: "TSM".

 

[bigred15]

Hey bhaven41,

Nothing was really done to resolve it, I just re-ran the restore and it worked the second time around :|
I couldn't find anything in the logs which suggested what the problem was.

If you post up all your logs, devconfig, volhistory, dsmserv.opt file then I can try and assist you.

Cheers,
bigred15

 

[bhaven41]

Hi bigred15,

It is strange - something which I can not understand. I tried it few times and it worked at the end. No changes in the environment. I have tired this few times in last 2 months, half of the times it did not work(same error as above) and half of the times it worked. I really do not understand what is going wrong.


Below message indicates communication protocol error but not sure which protocol/at which layer? I shall keep an eye on SAN switch port error next time I try this.



MESSAGE : SQL2025N An I/O error occurred. Error code: "136". Media on which
this error occurred: "TSM".


#define DSM_RC_COMM_PROTOCOL_ERROR 136 /* communications protocol error */

 

[SniperKing]

Hi,

I believe this may be related to the network connection issues / management class issues. Check these from IBM site recommendation.

http://www-01.ibm.com/support/docview.wss?uid=swg21208412

 

[bhaven41]

Hi SniperKing,

The article points to error "-50" - which is connection issue.
SQL2025N: An I/O error "-50" occurred on media "TSM".

#define DSM_RC_TCPIP_FAILURE -50 /* TCP/IP communications failure */

(* Anyway I had modified the these values but it did not help)

I am getting error code 136.

SQL2025N An I/O error occurred. Error code: "136". Media on which
this error occurred: "TSM"


Do let me know if you find any article on error "136"

 

[SniperKing]

Hi SniperKing,

The article points to error "-50" - which is connection issue.
SQL2025N: An I/O error "-50" occurred on media "TSM".

#define DSM_RC_TCPIP_FAILURE -50 /* TCP/IP communications failure */



I am getting error code 136.

SQL2025N An I/O error occurred. Error code: "136". Media on which
this error occurred: "TSM"


Do let me know if you find any article on error "136"

Hi,
Here you are~ The 136 code should be the error return code from TSM api.

http://publib.boulder.ibm.com/tividd/td/TSMM/SC32-9090-01/en_US/HTML/anrcms5526.htm

136E DSM_RC_COMM_PROTOCOL_ERROR
Explanation:
Communications protocol error. An unexpected communications message was received by the client.

System Action:
TSM canceled the current operation.

User Response:
Verify that your communication path is functioning properly. If the problem continues, have your service representative check for a possible program error.

 

[bhaven41]

Thanks SniperKing , I saw that however did not get any clue how to solve it.

I may do a few tests again to reproduce the problem..