Using ACKESQL

Before you begin

Before ACKESQL can run the DELETE statements in the discard data set, the CHKP status must be reset for the affected object. When setting up your CHECK PLUS and ACKESQL jobs, you must know which reset method you want to use. We recommend that ACKESQL automatically reset the CHKP status for you if you are using DISCARDFMT SQLDEL.

Reset CHKP status outside of ACKESQL by using one of the below methods:

• Run the REPAIR utility.
• Start the table space with START ACCESS(FORCE).

Also, if you are using DISCARDFMT SQLDEL, you must decide whether to enable full data access or restrict data access during delete processing.

To set up and run CHECK PLUS and ACKESQL jobs

1. If you plan to use ACKESQL to reset CHKP status or you plan to restrict data access during delete processing, enable discard serialization by completing as follows:
   1. Specify DISCARDFMT SQLDEL (DISCARDFMT) on your CHECK DATA command. 
      No other DISCARDFMT option is valid for these features.
   2. Enable CHECK PLUS to create serialization header records by using one of the following specifications:
      • Specify DSER=YES (DSER=NO) in your CHECK PLUS installation options before you run your CHECK PLUS job.
      • Specify DISCARDSERIALIZE YES on your CHECK DATA command.
2. Create your CHECK PLUS job as usual, but on your CHECK DATA command, specify DISCARDFMT SQLDEL (recommended) or DISCARDFMT SPUFI.
3. Create the job to run the ACKESQL program.
   For information about the JCL statements and execution parameters to use, see JCL-statements-and-parameters.
4. Run your CHECK PLUS job.

5. If you did not enable ACKESQL to reset the CHKP status in step 3, reset the CHKP status outside of ACKESQL with either the REPAIR utility or START ACCESS(FORCE).

   Warning

   START ACCESS(FORCE) also clears all other pending statuses. For this reason, we do not normally recommend using START ACCESS(FORCE).

6. Run the ACKESQL job.