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.
SAP Knowledge Base Article - Preview