IBM Support

IC90119: 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 using any type of restore that involves specifying a     *
    * subset of tablespaces that includes a temporary tablespace   *
    * used by reorg.                                               *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Update to Version 9.7 Fixpack 9 or later                     *
    ****************************************************************
    

Problem conclusion

  • Problem first fixed in Version 9.7 Fixpack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC90119

  • 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

    2013-02-08

  • Closed date

    2013-12-30

  • Last modified date

    2013-12-30

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

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

    IC90146

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 #: IC90119

Modified date: 30 December 2013