DB2 reports SQLEX_UNEXPECTED_SYSERR error resolution

I accidentally found that my DB2 test environment could not be used. I always reported an error when I opened it. I always thought it was db2audit and reported an error.

I accidentally found that my DB2 test environment could not be used. I always reported an error when I opened it. I always thought it was db2audit and reported an error.

I accidentally found that my DB2 test environment could not be used. I always reported an error when I opened it. I always thought it was db2audit and reported an error.

DB2 database performance adjustment and optimization (1st and 2) PDF

DB2 database performance optimization

DB2 9.7 for Linux 5.4 Installation Steps

2013-12-19-23.19.10.388418 + 480 E829168G1400 LEVEL: Event
PID: 6743 TID: 3054496656 PROC: db2syscr
INSTANCE: db2inst1 NODE: 000
FUNCTION: DB2 UDB, base sys utilities, DB2main, probe: 1
START: DB2 DBM
DATA #1: Build Level, 128 bytes
Instance "db2inst1" uses "32" bits and DB2 code release "SQL09075"
With level identifier "08060107 ".
Informational tokens are "DB2 v9.7.0.5", "s111017", "IP23291", Fix Pack "5 ".
DATA #2: System Info, 436 bytes
System: Linux marven 6 2 i686
CPU: total: 1 online: 1 Cores per socket: 1 Threading degree per core: 1
Physical Memory (MB): total: 1011 free: 161
Virtual Memory (MB): total: 3059 free: 2209
Swap Memory (MB): total: 2048 free: 2048
Kernel Params: msgMaxMessageSize: 65536 msgMsgMap: 65536 msgMaxQueueIDs: 1024
MsgNumberOfHeaders: 65536 msgMaxQueueSize: 65536
MsgMaxSegmentSize: 16 shmMax: 1059983360 shmMin: 1 shmIDs: 4096
ShmSegments: 4096 semMap: 256000 semIDs: 1024 semNum: 256000
SemUndo: 256000 semNumPerID: 250 semOps: 32 semUndoSize: 20
SemMaxVal: 32767 semajustonexit: 32767
Cur cpu time limit (seconds) = 0 xFFFFFFFF
Cur file size limit (bytes) = 0 xFFFFFFFF
Cur data size (bytes) = 0 xFFFFFFFF
Cur stack size (bytes) = 0x00A00000
Cur core size (bytes) = 0x00000000
Cur memory size (bytes) = 0 xFFFFFFFF
Nofiles (descriptors) = 0x00000800

2013-12-19-21.35.24.548881 + 480 I1899G343 LEVEL: Error
PID: 5979 TID: 3050367200 PROC: db2set
INSTANCE: db2inst1 NODE: 000
FUNCTION: DB2 UDB, bsu security, sqlexAuditGetNodeNum, probe: 13176
MESSAGE: ZRC = 0x070F00B8 = 118423736 = SQLO_NOT_FOUND
"Environment/registry variable was not found ."

2013-12-19-23.08.04.323645 + 480 i7336g904 LEVEL: Error
PID: 6306 TID: 3050825424 PROC: db2fm
INSTANCE: db2inst1 NODE: 000
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller: getState, probe: 40
MESSAGE: ECF = 0x9000028C =-1879047540 = ECF_GCF_GCF_FUNCTION_TIMED_OUT
Timeout occured while calling a GCF interface function
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0xB7D19809/opt/ibm/db2/V9.7/lib32/libdb2osse. so.1 + 0xBE809
[1] 0xB7D1AA78 ossLog + 0x96
[2] 0xB7C0F249 _ ZN9GcfCaller8getStateEP12GCF_PartInfojP11GCF_RetInfo + 0x7D
[3] 0x0804C385 main + 0xBE1
[4] 0x00299E9C _ libc_start_main + 0xDC
[5] 0x0804B721 _ gxx_personality_v0 + 0x111
[6] 0x00000000? Unknown + 0x0
[7] 0x00000000? Unknown + 0x0
[8] 0x00000000? Unknown + 0x0
[9] 0x00000000? Unknown + 0x0

2013-12-19-23.08.04.324035 + 480 I734541G1101 LEVEL: Error
PID: 6306 TID: 3050825424 PROC: db2fm
INSTANCE: db2inst1 NODE: 000
FUNCTION: DB2 Common, Generic Control Facility, GcfCaller: getState, probe: 40
MESSAGE: ECF = 0x90000292 =-1879047534 = ECF_GCF_SERVICE_FUNCTION_FAILED
The GCF function ran properly but the service did not behave accordingly
CALLED: DB2 Common, Generic Control Facility, gcf_reset
RETCODE: ECF = 0x90000298 =-1879047528 = ECF_GCF_FAILURE
Failure as reported through GCF standard (GCF_FAILURE)
CALLSTCK: (Static functions may not be resolved correctly, as they are resolved to the nearest symbol)
[0] 0xB7D19809/opt/ibm/db2/V9.7/lib32/libdb2osse. so.1 + 0xBE809
[1] 0xB7D1A94D ossLogRC + 0x4F
[2] 0xB7C0F29F _ ZN9GcfCaller8getStateEP12GCF_PartInfojP11GCF_RetInfo + 0xD3
[3] 0x0804C385 main + 0xBE1
[4] 0x00299E9C _ libc_start_main + 0xDC
[5] 0x0804B721 _ gxx_personality_v0 + 0x111
[6] 0x00000000? Unknown + 0x0
[7] 0x00000000? Unknown + 0x0
[8] 0x00000000? Unknown + 0x0
[9] 0x00000000? Unknown + 0x0