IC67276: EXPIRATION PERFORMANCE DEGRADED WHEN PROCESSING ARCHIVED DATA.

IBM Tivoli Storage Manager V6.1 Fix Pack 4 (6.1.4) Server Downloads

APAR status

• Closed as program error.

Error description

• Expiration processing performance of archived data can degrade
  over time as directory objects are added to the TSM server, but
  not deleted, even though they are not referenced anymore.
  
  This problem only occurs when using the backup/archive client to
  archive filesystem data. The TSM API is not affected.
  
  TSM Versions Affected: All 6.1 servers/platforms.
  
  Customer/L2 Diagnostics:
  Tracing the server with IMEXP DBSTMT traceflags will return
  output similiar to the following:
  HH:MM:SS.TTT [XXXXX][imdmgr.c][2634][ExpireArchiveData]:
    ExpirationProcessThread: Calling fetchNext.
  HH:MM:SS.TTT [XXXXX][tbcli.c][4130][RdbPrepareAndExecuteStmt]:
    Executing statement 'SELECT NODEID,FSID,OBJTYPE,HL,LL,INSDATE,
    OBJID,RETINIT_DATE,OBJINFO,BFSIZE,BKSETRET,HELD,VOLDATEGMT,
    ALIASOF FROM "TSMDB1"."ARCH_EXPDIRS" WHERE (NODEID=? AND
    FSID=? AND OBJTYPE=? AND OBJID>=? AND RETINIT_DATE<=? AND
    MCID=? AND CGID=?) FOR READ ONLY WITH UR --35799' submitted
    from imdmgr.c(2636).
  HH:MM:SS.TTT [XXXXX][tbcli.c][4635][RdbFetchAndGetNextResponse]:
   Performing fetch for imdmgr.c(2636) : 'SELECT NODEID,FSID,
   OBJTYPE,HL,LL,INSDATE,OBJID,RETINIT_DATE,OBJINFO,BFSIZE,
   BKSETRET,HELD,VOLDATEGMT, ALIASOF FROM "TSMDB1"."ARCH_EXPDIRS"
   WHERE (NODEID=? AND FSID=? AND OBJTYPE=? AND OBJID>=? AND
   RETINIT_DATE<=? AND MCID=? AND CGID=?) FOR READ ONLY WITH UR
   --35799'
  
  Initial Impact: Medium
  
  Additional Keywords:
  zz61 dirs directory directories expire expiration perf
  

Local fix

• Run expiration processing with the SKIPDIRS=YES parameter to
  shorten processing time if needed.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All users of IBM Tivoli Storage Manager      *
  *                 Server.                                      *
  ****************************************************************
  * PROBLEM DESCRIPTION: See Error Description.                  *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available.  This     *
  *                 problem is currently projected to be fixed   *
  *                 in server level 6.1.3.4, 6.1.4, and 6.2.1.   *
  *                  Note that this is subject to change at      *
  *                 the discretion of IBM.                       *
  ****************************************************************
  See Error Description.
  

Problem conclusion

• The performance has been improved.
  Affected Platforms: AIX, HP-UX, Sun Solaris, Linux, 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:

Modules/Macros

• IMDEFS   IMVIEW   TBDEFS   IMARQRY  TBTBL    TBREPAIR
  

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