IBM Support

IT08182: SERVER OPTION DISABLEREORGTABLE DOES NOT AFFECT TABLE REORG IN PAUSED STATE

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

  • If an online table reorganization of a specific database table
    is in paused state, and the server option DISABLEREORGTable in
    the server options file is updated to exclude that particular
    table from being reorganized, it will be ignored by the server.
    The DISABLEREORGTable option is only checked before starting new
     table reorganization and is not checked before resuming a
    paused online table reorganization.
    
    TSM Versions Affected:
    Tivoli Storage Manager server 6.3.5 and 7.1.1 on all platforms.
    
    Initial Impact:
    Low
    
    Additional Keywords:
    TSM server DISABLEREORGTable table Paused reorg
    

Local fix

  • Manually stop paused reorganization for specific table using db2
     command "reorg table TSMDB1.TABLE_NAME inplace stop".
    

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.
    
    ANR3029I
    
    Reorganization for table <table name> canceled.
    
    Explanation
    
    Based on the DISABLEREORGTABLE server option
    table reorganization is disabled
    for table <table name> and a
    paused reorganization has been cancelled.
    
    System action
    
    The reorganization is cancelled.
    
    User response
    
    If the intention is to disable table reorganization
    for table <table name> no further action is required,
    otherwise consider updating the DISABLEREORGTABLE server option.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT08182

  • 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-04-13

  • Closed date

    2015-05-19

  • Last modified date

    2015-05-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

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGSG7","label":"Tivoli Storage Manager"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"71W","Edition":"","Line of Business":{"code":"LOB26","label":"Storage"}}]

Document Information

Modified date:
19 May 2015