View previous topic :: View next topic
|
Author |
Message |
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
How did you bind the program before compiling it . . .
Possibly i misunderstand? |
|
Back to top |
|
|
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
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 |
|
|
Ronald Burr
Active User
Joined: 22 Oct 2009 Posts: 293 Location: U.S.A.
|
|
|
|
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 |
|
|
rocky_balboa
New User
Joined: 24 Mar 2010 Posts: 61 Location: Cape of Good Hope
|
|
|
|
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 |
|
|
vasanthkumarhb
Active User
Joined: 06 Sep 2007 Posts: 275 Location: Bang,iflex
|
|
|
|
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 |
|
|
arien
New User
Joined: 02 Nov 2006 Posts: 43 Location: London
|
|
|
|
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 |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Good to hear it is working - thank you for posting the reason
d |
|
Back to top |
|
|
|