IC85386: DB2DIAG.LOG on HADR primary could be flooded with informational messages in superasync mode

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When setting HADR SYNCMODE to SUPERASYNC , the db2diag.log is
    getting flooded with the following  Informational messages:
    
    2012-07-12-18.16.45.084079-240 I105154A402        LEVEL: Info
    PID     : 45613116             TID  : 3296        PROC : db2sysc
    INSTANCE: lzgotty              NODE : 000
    EDUID   : 3296                 EDUNAME: db2lfr (SAMPLE)
    FUNCTION: DB2 UDB, recovery manager, sqlplfrVerifyLogPages,
    probe:980
    DATA #1 : <preformatted>
    Inform shredder to overwrite ping with pong page in buffer.
    pageLso is 2654706243
    
    2012-07-12-18.16.45.186337-240 I105557A422        LEVEL: Warning
    PID     : 45613116             TID  : 3296        PROC : db2sysc
    INSTANCE: lzgotty              NODE : 000
    EDUID   : 3296                 EDUNAME: db2lfr (SAMPLE)
    FUNCTION: DB2 UDB, data protection services, sqlpgarl, probe:99
    MESSAGE : INFO ONLY: Found an old page in the log file:
    ByteOffset 0,  PageLso
              0 highLso 2654711029 lowLso  2654706953
    

Local fix

  • Use other HADR synchronous modes, eg. ASYNC or NEARSYNC;
    archive/remove db2diag.log if it's too large.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * When setting HADR SYNCMODE to SUPERASYNC, the db2diag.log is *
    *                                                              *
    * getting flooded with the following  Informational messages:  *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2012-07-12-18.16.45.084079-240 I105154A402        LEVEL:     *
    * Info                                                         *
    * PID     : 45613116             TID  : 3296        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: lzgotty              NODE : 000                    *
    *                                                              *
    * EDUID   : 3296                 EDUNAME: db2lfr (SAMPLE)      *
    *                                                              *
    * FUNCTION: DB2 UDB, recovery manager, sqlplfrVerifyLogPages,  *
    *                                                              *
    * probe:980                                                    *
    *                                                              *
    * DATA #1 : <preformatted>                                     *
    *                                                              *
    * Inform shredder to overwrite ping with pong page in buffer.  *
    *                                                              *
    * pageLso is 2654706243                                        *
    *                                                              *
    *                                                              *
    *                                                              *
    * 2012-07-12-18.16.45.186337-240 I105557A422        LEVEL:     *
    * Warning                                                      *
    * PID     : 45613116             TID  : 3296        PROC :     *
    * db2sysc                                                      *
    * INSTANCE: lzgotty              NODE : 000                    *
    *                                                              *
    * EDUID   : 3296                 EDUNAME: db2lfr (SAMPLE)      *
    *                                                              *
    * FUNCTION: DB2 UDB, data protection services, sqlpgarl,       *
    * probe:99                                                     *
    * MESSAGE : INFO ONLY: Found an old page in the log file:      *
    *                                                              *
    * ByteOffset 0,  PageLso                                       *
    *                                                              *
    *           0 highLso 2654711029 lowLso  2654706953            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 version 9.7 Fix Pack 7.                       *
    ****************************************************************
    

Problem conclusion

  • Problem was first fixed in DB2 version 9.7 Fix Pack 7.
    

Temporary fix

  • Use other HADR synchronous modes, eg. ASYNC or NEARSYNC;
    archive/remove db2diag.log if it's too large.
    

Comments

APAR Information

  • APAR number

    IC85386

  • 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

    2012-07-18

  • Closed date

    2012-11-05

  • Last modified date

    2013-07-12

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

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

    IC94091

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSY

       UP

  • R980 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

DB2 for Linux, UNIX and Windows

Software version:

9.7

Reference #:

IC85386

Modified date:

2013-07-12

Translate my page

Machine Translation

Content navigation