Using the Checkpoint Checker › Checkpoint Checker › Checkpoint Query Facility Panel

Checkpoint Query Facility Panel

Use this panel to do the following:

1. Define the selection criteria columns as described below:

   Jobname, Stepname, and Procstep

   Can be defined by using an underscore (_) as a wildcard. For example, ABAG____ searches for all job names that begin with ABAG.

   From Date Occurred

   Enter the most recent occurrence date.

   DB2

   Enter a Y to indicate that DB2 processing is involved.

   Checkpoint Freq.

   Enter the greater than number of average seconds between checkpoint writing.

   Checkpoint No.

   Enter the greater than number of checkpoint writes during step execution.

   Average Values Elapsed

   Enter the greater than average elapsed time in minutes.

   Average Values Service Units

   Enter the greater than average service units consumed in thousands.

   Impo

   Enter a number between 00 and 50 to indicate the importance of the job step. The higher the number, the more important the job step. This importance is from the perspective of computer center resource consumption.

After entering the query selection criteria, press Enter. The query facility searches for rows that match your criteria. The information that is found is displayed on the Checkpoint Checker List panel.

The Checkpoint Checker query facility works as follows:

• All input fields can be defined as you would in other query languages by using the LIKE command.
• The underscore is a wildcard used to represent one character.
• All selection criteria are used in combination with logical ANDs.

Values entered for elapsed time in minutes and service units in thousands are used in a greater compare. All jobs with consumption greater than the value entered are selected.

Values entered for frequency in seconds and number of checkpoint writes are used in a greater compare. All jobs with consumption greater than the value entered are selected.

• If the results table exceeds 4000 rows, you must define more specific selection criteria.