IBM Support

IC91320: TURNING OFF AUTO-RESIZE WHILE THE SAME TABLE SPACE IS BEING EXTENDED MAY RESULT IN UNREPLAYABLE LOG RECORD SEQUENCE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Assume a scenario like this:
    
    1) A DMS or AUTOMATIC STORAGE (for permanent data) table space
    partially filled with data, AUTORESIZE enabled.
    2) The user issues ALTER TABLESPACE ... REDUCE (optionally:
    MAX), causing the table space to shrink.
    3) The user attempts to insert new data, hence the table space
    will start to grow (AUTORESIZE enabled).
    4) While the grow operation is still in progress, the user
    issues ALTER TABLESPACE ... AUTORESIZE OFF from another session.
    5) The grow operation will finish now.
    
    If the timing is correct, these steps will result in a sequence
    of log records ordered in a way that cannot be replayed. If
    there is an attempt to replay this sequence (e.g. during
    ROLLFORWARD, HADR Standby, crash recovery), error
    "SQLB_NOT_ALLOWED_ROLLFORWARD_P" will be reported in the DB2
    diagnostic log, and the database will be shut down. Example:
    
    db2diag.log
    ===========
    2013-03-10-04.00.38.231675-240 I22886351E1467        LEVEL:
    Error
    PID     : 27644                TID : 140359422174976 KTID :
    27711
    PROC    : db2sysc
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-8                  APPID: *LOCAL.DB2.130310075939
    HOSTNAME: myhostname
    EDUID   : 62                   EDUNAME: db2redom (SAMPLE)
    FUNCTION: DB2 UDB, buffer pool services, sqlbExtendObject,
    probe:387
    MESSAGE :
    ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
              "Access not allowed. Tblspc RF Pending."
    
    <...skipping...>
    
    2013-03-10-04.00.38.242071-240 I22887819E554         LEVEL:
    Severe
    PID     : 27644                TID : 140359422174976 KTID :
    27711
    PROC    : db2sysc
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-8                  APPID: *LOCAL.DB2.130310075939
    HOSTNAME: myhostname
    EDUID   : 62                   EDUNAME: db2redom (SAMPLE)
    FUNCTION: DB2 UDB, data management, sqldomRedo, probe:1795
    RETCODE :
    ZRC=0x80020033=-2147352525=SQLB_NOT_ALLOWED_ROLLFORWARD_P
              "Access not allowed. Tblspc RF Pending."
    
    <...skipping...>
    
    2013-03-10-04.00.38.747509-240 E22902916E1003        LEVEL:
    Critical
    PID     : 27644                TID : 140359455729408 KTID :
    27703
    PROC    : db2sysc
    INSTANCE: db2inst1             NODE : 000            DB   :
    SAMPLE
    APPHDL  : 0-8                  APPID: *LOCAL.DB2.130310075939
    HOSTNAME: myhostname
    EDUID   : 54                   EDUNAME: db2agent (SAMPLE)
    FUNCTION: DB2 UDB, base sys utilities,
    sqleDoForceDBShutdownFODC, probe:10
    MESSAGE : ADM14001C  An unexpected and critical error has
    occurred:
              "ForceDBShutdown". The instance may have been shutdown
    as a result.
    

Local fix

  • Avoid replaying the unexpected log record sequence. If restoring
    or in an HADR Standby environment, use a backup image created
    after the table space has been resized (i.e. after step 5
    described above). No applicable workaround in the case of crash
    recovery.
    

Problem summary

  • See APAR description
    

Problem conclusion

  • Problem first fixed in DB2 9.7 FixPak 9
    

Temporary fix

  • See APAR description
    

Comments

APAR Information

  • APAR number

    IC91320

  • 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-04-03

  • Closed date

    2014-01-07

  • Last modified date

    2014-01-07

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

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

    IC91323

Modules/Macros

  • ENGN_SQB
    

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

Modified date: 07 January 2014