SQl Error -904



IBM's flagship relational database management system

SQl Error -904

Postby abhi.d.leo » Thu Nov 18, 2010 1:04 pm

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
abhi.d.leo
 
Posts: 6
Joined: Tue Oct 12, 2010 11:16 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQl Error -904

Postby mathigee » Thu Nov 18, 2010 1:22 pm

Hi abi,

Are you trying to update primary key value?
mathigee
 
Posts: 1
Joined: Fri Oct 08, 2010 12:18 pm
Location: Chennai
Has thanked: 0 time
Been thanked: 0 time

Re: SQl Error -904

Postby GuyC » Thu Nov 18, 2010 1:22 pm

search for "00C90096" will give you the answer.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: SQl Error -904

Postby abhi.d.leo » Thu Nov 18, 2010 2:11 pm

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
abhi.d.leo
 
Posts: 6
Joined: Tue Oct 12, 2010 11:16 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post