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
 

 

CICS online program error's -904 & -471

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

New User


Joined: 07 Jun 2005
Posts: 6

PostPosted: Wed Jul 28, 2010 2:29 pm    Post subject: CICS online program error's -904 & -471
Reply with quote

Hi

Can some please help me in resolving the below issue that I have been facing since yesterday. For the same program for different input I am getting the below errors. I have searched in form and could not get any solution.

I have compile and binded the program as it is db2 online program and also did NEW copy in ONLINE region.

*** SQL ERROR: 471-, TRANID: RY03

*** SQL ERROR: 904-,

Thanks,
Chandra.
Back to top
View user's profile Send private message

Garry Carroll

Active Member


Joined: 08 May 2006
Posts: 995
Location: Dublin, Ireland / Edinburgh, Scotland

PostPosted: Wed Jul 28, 2010 2:41 pm    Post subject:
Reply with quote

Quote:
*** SQL ERROR: 904-,


SQL CODe -904 is resource unavailable. Suggests that something else is using the resource.

SQL code -471 - suggestion is to look for related DSNX9xx message on console.

Garry.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6968
Location: porcelain throne

PostPosted: Wed Jul 28, 2010 2:43 pm    Post subject:
Reply with quote

you should have referred to the manual for the error messages.

both come with a reason code, which provides more explanation.

use the IBM LookAt site, which will provide you with the manual,
and page concerning the error messages.
then follow the instructions in the manual for finding the reason codes.
Back to top
View user's profile Send private message
gschandu13

New User


Joined: 07 Jun 2005
Posts: 6

PostPosted: Wed Jul 28, 2010 8:53 pm    Post subject: Reply to: CICS online program error's -904 & -471
Reply with quote

Hi,

I know what does -471 and 904 error description. But the problem there is error code that is displayed. I repaired with REPAIR for that particular table and it was successfull. But still I am getting the same error. The online program is using tables as well as on stored procedure. I tried all my options and posted.

Thanks,
Chandra.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm
No new posts How to Clear all TSQs during CICS sta... Hooman24 CICS 10 Mon Jun 26, 2017 9:46 pm
No new posts pre-compiler for program in an HFS Pedro DB2 0 Fri Jun 23, 2017 11:13 pm
No new posts CICS Transaction attach count of supp... lind sh CICS 1 Wed Jun 21, 2017 1:33 pm
No new posts Compiling program in endeavor for tra... RALAKKAL Compuware & Other Tools 4 Mon Jun 05, 2017 8:27 pm


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