00C90096
Explanation: The page, row or LOB lock on the page or subpage identified
by NAME in message DSNT500I or DSNT501I caused the total number of page,
row or LOB locks concurrently held to reach the installation maximum
number of page, row or LOB locks (NUMLKUS) allowed for a single agent in
the system.
Programmer Response: Reduce the total number of page, row or LOB locks
that the application concurrently holds by changing the locking protocol
on one or more of the table spaces to table space level locking. To do
this, use the ALTER ... LOCKSIZE TABLESPACE or LOCK TABLE statements.
Review the application to see if a different choice of SQL statements can
be used to perform the same operation with less concurrent access to
multiple tables with page, row or LOB locking.
If application logic permits, reduce the number of page, row or LOB locks
concurrently held for SELECT statements by rebinding the application plan
with isolation level of cursor stability instead of repeatable read or
read stability, or add more frequent commits.
System Programmer Response: If the application should be able to run with
the current page, row or LOB locking protocol and SQL statements, increase
the NUMLKUS value for the installation to allow a higher limit of page,
row or LOB locks to be concurrently held by a single application. If a
utility job encountered this resource unavailable condition, the NUMLKUS
value must be increased to accommodate the utility, because utilities are
programmed to use the minimum number of page, row or LOB locks possible.
Refer to Part 5 (Volume 2) of DB2 Administration Guide for further
information about choosing the value for NUMLKUS.
David A. Carow
Database Analyst
Enterprise Information Services
(920) 628-2777
Dave Carow/WI/Thrivent
Thrivent Financial for Lutherans
4321 N. Ballard Rd., Appleton, WI 54919-0001
"Ward Mike S "
<db2udbdba-ezmlms
hield-x12476156.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
02/24/2005 07:53 cc
AM
Subject
SQL Command
I am a newbie to db2 can someone explain to me why I am getting an error
on this command.
Thanks in advance.
db2 => UPDATE PROD.S_ADDR_PER SET PER_ID = (SELECT PROD.S_CONTACT.ROW_ID
ROM PROD.S_CONTACT, PROD.S_ADDR_PER WHERE PR_PER_ADDR_ID = PROD.S_ADDR
PER.ROW_ID AND PR_PER_ADDR_ID = '1-MMY9O')
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it returned:
SQL0904N Unsuccessful execution caused by an unavailable resource.
Reason
code: "00C90096", type of resource: "00000304", and resource name:
"SBLP02
.H0008005.X'002A28' '.X'09' ". SQLSTATE=57011
---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
DB2 & UDB email list listserv db2-l LazyDBA home page