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 package versioning? Please give an example.

1 Answers  

---

What is buffer pool and list some of them?

0 Answers  

---

What are the functions in DB2?

3 Answers   Satyam,

---

Which one allows duplicate values Union or Union All ?

3 Answers  

---

What is ibm db2 used for?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---

Which component is responsible for db2 startup and shutdown?

0 Answers  

---

Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  

---

Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?

1 Answers  

---

Select empno, sal from emptbl where empno < 101.By this query can we fetch first 100 recs? where empno is primary key.It won't throw -811 error? if it wont,then what is use of cursor technique while fetching first 100 recs. Please need more clarification.

2 Answers  

---

What is view db2?

0 Answers  

---

how to identify the pseudo conversation by seeing the program

2 Answers   DELL,

---