USELOADER

Read syntax diagramSkip visual syntax diagram USELOADER=NOYES

Specifies whether or not Db2® LOAD is employed by InfoSphere® CDC to refresh tables.

The default behavior (USELOADER=NO) is to use the standard InfoSphere CDC refresh operation.

USELOADER determines the use of Db2 LOAD at the system level. By using the CHCMTAUT utility, Db2 LOAD use can be set at the datastore and table levels. In this case, the USELOADER setting is overridden.

The following requirements must be met in order to use Db2 LOAD to refresh a target table in an InfoSphere CDC replication configuration:

  • Use of the Db2 LOAD utility must have been requested.
  • The mapped target table must be the only one in the table space.
  • The mapped target table cannot be included in a cascading replication configuration. For general information about cascading replication, see your Management Console documentation.
  • The total length of all columns in the mapped target table cannot exceed 32,760 bytes minus the number of columns in the table.
  • If user exit programs have been configured for the mapped target table, the clear table operation cannot be disabled.
  • A row identifier cannot be defined for the mapped target table.
  • Auditing of source table changes (LiveAudit™) cannot be enabled when configuring the mapped target table. For information about configuring LiveAudit, see your Management Console documentation.

If the Db2 LOAD utility has been enabled (through USELOADER or CHCMTAUT), but one or more of these requirements have not been met, an attempt to refresh a table in Management Console generates a warning message and the standard InfoSphere CDC refresh is used instead of Db2 LOAD.

Note: If use of the Db2 LOAD utility has been enabled, you should ensure that you have PTF UI12429 applied. This PTF determines that access to the Db2 LOAD utility within an InfoSphere CDC for z/OS® address space is serialized and prevents ABENDs of the utility. Multiple instances of the utility can only be invoked in parallel between separate InfoSphere CDC for z/OS address spaces.

This keyword is optional.

Default Setting—NO