|
VCR
Simplified, automated data cloning.
FREE DOWNLOAD
How VCR Clones DB2 Subsystems Fast and Easy
During this brief overview, you'll learn how you can clone a DB2 subsystem in minutes and gain access to critical data incredibly fast.
Download this overview
Download is in Windows Media Player .wmv format.
Many applications have critical requirements for quick and accurate cloning of entire DB2® subsystems or select table and index spaces, due to the need for production or development copies, recovery initiatives, query-only access, reporting, or testing. Using current techniques, data cloning can require the better part of a day. With the ever-increasing demands for usable clones, you need an easy, automated data cloning process with minimal downtime. Now you can clone entire DB2 subsystems or select table and index spaces quickly and easily.
VCR™ - clones DB2 subsystems quickly by volume-level using any fast copy or onsite mirroring tool. VCR also takes care of updating all of the cloned DB2 internals resulting in a clone that is ready in minutes versus days. Optionally, VCR can also clone batch data. VCR provides greater data access by simplifying and automating the process of cloning entire DB2 subsystems or table and indexes quickly and easily.
FTR™ - VCR’s selectable feature, Fast Table Space Refresh for DB2, clones DB2 table and index spaces quickly by data set using any fast or slow copy facility. FTR also performs the object translation automatically and reduces manual steps.
DB2 Subsystem Cloning by Volume
The challenge of using volume replicas to clone a DB2 subsystem is how to access the data from the same LPAR, since the cloned data looks like the source data. Renaming and cataloging of the data to produce a usable clone on the same LPAR is a manual and cumbersome process. As the demand for usable clones continues to grow, the jobs of Database Administrators (DBAs) and Storage Administrators become more complicated. With VCR, you can quickly provide usable data clones to meet the increased demand for data access.
By automating and simplifying volume data cloning you can:
- Clone a DB2 subsystem, (DB2, PeopleSoft, or SAP) either offline or online
- Clone batch or other data
- Keep online systems up for inquiry access while batch updates are running
- Provide quality assurance
- Refresh test beds quickly
Used with Database Backup and Recovery for DB2 (DBR for DB2), the clone can be taken off the DB2 subsystem backup volume. Learn more.
VCR quickly:
- Renames and catalogs the cloned data in record time
- Fixes the VTOC, VTOCIX, and VVDS conflicts
- Optionally updates DB2 internal control information
VCR is lightning fast - source volumes are available after the copy!
| Timing 1 |
-
A DB2 application on 588 volumes
-
3 minutes 41 seconds to copy (FlashCopy® V1)
-
10 minutes to rename
-
Less than a minute to update DB2
|
|
Timing 2 |
-
7200 volumes with 59,000 data sets
-
18 seconds to copy (FlashCopy Manager)
-
11 minutes to rename
|
VCR Benefits:
- Significantly reduce downtime
- Simplify DB2 system and database copies
- Reduce costs through automation
- Improve productivity
- Increase data availability
- Support business resiliency initiatives
Moving to DB2 V8 but Concerned About Testing and Possible Impact?
Many DBAs want to move to DB2 V8 to benefit from the latest enhancements, such as the improved alter capabilities for indexes and table spaces, reduced virtual storage constraints, faster log applies, dynamic scrollable cursors, and forward and backward searches via the same index. Some are hesitant, since all change involves some risk and can result in unexpected complications.
Stop fearing change in your DB2 environment! If you are interested in taking advantage of the newest version of DB2 or applying new maintenance - but want to avoid any potential problems - let VCR ease your fears by quickly cloning a DB2 subsystem for you to test with. Find out how VCR can simplify and automate data cloning.
FTR
Simplified, automated data cloning.
FREE DOWNLOAD
How FTR Refreshes Table and Index Spaces Fast and Easy
During this brief overview, you'll learn how you can clone DB2 table and index spaces incredibly fast.
Download this overview
Download is in Windows Media Player .wmv format.
DB2 Table Space Cloning by Data Set
The VCR selectable feature Fast Table Space Refresh™ (FTR™) for DB2 automates and simplifies data set cloning of DB2 table spaces. FTR:
- Automatically translates object IDs that differ between source and target subsystems.
- Uses TCP/IP to copy to subsystems not connected via CAF or DDF.
- Includes an interface similar to the IBM® LISTDEF facility to drastically reduce the learning curve.
- Allows you to select individual table spaces or an entire database.
- Provides the capability to exclude undesired table spaces and indexes.
- Lets you select all table spaces in an RI relationship.
- Simplifies the selection and migration of LOB tables and CLONE tables (DB2 V9).
- When used with DB2 V8 and higher, copies tables that have identity columns to another subsystem.
- Supports fast or slow copy utilities
Find out how VCR and FTR can simplify and automate data cloning.
ADDITIONAL RESOURCES
How VCR Clones DB2 Subsystems Fast and Easy
During this brief overview, you'll learn how you can clone a DB2 subsystem in minutes and gain access to critical data incredibly fast.
Download this overview
How FTR Refreshes Table and Index Spaces Fast and Easy
During this brief overview, you'll learn how you can clone DB2 table and index spaces incredibly fast.
Download this overview
Arrange for a personal briefing. | Contact us for more information.
|