One Plan versus Multiple Plans in a DB2 subsystem

greenspun.com : LUSENET : DBAzine : One Thread

We are OS/390 V 2.10.0, DB2 V 7.1. We are new to DB2 and are debating over setting up one plan ( one for batch and one for cics) for the shop or multiple plans (one for batch and one for cics per application) in a subsystem. What are the advantages and disadvantages of setting up one plan versus multiple plans. Thanks for your response.

-- Anil Mathur (amathur@harleysvillegroup.com), November 08, 2002

Moderation questions? read the FAQ