Components Overview

BCV6 – In-Flight Cloning When data must come from tables that​ require 24×7 enterprise availability there is an issue for IT. Users need to query and update the tables without interruption. Stopping the source objects is not a viable option. Without stopping the source objects, it can be very difficult to copy tables while preserving consistency between tables and indexes and between different tables. BCV5 minimizes the copy time, but cannot avoid the impact of changes made to objects while they are being copied. The good news is that DB2 stores information about all these table changes in its log. BCV5 is an automated solution that uses the information in the log to bring the copied tablespace to a consistent state.

RM – Reduction and Masking Data privacy regulations impact how test centers use production data. Providing production data for testing purposes requires that the database administrators do not copy the data directly without first masking the sensitive data fields. RM modifies sensitive data during the copy process following user specifications. RM provides a selection of masking methods and supports user algorithms making this process flexible and powerful. At the same time that sensitive data fields are being protected, RM also allows data reduction to take place. It supports using filtering criteria to select subsets from the source data. This is particularly useful for unit and regression testing where only certain data is needed from a large data source.

IB – Icebox Archive DB2 data and populate different environments. Need to provide DB2 data from last week, last month or last year? Want an automatic and efficient procedure to recreate everything, DDL and data in record time? IB takes fast snapshots on demand or periodically, and restores the objects or databases where/when needed using names specified. Issues of compatibility or completeness no longer cause concern. BCV5 IB packages the DB2 Version x imagecopy and later restores it to any other DB2 target version required. Upgrade to a newer version of DB2 knowing that former image copies will be still available for future needs.

RC – Remote Copy Some production systems are to such an extent physically isolated that it is extremely difficult to migrate data efficiently to test systems: separate sysplex neither shared DASD nor bridging volumes with the other systems. The RC component of BCV5 makes data transfer between isolated systems an easy task. RC uses TCP/IP to transfer tablespaces, indexspaces as well as meta data from one system to another. The entire cloning process is automated, error prone manual interventions are avoided.

BI – Batch Interface BI eliminates the need for most manual procedures. It supports the efficient use of batch processing to enhance throughput. It provides a powerful definition language for using all of BCV5‘s features and functions in a simple and flexible way. The Batch Interface function is the best way to implement mission critical trigger processes that require integrity, reliability and performance. It is the interface to BCV5 to define and control copy tasks by your own applications.

AA – Alter Automation Altering DB2 objects is an exhausting task, especially when changing attributes that cannot be modified with a simple DB2 ALTER command. Such cases require backing up the data of the objects, dropping these, recreating them with the respective DDL modifications, and then loading the data back into the objects. Authorizations and auxiliary objects (triggers, views, synonyms, etc,) of these objects also need to be backed up and restored. This complex procedure often proves to be a major challenge for performance sensitive production and test environments. AA automates the alter process and implements the most effective and efficient solution available. It applies structural changes while safeguarding the integrity of the original data.

SC – Structure Compare Enhanced production applications often require modifying the existing database to support the new functionality. Using production data to populate an altered DB2 test database demands extra work from the database administrators. SC uses an expert system engine to generate a report identifying all source/target discrepancies. It uses the AA feature to automate the alter process and make manual intervention obsolete. The reduction in cost and time to accomplish this task is considerable according to customer feedback.