getting -904 when i tried to delete rows from a table

Jeya Raj · New User Joined: 14 Jan 2007 Posts: 33 Location: USA

Hi,

I'm getting -904 when i tried to delete rows from a table. I need to delete almost 59000 rows. I tried thru SPUFI, BATCH. Still getting the same problem.

Is there a way to delete 5000 rows at a time to avoid this -904 error.

Thanks

This is my error des.

SNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90096, TYPE OF RESOURCE 00000304, AND
RESOURCE NAME BTD1 .BTTS007 .X'010060' '.X'05'
SNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
SNT415I SQLERRP = DSNXRSDL SQL PROCEDURE DETECTING ERROR
SNT416I SQLERRD = -190 13172746 0 13817319 -470675450 0 SQL DIAGNOSTIC
INFORMATION

bauer · New User Joined: 03 Mar 2009 Posts: 28 Location: germany

Have you seen the explanation for the reason code ?

00C90096

Explanation: The page or row lock on the page or subpage identified by NAME in message DSNT500I or DSNT501I caused the total number of page or row locks concurrently held to
reach the installation maximum number of page or row locks (NUMLKUS) allowed for a single agent in the system.

Jeya Raj · New User Joined: 14 Jan 2007 Posts: 33 Location: USA

I tried both ways thru Spufi and program.

bauer · New User Joined: 03 Mar 2009 Posts: 28 Location: germany

Have you seen the reason code?

You reached a system limit of your db2 installation.

Jeya Raj · New User Joined: 14 Jan 2007 Posts: 33 Location: USA

Hi Bauer,

oh ok. I tried the same sql to delete 10 rows at a time. I'm getting the same problem. I'll contact my DBAs. Thank you for your reply. Could you please let me know where can I get the explanation for reason codes?

Thanks

dick scherrer · Posted: Wed Mar 11, 2009 11:39 pm

Hello,

At the top of the page is a link to "IBM Manuals". Among them is the "DB2/UDB Messages & Codes". This is from that manual:
publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/4.8.26?

Jeya Raj · New User Joined: 14 Jan 2007 Posts: 33 Location: USA

Thank you Dick Scherrer.