IY89415: DB2REORG INPLACE PAUSE/STOP SHOWS WRONG REASON CODE 11 AND DB2PDSHOWS WRONG STATUS IF THERE IS A LOCK ON TABLE

APAR status

• Closed as program error.

Error description

• db2reorg does not show reason code 10 when a inplace stop or
  pause has been issued and we issue another one if there is a
  lock on the table:
  
   10 PAUSE or STOP has already been issued. The specified action
  is asynchronous and may not be effective immediately.
  
  db2pd shows an status of "started" and there is no way to know
  what has been issued or what is been progressing unless we have
  the right reason code:
  
  
  Reproduction following the steps:
  1. Issue an inplace reorg and pause it.
  2. Lock a row on the table
  3. Resume inplace reorg , it will show as "started" in db2pd
  -reorgs
  4. Issue a stop reorg
  db2pd -reorgs still shows reorg "started"
  
  5. Issue another stop:
  you get
  SQL2219N The specified INPLACE table reorganization action on
  table
  "DB2INST3.TEST_REORG" is not allowed on one or more nodes.
  Reason code:
  "11".
  11 There is no table reorganization to PAUSE or STOP.
  
  Would expect reason code "10"
  

Local fix

• No Workaround
  

Problem summary

• Users affected: ALL
  PROBLEM DESCRIPTION: DB2REORG INPLACE PAUSE/STOP SHOWS WRONG
  REASON CODE 11 AND DB2PD SHOWS WRONG STATUS IF THERE IS A LOCK
  ON TABLE
  PROBLEM SUMMARY:
  db2reorg does not show reason code 10 when a inplace stop or
  pause has been issued and we issue another one if there is a
  lock on the table:
  
   10 PAUSE or STOP has already been issued. The specified action
  is asynchronous and may not be effective immediately.
  
  db2pd shows an status of "started" and there is no way to know
  what has been issued or what is been progressing unless we have
  the right reason code:
  
  
  Reproduction following the steps:
  1. Issue an inplace reorg and pause it.
  2. Lock a row on the table
  3. Resume inplace reorg , it will show as "started" in db2pd
  -reorgs
  4. Issue a stop reorg
  db2pd -reorgs still shows reorg "started"
  
  5. Issue another stop:
  you get
  SQL2219N The specified INPLACE table reorganization action on
  table
  "DB2INST3.TEST_REORG" is not allowed on one or more nodes.
  Reason code:
  "11".
  11 There is no table reorganization to PAUSE or STOP.
  
  Would expect reason code "10"
  

Problem conclusion

• First fixed in DB2 UDB Version 8.2, FixPak 15
  

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 UDB ESE HP-

• Fixed component ID

  5765F4103

Applicable component levels