Routines for dynamic plan selection in CICS

You can create application packages and plans that allow application programs to access Db2 data at execution time. In a CICS® environment, you can design CICS transactions around the application packages and plans or use dynamic plan allocation.

Begin program-specific programming interface information.You can enable dynamic plan allocation by using one of the following techniques:

  • Use Db2 packages and versioning to manage the relationship between CICS transactions and Db2 plans. This technique can help minimize plan outage time, processor time, and catalog contention.
  • Use a dynamic plan exit routine to determine the plan to use for each CICS transaction.
Recommendation: Use Db2 packages and versioning, instead of a CICS dynamic plan exit routine, for dynamic plan allocation.End program-specific programming interface information.