FAQ - Frequently Asked Questions

Why is BCV5|6 so fast?

Date added:
Sunday, 05 April 2009
Hits:
754
Rating:
 
Vote for this:
Good  -  Bad

Answer

BCV5|6 has an integrated copy utility which is optimised for high speed DB2 copies. This utility works on physical dataset level. It copies the VSAM cluster of the involved tablespaces directly from source to target. During the copy process the program translates the object IDs (OBID) on the fly. This utility does not operate on row level like UNLOAD/LOAD works. Instead it copies the DB2 data pages directly from source to target. This saves a lot of CPU time. Additionally the program works with several copy threads. By default BCV5|6 copies 10 VSAM datasets in parallel, which reduces the elapsed up to 90 %.

Another reason why BCV5|6 is so fast is that is does not need to rebuild the indexes in the target. BCV5|6 just copies this indexes from source to target. This makes an additional rebuild index obsolete. 

Category