suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT24447 Status: Closed

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

product:
DB2 CONNECT / DB2CONNCT / B10 - DB2
Problem 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 : 
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 : 
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 : 
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 : 
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/".
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* ALL                                                          *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Db2 11.1 Mod 4 Fixpack 4 or higher                *
****************************************************************
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.
Solution
Workaround
not known / see Local fix
BUG-Tracking
forerunner  : IT24090 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
20.03.2018
27.11.2018
27.11.2018
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)