IBM Support

[Db2] データベース活動化時に db2loggr が DIA8411C (log not found) を報告することがある

Question & Answer


Question

データベースを活動化するとき、以下のようなエントリーが db2diag.log に記録されることがあります。
これはなぜでしょう。また、対応が必要でしょうか。
2020-02-04-00.39.11.385946+480 I57524A1196          LEVEL: Info
PID     : 35193132             TID : 4479           PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   : SAMPLE
HOSTNAME: db2srv1
EDUID   : 4479                 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.
DIA8411C A file "" could not be found.
DATA #1 : String, 19 bytes
Log is not found...
<snip>

2020-02-04-00.39.11.385948+480 I58720A544           LEVEL: Error
PID     : 35193132             TID : 4479           PROC : db2sysc 0
INSTANCE: db2inst1             NODE : 000           DB   : SAMPLE
HOSTNAME: db2srv
EDUID   : 4479                 EDUNAME: db2loggr (SAMPLE) 0
FUNCTION: DB2 UDB, data protection services, sqlpgOpenLogExtent, probe:10000
MESSAGE : ZRC=0x860F000A=-2045837302=SQLO_FNEX "File not found."
          DIA8411C A file "" could not be found.
DATA #1 : <preformatted>
Error opening database log extent 69798.

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m500000008PmcAAE","label":"Recovery-\u003ELogging"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

ibm10875198