Using one large plan for all transactions

A straightforward way to avoid having to switch plans during a transaction is to use one large plan for all CICS transactions that issue SQL calls.

For the example in Figure 1 :

There is one plan, PLAN0, using the DBRMs from P0, P1, P2, P3, PA, PB, PC, and PD
In CICS, define one DB2ENTRY specifying PLAN0 plus a DB2TRAN per transaction ID required (unless a wildcard transaction ID can be specified). One DB2ENTRY gives the best overall thread utilization if protected threads are used.