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.
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 *.*