Page 1 of 1

Package not found

PostPosted: Wed Dec 01, 2010 9:44 pm
by p19689
Hi , I have an error :
DBRM or Package name 'SUBSYSTENMANE.PACKAGE_1.Consistancey_token_1' was not found in
plan 'PLAN1'.

When I checked the Catalog there are 2 version of operable packages exist for PACKAGE_1.
PACKAGE_1 (version 1) bind under db2 8 - With Consistancy_Token_2
PACKAGE_1 (version 2) Bind under Db2 9 (current version) - With Consistance_Token_3
( Above consistance tokens were extracted from admin tool - under precompiler infor)
When I checked the PLAN1, It has package_1 (Version 1) bound.


My Question is why did I get -805 instead of -818. I thought the package is there but it's a incorrect pakage. Can you advice Please ?

Re: Package not found

PostPosted: Wed Dec 01, 2010 10:37 pm
by GuyC
well, according to you there is no package with Consistancey_token_1.

Select name,version,contoken from sysibm.syspackage where name = 'PACKAGE_1'
will show you if it's true.

Re: Package not found

PostPosted: Fri Dec 03, 2010 3:37 pm
by p19689
Thanks for the reply. If there is No pakage with Consistancy_token_1 , I thought it should come with ( -818) consistancy token mismatch as It has a packages with consistancy_token_2 and 3 for the same package name (PACKAGE_1). Where I am wrong here !

I have issued the query but CONTOKEN field came with unreadable format. Do I need to convert it to some other format ?

Re: Package not found

PostPosted: Fri Dec 03, 2010 5:13 pm
by GuyC
you can use hex(contoken)

primary key of a package = collid,name,contoken or collid,name,version
thus different contoken = different package. => -805

This is a standard confusion: Most site let DB2 decide the Version and this looks like a timestamp (but really isn't)
so each time you precompile you get a new VERSION.

But you can also specify the VERSION in the precompile options.
so each time you precompile your version (and contoken) remain the same. f.e IBM sometimes uses fixpack numbers or APARnumbers as Version.

Somewhere in the DBRM there is also a real timestamp_precompile.
and if this is different you get -818

Re: Package not found

PostPosted: Mon Dec 06, 2010 7:54 pm
by p19689
Hi , thanks for the reply and it explains my question.
I thought if we need vesioning we always have to use precomplier options. How can you get version without precompile options ?
Thanks very much for your excellent explanation earlier !

Re: Package not found

PostPosted: Wed Mar 09, 2011 7:32 pm
by iamamainframer
if you bind your dbrm to package and token doesn't match then -805 and
if you bind your dbrm to plan and token doesn't match then -818