Icebox – Snapshot DB2 data

Quickly reset test environments
In software development, tests must run repeatedly and under the same preconditions. If a test modifies data in a database, you need a fast and reliable way to reset tables to a previous state. BCV5 Icebox allows you to make a backup of your current data and structures once, and then restore it as often as needed with the push of a button.

Provide access to historic data
BCV5 Icebox is not only useful for testing purposes. Auditors may need to access data from months ago, and if table structures have changed in the meantime, this task can be technically challenging and time consuming. In addition, data typically must be restored to a different Db2 subsystem with different naming conventions. BCV5’s Icebox component (IB) reduces these challenges down to a simple task.

Restore Db2 Data to Where it’s Needed
IB enables the use of backups to provide the data and structures for other Db2 environments. Its restore function supports renaming the saved objects and allows you to create a completely different environment with the same data. IB fully automates the DDL generation, the creation of the target and the complete restore process. Simply specify the target name templates, activate the restore process and let IB do the work.

Lower Consumption of System Resources
IB’s backup process uses the proven technology of BCV5 to achieve speed and reliability. By working at the physical VSAM level for backup/restore processes and running multiple parallel threads, our customers report savings of up to 90% for CPU usage, I/Os and execution time. This way you are able to avoid UNLOAD/LOAD – which is not only much slower, but requires a substantial amount of attention from the DBA to complete the task. IB reduces the Db2 workload without impacting the performance of the Db2 subsystem.

Backup Structures
Icebox backups not only contain data of your tablespaces and indexes, but also structural information from the point in time where the backup was created. This is an advantage when compared to Db2 image copies, which do not contain structures. In a restore process, Icebox generates and restores the original DDL of all backed up objects. It can also generate the DDL for a chosen subset of objects. IB restores the DDL and the data, or only the DDL depending on your needs.

Additional Savings
Objects restored by IB are ready to use. You not only get the structures and data. Icebox will also update the target RUNSTATS and RTS information, set the high value for sequences and identity columns, and it detects and resets restricted states in the target. At the end of the process, it automatically runs any utilities that may be required, such as REPAIR CATALOG, on the target objects.

Supports 24×7 Business Needs
Since many organizations require 24×7 enterprise availability, IT often does not have the luxury to stop Db2 objects to make consistent backups. In general, image copies made with SHRLEVEL CHANGE are inconsistent and are therefore not ideal for copying into a new environment. IB eliminates this problem. When combined with the In-Flight Copy component, it is no longer necessary to stop the source objects in order to get a consistent backup. BCV5 can backup objects while users have full access, and then make the backup consistent by using information from the Db2 log.