Restriction: This topic applies to Windows environments only.
- Select schema(s) to extract
- List of schemas available in the DB2 database specified by the DB2 data source connection. The list includes schemas that
contain one or more tables, views, stored procedures, or any combination of tables, views, and stored procedures.
- Schema Extract Name
- A name for the schema extract file.
- Local
- Sets the Extract Schema tool to save the generated schema extract file to the directory specified by the
Local HCOSS Directory HCOSS option.
- Shared
- Sets the Extract Schema tool to save the generated schema extract file to the directory specified by the
Shared HCOSS Directory HCOSS option.
- DB2 DSN
- The DSN specified in the accompanying field is DB2.
- SQL Server DSN
- The DSN specified in the accompanying field is SQL Server.
- Catalog Schema
- The name of an IBM catalog schema to extract.
- Estimated using schema statistics
- Records the estimated table row count using statistics last updated by the mainframe DB2 RUNSTATS utility. Use this option
to improve performance.
- Both Estimated and Actual (COUNT(*))
- Records both the estimated table row count and the actual row count as retrieved using a SELECT BIG_COUNT(*) query. Use this
option to provide accuracy.
- New
- Create a new schema extract file.
- Revert
- Removes all changes made on this tab, setting each field and control to its last saved setting.
- Save
- Saves changes made on this tab.
- Delete
- Deletes the schema extract file.
- Extract
- Extract the schemas selected on the
Select Schema(s) to Extract list.
- Import
- Import a previously exported schema extract file.
- Export
- Copy the generated schema extract file to a specified directory so that it can be used to import the schema into the tool
when the mainframe is not available.