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

UNIX:
cobmfhco create db=databasename [coll=collsequence] [log=logfilename] 
   [id=logon-id] [pass=password] [srvr={nodename | db2instancename}] [lctn={L | R}]
Windows:
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 (applies to Windows environments only) 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.
db2instancename (applies to UNIX environments only) For databases on a local server, the default DB2 instance name specified by the DB2INSTANCE environment variable.
L Indicates that the database location is a local server. Default.
R Indicates that the database location is a remote server.

Examples

The following UNIX command:
cobmfhco create db=test srvr=db2inst1
creates a database named test using the default Enterprise Developer EBCDIC collating sequence in the DB2 instance db2inst1.
The following Windows command:
mfhco create db=test drv=e
creates a database named test on drive e using the default Enterprise Developer EBCDIC collating sequence.