| View previous topic :: View next topic |
| Author |
Message |
abracadabra
Beginner
Joined: 02 Sep 2003
Posts: 101
Topics: 55
Location: India
|
 Posted: Sat Jan 24, 2004 4:29 am Post subject: Lockmax-904 |
 |
|
What is the significance of LOCKMAX in SYSIBM.SYSTABLESPACE? Does LOACKMAX=-1 mean that the tablespace is locked? I am trying to update a table and getting -904.
_________________
Cheers! |
|
| Back to top |
|
 |
Himesh
CICS Forum Moderator
Joined: 20 Dec 2002
Posts: 80
Topics: 21
Location: Chicago
|
| Posted: Sat Jan 24, 2004 9:50 am Post subject: |
|
|
Hi,
The LOCKMAX parameter is used by DB2 to decide on when to escalate a lock.
Could you pls refer to the following PDF
DB2 UDB Administration Guide
An excerpt from the same:
| Quote: | LOCKMAX n
Specifies the maximum number of page or row locks that a single application
process can hold on the table space before those locks are escalated |
I guess you need to first find out about the process(s), that actually is acquiring the locks and then look at eliminating the same by re-visiting your application/database design.
The chapter on "Improving concurrency" will be of immense help in this regard.
regards,
himesh |
|
| Back to top |
|
|
chanm
Beginner
Joined: 18 Mar 2004
Posts: 1
Topics: 0
|
| Posted: Thu Mar 18, 2004 6:17 pm Post subject: |
|
|
Is it a program that you are using to update the table?. If yes are you doing commits in between?. This problem generally occurs if the number of locks of your program is trying to acquire exceeded the number defined in IRLM(Internal resource lock manager).
Hope it helps. |
|
| Back to top |
|
|
mdizon02
Beginner
Joined: 14 Nov 2006
Posts: 2
Topics: 1
|
| Posted: Mon Apr 16, 2007 4:49 am Post subject: |
|
|
hi, i am having the same problem, and yes my program is doing several commits in between. How do I sove this?
Thanks. |
|
| Back to top |
|
|
Manas Biswal
Intermediate
Joined: 29 Nov 2002
Posts: 382
Topics: 27
Location: Chennai, India
|
| Posted: Mon Apr 16, 2007 9:09 am Post subject: |
|
|
abracadabra, mdizon02,
Whats the problem here. LOCKMAX set to -1 only means that you have set the LOCKMAX as SYSTEM in your tablespace create (or alter). This is always recommended in most situations unless you are experienced and comfortable in tuning it.
Is your problem the -1 value or are you getting a lot of lock escalations?
Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948) |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
