Previous Topic Next topic Print topic


mfhco create command

Syntax

cobmfhco create db=databasename [coll=collsequence] [log=logfilename] 
   [id=logon-id] [pass=password] [srvr={nodename | db2instancename}] [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.
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 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.

Example

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