IBM Support

IT08744: DATABASE BACKUP CAN LEAD TO A PAUSE AND TERMINATION OF THE EXTEND DBS REDISTRIBUTION ACTIVITY WITH ANR9999D_3831306406

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • In TSM 7.1.x the extend dbspace command added function to
    automatically complete the DB2 redistribution and rebalance
    functions needed when space is added to the database. Depending
    upon the size of the database these functions can be long
    running. If a database backup starts while they are processing
    then DB2 will pause the redistribution or rebalance. While these
    functions can be manually restarted through DB2 the extend
    db2space command issues from TSM will fail at the point the DB2
    function is paused. The TSM server should not allow a database
    backup to run when the extend dbspace driven redistribution and
    rebalance functions are processing. To ensure the archive log
    does not fill while the extend is processing the server must
    have the needed archive log space. The extend dbspace
    documentation needs to make this clear.
    The following is an example of the messages in the actlog with
    this situation occurs:
    03/06/2015 08:50:18 ANR3140I Redistribution of data for database
    TSMDB1 on table space BFABFIDXSPACE is complet.
    03/06/2015 08:50:18 ANR3138I Reclaiming database storage for
    table space BFABFIDXSPACE is being started.
    03/06/2015 08:50:18 ANR3142I Redistribution of data for database
    TSMDB1 on table space BFBFEXTDATASPACE is starting.
    03/06/2015 19:34:16 ANR3140I Redistribution of data for database
    TSMDB1 on table space BFBFEXTDATASPACE is complet.
    03/06/2015 19:34:16 ANR3138I Reclaiming database storage for
    table space BFBFEXTDATASPACE is being started.
    03/06/2015 19:34:16 ANR3142I Redistribution of data for database
    TSMDB1 on table space BFBFEXTIDXSPACE is starting.
    03/07/2015 06:23:27 ANR3140I Redistribution of data for database
    TSMDB1 on table space BFBFEXTIDXSPACE is complet.
    03/07/2015 06:23:27 ANR9999D_3831306406
    ReportSQLDiagInfo(dbieval.c:1572) Thread<75>: Missing
    sqlState=55041, sqlCode=-258 from table. Returning rc = 9994.
    03/07/2015 06:23:27 ANR9999D Thread<75> issued message 9999
    from:
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC537035
    OutDiagToCons()+155
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC530F6C
    outDiagfExt()+10c
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2C8CE0
    ReportSQLDiagInfo()+2a0
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2C7CC0
    DbiEvalSQLOutcomeX()+4f0
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2B4554
    DbiExecuteOnConn()+1e4
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2B427C
    dbiExecuteStmt()+dc
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2E74C1
    ReclaimSpaceOneTbls()+f1
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8AC2E6CDD
    TblsReclaimThread()+1ed
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8ABC072EC
    startThread()+13c
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8CE913FEF
    beginthreadex()+107
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8CE914196
    endthreadex()+192
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8D6941832
    BaseThreadInitThunk()+1a
    03/07/2015 06:23:27 ANR9999D Thread<75> 000007F8D7F2D609
    RtlUserThreadStart()+21
    03/07/2015 06:23:27 ANR0162W Supplemental database diagnostic
    information: -1:55041:-258 ([IBM][CLI Driver][DB2/NT64] SQL0258N
    Neither container operations nor a REBALANCE can be performed
    while a rebalance of the table space is pending or in progress.
    SQLSTATE=55041).
    03/07/2015 06:23:27 ANR3137E Unable to reclaim database storage
    for table space BFBFEXTIDXSPACE. The error code 9994 is
    returned.
    03/07/2015 06:23:27 ANR0985I Process 2442 for EXTEND DBSPACE
    running in the BACKGROUND completed with completion state
    FAILURE at 06:23:27.
    03/07/2015 06:23:27 ANR1893E Process 2442 for EXTEND DBSPACE
    completed with a completion state of FAILURE.
    Tivoli Storage Manager Versions Affected: 7.1 all platforms
    Initial Impact: Medium
    Additional Keywords:
    TSM add increase redistribution balance
    

Local fix

  • Follow the steps from the TSM Knowldege Center on "Manually
    redistributing data and reclaiming space after you add
    directories to the database":
    
    www.ibm.com/support/knowledgecenter/SSGSG7_7.1.0/com.ibm.itsm.sr
    v.doc/t_srv_rebalance_manual.html?lang=en
    
    Modify the list of table spaces to process as obtained in step 2
    removing any that the extend dbs process was able to complete.
    Review of the ANR3140I messages from the time the extend was
    driving the rebalance will indicate which table spaces already
    completed the rebalance/reduce.
    

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

Problem conclusion

  • This problem was fixed.
    Affected platforms:  AIX, HP-UX, Solaris, Linux, and Windows.
    
    
    
    ANR3301E
    
    The EXTEND DBSPACE failed because database backup processing is
    active.
    
    Explanation
    
    The database backup and EXTEND DBSPACE processing are in
    conflict and cannot
    be active simultaneously.
    
    System action
    
    The EXTEND DBSPACE operation failed and is terminated.
    
    
    User response
    
    Rerun the EXTEND DBSPACE after the database backup completes.
    
    ANR3302E
    
    The database backup failed because EXTEND DBSPACE processing is
    active.
    
    Explanation
    
    The database backup and EXTEND DBSPACE processing are in
    conflict and cannot
    be active simultaneously.
    
    System action
    The database backup operation failed and is terminated.
    
    User response
    Rerun the database backup after EXTEND DBSPACE processing
    completes.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08744

  • Reported component name

    TSM SERVER

  • Reported component ID

    5698ISMSV

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-05-06

  • Closed date

    2015-06-05

  • Last modified date

    2015-06-19

  • 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



Document information

More support for: Tivoli Storage Manager

Software version: 71W

Reference #: IT08744

Modified date: 19 June 2015