Preparing DB2 Application Plans › Generating Application Plans › Plan Generation JCL

Plan Generation JCL

The JCL required by the GENERATE PLAN command is included in the IDPLAN procedure. You can modify it for your site. The statements are grouped by the process they perform such as, precompiler, assembler, link-edit, terminal monitor. Statements you might need to modify are:

• SQLMOD-Data sets where source for the Static I/O modules is placed.
• IDUDBRM-Specifies the data set containing all user DBRMs (CA Ideal and non-Ideal).
• ADRDBRM-The DSN where the DBRMs CA Ideal supplies are located. These DBRMs include the dynamic SQL DBRM.
• SYSLMOD-The load library containing the CA Ideal SQL load modules.