By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,382 Members | 2,032 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,382 IT Pros & Developers. It's quick & easy.

SQL Locks

P: n/a
Does this mean that only one of the two offending SQL statements
finished? The other did not?

2006-10-04-22.16.02.828568 Instance:xrprod Node:000
PID:11482(db2agent (CLINK_P)) Appid:C0A80AD6.AE97.061005051554
data_management sqldEscalateLocks Probe:2 Database:LINK_P

-- Lock Count, Target : 6491, 3245
-- Table (ID) Name : (1;14) LINK .VEHICLES_CA
-- Locks, Request Type : 6486, X
-- Result (0 = success): 0

SUCCESS: 0 Means this is not a deadlock, they both made it?

I have been getting one each min for 10 mins while a Java jobs runs
at night.

Thanks again

Ted
Oct 5 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Willard Farwark wrote:
Does this mean that only one of the two offending SQL statements
finished? The other did not?

2006-10-04-22.16.02.828568 Instance:xrprod Node:000
PID:11482(db2agent (CLINK_P)) Appid:C0A80AD6.AE97.061005051554
data_management sqldEscalateLocks Probe:2 Database:LINK_P

-- Lock Count, Target : 6491, 3245
-- Table (ID) Name : (1;14) LINK .VEHICLES_CA
-- Locks, Request Type : 6486, X
-- Result (0 = success): 0

SUCCESS: 0 Means this is not a deadlock, they both made it?

I have been getting one each min for 10 mins while a Java jobs runs
at night.
All queries completed. (If one didn't, you would have seen an error in
your applciation - either a lock timeout or deadlock error.)

All this message is telling you is that the lock escalation request was
successful.

You can avoid this scenario by increasing LOCKLIST (total space
allocated for locks) or by increasing MAXLOCKS (which increases the
percentage of LOCKLIST that a single query can use for locks before
triggering lock escalation).

--
Matt Emmerton

Oct 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.