Answer / sasi
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
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.
|Is This Answer Correct ?||8 Yes||3 No|
How do you do the EXPLAIN of a dynamic SQL statement?
What is the physical storage length of each of the following DB2 data types: DATE, TIME, TIMESTAMP?
How do you concatenate the firstname and lastname from emp table to give a complete name?
When Can you be sure that a query will return only one row?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is a correlated sub query?
What is the difference between primary key & unique index ?
select 100 records from million records ?
What is bind package and plan in db2?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
When is the access path determined for dynamic SQL?
Explain what a plan is?