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.

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

List out the three types of page locks that can be held.

0 Answers  

---

Describe what a storage group(STOGROUP) is?

2 Answers  

---

What is a recovery log?

1 Answers  

---

This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.

3 Answers  

---

How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

What is db2?

0 Answers  

---

How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,

---

When the like statement is used?

0 Answers  

---

How to create backup table in db2?

0 Answers  

---

what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,

---