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
 

 

information required on rebind package and plan

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

New User


Joined: 27 Sep 2005
Posts: 25
Location: india

PostPosted: Tue Jun 13, 2006 2:46 pm    Post subject: information required on rebind package and plan
Reply with quote

Hi,

i would like to know what actually rebind does, i need to rebind some 150 packages and plans, what way shall i process other than db2 primary option bind/rebind/free. will rebind affect any program execution, will it place any timestamp to plan or package. what is the syntax to rebind all the package and plan.

i believe REBIND PACKAGE (<OWNER>.*.*) and REBIND PLAN (*) will work for all the plan and package. please guide me with good solution. thanks for your help in advance.

Please resond ASAP.

thank you,
anandhamohan
Back to top
View user's profile Send private message

anamikak

New User


Joined: 10 May 2006
Posts: 64
Location: Singapore

PostPosted: Tue Jun 13, 2006 4:23 pm    Post subject:
Reply with quote

you do a rebind whenever your plan becomes invalid or inoperative.
Is that why you are doing a rebind?

Anamika
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Jun 14, 2006 2:12 pm    Post subject: Re: information required on rebind package and plan
Reply with quote

Anand,
you can not rebind the plans and packages when they are running...And if you are using packages , I guess rebinding of plans not needed.

Rebind will change the access paths as well as put the timestamp in the catalog.

Nothing will affect you if you rebind except the access path.

better do not use rebind package(*) or REBIND PLAN(*) ....
Use them like rebind package(collection.member) or rebind package(collectionID.*). It will reduce the list of packages to rebind....The subsystem will have many packages..so you should not use *.*



Regards
Rags
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 Obtaining file information pahiker COBOL Programming 25 Tue Sep 27, 2016 7:25 pm
No new posts Need information on COBOL MOVE CORRES... subratarec COBOL Programming 10 Tue Jun 28, 2016 10:38 pm


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