468,258 Members | 1,520 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,258 developers. It's quick & easy.

updating the locklist


If i get the error:: SQL0912N
The maximum number of lock requests has been reached for the database.

I need to increase the Database Configuration Parameter, locklist.

Do I need to restart the database after increasing the locklist size?

Aug 20 '07 #1
1 2523
locklist is configurable online, hence you dont need to re-start the server. But increasing the locklist size may not be the only solution. You should also consider
1> doing frequent commits to release the locks
2> If application integrity requirements are not compromised use Uncommitted
Read to decrease the amount of locking.

Aug 21 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Jason | last post: by
7 posts views Thread by Menon | last post: by
14 posts views Thread by el_sid | last post: by
6 posts views Thread by muttu2244 | last post: by
reply views Thread by =?Utf-8?B?YmFrZXJzaGFjaw==?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by zattat | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.