mysql unexpected identifier_DB2报SQLEX_UNEXPECTED_SYSERR错误解决

偶然发现自己的DB2测试环境无法使用，打开老是报错，之前一直以为是db2audit报错

偶然发现自己的DB2测试环境无法使用，打开老是报错，之前一直以为是db2audit报错

DB2数据库性能调整和优化(第1、2版) PDF

DB2数据库性能优化介绍

DB2 9.7 for Linux 5.4安装详细步骤

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 semAdjustOnExit:32767

Cur cpu time limit (seconds) = 0xFFFFFFFF

Cur file size limit (bytes) = 0xFFFFFFFF

Cur data size (bytes) = 0xFFFFFFFF

Cur stack size (bytes) = 0x00A00000

Cur core size (bytes) = 0x00000000

Cur memory size (bytes) = 0xFFFFFFFF

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 I733636G904 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

本文原创发布php中文网，转载请注明出处，感谢您的尊重！