View previous topic :: View next topic
|
Author |
Message |
anadhamohan
New User
Joined: 27 Sep 2005 Posts: 25 Location: india
|
|
|
|
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 |
|
|
anamikak
New User
Joined: 10 May 2006 Posts: 64 Location: Singapore
|
|
|
|
you do a rebind whenever your plan becomes invalid or inoperative.
Is that why you are doing a rebind?
Anamika |
|
Back to top |
|
|
ragshere
New User
Joined: 20 Dec 2004 Posts: 70
|
|
|
|
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 |
|
|
|