MVSFORUMS.com

[nagapa]

Hi,
I have a program that selects a record from a table and updates it. This table is a counter table, which holds all counter values. My programs picks a specific record from this table, uses the counter value and updates it with the new value. During this process the table is locked. When another program tried to access this table for a diff counter value, its abends with deadlock error -913.

Can anyone suggest a solution to get rid of this -913 abend in this logic.

Is there a way to do row level locking instead of table lock.

Regards
Nagappan

[Manas Biswal]

nagapa,

Try the following actions -
- Define the tablespace of the table with LOCKSIZE - ROW.
- Use an isolation level of CS in your program which retrieves the counter value.

See if that solves your problem.

Regards,
Manas

[nagapa]

Thanks Manas,
As developers we usually dont create table, but I have admin rights. Can I redefine this existing table for LOCKSIZE - ROW, or I have go for a new table and copy across the data from old to new.

Regards
Nagappan

[Manas Biswal]

nagapa,
LOCKSIZE is defined at the tablespace level and not at a table level.

Regards,
Manas

[SureshKumar]

Nagapa,
Ther are so many different variables that can impact. For example what is the size of the table you are updating - if its a very small table, DB2 takes a table lock else it will go for a page lock. How often do you commit, how important is the select in the second program - can it use WITH UR ? Is your process Batch or Online ? Most often its a design solution. Unless locks are held for too long it should be simple to handle programatically. Thanks

[suggala_r]

Nagapa,

As sureshkumar mentioned..You may need to consider all the factors what he mentioned..Added to that if it is online program..Handle -913
condition and retry the same paragraph 5-10 times..you should be able to
overcome..unless there is huge volume (Hits) on the same table..

Raghu
_________________
Raghu