View previous topic :: View next topic
|
Author |
Message |
durairajas
New User
Joined: 12 Dec 2007 Posts: 2 Location: Chennai
|
|
|
|
Dear all,
I have scenario where i am getting -805. Here the Consistency token between load and DBRM are matching. But when i tried to execute the program i am getting the above error.
Here the consistency token is <location_code>.<Coll_id>.<paackageid>.<Timestamp>.
here the timestamp is matching. But the plan which i tried to execute is not having this collection id.
Whether i need to bind the plan with this collection id? If so what will happen to exisitng collection ids?. I need that also in this plan.
Thanks:-)[/b] |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi Durairaj,
Kindly Check what are the package list are associated with your Plan by
Excuting the following query .
Code: |
SELECT * FROM SYSIBM.SYSPACKLIST WHERE PLANNAME= 'PLANNAME'; |
If your Collection id.* or collectionoid.package is not associated with plan , please bind the plan with correponding pakage list .
Code: |
BIND PLAN(plan-name) PKLIST(collection-id1.*,Collection-id2.*,colletion-id3.package1) -
ACTION (REPLACE) VALIDATE(BIND) ISOLATION (CS) FLAG (I) -
ACQUIRE (USE) RELEASE (COMMIT) EXPLAIN (NO) RETAIN -
OWNER(owner-id) QUALIFIER(schema-name) DEGREE(1) |
Thanks and Regards
Senthil |
|
Back to top |
|
|
durairajas
New User
Joined: 12 Dec 2007 Posts: 2 Location: Chennai
|
|
|
|
Dear Senthil,
Thanks for your quick response.
That collection id is not associated wiht the plan. so i need to bind this collection id with the plan. If i bind this collection id alone with replace option, will it impact the exisitng collaction id ?
If so whether i need to give all esisitng collection id and added to that i need to give this new collectionid and bind this plan? |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi Duari ,
Quote: |
If so whether i need to give all esisitng collection id and added to that i need to give this new collectionid and bind this plan? |
Yes, you need to give all esisitng collection id and add new collectionid and bind this plan
Code: |
BIND PLAN(plan-name) PKLIST(existing-collection-id1.*,existing-Collection-id2.*,new-colletion-id3.* ) -
ACTION (REPLACE) VALIDATE(BIND) ISOLATION (CS) FLAG (I) -
ACQUIRE (USE) RELEASE (COMMIT) EXPLAIN (NO) RETAIN -
OWNER(owner-id) QUALIFIER(schema-name) DEGREE(1) |
Thanks and Regards
Senthil |
|
Back to top |
|
|
|