Examples of CHECK PLUS jobs

This topic presents several examples of jobs that were run by using the CHECK PLUS product. Each example includes the following information:

Description of the check job
CHECK PLUS job stream
SYSPRINT from the job

Related topics

Getting-started

CHECK-command-syntax

Some examples show additional information that might be useful to understand a particular feature or to see the results of the check.

All of these examples have the following common properties:

These examples use a single BMC product load library, assuming that this library contains the CHECK PLUS load files and the common component load files that CHECK PLUS requires.
These examples use minimal data set space allocations in the JCL. You can find copies of the JCL for these examples in members ACKEXnn in the HLQ.LLQCNTL installation data set (where nn is the number of the example, and HLQ is the high-level qualifier set during installation, and LLQ is the low-level qualifier or prefix set during installation).

For syntax details, see CHECK-command-syntax. For information about JCL statement requirements, see Building-CHECK-PLUS-jobs.

The following table specifies which examples apply to specific check types or functions. Hyperlinks to the examples follow the table.

Function	Relevant examples
CHECK type or function
DATA	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules Example-11-CHECK-DATA-for-table-space-set-report-only
INDEX	Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space Example-4-Level-1-CHECK-INDEX-of-a-specified-index Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
TABLESPACE	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-2-Level-2-CHECK-TABLESPACE-with-table-check-constraints
Check constraints	Example-2-Level-2-CHECK-TABLESPACE-with-table-check-constraints Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows
Column data verification	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
Consistency checking between table space and index	Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
Deleting rows in violation with ACKESQL	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows
Online check	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
Page checking	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-2-Level-2-CHECK-TABLESPACE-with-table-check-constraints Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space Example-4-Level-1-CHECK-INDEX-of-a-specified-index Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set
Report only, table space set	Example-11-CHECK-DATA-for-table-space-set-report-only
RI checking, DB2-defined,	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set
RI checking, user-defined	Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules
Command option specified
CHECKIXLEVEL 0	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space
CHECKIXLEVEL 1	Example-4-Level-1-CHECK-INDEX-of-a-specified-index Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set
CHECKIXLEVEL 2	Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
CHECKTSLEVEL 0	Example-4-Level-1-CHECK-INDEX-of-a-specified-index Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space
CHECKTSLEVEL 1	Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space
CHECKTSLEVEL 2	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-2-Level-2-CHECK-TABLESPACE-with-table-check-constraints Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
CONSTRAINT	Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules
DISCARDFMT KEY	Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set
DISCARDFMT SPUFI	Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set
DISCARDFMT SQLDEL	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules
DISCARDSERIALIZE YES	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows
KEYSONLY	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
NAME	Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space Example-4-Level-1-CHECK-INDEX-of-a-specified-index
PART	Example-2-Level-2-CHECK-TABLESPACE-with-table-check-constraints Example-3-Level-2-CHECK-INDEX-of-a-partitioned-table-space
REPORT ONLY	Example-11-CHECK-DATA-for-table-space-set-report-only
RULES	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set
SAVERULES	Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set
SCOPE ALL	Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules Example-11-CHECK-DATA-for-table-space-set-report-only
SCOPE PENDING	Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows
SHRLEVEL CHANGE	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
SORTDEVT	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
TABLESPACE	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space Example-6-CHECK-DATA-for-RI-and-table-check-constraint-violations-in-a-table-space-using-ACKESQL-to-delete-rows Example-8-CHECK-DATA-for-user-defined-RI-violations-in-a-table-space Example-10-CHECK-DATA-for-user-defined-RI-using-saved-rules
TABLESPACESET	Example-7-CHECK-DATA-for-RI-violations-in-a-table-space-set Example-9-Check-for-Db2-defined-and-user-defined-RI-violations-in-a-table-space-set Example-11-CHECK-DATA-for-table-space-set-report-only
VERIFY	Example-1-Level-2-CHECK-TABLESPACE-of-a-partitioned-by-growth-table-space Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space
XBMID	Example-5-SHRLEVEL-CHANGE-CHECK-INDEX-and-CHECK-TABLESPACE-of-a-specified-table-space

This section contains the following examples:

Examples of CHECK PLUS jobs

On this page