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.

SQL batch execution program

The CHECK PLUS for Db2 product provides an SQL batch execution program (ACKESQL) that you can use to execute the DELETE statements in the discard data set (SYSDISC) that CHECK PLUS creates in the SQLDEL or SPUFI format. For details about specifying the format of the discard data set, see the DISCARDFMT option.

Important

We recommend that you specify DISCARDFMT SQLDEL if you plan to use the ACKESQL program.

Although you can use a different SQL execution program to execute the DELETE statements, the ACKESQL program offers commit, restart, lock, and CHKP reset capabilities through its execution parameters. Also, ACKESQL provides detailed messages that report the program’s activity. This assumes that you are using ACKESQL to execute the DELETE statements.

You run ACKESQL separately from CHECK PLUS by using JCL. Deleting rows with RI violations outside of the checking process enables the table space to remain available during the delete process. However, you can choose to restrict access to the data during the delete process by establishing certain options as described in the following topics:

Related topics

Command-and-syntax-reference

Examples-of-CHECK-PLUS-jobs

CHECK-command-syntax

DISCARDFMT

 

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