New Table States
The v8.1 LOAD utility does not use table space states (QUIESCED_EXCLUSIVE, LOAD_PENDING, DELETE_PENDING) to gain exclusive access to a table space. In fact, table spaces that are involved in the load operation are not quiesced. Instead, there are two new persistent table states: LOAD IN PROGRESS and READ ACCESS.
The LOAD IN PROGRESS table state restricts access to a partially loaded table. Except for the backup utility, no utility, command, or SQL statement can operate on a table that is in LOAD IN PROGRESS state and not in READ ACCESS state. No utility, command, or SQL statement can update a table that is in LOAD IN PROGRESS state. This state is reset at load commit time or during the commit of a load restart or a load terminate ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
