Running ADBTEP2

ADBTEP2 is a batch restart program that is supplied by Db2® Admin Tool. During installation and customization of Db2 Admin Tool, Tools Customizer generates a sample job that you can use to run ADBTEP2.

Procedure

To run ADBTEP2:
  1. Find the sample job in the product customization library. The product customization library name is site-specific.
  2. Modify this sample job as follows:
    • Edit the job to conform to the conventions established in your installation. The names of job cards, data sets, plans, and subsystems are site-specific.
    • Provide the input data stream for execution, which is called the batch statement list.

      The batch statement list can be specified inline, as a sequential data set, or as a member of a partitioned data set. It should contain all SQL statements, Db2 commands, utility control statements, and other valid statements that you want to process in a single execution. Within this series of statements, separate logical tasks or units of work with a COMMIT statement. These COMMIT statements denote the points at which a failed execution can be restarted. Non-SQL functions have implicit commits, both before and after them.

    • Modify parameters as needed.
      Recommendation: Because all ADBTEP2 jobs are restartable, specify the worklist parameter and provide a unique name.

      The RESTART parameter can be set to either YES or NO or used as default (YES), depending on whether the submission of the job is required to restart. ADBTEP2 is restartable regardless of the RESTART option. A job that is run with RESTART(NO), can be resubmitted with RESTART(YES) in the event of a failure.

      If the UNLOAD(HPU) parameter is specified, Db2 Admin Tool uses the DB2 NO parameter when performing the HPU UNLOAD operation.

  3. When you have modified the job and specified the parameters, submit the JCL for execution.

    Upon successful completion, both ADBTEP2 and ADBTEPA delete the checkpoint record.

    If the execution is unsuccessful, examine the output to determine the reason for the failure. Correct the error and resubmit the job.