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
 
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: 10326
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: 1281
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 line 52: Name or string > 250 char... Ashishpanpaliya CLIST & REXX 5 Sat Oct 14, 2017 2:29 am
No new posts How to write Rexx program to size and... sreejeshcs CLIST & REXX 14 Thu Oct 12, 2017 7:26 am
No new posts Accessing CICS tran with map from JCL... navdeepaggarwal CICS 5 Tue Oct 03, 2017 6:15 pm
No new posts Generate public-private key in batch ... vasanthz All Other Mainframe Topics 3 Fri Sep 15, 2017 9:20 am
No new posts Working with hex values in Filemanage... Emile Straker IBM Tools 0 Tue Sep 12, 2017 1:42 am

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