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
 

 

on line ok but batch gets -904

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

New User


Joined: 16 Sep 2008
Posts: 19
Location: illinois

PostPosted: Wed Dec 16, 2009 12:25 am    Post subject: on line ok but batch gets -904
Reply with quote

We have a random number generator program that is called by the on-line transactions. This program fetches and updates the next available number from a DB2 table. The on-line transactions always come back with the number and never a -904. We recently installed a batch program that also calls the random number generator, but it is plagued with -904s. Has anyone experienced this and resolved it?
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10231
Location: italy

PostPosted: Wed Dec 16, 2009 12:34 am    Post subject: Reply to: on line ok but batch gets -904
Reply with quote

what does the manual say about a -904 error code ?
read the manual and act accordingly to it' s suggestions
Back to top
View user's profile Send private message
Terry Heinze

JCL Moderator


Joined: 14 Jul 2008
Posts: 1249
Location: Richfield, MN, USA

PostPosted: Wed Dec 16, 2009 10:16 am    Post subject:
Reply with quote

Also, "random number" and "next available number" seem to be contradictory.
Back to top
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Dec 16, 2009 2:24 pm    Post subject:
Reply with quote

Hi xsray,

Please post full error text with the reason code.

Sushanth
Back to top
View user's profile Send private message
Lijo

New User


Joined: 24 Aug 2008
Posts: 41
Location: Cochin

PostPosted: Wed Dec 16, 2009 3:08 pm    Post subject: Reply to: on line ok but batch gets -904
Reply with quote

As said look into the Manual. Look for the REASON CODE (an 8 character value in the error message, like REASON 00C90084) under -904 SQLCODE. -904 can happen due to various reasons. Follow the instructions under 'User Response'.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Wed Dec 16, 2009 9:46 pm    Post subject:
Reply with quote

look at what the random number generator program does.
It probably updates/inserts some value in some table.

Replace this with db2 sequence.
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 Batch job tuning sgandhla Testing & Performance analysis 0 Fri Mar 24, 2017 9:41 pm
No new posts Count the length of the record & ... sreekusr DFSORT/ICETOOL 4 Thu Mar 23, 2017 7:52 pm
No new posts MIPS/CPU consumption reduction in Batch vishwakotin DFSORT/ICETOOL 4 Sat Mar 18, 2017 5:46 pm
No new posts TSO or command line utility to genera... kishpra JCL & VSAM 3 Thu Mar 09, 2017 1:11 am
No new posts How does a called pgm know if its cal... Graeme Westerman COBOL Programming 4 Tue Nov 29, 2016 9:25 pm


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