|
View previous topic :: View next topic
|
| Author |
Message |
sreelu.s
New User
Joined: 23 Jul 2010
Posts: 10
Location: hyderabad
|
|
|
|
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 ...  i m getting this wild idea / doubt because of this strange behavior .....
Did anyone encounter such situation ..... ? please help me ... |
|
| Back to top |
|
 |
prino
Senior Member
Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania
|
|
|
|
| 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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008
Posts: 8697
Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
sreelu.s
New User
Joined: 23 Jul 2010
Posts: 10
Location: hyderabad
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
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 . . .  |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| 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
 |
|
| Back to top |
|
|
haimzeevi
New User
Joined: 01 Mar 2010
Posts: 27
Location: Israel
|
|
|
|
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 |
|
|
|
|
