IBM Support

IC69049: DB2LOGMGR EDU CRASH IN SPRINTF CALLED FROM SQLPGRETRIEVELOGDISK ON HADR STANDBY REINTEGRATION

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When both LOGARCHMETH1 and/or LOGARCHMETH2/FAILARCHPATH are set,
    
    a standby server will attempt to search each location for a
    later version of the log file after seeing this message in the
    db2diag.log :
    
    FUNCTION: DB2 UDB, recovery manager, sqlplfrFMOpenLog, probe:600
    MESSAGE : Extent 203822 in log path may be stale. Trying
    archive.
    
    It's possible that after searching the 1st location ( pointed to
    by LOGARCHMETH1 ), the retrieve request used by the db2logmgr
    gets freed. This then can potentially lead to a crash in the
    db2logmgr edu upon trying the 2nd location ( e.g. pointed to by
    FAILARCHPATH ).
    
    A trap file may show the following list of functions :
    
    strlen
    _doprnt
    sprintf
    sqlpgRetrieveLogDisk
    sqlpgRetrieveLogFile
    sqlpgHandleLogMgrPost
    ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Environment using HADR                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * A standby database server may abend in the db2logmgr         *
    * eduunder specific circumstances, detailed in the             *
    * apardescription.                                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade the database server to V9.5 Fixpak 7                 *
    ****************************************************************
    

Problem conclusion

  • This problem was first fixed in V9.5 Fixpak 7
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC69049

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-07

  • Closed date

    2010-11-15

  • Last modified date

    2010-11-15

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

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

    IC70590 IC70591

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R950 PSN

       UP



Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 9.5

Reference #: IC69049

Modified date: 15 November 2010