Previous Topic Next topic Print topic


MFExtractSchemaInfo command

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
Previous Topic Next topic Print topic