Restartability

File-AID/RDX enables you to restart a failed load job from any particular step except LOADDRV. If a load job fails during the LOADDRV step, you must restart the load job from the CLEAN1ST step.

The procedure to restart the load job depends on whether you selected the Db2 Load Utility or SQL Insert load option.

Db2 Load Utility

The JCL generated for the Db2 Load Utility load job is step-restartable. To restart a Db2 Load Utility load job at a particular step:

1. Code the RESTART keyword parameter on the job card as follows:
   RESTART=xxxxxxxx

   where xxxxxxxx is the name of the step at which you want to restart the job.

2. Submit the JCL.

SQL Insert

The JCL generated for the SQL Insert load job is step-restartable. To restart an SQL Insert load job:

1. Code the RESTART keyword parameter on the job card as follows:
     RESTART=xxxxxxxx

   where xxxxxxxx is the name of the step at which you want to restart the job.

   If the job failed before the LDSQLIN step skip to Step 5.

   If the job failed during the LDSQLIN step, you must restart the job at the LDSQLIN step and then continue with Step 2.

2. Examine the Commit Report. Find the last report entry value in the Restart Point column of the Commit Report. This value has the following format:
      'RESTART=yyyyyyyy/zzzzzzzz'

   where yyyyyyyy is the number of rows committed and zzzzzzzz is the number of rows discarded. File-AID/RDX uses these values to determine where processing should restart.

3. Edit the DD EXTPARMS data set and modify the line containing RESTART RESTART=00000000/00000000 with the values from step 2.
4. Determine whether or not the load job stopped because the maximum rows to discard limit was reached. To do this, examine the load job output for File-AID/RDX error E336 or E187. These errors indicate that the limit set by Max Rows to Discard parameter was reached. In this case, increase the Max Rows to Discard parameter for the LDSQLIN step. Max Rows to Discard is the fourteenth parameter in the LDSQLIN EXEC statement PARM field (directly preceding the Restart Point Indicator).
5. Submit the JCL.