各位,这两天数据库发现一个奇怪的问题,部分表记录无法写入,部分可以。总体表现为数据库性能下降。
不能写入的表
都包含LONG VARCHAR FOR BIT ,该表共3个字段。记录数均在一千万左右。
数据库版本为9.1,fp11.操作系统:aix5.3
现贴上部分日志,请大家帮忙看下。其中比较明显的错误为第6行:sqlbDirectWrite:
2012-09-27-11.22.27.178699+480 I16542154A463 LEVEL: Error
PID : 1147206 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-989 APPID: 172.30.16.10.41611.120927014854
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDirectWrite, probe:820
MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
"LockTimeOut - tran rollback Reason code 68"
2012-09-27-11.22.27.178877+480 I16542618A459 LEVEL: Error
PID : 1147206 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-989 APPID: 172.30.16.10.41611.120927014854
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDirectWrite, probe:820
DATA #1 : String, 74 bytes
Obj={pool:3;obj:780;type:2} State=x27 Parent={3;780}, EM=10848, PP0=10880
2012-09-27-11.22.27.179048+480 I16543078A917 LEVEL: Error
PID : 1147206 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-989 APPID: 172.30.16.10.41611.120927014854
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDirectWrite, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 72 bytes
Obj: {pool:3;obj:780;type:2} Parent={3;780}
lifeLSN: 0000011164FA
tid: 0 0 0
extentAnchor: 10848
initEmpPages: 0
poolPage0: 10880
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 32
bufferPoolID: 1
partialHash: 17563651
bufferPool: 0x0780000027019280
2012-09-27-11.22.31.337123+480 I16543996A1134 LEVEL: Severe
PID : 225616 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-673 APPID: 172.30.16.11.57635.120927030348
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDirectWrite, probe:790
MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
"LockTimeOut - tran rollback Reason code 68"
DATA #1 : Direct write control block, PD_TYPE_SQLB_DIRECT_WRITE_CB, 96 bytes
obj: 0x07800002240a3580
accessMethod: 1
noMessageFlag: 624144704
length: 1
poolPointer: 57007379
objectPointer: 20434707
bytesProcessed: 0
utilityFlag: 0
addr_scheme: SQLB_AS_SECT512
buffer: 0x00000001108aed80
globals: 0x000000011083dfe0
isRestore: false
latchesHeld: 0x0000000000000000
ioPriority: 0
flushOptions: 0
smsFileOpenMode: 0
2012-09-27-11.22.31.338535+480 I16545131A466 LEVEL: Error
PID : 225616 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-673 APPID: 172.30.16.11.57635.120927030348
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDirectWrite, probe:860
MESSAGE : ZRC=0x80100044=-2146435004=SQLP_LTIMEOUT
"LockTimeOut - tran rollback Reason code 68"
2012-09-27-11.22.31.338708+480 I16545598A572 LEVEL: Error
PID : 225616 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-673 APPID: 172.30.16.11.57635.120927030348
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDirectWrite, probe:860
DATA #1 : String, 183 bytes
Obj={pool:3;obj:265;type:2} State=x27 Parent={3;265}, EM=3616, PP0=3648 Page=57007379 Cont=0 Offset=57007635 BlkSize=9
Container name = /db2inst1/db2inst1/NODE0000/db2inst1/T0000003/C0000000.LRG
2012-09-27-11.22.31.338967+480 I16546171A920 LEVEL: Error
PID : 225616 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-673 APPID: 172.30.16.11.57635.120927030348
AUTHID : db2inst1
FUNCTION: DB2 UDB, buffer pool services, sqlbDMSDirectWrite, probe:0
DATA #1 : Object descriptor, PD_TYPE_SQLB_OBJECT_DESC, 72 bytes
Obj: {pool:3;obj:265;type:2} Parent={3;265}
lifeLSN: 000001016582
tid: 0 0 0
extentAnchor: 3616
initEmpPages: 0
poolPage0: 3648
poolflags: 3122
objectState: 27
lastSMP: 0
pageSize: 4096
extentSize: 32
bufferPoolID: 1
partialHash: 50921475
bufferPool: 0x0780000027019280
2012-09-27-11.22.31.375217+480 I16547092A443 LEVEL: Severe
PID : 225616 TID : 1 PROC : db2agent (db2inst1) 0
INSTANCE: db2inst1 NODE : 000 DB : db2inst1
APPHDL : 0-673 APPID: 172.30.16.11.57635.120927030348
AUTHID : db2inst1
FUNCTION: DB2 UDB, DRDA Application Server, sqljsSignalHandler, probe:10
MESSAGE : DIA0505I Execution of a component signal handling function has begun.
2012-09-27-11.22.31.376395+480 I16547536A165 LEVEL: Severe
PID:225616 TID:1 NODE:000 Title: **** DRDA ASCB ****
Dump File:/home/db2inst1/sqllib/db2dump/2256161.000
以下dump文件省略
收起