BL_ALLOW_READ_ACCESS= Table Option

Specifies that the original table data is still visible to readers during bulk load.

Category: Bulk Loading
Requirements: Must follow BULKLOAD=YES
Must be specified within the BULKOPTS= Table Option
Data source: DB2 under UNIX and PC

Syntax

BL_ALLOW_READ_ACCESS= YES | NO

Arguments

YES

specifies that the original (unchanged) data in the table is still visible to readers while bulk load is in progress.

NO

specifies that readers cannot view the original data in the table while bulk load is in progress. This is the default value.

Details

For more information about using this option, see the SQLU_ALLOW_READ_ACCESS parameter in IBM DB2 Universal Database Data Movement Utilities Guide and Reference.

See Also

Table Options: