In this section we will discuss the online utilities like table load, index rebuild, index create and the incremental maintenance of materialized query table during load append.
Online Table Load
When loading data into a table in Version 8, the table space in which the table resides will no longer be locked. Users have full read and write access to all the tables in the table space, except for the table being loaded. For the table being loaded, the existing data in the table will be available for read access if the load is appending data to the table.
These new load features significantly improve the availability of the data and help customers deal with the maintenance of large data volumes and shrinking maintenance ...