From the HCOSS Extract Schema tool, click the
Schema Extract tab.
Do one of the following:
If using a direct connection to z/OS DB2:
In the
Connection group, select
DB2 DSN.
From the
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 using the offline schema extract solution:
In the
Connection group, select
SQL Server DSN.
From the
Connection drop-down list, select the SQL Server connection you created using the Manage Connections tool that points to the SQL Server database containing the schema objects that you want to extract.
Note: For detailed information about using the offline extract schema solution, see
Offline Extract Schema Solution.
If prompted, provide your user ID and password.
Click
New.
In the
Schema Extract Name field, type a name for the generated schema extract file.
In the
Metadata/Catalog Schema Name field, type the name of a schema containing alternative views of the SYSIBM table. Optional.
Note: This feature enables users to access the information in SYSIBM tables without having access to the SYSIBM catalog. In this case, you must create the alternative schema before running the Extract Schema tool.
Click
OK.
On the
Schema Extract tab, 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.
On the
Select schema(s) to extract list, check the box that corresponds to each schema you want to extract.
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.
Note: This option is not available when using the offline extract schema solution.
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.
On the
Schema Extract tab, click
Save to save the settings.
