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: 6967
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 IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am


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