SQL2025N An I/O error "-40" occurred on media "TSM".

[jip102]

hi all!
While I restore db redirect, the error occured.
SQL2025N An I/O error "-40" occurred on media "TSM".

in db2diag.log
2006-05-20-11.32.25.208470 Instance:crmsprod Node:000
PID:20790(db2med.36982.1 0) TID:1 Appid:none
database utilities sqluMCReadFromDevice Probe:102

Media controller -- problem reading from vendor device

2006-05-20-11.53.07.075054 Instance:crmsprod Node:000
PID:36982(db2agent (CRMSDB) 0) TID:1 Appid:*LOCAL.crmsprod.072B10004542
database utilities sqludrsa Probe:110 Database:CRMSDB

Restore Terminated.

and again When I restore redirect db
SQL2025N An I/O error "-14" occurred on media "TSM".

Do you know this error reason?

 

[MarcLodge]

From a quick Google, this appears to be a Tivoli Service Manager error. You should have a TSM Server that may provide you with more diagnostic info in the log.

http://publib.boulder.ibm.com/infocenter/tivihelp/v1r1/index.jsp

will give you a number of books on TSM, including error messages, but I must admit I couldn't see a -40.

http://publib.boulder.ibm.com/infoc....jsp?topic=/com.ibm.itsmc.doc/ansa0000149.htm

will give the the error return codes from API calls, but it infuriatingly has not got a -40 - it's got a load of minus messages, but not that one.

I'd probably have a word with whoever administers your Tivoli Service Manager and ask them if there is a known problem with it (like someone switched it off!).

Hope this helps.

Marc