Preparing DB2 Application Plans › Defining Application Plans › How to Create a New Plan Definition › Plan Resources Fill-in

Plan Resources Fill-in

To specify the CA Ideal programs that are included in the plan definition, issue the RESOURCE command or press the PF5/17 key. The following plan resources fill-in screen appears.

=>
=>
=>
-------------------------------------------------------------------------------
IDEAL: PLAN RESOURCES        PLA IQPLANA                     SYS: DOC   FILL-IN

Specify the programs, system, version and type that the Plan includes.

Command   Program    Sys   Type   Comments
-------   --------   ---   ----   -------------------------------------  
======    ========   ===   ===    ======= T O P =======================  
000010    MAINAP     ARI   APP    ______________________________________ 
000011    SQLFET     ARI   APP    ______________________________________ 
000012    REPORT1    ARI   PGM    ______________________________________ 
======    ========   ===   ===    ==== B O T T O M ====================  

The following list provides an explanation of the fields on the preceding screen:

Program

Identifies the name of a CA Ideal program. Non-ideal programs are specified on the DBRM fill-in.

Sys (Optional)

Identifies the three-character CA Ideal system ID. (Defaults to the current system.)

Type

Specifies whether the plan includes just the program or the program and all of its CA Ideal subprograms that issue SQL statements.

• PGM-Includes the specified program only. (Any subprograms that perform DB2 access must be named separately in the fill-in, be part of a different application plan, be non-Ideal, or run dynamic SQL.)
• APP-Includes all CA Ideal subprograms of the specified program. (DBRMs for non-Ideal subprograms must be specified on the DBRM fill-in.)

Comments

Information displayed with the plan definition. It has no effect on the plan generation or on the resulting plan.