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 do we specify index to include or not during bind process.

0 Answers   Satyam,

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

how to fetch first 100 rows in db2

2 Answers   IBM,

---

What is index cardinality?

3 Answers  

---

What is UNION,UNION ALL?

2 Answers  

---

What technique is used to retrieve data from more than one table in a single SQL statement?

9 Answers   CTS, IBM, TCS,

---

What is copy book?

1 Answers   Thomson Reuters,

---

Q3. How will you fetch duplicate values from a DB2 table?

2 Answers   RBS,

---

What are the three lock types?

2 Answers  

---

If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  

---

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

3 Answers   Accenture,

---

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

4 Answers   Mphasis,

---