IZ61301: QUIESCE RESET NOT RESETTING THE INDEX TABLESPACE STATE FROM QUIESCE:EXCLUSIVE TO NORMAL, WHEN DROP INDEX IS DONE.

DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

APAR status

• Closed as program error.

Error description

• The QUIESCE RESET command is not resetting the index tablespace
  state from QUIESCE:Exclusive to NORMAL, when drop index is done.
  The problem is that since we are allowing drop index to happen
  when the index tablespace was still quiesce under a certain
  object, this prevents the quiesce command to reset the
  tablespace state since the index object no longer exist.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The QUIESCE RESET command is not resetting the index         *
  * tablespace state from QUIESCE:Exclusive to NORMAL, when drop *
  * index is done.  The problem is that since we are allowing    *
  * drop index to happen when the index tablespace was still     *
  * quiesce under a certain object, this prevents the quiesce    *
  * command to reset the tablespace state since the index object *
  * no longer exist.                                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to DB2 9.5.6.                                        *
  ****************************************************************
  

Problem conclusion

• The problem was first fixed in DB2 9.5.6.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IZ61299

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  DB2 UDB ESE AIX

• Fixed component ID

  5765F4100

Applicable component levels

• R950 PSN

     UP