Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Problems In my Log - Lock Count

    Hai,
    I have been recieving the particular erro in my db2diag.log file for the last 2 days.

    2003-03-26-15.46.06.562000 InstanceB2 Node:000
    PID:1708(db2syscs.exe) TID:2808 Appid:CB512D0B.040E.030326074222
    data_management sqldEscalateLocks Probe:2 Database

    -- Lock Count, Target : 7346, 3673
    -- Table (ID) Name : (2;3) SSCWEB .ARTATTR
    -- Locks, Request Type : 6815, S
    -- Result (0 = success): 0

    Has any one got such an error before or can help me out with this.
    Is it because the table is kept locked due to some exp/imp activities.

    Thanks in advance

    Mickykt

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Problems In my Log - Lock Count

    Seems like it's a case of lock escalation!!! Lock escalation is a process where row level locks are replaced with table level lock due to the lack of memory allocated to database parameter LOCKLIST. You might want to look at configuring the LOCKLIST and MAXLOCKS parameter. Refer to admin guide for more information.

    dollar


    Originally posted by mickykt
    Hai,
    I have been recieving the particular erro in my db2diag.log file for the last 2 days.

    2003-03-26-15.46.06.562000 InstanceB2 Node:000
    PID:1708(db2syscs.exe) TID:2808 Appid:CB512D0B.040E.030326074222
    data_management sqldEscalateLocks Probe:2 Database

    -- Lock Count, Target : 7346, 3673
    -- Table (ID) Name : (2;3) SSCWEB .ARTATTR
    -- Locks, Request Type : 6815, S
    -- Result (0 = success): 0

    Has any one got such an error before or can help me out with this.
    Is it because the table is kept locked due to some exp/imp activities.

    Thanks in advance

    Mickykt

  3. #3
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Logs Error

    Hai,
    Thanks for the reply.
    I have a doubt ,how would this lock only happen to a particular table though many othere tables are used equally.The lock is shown only for one table.
    I have increased my locklist parameter and am constanly monitoring the logs.

    I also wold be greateful if u could give some guide line for having a good database performance,especially the memory usage.

    Regards,
    Micky

  4. #4
    Join Date
    Jul 2002
    Posts
    21
    Kindly check your query execution plan using command center. If it takes a tablescan then create appropriate indexes necessary on the required table. After creating indexes execute runstat command on the table so that the new access plan can be generated.
    Sometime if your indexes are corrupted, the access plan does not show so, you will have to judge and drop the index and recreate it again. The damaged indexes also locks the table.

Posting Permissions

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