IBM Support

IT20001: WITH MULTIPLE DB2READLOG API CALLERS RETRIEVING THE SAME LOG FILE, DB2READLOG API CALLERS MAY TIME OUT OR FAIL WITH SQL2038N

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When two or more db2readlog API callers try to retrieve the same
    log file, the
    following messages may occur in db2diag.log:
    
    2015-12-14-23.01.48.290843+480 I10452773E1476        LEVEL:
    Warning
    PID     : 29521                TID : 140728323794688 PROC :
    db2sysc 0
    INSTANCE: lkinst1              NODE : 000            DB   :
    LKEBBS
    HOSTNAME: PG1248
    EDUID   : 25550                EDUNAME: db2lfr.0 (LKEBBS) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgRetrieveStartUse, probe:190
    DATA #1 : <preformatted>
    WARNING: No room for retrieved log number 13365 in
    retrieveArray. Index
    18446744073709551615 entryCount 264
    CALLSTCK: (Static functions may not be resolved correctly, as
    they are
    resolved to the nearest symbol)
    [0] 0x00007FFFEDF0ACCF pdLogPrintf + 0x8F
    [1] 0x00007FFFF2E9F68D
    _Z21sqlpgRetrieveStartUseP14sqlpMasterDbcbjtPmmPKcmm
    + 0x76D
    [2] 0x00007FFFF2EFF7AB
    _Z25sqlplfrAddToRetrieveArrayP14sqlpMasterDbcbP12SQLPLFR
    _DBCBjPKcP21SQLPLFR_REQ_SCAN_NEXTmPmb + 0xEB
    [3] 0x00007FFFF2F03E30
    _Z16sqlplfrFMOpenLogP12SQLPLFR_DBCBjP21SQLPLFR_REQ_SCAN_
    NEXTmPmPP9SQLP_LECB + 0x31B0
    [4] 0x00007FFFF2EF6616
    _Z16sqlplfrFMReadLogP12SQLPLFR_DBCBP21SQLPLFR_REQ_SCAN_N
    EXTP17SQLPLFR_SCAN_DATA + 0x1C6
    [5] 0x00007FFFF2EFA638
    _Z17sqlplfrDoScanNextP12SQLPLFR_DBCBP11SQLPLFR_REQ + 0x2
    B8
    [6] 0x00007FFFF0F7CE8A _Z10sqlplfrEduP9sqpLfrEdu + 0x4CA
    [7] 0x00007FFFF0FC7948 _ZN9sqpLfrEdu6RunEDUEv + 0x28
    [8] 0x00007FFFF16E0C17 _ZN9sqzEDUObj9EDUDriverEv + 0xF7
    [9] 0x00007FFFF0EC98B1 sqloEDUEntry + 0x301
    [10] 0x0000003B3A0077F1 /lib64/libpthread.so.0 + 0x77F1
    [11] 0x0000003B39CE5CCD clone + 0x6D
    
    or
    
    2017-03-15-08.55.01.297715+600 I2413802A537         LEVEL: Error
    PID     : 33095832             TID : 91182          PROC :
    db2sysc 0
    INSTANCE: ap5db2a              NODE : 000           DB   :
    SOREWP01
    HOSTNAME: db2ap5
    EDUID   : 91182                EDUNAME: db2lfr.0 (SOREWP01) 0
    FUNCTION: DB2 UDB, recovery manager, sqlplfrOpenExtentRetrieve,
    probe:210
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    DATA #1 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
    89020
    
    Once these messages occurs, db2readlog API callers may time out
    or receive
    SQL2038N error or are not able to continue retrieving log files
    until database
    reactivation.
    

Local fix

  • To avoid the problem from happening, set overflow log path
    directly to the
    archive log path (including the chain folder), example:
    db2 update db cfg for sample using overflowlogpath
    /data1/jamesji/logs3/jamesji/SAMPV11/NODE0000/LOGSTREAM0000/C000
    0000
    
    Once the problem occurs, database need to be reactivated to
    resolve the issue.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 10.5 Fix Pack 9 or higher                     *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 10.5 Fix Pack 9
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT20001

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    A50

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-04-02

  • Closed date

    2017-09-29

  • Last modified date

    2017-09-29

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

  • 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

  • RA50 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.5","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
13 January 2022