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:
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","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"11.1","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
14 December 2020