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

Db2 Version 11.1 Mod 4 Fix Pack 5 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod 4 Fix Pack 6 for Linux, UNIX, and Windows

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