Page 1 of 1

SQl Error -904

PostPosted: Thu Nov 18, 2010 1:04 pm
by abhi.d.leo
Hi ,

I am trying to update a table in test using SPUFI. There are multiple similiar & Simple updates on same table.But at one particular update statment processing terminates with SQLCODE -904.

I find following error message:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000302, AND
RESOURCE NAME XYZXYTST.ABCAB09 . X'070005B3'
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRRC SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 101 13172746 0 13228501 -404549623 0 SQL DIAGNOSTIC
INFORMATION
DSNT416I SQLERRD = X'00000065' X'00C9000A' X'00000000' X'00C9D9D5'
X'E7E31009' X'00000000' SQL DIAGNOSTIC INFORMATION

I am getting this error even I try to execute the same UPDATE statement alone.

Does anyone has any Idea?

Regards,

~Abhi

Re: SQl Error -904

PostPosted: Thu Nov 18, 2010 1:22 pm
by mathigee
Hi abi,

Are you trying to update primary key value?

Re: SQl Error -904

PostPosted: Thu Nov 18, 2010 1:22 pm
by GuyC
search for "00C90096" will give you the answer.

Re: SQl Error -904

PostPosted: Thu Nov 18, 2010 2:11 pm
by abhi.d.leo
Thank you! Guy C.

Here is the explanation I found:

"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"

I was suspecting for the same.

Regards,
~Abhi