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 with Multiple Row Fetch Logic

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

New User


Joined: 13 Sep 2005
Posts: 18

PostPosted: Thu Jun 14, 2007 3:44 pm    Post subject: Getting -904 with Multiple Row Fetch Logic
Reply with quote

My cursor fetches 18,22,749 number of rows.
To reduce the run time i declared the
cursor with Rowset Positioning.

i.e FETCH NEXT ROWSET TAX_CSR FOR 100 ROWS

in the above case i am getting -904(resource
not available) after fetching some 291489
rows.

The same cursor without this multiple
row fetch logic is working fine.whereas with rowset positioning i am getting -904.
can anybody tell me the process to solve this error
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: Fri Jun 15, 2007 1:54 am    Post subject:
Reply with quote

Hello,

Is the -904 always after the same number of fetched rows?

What is the reason code? What other diagnostic information was presented (look in the jes sysout datasets).

What type of resource failed and what was the name of that resource?

I'd suggest you look into the "DB2 Messages & Codes" linked to from the "Manuals" link at the top of the page.
Back to top
View user's profile Send private message
Santoshdorge

New User


Joined: 27 Jun 2006
Posts: 48
Location: Pune

PostPosted: Fri Jun 15, 2007 9:56 am    Post subject:
Reply with quote

Hi,
One of the reason for -904 is limit on the number of locks aquired.
you can bind the program with isolation option CS(cursor stability)
and execute the same.
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 Changeman get multiple "Browse C... elixir1986 Compuware & Other Tools 4 Fri Jul 14, 2017 1:48 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Need DB2 query to fetch previous row ! Chandan1993 DB2 10 Sat Jun 03, 2017 10:43 am
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm


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