IBM Support

IT23745: LONG RUNNING REPAIR OCCUPANCY FAILS WITH RC 4522

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Error Description: REPAIR OCCUPANCY can fail with the following
    messages.:
    
    ANR0158W Database operation FETCH for table SD.Pool.Clusters
    failed with operation code 4522 and tracking id
    0000000E03548860. The data for column 1 is: (int32)2169.
    ANR0106E sdpool.c(1136): Unexpected error 4522 fetching row in
    table "SD.Pool.Clusters".
    ANR0171I dbiconn.c(2226): Error detected on 0:130, database in
    evaluation mode.
    ANR0162W Supplemental database diagnostic information:
    -1:08003:-99999 ([IBM][CLI Driver] CLI0106E  Connection is
    closed. SQLSTATE=08003).
    REPAIR OCCUPANCY: Failed to repair cluster for Node <node name>
    and fsId XX in pool <pool name> with rc 4522.
    
    This is caused by the transaction for the REPAIR OCCUPANCY being
    long running to the point where the DB2 NUM_LOG_SPAN value is
    exceeded. This leads to DB2 terminating the transaction and
    therefore the server REPAIR process fails.
    
    Tivoli Storage Manager/IBM Spectrum Protect  Versions Affected:
    7.1.X and 8.1.X on all supported platforms
    
    Customer/L2 Diagnostics: db2diag log will show the following
    NUM_LOG_SPAN message.:
    
    2018-01-11-05.21.53.446000-210 E2882654F753         LEVEL: Error
    PID     : 17968                TID : 11688          PROC :
    db2syscs.exe
    INSTANCE: SERVER1              NODE : 000           DB   :
    TSMDB1
    HOSTNAME: HOST
    EDUID   : 11688                EDUNAME: db2loggr (TSMDB1) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpScanTranTableForLowTran, probe:550
    MESSAGE : ADM1541W  Application "dsmsvc.exe" with application
    handle "0-56225"
              and application id "*LOCAL.SERVER1.180114214336"
    executing under
              authentication id "TSMADMIN" has been forced off of
    the database for
              violating database configuration parameter
    NUM_LOG_SPAN (current
              value "135"). The unit of work will be rolled back.
    
    Initial Impact: Low
    
    Additional Keywords: rep occ log pin pinned long running
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All IBM Spectrum Protect server users.                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See error description.                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed in levels 7.1.9, 8.1.1.200 and 8.1.5.  *
    * Note that this is subject to change at the discretion of     *
    * IBM.                                                         *
    ****************************************************************
    

Problem conclusion

  • Problem Conclusion:
    This problem was fixed.
    
    Platforms fixed:  AIX, Linux, Solaris and Windows.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT23745

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    81W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-26

  • Closed date

    2018-02-01

  • Last modified date

    2018-06-07

  • 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

  • R71A PSY

       UP

  • R71H PSY

       UP

  • R71L PSY

       UP

  • R71S PSY

       UP

  • R71W PSY

       UP

  • R81A PSY

       UP

  • R81L PSY

       UP

  • R81W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 81W

Reference #: IT23745

Modified date: 07 June 2018