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
 

 

805 error when firing the transaction

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

New User


Joined: 23 Jul 2010
Posts: 10
Location: hyderabad

PostPosted: Fri Nov 02, 2012 12:31 am    Post subject: 805 error when firing the transaction
Reply with quote

Hi ,

We have two collection ids and packages ... TGA & TGB . Our bind is successful for TGA , but it failed for TGB . we know the reason for it and no worries for that .

But my question is , when we fire the transaction in the morning time we are getting 805 error . but thats not happening when we fire the transaction after 4 in the evening. The transaction is working absolutely fine .....

Not sure why is it happening and how is it getting solved by itself ...
Is it possible that .. in the morning time the region is pointing to one package or collection id and in the evening other ... icon_smile.gif i m getting this wild idea / doubt because of this strange behavior .....
Did anyone encounter such situation ..... ? please help me ...
Back to top
View user's profile Send private message

prino

Active Member


Joined: 07 Feb 2009
Posts: 982
Location: Oostende, Belgium

PostPosted: Fri Nov 02, 2012 2:44 am    Post subject:
Reply with quote

How do you "fire" a transaction? Do you use an UZI, or a COLT 45, or Walther PPK? Or do you give it a pink slip?
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 Nov 02, 2012 2:59 am    Post subject:
Reply with quote

Hello,

What happens at 4 in the evening?

Knowing exactly why the 805 is raised may offer a suggestion to what "fixes" it . . .

We have a policy that if a bind fails, it is fixed right then, so we don't have the opportunity for something to magically fix itself.
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


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

PostPosted: Fri Nov 02, 2012 3:04 am    Post subject:
Reply with quote

sreelu.s
wrote:
Is it possible that .. in the morning time the region is pointing to one package or collection id and in the evening other


sreelu.s
while I can provide praise concerning your assumption,
i question your ability to find your way home
based on your question.

had you looked at the SDSF (or whatever spool support software you uses)
CICS JOBs and look at the allocation messages for the cics task as it starts.
that will tell you the 'user' libraries that are being used.
while you are there,
they will tell you in which
CICS StartJCL
DD REFEFerence Name concatenation
they exist.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 7904
Location: Bellevue, IA

PostPosted: Fri Nov 02, 2012 5:11 am    Post subject:
Reply with quote

Is the 805 an SQL code, or a code generated by the application, or what? CICS codes (and you posted in the CICS forum) are 4-characters such as AKC3 or AICA -- definitely not 3-digit numbers.

When does the region come down and come up? When does DB2 come down and come up?
Back to top
View user's profile Send private message
sreelu.s

New User


Joined: 23 Jul 2010
Posts: 10
Location: hyderabad

PostPosted: Sat Nov 03, 2012 12:26 am    Post subject:
Reply with quote

805 is the msg generated by the program .... its like error handling .. if we get the sqlcode other than 0 we will send the program name and the sql code on to the screen as message ... by that we can find the error ..

The transaction is running in QA region ... where i didnt see the details in the cics messages and job details ....

Please help me how to check those things in the sdsf or osda ..... so that will check ..

Thanks to everyone .. for the quick responses ...
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: Sat Nov 03, 2012 1:20 am    Post subject:
Reply with quote

Hello,

Quote:
805 is the msg generated by the program
Why might a program raise an 805? I suspect the program issued some SQL statement that returned the 805 and the program simply passed this along. . .

There are multiple reasons that cause an -805. Have you made sure that none of them can happen or has happened?

How often is a bind done on these?

Again, why is a run attempted when the bind has failed . . . icon_confused.gif
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10201
Location: italy

PostPosted: Sat Nov 03, 2012 1:47 am    Post subject: Reply to: 805 error when firing the transaction
Reply with quote

Quote:
Again, why is a run attempted when the bind has failed . .


just like when asking a girl out for dinner,
even if she said no, maybe asking again will make her say Yes

or if we want to tackle the issue from a philosophical point of view ...
everybody deserves a second chance

icon_cool.gif
Back to top
View user's profile Send private message
haimzeevi

New User


Joined: 01 Mar 2010
Posts: 27
Location: Israel

PostPosted: Mon Nov 05, 2012 6:55 pm    Post subject: Reply to: 805 error when firing the transaction
Reply with quote

sreelu.s,
First, like everybody mentioned, there's nothing OK when a bind fails... it should be fixed & rebound. Second, ask DBA or CICS guys, if there is some switch of data-bases or RPL (load-lib's) during the day/night, this might explain this failures for the failed BIND.
Last but not least, can you run (after re-binding) the transaction under CEDF / CEDX (good old step-by-step debugger)? it provides you with all possible info in case of any failure...
Good luck,
Haim Zeevi
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 S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm
No new posts Error IEC161I 052(009,XXXRS00)-084 wh... amitc23 JCL & VSAM 10 Wed Oct 12, 2016 5:00 pm


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