Table TAB_A resides within table space TBSP_1.
Which statement is correct?
A.
Using the COPY NO option means the data in any table within table space TBSP_1 cannot be updated or
deleted until either a table space backup of TBSP_1 or a full database backup is completed.
B.
Using the ALLOW READ ACCESS option along with INCREMENTAL indexing mode means that the newly
inserted data can be accessed because of the new CURRENTLY COMMITTED semantics.
C.
Using the COPY NO and ALLOW READ ACCESS options means that the existing table data is only
readable until the index build phase begins, since no copy of the existing data is made during the LOAD.
D.
Using the INSERT INTO and the INCREMENTAL indexing mode allows DB2 to increase the concurrency of
table access during the LOAD operation because LOAD will always append the inserted data to the end of
the table and the new index pages are also added to the end of the existing index when using
INCREMENTAL indexing mode.
COPY NO
Specifies that the table space in which the table resides will be placed in backup pending state if forward recovery is enabled (that is, logretain or userexit is on). The COPY NO option will also put the table space state into the Load in Progress table space state. This is a transient state that will disappear when the load completes or aborts. The data in any table in the table space cannot be updated or deleted until a table space backup or a full database backup is made. However, it is possible to access the data in any table by using the SELECT statement.
LOAD with COPY NO on a recoverable database leaves the table spaces in a backup pending state. For example, performing a LOAD with COPY
0
0