Updates that apply to DB2 Path Checker Version 4.2 User's Guide (SC19-4141-02)
Date of change: November 20, 2014
Topics: SYSCHG report, OPTIONS command
Change description: This update introduces new reporting features and formats that are available when using the OPTIONS command.
Displays only the access paths that have changed. Use this report to see which versions were compared and to check the bind time of each version. You can also use this report to identify a package or DBRM and issue a FIND statement in the SYSPRINT report to view details of the access path changes. The reported data for this option includes the package or DBRM name, version ID, number of statements with changed access paths, bind time, explain time, and collection ID. Use this report for a quick analysis.
Displays access path changes in the SYSPRINT report in a more readable side-by-side table. Values in the table are displayed only if differences exist between corresponding columns in the PLAN_TABLE. Blank values in the table indicate that the columns in the PLAN_TABLE are the same for both the current and previous statements. New or deleted statements are listed after the table.
REPORTCHGSBS, REPORTCHG, REPORTALL, and REPORTTERSE are mutually exclusive. If you specify more than one of these options, the last option specified is the one that takes effect, and the others are ignored.
Displays the same information as the REPORTCHG default option in a more compact format. Statements are grouped by package or DBRM name and also include the version ID, number of statements with access path changes, bind time, explain time, and collection ID. The asterisk (*) indicates the column or columns that differ from the old version. This option reduces the volume of reported data by omitting messages CKP212I, CKP206I, and CKP203I. This option is an alias for the REPORTQUIET option and produces the same results.
REPORTCHG, REPORTCHGSBS, REPORTALL, and REPORTTERSE are mutually exclusive. If you specify more than one of these options, the last option specified is the one that takes effect, and the others are ignored.