这是 db2diag.log的输出
大家帮忙看看 谢谢了 初学多多指教了
db2 create event monitor locktimeout for locking WRITE TO UNFORMATTED EVENT TABLE
db2 commit
db2 set event monitor locktimeout state 1
db2 set event monitor locktimeout state 0
执行这一步的时候报错
db2 "call EVMON_FORMAT_UE_TO_TABLES('LOCKING', NULL, NULL, NULL, NULL, NULL,'RECREATE_FORCE', -1,'SELECT * FROM locktimeout ORDER BY event_timestamp')"
报错信息如下:
2010-06-08-10.29.13.258000+480 I1F1123 LEVEL: Event
PID : 3668 TID : 5200 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-4573 APPID: *LOCAL.DB2.100607082614
AUTHID : NOWHILL
EDUID : 5200 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, RAS/PD component, pdLogInternal, probe:120
START : New Diagnostic Log file
DATA #1 : Build Level, 152 bytes
Instance "DB2" uses "64" bits and DB2 code release "SQL09071"
with level identifier "08020107".
Informational tokens are "DB2 v9.7.100.177", "s091114", "IP23029", Fix Pack "1".
DATA #2 : System Info, 1568 bytes
System: WIN32_NT 岑仁彪 6.1 AMD64 Family 6, model 23, stepping 6
CPU: total:2 online:2 Cores per socket:2 Threading degree per core:1
Physical Memory(MB): total:4031 free:916 available:916
Virtual Memory(MB): total:17592186048446 free:17592186044960
Swap Memory(MB): total:17592186044415 free:17592186044044
Information in this record is only valid at the time when this file was
created (see this record's time stamp)
2010-06-08-10.29.13.257000+480 E1127F583 LEVEL: Warning
PID : 3668 TID : 5200 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-4573 APPID: *LOCAL.DB2.100607082614
AUTHID : NOWHILL
EDUID : 5200 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, database application extension for syste, monLockEventFormatter::LogPartialEvents, probe:908
MESSAGE : Partial (incomplete) event with XMLID
'db2LockEvent_8_LOCKWAIT_2010-06-08-10.36.13.040409_0' exists.
2010-06-08-10.29.13.259000+480 E1712F737 LEVEL: Warning
PID : 3668 TID : 5200 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-4573 APPID: *LOCAL.DB2.100607082614
AUTHID : NOWHILL
EDUID : 5200 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, runtime interpreter, sqlriTrustedTruncateTokensUserSqlState, probe:100
DATA #1 : signed integer, 4 bytes
-443
DATA #2 : String with size, 5 bytes
38553
DATA #3 : String with size, 30 bytes
SYSPROC.EVMON_FORMAT_UE_TO_XML
DATA #4 : String with size, 22 bytes
EVMON_FORMAT_UE_TO_XML
DATA #5 : String with size, 43 bytes
Partial events exist. Check the db2diag.log
2010-06-08-10.29.13.260000+480 E2451F991 LEVEL: Error
PID : 3668 TID : 5200 PROC : db2syscs.exe
INSTANCE: DB2 NODE : 000 DB : SAMPLE
APPHDL : 0-4573 APPID: *LOCAL.DB2.100607082614
AUTHID : NOWHILL
EDUID : 5200 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, xml decomposition, xdbDecompMultiBLOB, probe:1444
MESSAGE : ZRC=0xFFFFFFFF=-1
DATA #1 : String, 23 bytes
Error in closing cursor
DATA #2 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -443 sqlerrml: 67
sqlerrmc: EVMON_FORMAT_UE_TO_XML Partial events exist. Check the db2diag.log
sqlerrp : SQLRI4FE
sqlerrd : (1) 0x801A006D (2) 0x00000000 (3) 0x00000000
(4) 0x00000000 (5) 0xFFFFFF83 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 38553
收起