Features and benefits
Key features include:
- Point and Shoot: Powerful data extract facility with optional selection criteria, data sampling, data partitioning, extracts all data or just a slice of data in a related set of objects
- Intelligent masking and key propagation: Allows you to de-identify test data while preserving DB2 referential integrity and application-defined relationships across multiple file and database types
- Repository and repository management software: The Optim Directory supplements the DB2 catalog which provides, maintains data definitions, tracks request processing, stores database connection information and user-defined relationships
- Provides for one-to-one, one-to-many, and many-to-one data creation
- Alter data content during the copy process, while maintaining application-defined relationships
- Related Data Extract Facility: Extract data or object definitions from source tables using dynamic SQL or batch UNLOAD (including DB2 Image Copies and High Performance Unload)
- Multiple file and database support: IBM DB2®, IMS™, VSAM, and z/OS™ sequential data in one product
