IC73231: DELETE VOLHISTORY DOES NOT RETURN DBBACKUP VOLUMES TO SCRATCH

APAR status

• Closed as program error.

Error description

• If a DB backup failed and if the volumes have been allocated for
  this DB backup as DBBACKUP private volumes,
  these volume will get orphaned.  After the delete volhist was
  issued, these volumes will not be put back to scratch.
  .
  For example:
  The DB2 APAR IC65595 can cause the DB backup to fail -2428 at a
  late stage of the DB backup.
  The tape volume has been allocated as dbbackup private volume.
  Since the DB backup failed, the Tivoli Storage Manager did not
  return these volumes to scratch.
  .
  See also technote 1444358:
  Database Backup might fail with DB2 error SQL2428 due to DB2
  APAR IC65595
  http://www-01.ibm.com/support/docview.wss?uid=swg21444358
  .
  Tivoli Storage Manager Versions Affected:
  Tivoli Storage Manager  server 6.1 and 6.2 on all platforms
  .
  Initial Impact:
  medium
  .
  Additional Keywords:
  zz61 zz62 TSM DB2 IC65595
  

Local fix

• - Generate a list of volumes from QUERY LIBVOLUME for all
    volumes with  "Last Use" equal "DbBackup"
  - Take off all volumes from the list above from volumes find in
    QUERY VOLUMEHISTOTY TYPE=DBBACKUP
  - Checkout the volumes from found list: CHECKOUT LIBVOLUME with
    options REMOVE=NO and CHECKLABEL=NO
  - Checkin these volumes with LABEL LIBVOLUME with options
    CHECKIN=SCRATCH and OVERWRITE=YES
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All Tivoli Storage Manager server users.     *
  ****************************************************************
  * PROBLEM DESCRIPTION: See error description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This      *
  *                 problem is currently projected to be fixed   *
  *                 in levels  6.1.5 and 6.2.3. Note that this   *
  *                 is                                           *
  *                 subject to change at the discretion of IBM.  *
  ****************************************************************
  *
  

Problem conclusion

• This problem was fixed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  TSM SERVER

• Fixed component ID

  5698ISMSV

Applicable component levels

• R61A PSY

     UP

• R61H PSY

     UP

• R61L PSY

     UP

• R61S PSY

     UP

• R61W PSY

     UP

• R62A PSY

     UP

• R62H PSY

     UP

• R62L PSY

     UP

• R62S PSY

     UP

• R62W PSY

     UP