Results 1 to 3 of 3

Thread: Lock list full

  1. #1
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276

    Unanswered: Lock list full

    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.

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186
    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.
    David Quigley

  3. #3
    Join Date
    May 2002
    Location
    General Deheza, Cba, Arg.
    Posts
    276
    thanks quigleyd.
    Abel.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •