The Smarter Way to Copy Large Tablespaces
July 7 @ 11:00 am - 12:00 pm EDT
If you have large tables that store transactional data, or data that is clustered by day, week or month, you know that keeping that data synchronized with your test environments can be a challenge. Making a full copy takes a lot of time, and using traditional data propagation tools results in vast amounts of SQL statements and a lot of logging overhead.
There is a smarter way to copy deltas into your Db2 for z/OS test beds: BCV5
BCV5 is a fast copy tool that enables you to copy only the newest partitions of your PBGs or range-partitioned tablespaces and indexes, even when they rotate every day or every week. By skipping data that has not changed you can save between 90% – 99% of CPU time and elapsed time and still keep your test beds current.
Finally there is a way to select only the partitions that have changed since you did your last copy.
Instead of having to copy all the partitions in the tablespace, BCV5‘s “Partition Level Refresh” feature allows users to make fast VSAM-to-VSAM copies of only some partitions of a table. Anyone who has ever made copies of especially large tablespaces knows how much time you can save if you only refresh the partitions that have changed. No other fast copy tool on the market offers this unique feature.
To learn more about this new way of propagating deltas to your test beds join our webinar: