Online Load
Load operations now take place at the table level. This means that the load utility no longer requires exclusive access to the entire table space, and concurrent access to other table objects in the same table space is possible during a load operation. The LOAD utility locks only the table objects that are associated with the load operation. During a load insert (but not a load replace) operation, read access to data existing in the table prior to the load operation is permitted. This access is permitted for the entire duration of the load operation, except for a brief period just before the data is commited, when the LOAD utility must lock the table in exclusive mode. The loaded data cannot be read until the load operation has completed. ...
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.
