IBM Support

IC74074: "QUIESCE TABLESPACES FOR TABLE <TABLE_NAME> RESET" FAILS TO RESET TABLESPACE STATE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The problem occurs when using the QUIESCE TABLESPACES FOR TABLE
    command to quiesce a tablespace that has already been quiesced
    for a different table using a compatible mode.  Once in the
    state the "QUIESCE TABLESPACES FOR TABLE <TABLE_NAME> RESET", if
    run in a certain order, may return successfully without actually
    resetting the tablespace state.
    

Local fix

  • 1.  Issue the "GET SNAPSHOT FOR TABLESPACES ON <databaseName>"
    command and to determine the tablespace and object IDs of the
    tables for which the tablespace is quiesced along with the
    authorization ID used to quiesce the tablespace.
    
    Example output from "GET SNAPSHOT FOR TABLESPACES ON
    <databaseName>"
    
    ...
    Tablespace name                            = TS1
      Tablespace ID                            = 3
      Tablespace Type                          = Database managed
    space
      ...
      Tablespace State                         = 0x'00000001'
       Detailed explanation:
         Quiesced: SHARE
      ...
      Number of quiescers                      = 2
    
      Quiescer authorization ID                = ZTOTH
          Quiescer agent ID                    = 7
          Quiescer tablespace ID               = 3
          Quiescer object ID                   = 4
          Quiesce state                        = 1
    
      Quiescer authorization ID                = ZTOTH
          Quiescer agent ID                    = 7
          Quiescer tablespace ID               = 3
          Quiescer object ID                   = 5
          Quiesce state                        = 1
     ...
    
    
    2.  Query the SysCat.Tables catalogue table to determine the
    table names from the tablespace and object IDs.
    Examples:
    SELECT TabSchema,TabName FROM SysCat.Tables WHERE TbSpaceID=3
    AND TableID=4
    and
    SELECT TabSchema,TabName FROM SysCat.Tables WHERE TbSpaceID=3
    AND TableID=5
    
    Result:  The tables are ZTOTH.T1 and ZTOTH.T2.
    
    3.  Using the authorization ID in the "GET SNAPSHOT FOR
    TABLESPACES ON <databaseName>" output, connect to the database
    and issue "QUIESCE TABLESPACES FOR TABLE <TableName> RESET" for
    each of the tables.
    
    4.  Due to the bug this APAR is fixing, at least one of the
    "QUIESCE TABLESPACES FOR TABLE <TableName> RESET" will work, but
    possibly not all of them on the first try, so repeat steps 1 and
    3 until the tablespace is no longer quiesced, or simply repeat
    step 3 X times where X is the number of quiescers displayed in
    the "GET SNAPSHOT FOR TABLESPACES ON <databaseName>" output.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * All users.                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * The problem occurs when using the QUIESCE TABLESPACES FOR    *
    * TABLE command to quiesce a tablespace that has already been  *
    * quiesced for a different table using a compatible mode.      *
    * Once in the state the "QUIESCE TABLESPACES FOR TABLE         *
    * <TABLE_NAME> RESET", if run in a certain order, may return   *
    * successfully without actually resetting the tablespace       *
    * state.                                                       *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 9.7.0.4.                                      *
    ****************************************************************
    

Problem conclusion

  • The problem is fixed in DB2 9.7.0.4.
    

Temporary fix

  • 1.  Issue the "GET SNAPSHOT FOR TABLESPACES ON <databaseName>"
    command and to determine the tablespace and object IDs of the
    tables for which the tablespace is quiesced along with the
    authorization ID used to quiesce the tablespace.
    
    Example output from "GET SNAPSHOT FOR TABLESPACES ON
    <databaseName>"
    
    ...
    Tablespace name       = TS1
      Tablespace ID       = 3
      Tablespace Type      = Database managed
    space
      ...
      Tablespace State      = 0x'00000001'
       Detailed explanation:
         Quiesced: SHARE
      ...
      Number of quiescers      = 2
    
      Quiescer authorization ID     = ZTOTH
          Quiescer agent ID      = 7
          Quiescer tablespace ID     = 3
          Quiescer object ID     = 4
          Quiesce state      = 1
    
      Quiescer authorization ID     = ZTOTH
          Quiescer agent ID      = 7
          Quiescer tablespace ID     = 3
          Quiescer object ID     = 5
          Quiesce state      = 1
     ...
    
    
    2.  Query the SysCat.Tables catalogue table to determine the
    table names from the tablespace and object IDs.
    Examples:
    SELECT TabSchema,TabName FROM SysCat.Tables WHERE TbSpaceID=3
    AND TableID=4
    and
    SELECT TabSchema,TabName FROM SysCat.Tables WHERE TbSpaceID=3
    AND TableID=5
    
    Result:  The tables are ZTOTH.T1 and ZTOTH.T2.
    
    3.  Using the authorization ID in the "GET SNAPSHOT FOR
    TABLESPACES ON <databaseName>" output, connect to the database
    and issue "QUIESCE TABLESPACES FOR TABLE <TableName> RESET"
    for each of the tables.
    
    4.  Due to the bug this APAR is fixing, at least one of the
    "QUIESCE TABLESPACES FOR TABLE <TableName> RESET" will work,
    but possibly not all of them on the first try, so repeat steps
    1 and 3 until the tablespace is no longer quiesced, or simply
    repeat step 3 X times where X is the number of quiescers
    displayed in the "GET SNAPSHOT FOR TABLESPACES ON
    <databaseName>" output.
    

Comments

APAR Information

  • APAR number

    IC74074

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2011-01-24

  • Closed date

    2011-04-28

  • Last modified date

    2011-04-28

  • 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

  • R970 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.7

Reference #: IC74074

Modified date: 28 April 2011