Can you just bind a package and run your program (Fidelity)

mfguruintraining · New User Joined: 26 Sep 2006 Posts: 8

This question asked in fidelity:

can you just bind a package and run your program ?

After the interview i saw an ibm manual which says :

"Regardless of what the plan contains, you must bind a plan before the application can run"

Can anyone clarify this ?

Thanks

raghunathns · Posted: Tue Oct 03, 2006 1:07 am

you must bind plan after binding the package. bind plan will bind all packages in to a single plan.

hikaps14 · Active User Joined: 02 Sep 2005 Posts: 189 Location: Noida

Hi

I hav some doubt.

If we have Plan A which is binded and it contains many packages
one of the packages in it is 'B'.

If we make few changes in 'B' and then Bind the Package 'B'.

Then I guess we can directly execute the Program n we don't need to bind the Plan again.

cooolguy · New User Joined: 05 Sep 2006 Posts: 9

yes what hikaps14 says is correct!

You need to create a plan only once after that if you do a package bind that is sufficient. This is one of the advantage of using package.

raghunathns · Posted: Thu Oct 05, 2006 12:13 am

package is updated (bind package) and no bind plan.

when you run the program first time, the system will bind the plan with the updated package. so you may find a delay in execution first time.

-----------

The advantage of package is
when there is any index update in one of the tables and that table is used in multiple programs. you need to rebind only the plan. no need of rebinding all packages.