You are running out of lock resources. maybe you could break that update
up so that it will update less rows. Change the
update to a select and see how many rows it would update. Its probably not
a great practice to update that many rows
at once. You will use up lock resources and nobody else can get access
while you are running that sql.






"Ward Mike S "
<db2udbdba-ezmlms
hield-x12476156.x To
[Email Address Removed] "LazyDBA Discussion"
a.com> <[Email address protected]
cc
02/24/2005 08:53
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