SAP Knowledge Base Article - Preview

3261552 - DB6: Database activation fails due to out-of-sync of LFH and GLFH

Symptom

You notice database activation fails with SQL1042C error.

It is detected that the LFH and GLFH are out of sync.

db2diag.log 

2022-10-01-12:34:56.433269+000 E3847E913             LEVEL: Error
PID     : 87330                TID : 140736913729280 PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000            DB   : abc
APPHDL  : 0-7                  APPID: *LOCAL.db2abc.221001075759
AUTHID  : DB2abc               HOSTNAME: abcdefg
EDUID   : 25                   EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, data protection services, sqlpgint, probe:374
MESSAGE : ZRC=0x8710001D=-2028994531=SQLP_LERR "Fatal Logic Error"
          DIA8526C A fatal error occurred in data protection services.
DATA #1 : String, 97 bytes
Detected LFH and GLFH to be out of sync.
Please collect the diag data and send it to IBM support.
DATA #2 : Dumped object of size 12288 bytes at offset 0, 38 bytes
/db2/abc/db2dump/87330.25.000.dump.bin
DATA #3 : Dumped object of size 12288 bytes at offset 12456, 38 bytes
/db2/abc/db2dump/87330.25.000.dump.bin

2022-10-01-12:34:56.434009+000 E4761E2420            LEVEL: Severe
PID     : 87330                TID : 140736913729280 PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000            DB   : abc
APPHDL  : 0-7                  APPID: *LOCAL.db2abc.221001075759
AUTHID  : DB2abc               HOSTNAME: abcdefg
EDUID   : 25                   EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, data protection services, SQLP_DBCB::setLogState, probe:5000
DATA #1 : <preformatted>
Database error has been detected.  As a result, for precautionary reasons
all logging services have been stopped.
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
  [0] 0x00007FFFECBEFBFF pdLogPrintf + 0x8F
  [1] 0x00007FFFEFD690AB _Z8sqlpinitP8sqeAgentP16sqeLocalDatabaseP5sqlcam + 0xEDB
  [2] 0x00007FFFEED35107 /db2/db2abc/sqllib/lib64/libdb2e.so.1 + 0x3224107
  [3] 0x00007FFFEED2E432 _ZN16sqeLocalDatabase12FirstConnectEP8SQLE_BWARcP8sqeAgentP8sqlo_gmtiiPb + 0x18A2
  [4] 0x00007FFFEED1D590 _ZN8sqeDBMgr23StartUsingLocalDatabaseEP8SQLE_BWAP8sqeAgentRccP8sqlo_gmtPb + 0x15D0
...



2022-10-01-12:34:56.442704+000 I8329E907             LEVEL: Severe
PID     : 87330                TID : 140736913729280 PROC : db2sysc 0
INSTANCE: db2abc               NODE : 000            DB   : abc
APPHDL  : 0-7                  APPID: *LOCAL.db2abc.221001075759
AUTHID  : DB2abc               HOSTNAME: abcdefg
EDUID   : 25                   EDUNAME: db2agent (abc) 0
FUNCTION: DB2 UDB, base sys utilities, sqeLocalDatabase::FirstConnect, probe:10357
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
 sqlcaid : SQLCA     sqlcabc: 136   sqlcode: -1042   sqlerrml: 0


Read more...

Environment

SAP on IBM Db2 for Linux, UNIX, and Windows

Keywords

detected, LFH, GLFH, out of sync, SQL1042C , KBA , BC-DB-DB6 , DB2 Universal Database for Unix / NT , BC-DB-DB6-DBA , Database Administration , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.