SQL2025N An IO error -50 occurred on media TSM

13 August,2013 by Jack Vamvas

Question: During a scheduled DB2 backup the SQL2025N appeared

 

db2 backup db MYDB online use TSM include logs

SQL2025N  An IO error -50 occurred on media TSM.

 

Some extra information:

1)     The backup has been running as expected for the last few months

2)     The DB2 backup occurs during a busy backup window

 

Answer:  There are a number of configurations to check , such as any recent firewall changes.

If no changes occurred which block the backup , try increasing the COMMTIMEOUT and IDLETIMEOUT parameters

From the Tivoli TSM documentation :

The COMMTIMEOUT option specifies how long the server waits for an expected client message during an operation that causes a database update. If the length of time exceeds this time-out, the server ends the session with the client. You may want to increase the time-out value to prevent clients from timing out. Clients may time out if there is a heavy network load in your environment or they are backing up large files.

The IDLETIMEOUT option specifies the amount of time, in minutes, that a client session can be idle before the server cancels the session. You may want to increase the time-out value to prevent clients from timing out if there is a heavy network load in your environment. Note, however, that a large number of idle sessions could prevent other users from connecting to the server.

Increase the COMMTIMEOUT and IDLETIMEOUT parameters located in the dsmserv.opt file on the TSM server or dsm.sys

I normally change the COMMTimeout to a large number such as 6 hrs (21600)

Note:

COMMTimeout   (seconds)

IDLETimeout       (minutes)

Read More

TSM backup client configuration for DB2 on Linux - DBA DB2

DB2 and TSM Cross-node recovery - DBA DB2

TSM losing connection with DB2 - DBA DB2

DB2 - SQL2033N and TSM reason code: 610 - DBA DB2

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL2025N An IO error -50 occurred on media TSM

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright