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.