Using the Application Checkpoint Report Options panel
To access and work with the Application Checkpoint Report Options panel
- Access the REPORTS Control Statement panel.For instructions, see Using the REPORTS Control Statement panel to build the REPORTS control statement.
In the Specify input field to the left of the Application Checkpoint label, enter S.The Application Checkpoint Report Options panel is displayed as shown below:
Application Checkpoint Report Options
Command ===> _______________________________________________________________
More: +
Jobs to include or exclude.
_ 1.Include 2.Exclude
Jobnames _____________________________________________________
PSBs to include or exclude.
_ 1.Include 2.Exclude
PSB names _____________________________________________________
DB2 plans to include or exclude.
_ 1.Include 2.Exclude
Plan names _____________________________________________________
Checkpoint frequency.
Comparison operator __ (<,<=,>,>=)
Number of checkpoints ____ (0-9999)
Per threshold ___ (SEC or MIN)
Sort by.
_ 1.Start time 2.Frequency
Other options. Select if desired.
_ Show information on jobs with duration < 1 second
_ Create output file in CSV form
F1=HelpF3=ExitF4=ClearF12=Cancel(Optional) In the Jobs to include or exclude field, enter one of the following values to control generation of the JOB subkeyword of the APPCHECK keyword:
Value
Result
1
In the Application Checkpoint report, display information only for jobs that you specify in the Jobnames field. Omit information about all other jobs that Log Analyzer finds in the input logs.
2
In the Application Checkpoint report, omit information about the jobs that you specify in the Jobnames field. Display information about all other jobs that Log Analyzer finds in the input logs.
If you specify a value in the Jobs to include or exclude field, enter one or more job names in the Jobnames field.
You can enter a masked value by using wildcard characters:
- Specify an asterisk (*) to match any number of characters, starting from that position.
- Specify a percent sign (%) to match a single character at that position.
Separate multiple names with a space, a comma, or both. The ISPF interface separates the names with a comma, as required by the keyword syntax.
(optional) In the PSBs to include or exclude field, enter one of the following values to control generation of the PSB subkeyword of the APPCHECK keyword:
Value
Result
1
In the Application Checkpoint report, display information only for BMPs with PSBs that you specify in the PSB names field. Omit information about all other BMPs that Log Analyzer finds in the input logs.
2
In the Application Checkpoint report, omit information about the BMPs with PSBs that you specify in the PSB names field. Display information about all other BMPs that Log Analyzer finds in the input logs.
If you specify a value in the PSBs to include or exclude field, enter one or more PSB names in the PSB names field.
You can enter a masked value by using wildcard characters:
- Specify an asterisk (*) to match any number of characters, starting from that position.
- Specify a percent sign (%) to match a single character at that position.
Separate multiple names with a space, a comma, or both. The ISPF interface separates the names with a comma, as required by the keyword syntax.
(Optional) In the DB2 plans to include or exclude field, enter one of the following values to control generation of the PLAN subkeyword of the APPCHECK keyword:
Value
Description
1
In the Application Checkpoint report, display information only for BMPs with DB2 plans that you specify in the Plan names field. Omit information about all other BMPs that Log Analyzer finds in the input logs.
2
In the Application Checkpoint report, omit information about the BMPs with DB2 plans that you specify in the Plan names field. Display information about all other BMPs that Log Analyzer finds in the input logs.
You can enter a masked value by using wildcard characters:
- Specify an asterisk (*) to match any number of characters, starting from that position.
- Specify a percent sign (%) to match a single character at that position.
Separate multiple names with a space, a comma, or both. The ISPF interface separates the names with a comma, as required by the keyword syntax.
(Optional) Use the following Checkpoint frequency fields to establish a filter for the Application Checkpoint report, based on the calculated frequency of checkpoints.These fields control the generation of the CHKFREQ subkeyword and the THRESH subkeyword of the APPCHECK keyword.
In the Comparison operator field, enter one of the following values to define how to compare the calculated frequency of checkpoints with the threshold value that you specify in the Number of checkpoints field.
Value
Result
<
Display data for this job and PSB if the calculated checkpoint frequency is less than the specified threshold value.
<=
Display data for this job and PSB if the calculated checkpoint frequency is less than or equal to the specified threshold value.
>
Display data for this job and PSB if the calculated checkpoint frequency is greater than the specified threshold value.
>=
Display data for this job and PSB if the calculated checkpoint frequency is greater than or equal to the specified threshold value.
- In the Number of checkpoints field, specify the threshold number of checkpoints to compare with the calculated frequency of checkpoints. Valid values are 0 through 9999.
- In the Per threshold field, specify the time unit for the threshold value. Valid values are SEC (seconds) and MIN (minutes).
For the filter, you specify a comparison operator, the threshold number of checkpoints per time unit, and the time unit. Log Analyzer calculates the checkpoint frequency for an included job and PSB by dividing the number of checkpoint records by the elapsed time of the job (as reflected in the input log records). Then Log Analyzer compares this calculated checkpoint frequency with the threshold number of checkpoints per time unit. If the comparison results in a true statement, the report displays information about the job and PSB.
(Optional) In the Sort by field, specify how to sort the information in the Application Checkpoint report. Enter one of the following values to control generation of the SORTBY subkeyword of the APPCHECK keyword:
Value
Description
1
Sort by start time. This is the default.
2
Sort by frequency.
- (Optional) Enter a slash (/) in the Show information on jobs with duration < 1 second field to generate the LSEC subkeyword. This will display the LUOW information for jobs with a job duration of less than a second in Application Checkpoint report.
- (Optional) Enter a slash (/) in the Create output file in CSV form field to generate the generate the CSVRPT subkeyword. This will create the report output file in a comma-separated (CSV) format.
- Press F3 to save the changes and return to the REPORTS Control Statement panel.