BL_RECOVERABLE= Table Option

Specifies whether the LOAD process is recoverable.

Category: Bulk Loading
Requirement: Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC, Oracle

Syntax

BL_RECOVERABLE= YES | NO

Arguments

YES

specifies that the LOAD process is recoverable. For DB2, YES also specifies that BL_COPY_LOCATION= should specify the copy location for the data.

NO

specifies that the LOAD process is not recoverable.

Details

DB2 under UNIX and PC Hosts: The default is NO.
Oracle: The default is YES. Set this option to NO to improve direct load performance. Specifying NO adds the UNRECOVERABLE keyword before the LOAD keyword in the control file.
CAUTION:
Be aware that an unrecoverable load does not log loaded data into the redo log file. Therefore, media recovery is disabled for the loaded table.
For more information about the implications of using the UNRECOVERABLE parameter in Oracle, see your Oracle utilities documentation.
Last updated: February 23, 2017