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) |