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
 

 

Binding a package to a exisitng plan

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

New User


Joined: 12 Dec 2007
Posts: 2
Location: Chennai

PostPosted: Wed Dec 12, 2007 11:43 am    Post subject: Binding a package to a exisitng plan
Reply with quote

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
View user's profile Send private message

senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Wed Dec 12, 2007 12:08 pm    Post subject:
Reply with quote

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
View user's profile Send private message
durairajas

New User


Joined: 12 Dec 2007
Posts: 2
Location: Chennai

PostPosted: Wed Dec 12, 2007 12:39 pm    Post subject: Reply to: [b]Binding a package to a exisitng plan[/b]
Reply with quote

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
View user's profile Send private message
senthilssg

New User


Joined: 09 Dec 2005
Posts: 64
Location: USA

PostPosted: Wed Dec 12, 2007 8:36 pm    Post subject:
Reply with quote

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
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 Why myself doing Package Bind always ... Susanta DB2 5 Thu Mar 02, 2017 10:47 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts -419 SQL error when binding senthamizh DB2 2 Sun Jun 12, 2016 8:20 pm
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us