IBM Support

Why am I getting a DIA8411C A file "" could not be found in the db2diag.log?

 https://www.ibm.com/support/pages/why-am-i-getting-dia8411c-file-could-not-be-found-db2diaglog

Question & Answer

Question

Why am I getting a DIA8411C A file "" could not be found in the db2diag.log?

Cause

 



2016-02-03-11.02.46.653000-200 I225897131F0639 LEVEL: Info

PID : 3294 TID : 2116 PROC : db2syscs.exe

INSTANCE: DB2 NODE : 000 DB : SAMPLE

HOSTNAME: myhost1

EDUID : 1963 EDUNAME: db2loggr (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 47958

DATA #5 : unsigned integer, 4 bytes 0

DATA #6 : db2LogStreamIDType, PD_TYPE_DB2_LOG_STREAM_ID, 2 bytes 0

 

Answer

These messages are related to the log file clean-up during runtime.

The 'File not found' message relates to a file that has already been

renamed or deleted. These are informational message are should not be

of concern unless followed by other Error messages.

So one thing to try is deactivate the db, rename the db2dia.log using

db2diag -A, then activate the db again and monitor. A new log chain

will be created and the above errors should go away.

Was this topic helpful?

Document Information

More support for:
Db2 for Linux, UNIX and Windows

Software version:
9.7, 10.1, 10.5, 11.1

Operating system(s):
AIX, HP-UX, Linux, Solaris, Windows

Document number:
278169

Modified date:



07 December 2022

------------------------------------------------------------------------------------------
如果你觉得文章有用，欢迎打赏

自然语言处理爱好者，欢迎交流。QQ: 7214218