Optim Move for DB2

Streamlines the creation and management of test files and databases by identifying and optionally masking related subsets.

Populating your System z™ test environments with data and migrating application data to different environments is quick and easy with this problem determination tool.

  • 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.
  • De-identify test data with intelligent masking and key propagation to preserve DB2 referential integrity and application-defined relationships across multiple file and database types.
  • Optim Directory supplements DB2 catalog, 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.
  • IBM Optim MOVE for DB2 is member of two IBM solution families: the IBM Problem Determination tools and IBM Optim solutions
  • Supports IBM DB2®, IMS™, VSAM, and z/OS™ sequential data in one product.

Learn more

IBM Software
See what smarter software can do for you

Optim Move for DB2

IBM Software Subscription and Support is included in the product price for the first year.

Not available to buy online. Other ways to purchase or learn more.

Contact IBM

More Less

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

System requirements

Optim Move for DB2 runs on the following systems or higher:


Operating SystemSoftwareHardware
z/OS Optim Move for DB2 requires z/OS V1.6 (5694-A01), or later

It operates with the following DB2 configurations:
It requires DB2 V7 or later		 Any IBM eServer® zSeries® machine on which a required operating system and other required software are installed and running

Back to top

Considering a purchase?

Contact IBM

Considering a purchase?

Optim Move for DB2

 

 

 

IBM Software