IBM Support

IC70590: 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:                                              *
    * HADR users                                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * HADR standby crash can occur on reintegration with primary.  *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade DB2 server to v9.7 Fixpak 4                          *
    ****************************************************************
    

Problem conclusion

  • This problem has first been fixed in V9.7 Fixpak 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IC70590

  • 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

    2010-08-17

  • Closed date

    2011-05-24

  • Last modified date

    2011-05-24

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

    IC69049

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

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

Modified date: 24 May 2011