MVSFORUMS.com

[bauer]

Hi all,

what is the influence on the performance during program / plan execution in the following situations?


(1) serveral packages, bound to one collection, only this collection is bound to the plan
(2) several packages, bound to different collections, several collections are bound to the plan
(3) several collections with a lot of packages are bound to the plan, but only some packages are really used during plan execution



regards,
bauer

[Manas Biswal]

bauer,

Although I have no direct evidence (meaning actual numbers), but I would think that options 2 and 3 shld be a little more expensive than option 1. Simply because, for options 2 and 3, DB2 directory access will be a bit more.
But again Options 2 or 3 will be used only for circumstances different from option 1. I don't think you will ever have to choose between options 1 and 2(or 3). If you database segmentation or package versioning, then you will have to use Options 2 or 3. And if you don't, then you should be using option 1.

Of course, for option 3, you should have the frequently used collections higher up in the PKLIST than the less frequent ones during BIND PLAN.

Regards,
Manas
_________________
There is no path to peace. Peace is the path.
- Mahatma Gandhi (1869-1948)

[bauer]

Manas Biswal,

thank you for your answer.

yesterday I did some testing (binding packages / plan using option 1,2,3), checking CPU time, memory using omegamon, but i couldn't find any really difference.

regards,
bauer