Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see UNLOAD PLUS for DB2 13.1.

FORCE

The FORCE option specifies whether to cancel Db2 threads that might prevent a drain process from completing.

FORCE.png

This option is meaningful only when DIRECT YES is in effect.

You cannot use this option to cancel threads when UNLOAD PLUS is attempting to acquire a lock on a table. For information about when UNLOAD PLUS uses lock table processing instead of drain processing, see Drain-and-lock-table-processing.

Specifying the default

You can specify a default for the FORCE command option in your installation options module by using the FORCE installation option. UNLOAD PLUS was shipped with a default value of NONE for this option. The FORCE command option overrides the default that is in the installation options module.

NONE

FORCE NONE tells UNLOAD PLUS not to cancel Db2 threads that might prevent the drain process from completing.

ALL

FORCE ALL tells UNLOAD PLUS to cancel both read and write claimers at the point specified by the FORCE_AT option.

FORCE_AT

The FORCE_AT option tells UNLOAD PLUS at which point during the drain process to cancel Db2 threads that might prevent the drain process from completing. You can specify one of the following keywords:

FORCE_AT option keywords

Keyword

Description

START

FORCE_AT START tells UNLOAD PLUS to start canceling threads when the drain request begins.

RETRY

FORCE_AT RETRY tells UNLOAD PLUS to start canceling threads the first time the drain process times out and UNLOAD PLUS attempts to retry the drain.

LASTRETRY

FORCE_AT LASTRETRY tells UNLOAD PLUS to start canceling threads at the beginning of the last retry attempt following a drain process timeout. You can control the number of drain retry attempts with the RETRY command option or DRNRETRY installation option.

Specifying the default

You can specify a default for the FORCE_AT command option in your installation options module by using the first parameter of the FORCE_AT installation option. UNLOAD PLUS was shipped with a default value of START for this option. The FORCE_AT command option overrides the default that is in the installation options module.

Additional considerations

The cancelation process includes a small amount of time to issue the cancel commands, plus any time that Db2 needs to roll back the canceled transactions. If the drain wait time (controlled by the DRAIN_WAIT option) is shorter than the total cancelation process time, the drain fails. FORCE_AT START and FORCE_AT RETRY allow for additional drain attempts after the start of the cancelation process; therefore, these options increase the likelihood that the drain will succeed when a short drain wait time is in effect. (Alternatively, you can increase the drain wait time.)

FORCE_DELAY

The FORCE_DELAY option tells UNLOAD PLUS how long to wait, in hundredths of a second, before starting the thread cancelation process. For example, specify 7 to tell UNLOAD PLUS to wait .07 seconds.

Specify an integer value of 0 or greater. A value of 0 tells UNLOAD PLUS to start the cancelation process immediately upon reaching the point specified by the FORCE_AT option.

Specifying the default

You can specify a default for the FORCE_DELAY command option in your installation options module by using the second parameter of the FORCE_AT installation option. UNLOAD PLUS was shipped with a default value of 3 for this parameter. The FORCE_DELAY command option overrides the default that is in the installation options module.

FORCE_RPT

The FORCE_RPT option tells UNLOAD PLUS whether to display a report of the canceled threads. You can specify one of the following keywords:


FORCE_RPT option keywords

Keyword

Description

NO

NO tells UNLOAD PLUS not to display the report.

YES

YES tells UNLOAD PLUS to display the report. If your JCL includes a BMCFORCE DD statement, UNLOAD PLUS sends the canceled threads report to that data set. Otherwise, the report is displayed in the UNLOAD PLUS SYSPRINT.

  Specifying the default

You can specify a default for the FORCE_RPT command option in your installation options module by using the FORCE_RPT installation option. UNLOAD PLUS was shipped with a default value of NONE for this option. The FORCE_RPT command option overrides the default that is in the installation options module.

REPORTONLY

FORCE REPORTONLY tells UNLOAD PLUS to display a report of the threads that it would have canceled if you had specified FORCE ALL. When reporting which threads it would have canceled, UNLOAD PLUS takes into account the current values of FORCE_AT and FORCE_DELAY.

If your JCL includes a BMCFORCE DD statement, UNLOAD PLUS sends the canceled threads report to that data set. Otherwise, the report is displayed in the UNLOAD PLUS SYSPRINT.

FORCE_AT

For information about this option, see ALL.

FORCE_DELAY

For information about this option, see ALL.

FORCE_RPT

UNLOAD PLUS ignores FORCE_RPT when you specify FORCE REPORTONLY.

Related topic

Basic-processing-options

 

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*