Preparing DB2 Application Plans › Generating Application Plans › Impact Report

Impact Report

The report that the generation process produces has three parts.

• The components of the plan definition and the programs involved in the plan.
• The generated BIND command text, including all DBRMs.
• Error and completion messages.

You can produce this report without actually doing the BIND or updating the plan tables by using the VERIFY option on the PRINT PLAN command. For information about the complete syntax, see the Command Reference Guide.

The first section of the report shows the plan information entered in the plan definition. It is identical to the information a PRINT PLAN command produces.

                         IDEAL APPLICATION PLAN/PKG REPORT
          RELEASE:  14         DATE: March 10, 2010     TIME: 15:27:49
                        GENERATE APPLICATION PLAN/PKG DB2PLN
 IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
PLAN:     DB2PLN ________
                   PLAN DB2PLN
                   Created:        11/01/08               By $ID
                   Last Modified:  03/10/09 at 15:01      By $ID
                   Short Description:  uses a package
                   Description:
                    _______________________________________________________
IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
PLAN:     DB2PLN ________
                   Dynamic SQL?    N (Y=Yes, N=No)
                   Bind Options:
                   Owner: WESJO01              Qualifier:
                       Action:    R (R=Replace, A=Add)
                       Retain:    Y (Y=Yes, N=No)
                       Validate:  R (R=Run, B=Bind)
                       Isolation: R (R=Repeatable Read, C=Cursor Stability)
                       Flag:      I (I=InformationalWarningErrorCompletion,
                                     W=WarningErrorCompletion, E=ErrorComple
                                      C=Completion only)
                       Acquire    U (U=Use, A=Allocate)
                       Release    C (C=Commit, D=Deallocate)
                       Explain    N (Y=Yes, N=No)
                       Prepare    N (N=Nodefer, D=Defer)
                       Cachesize:  0512 (0 - 4096)
                       Currentdata:  Y (Y=Yes, N=No)
                       Currentserver:           (Location Name)
                       Enable/Disable:
 IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
PLAN:     DB2PLN ________
                  ------    --------  ----  ---   ----   -------------------
                  SEQ       PROGRAM   VER   SYS   TYPE   COMMENTS
                  ------    --------  ----  ---   ----   -------------------
                  001200    TABSPACE  0001  $ID   PGM
                 
 PLAN:    DB2PLN
                  ------  -   --------   ---------------   -----------------
                  SEQ     I   PACKAGE    COLLECTION        COMMENTS
                  ------  -   --------   ---------------   -----------------
                  001300  I   DB2PKG                       IDEAL package
 IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
PLAN:     DB2PLN ________
                  ------     --------       -------------------------------
                  SEQ        DBRM                            COMMENTS
                  ------     --------       -------------------------------
                     NO DBRM LINES FOR THIS PLAN
                 
IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
                         Application Plan/Pkg Impact Report
SQL MOD   PROGRAM   SYS  VER   TYPE  LANG    SQL STMTS  STATUS  ERROR IND
--------  --------  ---  ----  ----  ------  ---------  ------  -----------
DB2PLN0   TABSPACE  $ID  001   PROG  IDEAL  0003
Impact Report Abbreviations:
TYPE:   APPL   - Application (program with all its subprograms)
        PROG   - Program without its subprograms
        SPGM   - Subprogram belonging to an above application
Application Plan/Pkg Statistics:
Maximum number of SQL statements in effect: 0200
01     SQL modules are included in this Plan/Pkg
001    Programs are included in this Plan/Pkg
000003 SQL statements are in this Plan/Pkg
IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
                      Authorization ID Assignment Report
       No Authorization ID Assignments are in effect for this Plan/Pkg

The list of programs is shown by Static I/O module name and includes the following:

• Program name
• System ID
• Program version
• Type (application, program, or subprogram)
• Program language
• Number of SQL statements in the program
• Resource status (the first three are warnings; the rest are fatal errors that terminate the process):
  • DUPLIC-Program already included in the plan
  • NOSQL-Program does not contain any SQL
  • EXCLIM-Number of SQL statements exceeds the maximum
  • NOTFND-Program not found (for example, not compiled or not defined to the dictionary)
  • NOTAVL-Program not available (busy)
  • DIFVER-Program already included with a different version
  • HIST-Program in history status
  • INCREL-Program compiled with an incompatible (higher) CA Ideal release

The second section of the report shows the generated BIND command text. It displays all DB2 BIND options selected. The MEMBER list includes the system DBRMs that CA Ideal requires, the DBRMs the plan generation generates, and non-Ideal DBRMs specified in the plan definition. The PKLIST includes all the packages specified in the plan definition.

IDEAL Application Plan/Pkg DB2PLN        March 10, 2010     15:27:49
                     Application Plan/Pkg BIND command
DSN SYS (D310)
BIND PLAN (DB2PLN) OWNER (WESJO01) MEMBER (DB2PLN0) LIBRARY ('IDLD.DB23-
10.DBRMLIB','IDLD.V2R1.DBRM') PKLIST (JWCOLL.DB2PKG@). AC-
TION (REPLACE) RETAIN VALIDATE (RUN) ISOLATION (RR) FLAG (I) ACQUIRE (USE)
RELEASE (COMMIT) EXPLAIN (NO) CURRENTDATA (YES)

Application Plan Summary Messages:
001201 1-IDADPLAG02I - Plan or Package DB2PLN existed before and has been replaced
001201 1-IDADPLAG05I - Generation successfully executed

End of Plan/Package Generation Report_

Note: The preceding summary message shows that CA Ideal's generation process is complete. It does not show the status of the DB2 BIND.