How To Resolve 805 Error In Db2
Contents |
by DB2 precompiler ) between the load module and the DBRM doesn't match.On the other hand , we get -805 when any DBRM or Package http://db2guide.blogspot.com/2011/02/sql-code-818-vs-805-timestamp-mismatch.html is not found in Plan which supposed to be there. Now lets see http://www.geekinterview.com/question_details/65124 how we resolve both the abend. In case of -818, if we have the correct DBRM (DBRM with same consistency token as there in the load module or in other word the output DBRM from the same precompiler step from where we got our load module) then we can just bind our db2 sql plan with DBRM and intern run the job with this new plan and corresponding load module.In case you don't have the correct DBRM with you, just precompile the job again create new load module( via compile, link-edit) and bind to crate new plan so you can be sure that at run time the consistency token matches. For -805, you just see which dbrm or Package db2 sql error is not there in plan and include it accordingly in plan by binding it in plan. Now the real problem is even though sometimes the particular DBRM or the Package does exist in plan we get -805. Then obvious question is why???? why am i still getting -805 in this case. The answer is main reason for getting -805 is not just DBRM or Package not found in plan but it is -805 DBRM OR PACKAGE NAME location-name.collection-id.progname. consistency -token NOT FOUND IN PLAN plan-name REASON reason Simply stated, it means that an application program attempted to use a package 'location-name.collection-id.progname.consistency-token' that was not found. The DBRM name ‘dbrm-name' matched one or more entries in the package list and the search of those entries did not find the package (that is, it is present but the consistency token does not match). In this case the LOADLIB and the DBRM from which the package was created are not the same. So you can get timestamp mismatch (consistency token mismatch ) in case of -805 also as in case of -818 The difference is if you bind a DBRM to Package and then bind that Pac
Management Accounting Operating System Operating System Android iOS Microsoft Coding Programming J2EE Languages Database Database Data Warehousing Oracle Applications Applications Clarify CRM Oracle Apps Peoplesoft Siebel Software Testing Testing Testing Tools Miscelleanous Helpdesk Mainframe Networking SAP R/3 Web Interview Coaching Career Counseling Job Interview Interview eBooks Accounting eBook C eBook Citrix eBook Job Interview eBook Career Advice Career Change Jobs Help Projects Requests Resume Help Training Advice Engineering Chemical Engineering Civil Engineering Electrical Engineering Electronics Engineering Micro Processor Mechanical Engineering By Company Ask Question Home Interview QuestionsMainframeDB2 If Sql return -805 , what will user want to do sprabodhini ProfileAnswers by sprabodhiniQuestions by sprabodhini May 7th, 2008 9 9219 Questions by sprabodhini DB2 Answer First Prev Next Last Showing Answers 1 - 9 of 9 Answers rajasekhar24 ProfileAnswers by rajasekhar24 May 9th, 2008 Bind the database to avoid the -805 error.The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.'%.pkgname' if the CURRENT PACKAGE PATH is set but no package with the name 'pkgname' could be found in any of the schemas in the CURRENT PACKAGE PATH. Was this answer useful?Yes Reply yuvaevergreen ProfileAnswers by yuvaevergreen Mar 26th, 2010 Be sure that the program has been preprocessed with no errors. If not, correct any errors which caused the preprocess to fail, preprocess the program and rerun it.
Was this answer useful?Yes Reply pawan_singh ProfileAnswers by pawan_singh May 14th, 2010 He should rebind and new copy his program. -805 is a bind error. Was this answer useful?Yes Reply pawan_singh ProfileAnswers by pawan_singh May 14th, 2010 -805 is a bind error user needs to