From the HCOSS Extract Schema tool, click the
Schema Extract tab.
From the
Source Connection drop-down list, select the DB2 connection you created using the Manage Connections tool that points to the DB2 database containing the schema objects that you want to extract.
If prompted, provide your user ID and password.
On the
Select schema(s) to extract list, check the box that corresponds to each schema you want to extract.
In the
Schema Extract Name field, type a name for the generated schema extract file.
Choose one of the following:
Local
To save the generated schema extract file to the directory specified by the
Local HCOSS Directory HCOSS option.
Shared
To save the generated schema extract file to the directory specified by the
Shared HCOSS Directory HCOSS option.
In the
Table Row Count group, select one of the following:
Estimated using schema statistics - to record 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(*) - to record 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.
Click
Extract.
On the
Results tab, verify that the schema extract file has been generated properly.
Note: If you get a -551 SQL error extracting a table, no schema is extracted. To correct this, have your DB2 DBA grant you READ access to the table that generated the error; then rerun the Extract Schema tool.