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
utility.

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.

What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,

---

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

---

How to find the number of rows in a db2 table?

0 Answers  

---

What does the REORG Utility do?

2 Answers  

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

What is a LIKE table and how is it created?

2 Answers  

---

i want to delete 20th million record how ?

4 Answers   IBM,

---

Can a array declared with an index be displayed(readable format) in spool?

4 Answers   Syntel, UST,

---

What is the difference between SYNONYM and ALIAS?

6 Answers   TCS,

---

What is runstats utility in db2?

0 Answers  

---

What is an asychronous write?

1 Answers  

---