Previous Topic Next topic Print topic


mfhco create command

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 Specifies the collating sequence to use. The default value is MFD, which is the EBCDIC collating sequence installed by Enterprise Developer.
logfilename The name of the logfile 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.
Previous Topic Next topic Print topic