IBM Support

IC93888: DB2INIDB AS SNAPSHOT COMMAND MIGHT BE VERY SLOW DUE TO OUTDATED MINBUFFLSN

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • db2inidb as snapshot command might be very slow because there is
    a big gap between minbufflsn and lowtranlsn, i.e. there is a
    long recovery window for the crash recovery.
    
    2013-06-18-23.53.45.260787+480 I2965333A493       LEVEL: Warning
    PID     : 7274622              TID  : 1801        PROC : db2sysc
    0
    INSTANCE: sample              NODE : 000         DB   : sample
    APPHDL  : 0-9                  APPID: *LOCAL.sample.130618155344
    AUTHID  : sample<
    EDUID   : 1801                 EDUNAME: db2agent (sample) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:410
    MESSAGE : Crash recovery started. LowtranLSN 0000076D59F08010
    MinbuffLSN<
              0000076B99F0E0BF
    
    ...
    
    2013-06-19-00.36.47.207864+480 I2969130A503       LEVEL: Warning
    PID     : 7274622              TID  : 1801        PROC : db2sysc
    0
    INSTANCE: sample              NODE : 000         DB   : sample
    APPHDL  : 0-9                  APPID: *LOCAL.sample.130618155344
    AUTHID  : sample<
    EDUID   : 1801                 EDUNAME: db2agent (sample) 0
    FUNCTION: DB2 UDB, recovery manager, sqlprecm, probe:4000
    MESSAGE : DIA2051W Forward phase of crash recovery has
    completed.  Next LSN is<
              "0000076D59F08010".
    
    ...
    2013-06-19-00.36.47.291241+480 I2970091A458       LEVEL: Warning
    PID     : 7274622              TID  : 1801        PROC : db2sysc
    0
    INSTANCE: sample              NODE : 000         DB   : sample
    APPHDL  : 0-9                  APPID: *LOCAL.sample.130618155344
    AUTHID  : sample<
    EDUID   : 1801                 EDUNAME: db2agent (sample) 0
    FUNCTION: DB2 UDB, recovery manager, sqlpresr, probe:3170
    MESSAGE : Crash recovery completed. Next LSN is 0000076D59F08010
    

Local fix

  • Reduce softmax to smaller value to get a small recovery window.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL USERS                                                    *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to v9.7 FP9 or use local fix as workaround.          *
    ****************************************************************
    

Problem conclusion

  • This problem has been fixed in v9.7 FP9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC93888

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

  • Closed date

    2013-12-16

  • Last modified date

    2013-12-16

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

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

    IC96293 IC96329

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

Modified date: 16 December 2013