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-BIND error during INSERT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arien

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Sun Feb 06, 2011 3:14 am    Post subject: 805-BIND error during INSERT
Reply with quote

Hi,

I am working with Changeman and my binds were successful, while running the program it results in -805 error during INSERT.

I bound the plan, the package, compiled the program in this order. What could be the error?
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: Sun Feb 06, 2011 6:42 am    Post subject:
Reply with quote

Hello,

How did you bind the program before compiling it . . . icon_confused.gif

Possibly i misunderstand?
Back to top
View user's profile Send private message
arien

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Sun Feb 06, 2011 7:13 am    Post subject:
Reply with quote

BIND is taken care of by changeman.. I received a successful BIND while promoting my code to Dev environment. When I tried executing the INSERT/UPDATE query, the run time -805 error was generated. There are other programs in my packages which are all working fne...except this one.. I'm head over heels with this program...
I have placed display statements which shows it does enter the program.. it throws 805 error which executing INSERT/UPDATE to the table. What could be wrong ?
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: Sun Feb 06, 2011 7:33 am    Post subject:
Reply with quote

Hello,

Suggest you work with your dba to resolve. They should be most familiar with your environment.

It sounds like the execution is using the wrong copy of the plan. . .
Back to top
View user's profile Send private message
Ronald Burr

Active User


Joined: 22 Oct 2009
Posts: 293
Location: U.S.A.

PostPosted: Sun Feb 06, 2011 7:41 am    Post subject:
Reply with quote

An -805 indicates that the consistency token contained in either the PLAN or the program's PACKAGE does not match the consistency token contained in the program's executable.

This can occur if the PLAN includes programs' DBRMs rather than a COLLECTION (which points to the PACKAGEs representing the programs in that PLAN). In that case, the PLAN needs to be rebound following a recompile, because the consistency token for the recompiled program and its associated DBRM are regenerated, and the new DBRM must therefore be rebound into the PLAN (replacing the old DBRM).

If everything has been bound correctly, then one way that an -805 can occur is that a STEPLIB or JOBLIB concatenation is present and a version of the program causing the -805 is present in one of the libraries that is higher in the concatenation than the library where the recompiled (and rebound) program resides.
Back to top
View user's profile Send private message
rocky_balboa

New User


Joined: 24 Mar 2010
Posts: 61
Location: Cape of Good Hope

PostPosted: Sun Feb 06, 2011 1:35 pm    Post subject: Reply to: 805-BIND error during INSERT
Reply with quote

Let me add another probable cause. If you are using CURRENT
PACKAGESET special register check whether correct value is being passed or is not blank..
Back to top
View user's profile Send private message
vasanthkumarhb

Active User


Joined: 06 Sep 2007
Posts: 276
Location: Bang,iflex

PostPosted: Sun Feb 06, 2011 11:06 pm    Post subject:
Reply with quote

Please look whether you are pointing to other DB2 region. This may result to -805. Also check programs are linked properly.. Hope it helps you
Back to top
View user's profile Send private message
arien

New User


Joined: 02 Nov 2006
Posts: 43
Location: London

PostPosted: Tue Feb 08, 2011 9:03 pm    Post subject:
Reply with quote

The DBA said he couldn't find the program. The problem was in the DBB card.. the program name was mispelled in it by a character. Believe me I am banging my head to the wall here !

This is solved.. thanks all for your inputs.
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: Tue Feb 08, 2011 9:54 pm    Post subject: Reply to: 805-BIND error during INSERT
Reply with quote

Good to hear it is working - thank you for posting the reason icon_smile.gif

d
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
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 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