IC67117: TSM 6.1 UPGRADE UTILITY SETS THE BACKUPSET RETENTION TO UNLIMITED.

APAR status

• Closed as program error.

Error description

• During the IBM Tivoli Storage Manager 6.1 upgrade using
  the upgrade utilities, in some cases the retention initiation
  date for backup sets to NULL, causing the upgraded server to
  think that the backup sets are to be retained forever. Which
  means that the backupsets are to be retained for unlimited
  period.
  
  This happens under a specific set of circumstances:
  - The upgraded server was initially created by a TSM level
  earlier than 5.3.6 or 5.4.2,
  - The server is used for Archive in addition to Backup, and
  - The REPAIR EXPIRATION utility was never run to correct the
  problems identified by APAR IC53075.
  
  
  TSM Versions Affected:
  TSM client V6.1 on all Linux Platform.
  
  Initial impact: Medium
  
  Additional Keywords:
  backupset retention unlimited zz61
  

Local fix

• - On servers that have already been upgraded to V6 and exhibit
  this problem, a DB2 SQL statement
  can be executed to fix the database entries in error:
  
       update tsmdb1.archive_objects set retinit_date=insdate
  where retinit_date is null and objtype in (6, 22)
  
    Note that the TSM database must be backed up before attempting
  this repair action, and the TSM
  server must be halted while it is being performed.
  
  - For servers that have not yet been upgraded, but that might
  exhibit this problem upon being
  upgraded:
    -- Specify the EVENTBASEDUSED=NEVER parameter on the DSMUPGRD
  EXTRACTDB command.   However, do
  not do this if there is any chance that event based archive
  retention has ever been used on the
  server.  Instead,
    -- Run the command "REPAIR EXPIRATION * TYPE=ARCHIVE
  EVENTBASEUSED=FIX FIX=YES" prior to
  upgrading.  Note that this command inspects every archive object
  stored on the server, and so can
  take a long time to complete, depending on the number of archive
  objects stored.
  

Problem summary

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

Problem conclusion

• The V6 database upgrade was modified to correctly process backup
  
  set retention initiation dates.
  
  In addition, a new command
  
    REPAIR BACKUPSETS
  
  was added to repair the retention initiation date for any backup
  
  set whose retention initiation date was set to NULL by database
  upgrade.
  
  REPAIR BACKUPSETS (Repair retention initiation dates for
  backup sets)
  
  Use this command to reset the retention initiation date for
  backup sets whose retention initiation date was set to NULL by
  the V6 database upgrade (the DSMSERV INSERTDB command).
  
  Privilege class
  
  To issue this command, you must have system privilege.
  
  Syntax
  
  >>-REPAIR BACKUPSETs---------------------------------------><
  
  Parameters
  
  None
  
  Affected platforms:  AIX, HP-UX, Sun Solaris, Linux, and
  Windows.
  

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