Specifying restart parameters

If you add the restart parameters to a configuration file, they will be used for all requests that refer to that configuration file. Ensure that the restart parameters which you specify are valid for all requests that use the configuration. For more information about the restart parameters, see Restart-parameters.

To add restart parameters to a configuration

1. Edit the configuration file or apply request, using one of the following methods:

   • Edit a configuration file or create a new one, as described in Creating and managing configuration files, and add the [Restart] section to the file.
   • Edit or create an apply request, as described in Creating-and-running-apply-requests:
     • Add restart parameters to the EXEC statement by using the PARM parameter, or include them in a separate DD statement.

   If you include restart parameters in the apply request and the configuration file, High-speed Apply Engine uses the parameters that you specify in the apply request.

2. If you are creating a configuration file, enter the section heading ([Restart] or /Restart/).
3. Specify the name of the restart table with the TableName parameter, or accept the default value, as follows:
   • Specify a unique table name in the format owner.tableName, where owner is the user ID of the restart-table owner, and tableName is the name of the restart table.
   • If you do not include the TableName parameter, High-speed Apply Engine uses the default value, as follows:
     • The default alias for the Db2 restart table is BMCAPT_APTRSCL.

4. Specify the RestartType and RestartID parameters as follows:

   • To specify parameters before the initial run of the apply request, take one of the following actions:

     • Specify RestartType as New/Restart and specify a value for RestartID (High-speed Apply Engine uses your restart ID value for the apply request). For advantages and disadvantages of this technique, see Step 2.b in the Restarting-an-apply-request topic.
     • Specify RestartType as New and do not specify a restart ID (High-speed Apply Engine generates a restart ID).
     • To avoid recording restart information for the apply request, specify RestartType as None.

     Important

     To maintain data integrity in case of a system failure, we recommend that you record restart information for your apply requests by specifying the restart type as New/Restart or New.

   • To restart a previously interrupted apply request, perform the steps described in Restarting-an-apply-request.

   For more information about using restart parameters, see Specifying-and-using-restart-parameters, RestartID, or RestartType.

5. (Optional) Specify a value for the Retry parameter. The Retry parameter determines the number of times that High-speed Apply Engine attempts to access the restart table. For more information, see Retry.
6. (Optional) Specify a value for the RetainTime parameter. This parameter determines how long High-speed Apply Engine retains restart information for an apply request in the restart table. For more information, see RetainTime.
7. (Optional) Specify a value for the CheckpointFrequency parameter. This parameter determines how often the High-speed Apply Engine performs checkpoint processing to update the restart table with a statement ID that represents the progress of all agents through the input file. For more information, see CheckpointFrequency.
8. Save the configuration file or apply request.
9. Run the apply request to enable the restart parameters or to restart apply processing.