IBM Support

IC90146: DATABASE ROLLFORWARD FAILS DURING REPLAY OF A CLASSIC REORG IF THE REQUIRED SYSTEM TEMPSPACE IS IN RF PENDING

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • During roll forward of a classic (offline) table reorg that
    included the 'USE tablespace' clause, if the specified temporary
    tablespace is in roll forward pending state, the replay of the
    reorg will fail.  This will not happen with a full database
    restore, but with any type of restore that involves specifying a
    subset of tablespaces that includes the specified system
    temporary tablespace; for example, 'RESTORE DATABASE <name>
    REBUILD WITH ALL TABLESPACES IN IMAGE EXCEPT (some other
    tablespace)', or 'RESTORE DATABASE <name> TABLESPACE', either
    with no listed table spaces (meaning all are to be restored) or
    with a list that includes the specified temporary tablespace.
    
    You will see severe error messages in the db2diag.log that
    include the error 'SQLB_NO_TEMP_AVAIL'.
    

Local fix

  • Perform a full database restore without the REBUILD or
    TABLESPACE clauses, if possible.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Any doing classic reorg with a tempspace and a subsequent    *
    * restore and rollforward through that operation               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 10 fixpack 3 or later                 *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in DB2 version 10 fixpack 3
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90146

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-11

  • Closed date

    2013-10-28

  • Last modified date

    2013-10-28

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

    IC90119

  • 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

  • RA10 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1

Reference #: IC90146

Modified date: 28 October 2013