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

    Unanswered: Locks on table in Logs

    Hai all,
    I had early posted a particular error in my db2diag.log

    As per the advice i increased the locklist parameter.

    I also had a doubt if the locklist parameter is low how would it just affect a single table ,while there are other tables which are more larger and more accessed ,then why for this particular table alone.
    The bad news is that i am still facing the same problem.


    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 DatabaseSCWEB

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


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

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


    This occurs nearly 20 times a day only if the table is used.ie;on saturdays and sundays and off peak times during the day time this error does not occur.Only when it is accessed.

    Is this a serious issue or can i ignore it till we have our monthly tunning time which will take two weeks time.

    It would be very greatfull if any one could advice me on this.

    Thanks in advance

    Micky

  2. #2
    Join Date
    Sep 2002
    Posts
    456

    Re: Locks on table in Logs

    well, increasing the locklist parameter is not good enough, you also have to adjust your maxlocks paramter accordingly. Locklist is the total storage allocated to locks whereas maxlock is the % of locklist allocated to each application. The formula to calculate maxlocks is:

    maxlocks = 2 * 100 / maxappls

    you can get the value of maxappls from your db config file.

    Try adjusting this value, might help!!!

    dollar

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

    Re: Locks on table in Logs

    Hai,
    I am a bit comfused ,
    I have set a value of 132 (4K) pages of mem for my lock list.
    The value set for my maxlocks is 66 while maxappl is 40.according to ur equation my maxlocks should be 2*100/40=5

    so is the value set too high.

    so does this mean that 5% of my locklist memory would be equally divided amoung the 40 applications at maximum load.

    Is this the real problem.

    Thanks

    micky

  4. #4
    Join Date
    Sep 2002
    Posts
    456

    Re: Locks on table in Logs

    Well, it could be part of the problem. Keep in mind that when you configure one parameter it affects others as well. Do one thing at a time and see the effect. The value of 5 is right in your case so go ahead and change and then monitor again.

    dollar

    Originally posted by mickykt
    Hai,
    I am a bit comfused ,
    I have set a value of 132 (4K) pages of mem for my lock list.
    The value set for my maxlocks is 66 while maxappl is 40.according to ur equation my maxlocks should be 2*100/40=5

    so is the value set too high.

    so does this mean that 5% of my locklist memory would be equally divided amoung the 40 applications at maximum load.

    Is this the real problem.

    Thanks

    micky

Posting Permissions

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