Executes the HCOSS Extract Schema tool from the command line.
Syntax:
MFExtractSchemaInfo DB2=DB2Connection;
[U=DB2UserID;]
[P=DB2Password;]
OUT=SchemaExtractFileName;
[OUTLocal={TRUE | FALSE};]
{SCHEMA=DB2Schema1[, DB2Schema2 ...] |
TBS=DB2Tablespace1[, DB2Tablespace2 ...]};
[TYPELOG={CONSOLE | FILE | BOTH};]
Parameters:
- DB2
- The name of a cataloged DB2 connection.
- U
- The user ID required to access the DB2 database specified by the
DB parameter, if applicable.
- P
- The password required for the user ID specified by the
U parameter, if applicable.
- OUT
- The name of the generated schema extract file. Do not specify a file extension. The default file extension is
.hcodbs.
- OUTLocal
- Determines the location of the generated schema extract file. Schema extract files are stored in the
\Schemas subdirectory of either of the following, depending on the value specified:
| TRUE
|
Directory specified by the
Local HCOSS Directory HCOSS option. Default.
|
| FALSE
|
Directory specified by the
Shared HCOSS Directory HCOSS option.
|
- SCHEMA
- The name of one or more valid DB2 schemas to extract. Separate schema names with a comma (,). You may also use the
% wild card character in schema names.
- TBS
- The name of one or more valid DB2 tablespaces to extract. Separate tablespace names with a comma (,).
- TYPELOG
- Sets the type of logging to perform. Defaults to the equivalent of the value specified for the
Type of logging to do HCOSS option.
Example:
MFExtractSchemaInfo DB2=MVS91; OUT=LocalSchemaExtract; SCHEMA=MFIREX%,SDI002; TYPELOG=FILE
MFExtractSchemaInfo DB2=MVS91; OUT=SharedSchemaExtract; OUTLocal=FALSE; SCHEMA=MFIREX%,SDI002
