mfhco create command

Important: Before executing the mfhco create command, be sure that the MFCODESET environment variable is set to the appropriate country code. See Creating a DB2 LUW Database for HCO for details.

Syntax

mfhco create db=databasename [coll=collsequence] [log=logfilename] 
   [drv=driveletter] [id=logon-id] [pass=password] [srvr=nodename] [lctn={L | R}]

Syntax Rules

At least one space must occur before each parameter in the command.
There must be an equals sign (=) between parameters and their values.
If you omit parameters that have a default value, Host Compatibility Option uses the default value.

Parameters

`databasename`	Specifies the name of the new database.
`collsequence`	If specified, must be the default value MFD. This ensures that the environment variable MFCODESET is used.
`logfilename`	The name of the log file in which to capture output information. The default value is createdb.log.
`driveletter`	The drive letter to create local database on.
`logon-id`	The logon ID required to connect to the server where the database is to reside.
`password`	The password required to connect to the server where the database is to reside.
`nodename`	For databases on a remote server, the cataloged DB2 node name for that server.
L	Indicates that the database location is a local server. Default.
R	Indicates that the database location is a remote server.

Example

The following command:

mfhco create db=test drv=e

creates a database named test on drive e using the default Enterprise Developer EBCDIC collating sequence.