Page 1 of 1

What is "incremental" in DB2?

Posted: Tue Jan 19, 2016 2:08 pm
by Hemendra Singh
Hi,

What is "incremental" in DB2? For example, I have seen usage like "incremental" IMAGE Copy? Is it like it's applicable to only a specific task or this is used in a generalized way? But in any case what exactly it means?

Re: What is "incremental" in DB2?

Posted: Tue Jan 19, 2016 4:47 pm
by William Collins
An incremental copy just copies the things which have changed since the last incremental copy. Somewhere at the back there will be a full copy. The incremental copies means that you have a "state" at various points. To rebuild completely, you have to go to the base full copy, then apply each incremental copy.

There will often be a combination of copy policies, to satisfy different requirements through flexibility.

Re: What is "incremental" in DB2?

Posted: Tue Jan 19, 2016 9:28 pm
by Robert Sample
The term is a common one when discussing back ups. Full back ups allow restoration of the entire data base (or system, depending upon what is being backed up), but take longer. An incremental back up requires the full back up base and all incremental back ups from the base to be available, and hence can require more storage (or tapes) overall, but the incremental back up will usually be smaller and hence run faster -- possibly quite a bit faster.

Re: What is "incremental" in DB2?

Posted: Fri Jan 22, 2016 4:13 pm
by zprogrammer
http://www-01.ibm.com/support/knowledge ... opies.html

A very good link to start...

If you need to know incremental image copy

http://www-01.ibm.com/support/knowledge ... ml?lang=en

Merge copy is used to copy incremental copy with full image copy to make a new full image copy