View previous topic :: View next topic
|
Author |
Message |
kunal jain
New User
Joined: 19 May 2011 Posts: 59 Location: India
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Just make sure EVERYTHING is done at the same time - usually your source control software will do this so use it. |
|
Back to top |
|
|
kunal jain
New User
Joined: 19 May 2011 Posts: 59 Location: India
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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 |
|
Back to top |
|
|
kunal jain
New User
Joined: 19 May 2011 Posts: 59 Location: India
|
|
|
|
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 |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
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
|
|
Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006 Posts: 792 Location: Pennsylvania
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
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 |
|
|
|