Manage DB2 backups retention policy

How can I manage a DB2 database backup retention policy if the database is configured to use TSM . I understand I can manage the old backups through a script , but I’d prefer if DB2 managed the process? DB2 manages backup files and the retention policy using built-in database configuration parameters. Since DB2 9.5 , three parameters are available to manage the retention policy and automatic deletion of backup images. Number of database backups to retain (NUM_DB_BACKUPS) = 10 Recovery history retention (days) (REC_HIS_RETENTN) = 10 Auto deletion of recovery objects (AUTO_DEL_REC_OBJ) = ON This example removes database history... Read more →

SQL2025N An IO error -50 occurred on media TSM

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... Read more →