IBM Support

IC97786: UNEXPECTED DATABASE GROWTH ON REPLICATION TARGET SERVERS CAUSED BY ORPHANED GROUP_LEADERS RECORDS.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • A Tivoli Storage Manager replication target server might see
    unexpected database growth compared to the replication source
    server.
    
    The symptom is caused by orphan records in the replication
    target servers Group.Leaders table.
    The group leaders for these orphan records have been deleted in
    both target and source, but on the target server the grouping
    info still exists in the GROUP_LEADERS table.
    
    The symptom reported by this APAR is more likely to be seen on
    servers managing system state backup objects and/or Tivoli
    Storage Manager for Virtual Environment group files
    
      Tivoli Storage Manager Versions Affected: all V6.3 & 7.1
      Customer/L2 Diagnostics (If Applicable)
    
    You can use the following commands to verify you are affected by
    the APAR:
    
    db2 connect to tsmdb1
    db2 "select count(*) from tsmdb1.group_leaders imgl left join
    tsmdb1.backup_objects imbk on
    (imgl.LEADERID=imbk.objid) left join tsmdb1.archive_objects imar
    on (imgl.LEADERID=imar.objid) left
    join tsmdb1.SpaceMan_Objects IMSM on (imgl.LEADERID=imsm.objid)
    left join
    tsmdb1.InFlight_ReplGroups NRIG on
    (imgl.leaderid=nrig.TGT_GROUPID) where imgl.LEADERID is not null
    and imbk.objid is null and imar.objid is null and imsm.objid is
    null and  nrig.TGT_GROUPID is null"
    
    
    
    
    
    
    
    If the previous command, submitted at the replication target
    server,
    returns a non-empty result set you are affected by the APAR.
    
      Initial Impact: Medium
      Additional Keywords: TSM TSM4VE zz63 zz71
    

Local fix

  • Apply fixing level once available, if you confirm you are
    affected by the subject APAR contact IBM support for cleanup
    instructions
    

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.3.5 and 7.1.1. Note that   *
    * this is subject to change at the discretion of IBM.          *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IC97786

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    63L

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-11-20

  • Closed date

    2014-04-03

  • Last modified date

    2014-04-03

  • 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

  • R63A PSY

       UP

  • R63H PSY

       UP

  • R63L PSY

       UP

  • R63S PSY

       UP

  • R63W PSY

       UP

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 63L

Reference #: IC97786

Modified date: 03 April 2014