Answer / s

changes to the table are logged in a the active logs and
archived when the active logs become full. In recovery
situations the tablespace is restored using the image copy
and applies the log records from the active/archive logs to
current time.

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,

---

What is difference between *omit and *nopass?

1 Answers   IBM, TCS,

---

What is the purpose of rollback and commit?

0 Answers  

---

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

---

If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  

---

What is PRIME TABLE and what are the uses of it

1 Answers  

---

Is it possible to precompile if db2 goes down?

4 Answers   Target,

---

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

4 Answers  

---

What is the difference between plan and package in db2?

0 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

Explain what a plan is?

3 Answers   CTS,

---