Hi,

DB2 for windows 8.1.5

My db2diag show this:
---------------------------------------------
2004-07-22-09.22.00.480000 InstanceB2INST1 Node:000
PID:8064(db2syscs.exe) TID:11840 Appid:*LOCAL.DB2INST1.051182122201
access plan manager sqlra_find_pkg Probe:99 DatabaseBDC

DIA8310C Lock list was full.
ZRC=0x8510000Aÿ

PID:11260 TID:9500 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -912 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRAPLK

sqlerrd : (1) 0x8510000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57011

2004-07-22-09.23.18.637000 InstanceB2INST1 Node:000
PID:8064(db2syscs.exe) TID:11732 Appid:*LOCAL.DB2INST1.051182122318
access plan manager sqlra_find_pkg Probe:99 DatabaseBDC

DIA8310C Lock list was full.
ZRC=0x8510000Aÿ

PID:11260 TID:9500 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -912 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRAPLK

sqlerrd : (1) 0x8510000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57011

2004-07-22-09.23.18.746000 InstanceB2INST1 Node:000
PID:8064(db2syscs.exe) TID:9616 Appid:*LOCAL.DB2INST1.051182122319
access plan manager sqlra_find_pkg Probe:99 DatabaseBDC

DIA8310C Lock list was full.
ZRC=0x8510000Aÿ

PID:11260 TID:9500 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -912 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRAPLK

sqlerrd : (1) 0x8510000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57011

2004-07-22-09.24.44.903000 InstanceB2INST1 Node:000
PID:8064(db2syscs.exe) TID:11880 Appid:*LOCAL.DB2INST1.051182122444
access plan manager sqlra_find_pkg Probe:99 DatabaseBDC

DIA8310C Lock list was full.
ZRC=0x8510000Aÿ

PID:11260 TID:9500 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -912 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRAPLK

sqlerrd : (1) 0x8510000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57011

2004-07-22-09.24.45.012000 InstanceB2INST1 Node:000
PID:8064(db2syscs.exe) TID:11764 Appid:*LOCAL.DB2INST1.051182122445
access plan manager sqlra_find_pkg Probe:99 DatabaseBDC

DIA8310C Lock list was full.
ZRC=0x8510000Aÿ

PID:11260 TID:9500 Node:000 Title: SQLCA
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -912 sqlerrml: 0
sqlerrmc:
sqlerrp : SQLRAPLK

sqlerrd : (1) 0x8510000A (2) 0x0000000A (3) 0x00000000
(4) 0x00000000 (5) 0x00000000 (6) 0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 57011
---------------------------------------------

I find any information abaout this message "DIA8310C Lock list was full".

TIA
Abel.

Change your locklist parm, out of the box its too small, try increasing it slowely until you don' t get that message. Start with 20000 and work your way up. Depending on how much stuff you have running in your system you may need to increase it allot higher. It is database cfg parm.

thanks quigleyd.
Abel.