• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

SQL2025N An I/O error "-72" occurred on media "TSM" on DB2 onoline backup

AjM

ADSM.ORG Member
Joined
Jan 19, 2009
Messages
132
Reaction score
2
Points
0
Location
Mexico
Hi,

DB2 backup fails with this error message during db2 onlibe backup, sometime works fine.

Also appears this errors on db2diag


2012-08-28-01.15.08.200119-300 E234044483A380 LEVEL: Error
PID : 15335614 TID : 21929 PROC : db2sysc 0
INSTANCE: db2p01 NODE : 000
EDUID : 21929 EDUNAME: db2med.17736.0 (P01) 0
FUNCTION: DB2 UDB, database utilities, sqluMCWriteToDevice, probe:930
MESSAGE : Media controller -- problem writing to vendor device. rc = -2025


2012-08-28-01.15.08.236825-300 E234047007A462 LEVEL: Error
PID : 15335614 TID : 17736 PROC : db2sysc 0
INSTANCE: db2p01 NODE : 000 DB : P01
APPHDL : 0-4723 APPID: *LOCAL.db2p01.120828051433
AUTHID : DB2P01
EDUID : 17736 EDUNAME: db2agent (P01) 0
FUNCTION: DB2 UDB, database utilities, sqlubMWResponse, probe:970
MESSAGE : SQL2025N An I/O error "-72" occurred on media "TSM".

2012-08-28-01.15.14.852336-300 E234047470A448 LEVEL: Error
PID : 21364818 TID : 1 PROC : db2vend
INSTANCE: db2p01 NODE : 000
EDUID : 1
FUNCTION: DB2 UDB, database utilities, sqluvDoQueryAndDelete, probe:2762
DATA #1 : Vendor RC, PD_DB2_TYPE_VENDOR_RC, 4 bytes
Vendor RC=0x00000006=6 -- see DB2 API Guide for meaning.
MESSAGE : Could not find any objects to delete.
DATA #2 : signed integer, 8 bytes
0



2012-08-28-01.15.16.111932-300 E234048853A592 LEVEL: Error
PID : 15335614 TID : 17736 PROC : db2sysc 0
INSTANCE: db2p01 NODE : 000 DB : P01
APPHDL : 0-4723 APPID: *LOCAL.db2p01.120828051433
AUTHID : DB2P01
EDUID : 17736 EDUNAME: db2agent (P01) 0
FUNCTION: DB2 UDB, database utilities, sqlubCleanupPartialBackup, probe:708
MESSAGE : SQL2062N An error occurred while accessing media "". Reason code:"".
DATA #1 : String, 63 bytes
Could not delete partial backup image created on vendor device.



Any ideas?

Thabks in advance.
 

Attachments

AjM

ADSM.ORG Member
Joined
Jan 19, 2009
Messages
132
Reaction score
2
Points
0
Location
Mexico
Found this on tsm log

ANR0538I A resource waiter has been aborted.

On past days, set this values on dsmserv.out and dsmsta.opt

idletimeout 60
commtimeout 3600
resourcetimeout 60

this is a lanfree backup.
 

opermty

ADSM.ORG Senior Member
Joined
Jan 23, 2010
Messages
219
Reaction score
10
Points
0
Location
San Nicolas de los Garza NL
Website
www.gnsys.com.mx
please check this and let us know if it working for you

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

Resolving the problem
Exceeding the COMMTIMEOUT setting on the Tivoli Storage Manager Server is a common problem during DB2 redirected restores. The problem occurs because DB2 spends time rebuilding the containers that the backup data will be restored into. For large databases, this process can take over an hour, and the Tivoli Storage Manager session will remain in a SendW state for this time period which is counted against the COMMTIMEOUT option.

For the restore to be successful, increase the COMMTIMEOUT on the Tivoli Storage Manager Server using the command SETOPT COMMTIMEOUT. This value should be increased to at least 3600, and may need to be set over 10000 seconds for very large (over 200GB) databases.

NOTE: If this is a LANFREE restore, the error might be reported as a -72. In this case, the COMMTIMEOUT and IDLETIMEOUT values would need to be increased on the Storage Agent, also.

regards
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

DigitalOcean $100 Credit

Support ADSM.ORG and get DigitalOcean FREE credit. DigitalOcean currently offer a $100, 60-day Free Credit for new accounts. Sign-up here:

DigitalOcean Referral Badge

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 20 18.7%
  • Keep using TSM for Spectrum Protect.

    Votes: 65 60.7%
  • Let's be formal and just say Spectrum Protect

    Votes: 13 12.1%
  • Other (please comement)

    Votes: 9 8.4%

Forum statistics

Threads
31,897
Messages
135,988
Members
21,783
Latest member
london
Top