Assess Data Migration Tool

The Assess Data Migration tool enables you to examine extracted DB2 schemas to estimate the table sizes, and to identify the tables you want to migrate to your SQL Server database using HCOSS.

The Assess Data Migration Tool provides the following functionality:

• Reads the content of an extracted schema file created using the Extract Schema tool.
• Shows the contents of the extracted schema, including the following information for each table represented in the schema:
  • Creator
  • Name
  • Row count
  • Count type
  • Maximum row size
  • Data volume
  • Transfer option
  • Date of last update
• Provides two count type options for each table:
  • Actual - Determined by running a query against the DB2 table on the mainframe. Depending on the table size, this could be time consuming; however, the results are reliably accurate.
  • Estimated - Based on the statistics collected by the DB2 RUNSTATS utility. While this is the most time-efficient method for determining table size, it is not always accurate because the statistics can be out of date.
  The default setting is based on the Table Row Count option you selected when extracting the schema.
• Provides two data migration transfer options for each table represented in the extracted schema:
  • HCOSS - to migrate all data in the table
  • OTHER - to bypass migration of the data in the table
• Updates the schema extract file with your changes.
• Provides a report of error messages encountered when updating the schema extract file.
• Enables you to save the extracted schema information as a flat text file or in CSV format compatible with spreadsheet software.