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

  1. At least one space must occur before each parameter in the command.
  2. There must be an equals sign (=) between parameters and their values.
  3. 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.