Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 Fetch Previous month & year in MM... girishb2 DFSORT/ICETOOL 3 Thu Sep 21, 2017 9:54 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am
No new posts Repeat part of record multiple times Learncoholic DFSORT/ICETOOL 4 Tue Aug 29, 2017 11:33 am
No new posts Match two files using multiple keys a... santoshks1987 SYNCSORT 11 Fri Aug 18, 2017 10:50 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us