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.

When the like statement is used?

1 Answers  

---

If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  

---

How to compare data between two tables in db2?

1 Answers  

---

Where is the access path logic created by the DB2 Optimizer stored?

1 Answers  

---

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

---

How to check last update on table in db2?

1 Answers  

---

I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?

4 Answers   CTS,

---

Explain packages.

1 Answers  

---

What is sqlca’s maximum length?

1 Answers  

---

How can deadlocks be resolved?

1 Answers  

---

Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,

---

what is the name of the default db2 catalog database?

3 Answers   IBM,

---