Using ACKESQL

Use the following instructions to set up and run the ACKESQL program.

Before you begin

Before ACKESQL can execute the DELETE statements in the discard data set, CHKP status must be reset for the affected object. When setting up your CHECK PLUS and ACKESQL jobs, you will need to know which reset method you want to use. You can have ACKESQL automatically reset CHKP status for you (recommended), 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 will need to 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 CHKP status in step 3, reset 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.