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
 

 

Need a golden rule to avoid SQLCODE -805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
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    Post subject: Need a golden rule to avoid SQLCODE -805
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: 1717
Location: UK

PostPosted: Mon Sep 17, 2012 1:48 pm    Post subject:
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    Post subject:
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

Senior Member


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

PostPosted: Mon Sep 17, 2012 2:48 pm    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Mon Sep 17, 2012 3:35 pm    Post subject: Reply to: Need a golden rule to avoid SQLCODE -805
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    Post subject:
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10203
Location: italy

PostPosted: Mon Sep 17, 2012 6:19 pm    Post subject: Reply to: Need a golden rule to avoid SQLCODE -805
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: 645
Location: Pennsylvania

PostPosted: Mon Sep 17, 2012 7:08 pm    Post subject:
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

Senior Member


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

PostPosted: Mon Sep 17, 2012 7:16 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am
No new posts -81 SQLCODE returned when Remote Stor... kameswaramanoj.Akella DB2 1 Wed Dec 03, 2014 5:36 am


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