86) What is COPY PENDING status?
A state in which, an image copy on a table needs to be taken, In this status,
the table is available only for queries. You cannot update this table. To remove
the COPY PENDING status, you take an image copy or use REPAIR utility.
87) What is CHECK PENDING ?
When a table is LOADed with ENFORCE NO option, then the table is left in
CHECK PENDING status. It means that the LOAD utility did not perform constraint
checking.
88) What is QUIESCE?
A QUIESCE flushes all DB2 buffers on to the disk. This gives a correct
snapshot of the database and should be used before and after any IMAGECOPY to
maintain consistency.
89) What is a clustering index ? –
Causes the data rows to be stored in the order specified in the index. A
mandatory index defined on a partitioned table space.
90) How many clustering indexes can be defined for a table?
Only one.
|