Answer / s

Full image copy uses tablespace scan to make a copy.
Incremental copy has to access the space map pages to check
if the page has been updated or not before copying the
page.

Answer / andank

I think the question is wrong. Full image Copies are not
faster than incremental image copies.

Answer / mehdee

- Incremental image copies are for very large DB2 tables,
and it will not work if you are also loading data into it.
It will work only if this very large DB2 table is being
updated or inserted or deleted. Now that for the backup
purpose we do image copy every day, you can tell that the
daily updated or inserted or deleted rows are no match to
the number of rows that this DB2 table contains. And since
these image copies will be on tapes then you can tell how
faster and more efficient is to do incremental image copies.

Answer / mahesh vasudevan

It all depends on the size of the tablespace. Full image
copy gives us full recovery consitent state. In case of
Incremental image copy the page needs to be checked against
the condition provided for incremental image copy and in
addition to it just by merging the incremental image copies
we can not get a full recovery of tablespaces...additional
archive log records and prior full image copies are
required. so from the recovery point of view full image copy
would be faster than these incremental image copy.....by the
way the question should be very precise and not be vauge as
it has been posted.

How to test SQL -911 error while developing COB-DB2 program

1 Answers   Satyam,

---

What is a db2 schema?

0 Answers  

---

wt is view ? wht r the restrictions for view ?

3 Answers   Verizon,

---

What is package versioning? Please give an example.

1 Answers  

---

How many buffer pools are available in db2?

2 Answers  

---

Can i insert bulk records into a db2 table using qmf of spufi only............!!!

2 Answers  

---

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers  

---

I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,

---

Where is the output of EXPLAIN stored?

2 Answers  

---

B37 abend during spufi?

0 Answers   IBM,

---

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers   IBM,

---

what is the difference between normal select query and currosor

2 Answers   Cap Gemini, TCS,

---