Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Jeya Raj

New User


Joined: 14 Jan 2007
Posts: 33
Location: USA

PostPosted: Wed Mar 11, 2009 9:21 pm    Post subject: getting -904 when i tried to delete rows from a table
Reply with quote

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
Back to top
View user's profile Send private message

bauer

New User


Joined: 03 Mar 2009
Posts: 26
Location: germany

PostPosted: Wed Mar 11, 2009 10:43 pm    Post subject:
Reply with quote

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.
Back to top
View user's profile Send private message
Jeya Raj

New User


Joined: 14 Jan 2007
Posts: 33
Location: USA

PostPosted: Wed Mar 11, 2009 10:44 pm    Post subject: Reply to: getting -904 when i tried to delete rows from a ta
Reply with quote

I tried both ways thru Spufi and program.
Back to top
View user's profile Send private message
bauer

New User


Joined: 03 Mar 2009
Posts: 26
Location: germany

PostPosted: Wed Mar 11, 2009 10:48 pm    Post subject:
Reply with quote

Have you seen the reason code?

You reached a system limit of your db2 installation.
Back to top
View user's profile Send private message
Jeya Raj

New User


Joined: 14 Jan 2007
Posts: 33
Location: USA

PostPosted: Wed Mar 11, 2009 11:07 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Mar 11, 2009 11:39 pm    Post subject:
Reply with quote

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:
http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/handheld/Connected/BOOKS/dsnmcj10/4.8.26?
Back to top
View user's profile Send private message
Jeya Raj

New User


Joined: 14 Jan 2007
Posts: 33
Location: USA

PostPosted: Thu Mar 12, 2009 12:29 am    Post subject: Reply to: getting -904 when i tried to delete rows from a ta
Reply with quote

Thank you Dick Scherrer.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm
No new posts Data replication from multiple Db2 ta... kishpra DB2 9 Mon Mar 27, 2017 9:58 pm
No new posts To display values of multiple rows in... vinu78 DB2 2 Thu Mar 09, 2017 1:20 pm
No new posts how to send just 10 rows in a CICS sc... Megha Gupta CICS 5 Thu Feb 23, 2017 6:57 pm
No new posts Join of more than one table dibyendumandal11111 DB2 6 Mon Feb 13, 2017 11:36 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us