Advantages
- This method allows you to implement different types of application design, such as using one large plan or many small plans.
- The decision of when to switch plans is taken away from the development process, and is not part of the coding.
- Only the control table needs to be updated when new programs are set into production. The existing programs do not need to be changed, even if they can call the new functions.
- The relationship between the transaction IDs, the DB2 plans, and the programs can be changed without changing the programs. However, the control table must then be changed.
- Information from the DB2 catalog (SYSPLAN and SYSDBRM) can be used to build the control table.
- Alternatively, the control table can be used to generate information about the DBRM structure of the plans.
- The control table contains information that can assist in defining the DB2ENTRYs and DB2TRANs in CICS, (if the plan name column is available).
- Other functions can be included in a control table structure, for example information about which transaction ID to use in the TRANSID option of the EXEC CICS RETURN command.