IBM Support

IT27061: PAUSED-REORG RECORD IS REMOVED IN DB2PD -REORG BY REORG PAUSE COMMAND ON THE SAME TABLE IN PURESCALE

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 "reorg table <tablename> inplace pause" is issued on
    reorg-paused table in purescale, the record of that reorg-paused
    table will be removed in db2pd -reorg.
    
    $ db2pd -d TSTV111 -reorg
    
    Database Member 0 -- Database TSTV111 -- Active -- Up 0 days
    00:03:49 -- Date 2018-09-28-21.51.48.811450
    
    Table Reorg Information:
    Address            TbspaceID TableID PartID MasterTbs MasterTab
    TableName          Type    IndexID    TempSpaceID
    0x07700000CC72DB88 2         5       n/a    n/a       n/a
    TSTTBL             Online  0          2
    
    Table Reorg Stats:
    Address            TableName          Start               End
    PhaseStart          MaxPhase   Phase      CurCount   MaxCount
    Status  Completion
    0x07700000CC72DB88 TSTTBL             09/28/2018 21:51:48
    09/28/2018 21:51:48 n/a                 n/a        n/a
    543        2004       Paused  0
    >>>>> table "TSTTBL" is on "Paused" status
    
    $ db2 reorg table tsttbl inplace pause
    SQL2219N  The inplace table reorganization failed on one or more
    members.
    Table name: "WOONGC.TSTTBL". Reason code: "11".
    >>>>> issued reorg pause to reorg-paused table.
    
    $ db2pd -d TSTV111 -reorg
    
    Database Member 0 -- Database TSTV111 -- Active -- Up 0 days
    00:03:50 -- Date 2018-09-28-21.51.49.111801
    
    Table Reorg Information:
    Address            TbspaceID TableID PartID MasterTbs MasterTab
    TableName          Type    IndexID    TempSpaceID
    
    Table Reorg Stats:
    Address            TableName          Start               End
    PhaseStart          MaxPhase   Phase      CurCount   MaxCount
    Status  Completion
    >>>>> the record is removed
    

Local fix

  • Please upgrade to v111m4fp5 and future release.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 5 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27061

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-11-21

  • Closed date

    2020-01-18

  • Last modified date

    2020-01-18

  • 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

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
18 January 2020