 | IBM DB2 Object Restore Tool is an affordable, robust tool that enables you to recover valuable data assets by quickly restoring dropped objects without downtime, even if they no longer exist in the DB2 catalog. Such dropped objects may include databases, tablespaces, tables, indexes and data, as well as table authorizations. Latest enhancements include double-byte (DBCS) support, single thread Versioning Repository update, partial Versioning Repository refresh, point-in-time SQL JCL recovery in one-step, and single table recovery.  - Allows you to exploit the features available in DB2 Version 8.
- Supports double-byte character set (DBCS) for input and output, allowing you to use DB2 Object Restore with DBCS object names.
- Offers Single thread Versioning Repository update, which prevents users from unnecessarily consuming valuable system resources from multiple, concurrent Versioning Repository updates, ensuring that your system's resources are available when they are needed most.
- Allows you to specify what types of objects and privileges will be maintained within the DB2 Object Restore Versioning Repository.
- Implements a method through which you can save time and system resources by performing a partial Versioning Repository refresh. You are no longer required to refresh the entire Versioning Repository if you know the individual database that contains the changes that you want to save.
- Displays a list of defined DB2 SSIDs from which you can select. You no longer need to remember numerous DB2 subsystems.
- Allows you to recover a single table from image copies, UNLOAD utility backups, and dropped tables in table space VSAM data sets. You can use DB2 High Performance Unload (if installed) when performing single-table recovery from an image copy, which is much more efficient than recovering an entire table space just to obtain one table.
- Restores a DB2 table to a point in time that you choose by using an interface to DB2 Log Analysis Tool, making the point-in-time restoration one step.
- Recovers any SYSCOPY rows that have been archived in the Versioning Repository. These rows are normally lost or recoverable only through a lengthy resource and time-intensive restore from backup resources.
- Automatically restores previously dropped objects and all related dependencies.
- Saves DASD space by eliminating the need for a duplicate shadow copy of the catalog to recover objects.
- Supports recreation of storage groups, databases, table spaces, tables, indexes, aliases, synonyms, views, plans and packages.
- Expands support to include the following privileges: user, system, database, table, view, collection, plan, package and column.
- Offers a user restore option that lets you select only the dependent object types desired instead of restoring all dependent objects.
- An expanded scope of recoverable objects and attributes, including triggers; RI foreign key, primary key, and unique key constraints; large object (LOB) table spaces; alter time stamp versioning, and UDTs.
- Enhanced repository management through new automated loading, cleanup, and update capabilities.
- Easier access to image copy functions and the ability to inspect image copy results.
- Integration with DB2 Table Editor, enabling you to invoke DB2 Table Editor and immediately edit a table within a DB2 Object Restore session to more quickly modify data.
- Improved integration with DB2 Log Analysis Tool with a focus on point-in-time recovery.
Program number: 5697-I20
DB Recovery Management |
IBM DB2 Object Restore for z/OS, V2.1 is designed to operate with the following DB2 versions: - DB2 9 (5635-DB2)
- DB2 V8 (5625-DB2)
- DB2 V7 (5675-DB2)
The following versions of the z/OS operating system are required: - z/OS V1.6 (5694-A01), or later
For more information on the system requirements, see the Program Directory on the Library page.  Get Adobe® Reader®
|
| |
|
