Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see CHECK PLUS for DB2 13.1.

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

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. Links to the examples follow the table.

Function

 Relevant examples

CHECK type or function

DATA

6, 7, 8, 9, 10, 11

INDEX

3, 4, 5

TABLESPACE

1, 2

Check constraints

2, 6

Column data verification

1, 5

Consistency checking between table space and index

3, 5

Deleting rows in violation with ACKESQL

Online check

Page checking

1, 2, 3, 4, 5, 7, 9

Report only, table space set

RI checking, DB2-defined,

6, 7, 9

RI checking, user-defined

8, 9, 10

Command option specified

CHECKIXLEVEL 0

6, 8

CHECKIXLEVEL 1

4, 7

CHECKIXLEVEL 2

3, 5

CHECKTSLEVEL 0

4, 6, 7, 8

CHECKTSLEVEL 1

CHECKTSLEVEL 2

1, 2, 5

CONSTRAINT

DISCARDFMT KEY

DISCARDFMT SPUFI

8, 9

DISCARDFMT SQLDEL

6, 10

DISCARDSERIALIZE YES

KEYSONLY

NAME

3, 4

PART

2, 3

REPORT ONLY

RULES

1, 5, 8, 9

SAVERULES

8, 9

SCOPE ALL

7, 8, 9, 10, 11

SCOPE PENDING

SHRLEVEL CHANGE

SORTDEVT

TABLESPACE

5, 6, 8, 10

TABLESPACESET

7, 9, 11

VERIFY

1, 5

XBMID

This section contains the following topics:

Related topic

Command-and-syntax-reference

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*