Schema Extract tab
- Source Connection
- The name of a DB2 data source connection.
- Select schema(s) to extract
- List of schemas available in the DB2 database available via the specified DB2 data source connection.
- 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.
- Estimated using schema statistics
- Records the estimated table row count based on the schema statistics stored in SYSIBM.SYSTABLES. Use this option to improve performance.
- Both Estimated using schema statistics and Actual using SELECT BIG_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.
- Extract
- Extract the schemas selected on the
Select Schema(s) to Extract list.