IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Need a golden rule to avoid SQLCODE -805


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Mon Sep 17, 2012 1:42 pm
Reply with quote

Hi Everyone,
I have faced SQLCOE -805 many times when the source program load & DB2 load are not at same promotion levels in CHANGEMAN.
Two possible case here:
1. Promotion level of DB2 load > promotion level of source Program load
2. Promotion level of DB2 load < promotion level of source Program load
As per my experience, for one of the above case the job doesnot abend for SQLCODE -805. However I do not recollect the exact case.

Can anyone please help me to throw some light here so that i can be assured to avoid abend for SQLCODE -805.

Thanks in advance for your valuable assistance.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Mon Sep 17, 2012 1:48 pm
Reply with quote

Just make sure EVERYTHING is done at the same time - usually your source control software will do this so use it.
Back to top
View user's profile Send private message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Mon Sep 17, 2012 2:39 pm
Reply with quote

Thanks Nic for your reply!
I have experienced that for one of the case mentioned above, job doesnt abend for SQLCODe -805.
So I was trying to understand the concept here.
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Sep 17, 2012 2:48 pm
Reply with quote

You're possibly stuck in some site-specific set-up as you talk about Change-Man. If so, suggest you talk with someone at your shop and see if there is way out or some process is already in use, as Nic also indicates 'to get things done at the same time'.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10801
Location: italy

PostPosted: Mon Sep 17, 2012 3:35 pm
Reply with quote

Quote:
Can anyone please help me to throw some light here so that i can be assured to avoid abend for SQLCODE -805.


just follow the standards and do not be sloppy while doing Your work icon_cool.gif
Back to top
View user's profile Send private message
kunal jain

New User


Joined: 19 May 2011
Posts: 59
Location: India

PostPosted: Mon Sep 17, 2012 6:14 pm
Reply with quote

Thank you to all who had responded till now.
Does anyone in this forum working with Changeman would like to express his views on my query?

I believe Changeman might be used by majority of shops as version control tool.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10801
Location: italy

PostPosted: Mon Sep 17, 2012 6:19 pm
Reply with quote

Quote:
Does anyone in this forum working with Changeman would like to express his views on my query?


the change management tool used is irrelevant to the problem being discussed

if the <program types> the <build processes> and the <standards> have been defined/implementd properly and are used properly

any CM tool will do... changeman, endevor, SCLM

the ball now is in the CM support court
icon_cool.gif
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 768
Location: Pennsylvania

PostPosted: Mon Sep 17, 2012 7:08 pm
Reply with quote

What is most likely is:

Your CM product is not configured to Bind to the DB2 Subsystem/Region you are trying to access with your Job or Cics transaction.

Or said Bind has failed for some reason.

as many have said above: the ball now is in the CM support court
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India

PostPosted: Mon Sep 17, 2012 7:16 pm
Reply with quote

Enrico is correct, you should listen to his advise. I had been to couple of shops where Change-Man was in use, however, the set-ups were different and they were specific to those specific shops.

At one shop, what you said here
Quote:
1. Promotion level of DB2 load > promotion level of source Program load
2. Promotion level of DB2 load < promotion level of source Program load
similar to that was in use; at other, BIND was done "automatically" the moment you compiled it. Though, under the covers a 'BIND job' will execute but at the "face of it" you just complied the COBOL-DB2 program. Now - I've told you this, however, how would you use this 'information'?! Well, you cant'.

So pick your choice - and either talk to your site support group or to CM support as has been suggested already.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts SQLCODE = -16002 when using XMLEXISTS DB2 1
No new posts Is SQLCODE -811 possible while fetchi... DB2 1
No new posts SQLCODE=-204 SQLSTATE=42704 DB2 4
No new posts Getting sqlcode 805 while executing R... DB2 10
No new posts SQLCODE -950 in PREPARE statement ... DB2 2
Search our Forums:

Back to Top