IBM Support

IT24447: AFTER DB2 RECYCLE, DB2 STARTED ARCHIVING OLD LOG FILES CAUSING ACTIVE LOG FILESYSTEM QUICK GROWTH.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 could cause attempt to archive from failpath happen forever
    and produce FNEX error every archretrydelay seconds.
    
    Before db2stop:
    
    2018-02-04-00.35.33.718859+480 I1339325887A498      LEVEL: Info
    PID     : 37945456             TID : 166285         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: dummyhost
    EDUID   : 166285               EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgArchiveLogFile, probe:3180
    DATA #1 : <preformatted>
    Completed archive for log file S1383462.LOG to TSM chain 0 from
    /db2inst1/db2log/SAMPLE/NODE0000/LOGSTREAM0000/.
    
    db2stop:
    
    2018-02-04-00.35.36.932816+480 I1339351794A332      LEVEL: Event
    PID     : 28508532             TID : 1              PROC :
    db2stop
    INSTANCE: db2inst1             NODE : 000
    HOSTNAME: dummyhost
    EDUID   : 1
    FUNCTION: DB2 UDB, base sys utilities, sqleIssueStartStop,
    probe:10932
    DATA #1 : <preformatted>
    Single node stopped [-1064].
    
    After db2 recycle:
    
    2018-02-04-00.39.10.389749+480 E56312A782           LEVEL: Info
    PID     : 35193132             TID : 46006          PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    APPHDL  : 0-303                APPID:
    *LOCAL.db2inst1.180203164326
    AUTHID  : db2inst1             HOSTNAME: dummyhost
    EDUID   : 46006                EDUNAME: db2agent (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpinit,
    probe:1500
    DATA #1 : <preformatted>
    Database is starting up with the following values:
                     Head Extent ID: 1383548
                      Log File Size: 50000
                        Startup Lso: 0
                           Base Lso: 169058743977825
                Last Log Record Lso: 169058737720345
    Current Write Log Extent Limit: 169058947777825
    
    2018-02-04-00.39.11.385395+480 E57095A428           LEVEL: Info
    PID     : 35193132             TID : 164228         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: dummyhost
    EDUID   : 164228               EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgArchiveLogFile, probe:3108
    DATA #1 : <preformatted>
    Started archive for log file S1215044.LOG.
    
    2018-02-04-00.39.11.385946+480 I57524A1196          LEVEL: Info
    PID     : 35193132             TID : 164228         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: dummyhost
    EDUID   : 164228               EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent,
    probe:2164
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    DATA #1 : String, 19 bytes
    Log is not found...
    DATA #2 : Codepath, 8 bytes
    19:24:26
    DATA #3 : String, 99 bytes
    extNum / logLocation / logStreamId / callerFlag / logFileName1 /
    logFileName2 / callerSpecifiedPath
    DATA #4 : SQLPG_EXTENT_NUM, PD_TYPE_SQLPG_EXTENT_NUM, 4 bytes
    1215044
    DATA #5 : unsigned integer, 4 bytes
    0
    DATA #6 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes
    0
    DATA #7 : Hex integer, 8 bytes
    0x0000000002020603
    DATA #8 : String, 0 bytes
    Object not dumped: Address: 0x0A000000ADBFD6B8 Size: 0 Reason:
    Zero-length data
    DATA #9 : String, 0 bytes
    Object not dumped: Address: 0x0A000000ADBFD7E0 Size: 0 Reason:
    Zero-length data
    DATA #10: String, 47 bytes
    /db2inst1/db2log/SAMPLE/NODE0000/LOGSTREAM0000/
    
    2018-02-04-00.39.11.387096+480 I58721A477           LEVEL: Error
    PID     : 35193132             TID : 164228         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: dummyhost
    EDUID   : 164228               EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgArchiveLogVendor, probe:1630
    MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
              DIA8411C A file "" could not be found.
    
    2018-02-04-00.39.11.387516+480 E59199A509           LEVEL:
    Warning
    PID     : 35193132             TID : 164228         PROC :
    db2sysc 0
    INSTANCE: db2inst1             NODE : 000           DB   :
    SAMPLE
    HOSTNAME: dummyhost
    EDUID   : 164228               EDUNAME: db2logmgr (SAMPLE) 0
    FUNCTION: DB2 UDB, data protection services,
    sqlpgArchiveLogFile, probe:3150
    MESSAGE : ADM1848W  Failed to archive log file "S1215044.LOG" to
    "TSM chain 0"
              from
    "/db2inst1/db2log/SAMPLE/NODE0000/LOGSTREAM0000/".
    

Local fix

  • Set logarchmeth to logretain, re-cycle db, set logarchmeth1 back
    to original method and re-cycle again.
    Make a local copy of any log that was not archived.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
    ****************************************************************
    

Problem conclusion

  • First fixed in Db2 11.1 Mod 4 Fixpack 4
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT24447

  • Reported component name

    DB2 CONNECT

  • Reported component ID

    DB2CONNCT

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-03-20

  • Closed date

    2018-11-27

  • Last modified date

    2018-11-27

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

    IT24090

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

Fix information

  • Fixed component name

    DB2 CONNECT

  • Fixed component ID

    DB2CONNCT

Applicable component levels

  • RB10 PSN

       UP

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
19 June 2020