Preparing DB2 Application Plans › Connecting Plans to Applications › Specifying Plans Independently of Transaction-IDs in CICS › Specifying Plans with a CA Ideal Plan Name Exit

Specifying Plans with a CA Ideal Plan Name Exit

In addition to the exit required for plan switching, CA Ideal lets you specify a plan name exit program. CA Ideal passes parameters to the plan name exit, including the current installed default plan name, the session default, or the name set in the application. The exit can modify it, pass it on unchanged, or ignore it and select a new plan name.

The use of a plan name exit is optional. To use one, enter the following command in your signon member, jobstream, or at the terminal:

SET [SITE] ENVIRONMENT DB2PLAN-EXIT exit-name

You can also use the command to disable the exit:

SET [SITE] ENVIRONMENT DB2PLAN-EXIT NONE

If the plan name exit is enabled, CA Ideal calls it before the first SQL statement in a logical unit of work. That is, it is called before the first SQL statement at the beginning of each CICS transaction and before the first SQL statement following each database commit.

Note: The first SQL statement can be embedded SQL or SQL generated by a FOR construct for a DB2 dataview or in a non-Ideal subprogram. A Commit can be a CHECKPOINT or BACKOUT statement, or an SQL COMMIT or ROLLBACK statement.