Migrate provides an easy, interactive way to copy one or more data tables between XDB Server locations or between an XDB Server location and a DB2 subsystem. You can use Migrate to quickly download a copy of a table from a mainframe for development and testing purposes. Or, you can use it to regularly copy up-to-date information from a production database on an XDB Server to a DB2 database on the mainframe.
Migrate simplifies the process of copying data from one location or database to another by eliminating intermediate file transfers and by eliminating the hand-editing of indexes and foreign keys. With Migrate, you can copy keys, indexes and tables in a single step. You can also quickly copy a subset of a table (certain columns or rows) by extracting data with a SELECT statement.
For complex migrations, you can use the Migrate utility's referential-integrity feature to detect data dependencies automatically and copy tables in the correct order. You can also produce a preliminary "impact analysis" report, which describes the effect of a migration before it is performed. If you copy certain tables regularly, you can save the specification in a .mig file. You can then run this file in batch mode, enabling you to perform a migration without respecifying it manually.
If your system administrator has configured the mainframe connectivity facilities of SQL Option, you can use the Migrate utility to import or export data between XDB locations, or between an XDB location and a DB2 subsystem.