Re: Performance using PACKAGE

Jim Knisley

Re: Performance using PACKAGE
(in response to ajay kumar)
For our shop using one plan turned out to not be a good idea. I remember
attending a session at the DB2 Tech conference a few years ago shortly after
packages came out and it was stated that one plan was okay. That was also back
when we were being told that one large bufferpool was okay, too. You will
experience some performance degredation in the buffer pool and EDM pool,
depending on the other bind parameters you choose. For example,
RELEASE(DEALLOCATE) for plans with many packages will expand the space
requirements in the EDM pool. But, the biggest drawback is in management of the
applications from a monitoring standpoint. For example, if you are using CICS
and specify TOKENI (or TOKENE) in the RCT, you will get an SMF record for every
transaction, so you will be able to monitor individual transactions, but it you
try to roll-up the data to the plan level, the data is meaningless. For most of
the DB2 monitors, you will have to create custom reports and screens to deal
with transactions at the tranid or package level, instead of at the plan level.
By having a seperate plan for each transaction, you can monitor and tune at a
much more granular level. We tried using one plan and monitoring and tuning was
much more difficult.

Regards,
Jim





ajay kumar <[login to unmask email]> on 12/15/99 11:36:54 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Jim Knisley/TFG/HII)
Subject: Performance using PACKAGE



Hi,

I am going to shift all my DB2/CICS/COBOL programs from TEST region to PROD
region. For that, I created 4 collections, Each collection has around 150
programs. All these collections are binded with One Plan.

My question, Is it slow down my application performance or to have separate
plan for the each collection...? In the 4 collections few programs are
common to all(ie common programs).

If you have any suggestions regarding this pls give your feedback, This
application is going to use 300 - 400 users.

Thaks in Advance.
DB2 Admin

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com








ajay kumar

Performance using PACKAGE
Hi,

I am going to shift all my DB2/CICS/COBOL programs from TEST region to PROD
region. For that, I created 4 collections, Each collection has around 150
programs. All these collections are binded with One Plan.

My question, Is it slow down my application performance or to have separate
plan for the each collection...? In the 4 collections few programs are
common to all(ie common programs).

If you have any suggestions regarding this pls give your feedback, This
application is going to use 300 - 400 users.

Thaks in Advance.
DB2 Admin

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com