DRAIN_WAIT

The DRAIN_WAIT option specifies the drain timeout value to use.

Related topic

Basic-processing-options

DRAIN_WAIT.png

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

If it cannot drain all of the objects within the time period specified by DRAIN_WAIT, UNLOAD PLUS completes the following process:

  1. Releases the drains that it has obtained so far
  2. Waits the length of time that you specify in the RETRY_DELAY command option (or DRNDELAY installation option)
  3. Tries again to drain the objects for the number of times that you specify in the RETRY command option (or DRNRETRY installation option)

Important

The FORCE option tells UNLOAD PLUS whether to cancel DB2 threads that might prevent a successful drain and, if so when to cancel them. Depending on the FORCE option that you specify, the drain process might differ from the process described here. For more information, see FORCE.

Restriction

UNLOAD PLUS ignores this option when DIRECT NO is in effect.

Specifying the default

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

NONE

If you specify NONE, the drain request that UNLOAD PLUS issues times out immediately if the drain cannot acquire the lock. NONE prevents any application transactions from being queued during the drain process. We recommend that you specify NONE in high-transaction environments.

UTIL

UTIL tells UNLOAD PLUS to use the standard DB2 utility timeout value defined in DSNZPARMS for your site (IRLMRWT multiplied by UTIMOUT). The wait time applies to each object involved in the unload.

SQL

If you specify SQL, UNLOAD PLUS uses the standard SQL timeout value (IRLMRWT) as the drain timeout value. The wait time applies to each object involved in the unload.

integer

Specify any integer value from 0 through 1800, as follows:

  • 0 is equivalent to the value UTIL.
  • 1 through 1800 specifies the number of seconds to wait to obtain the drain for each drain retry before timing out.

 

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