Command Reference

db2icrt - Create Instance

Creates DB2 instances.

On UNIX based systems, this utility is located in the DB2DIR/instance directory, where DB2DIR represents /usr/lpp/db2_07_01 on AIX, /usr/IBMdb2/V7.1 on Linux, and /opt/IBMdb2/V7.1 on all other UNIX based systems. On OS/2 or the Windows operating system, it is located in the \sqllib\bin subdirectory.

For a complete description of this command, see the Administration Guide.

Authorization

Root access on UNIX based systems or Local Administrator on Windows operating systems or OS/2.

Command Syntax

For UNIX Based Systems

>>-db2icrt----+----+---+-----+---+---------------+-------------->
              +--h-+   '--d--'   '--a--AuthType--'
              '--?-'
 
>-----+---------------+---+---------------+---+---------------+->
      '--p--PortName--'   '--s--InstType--'   '--u--FencedID--'
 
>----InstName--------------------------------------------------><
 

For Windows Operating Systems and OS/2

>>-db2icrt----+---------------+---+-------------------------+--->
              '--s--InstType--'   '--u--UserName, Password--'
 
>-----+-------------------+---+------------------+-------------->
      '--p--InstProfPath--'   '--c--ClusterName--'
 
>-----+---------------+---+----------------+--InstName---------><
      '--h--HostName--'   '--r--PortRange--'
 

Command Parameters

For UNIX Based Systems

-h or -?

Displays the usage information.

-d

Turns debug mode on.

-a AuthType

Specifies the authentication type (SERVER, CLIENT or DCS) for the instance. The default is SERVER.

-p PortName

Specifies the port name or number used by the instance.

-s InstType

Specifies the type of instance to create (EEE, EE or CLIENT).

-u Fenced ID

Specifies the name of the user ID under which fenced user defined fucntions and fenced stored procedures will run.

InstName

Specifies the name of the instance.

For Windows Operating Systems and OS/2

-s InstType

Specifies the type of instance to create. Valid values are:

Client

Used to create an instance for a client.

Standalone

Used to create an instance for a database server with local clients.

Satellite

Used to create an instance for a satellite database server.

EE

Used to create an instance for a database server with local and remote clients.

EEE

Used to create an instance for a partitioned database server.

-u Username, Password

Specifies the account name and password for the DB2 service. This option is required when creating a partitioned database instance.

-p InstProfPath

Specifies the instance profile path. This option is required when creating a partitioned database instance.

-h HostName

Overrides the default TCP/IP host name if there is more than one for the current machine. The TCP/IP host name is used when creating the default node (node 0). This option is only valid for partitioned database instances.

-c ClusterName

Specifies the MSCS cluster name. This option is specified to create a DB2 instance that supports MSCS.

-r PortRange

Specifies a range of TCP/IP ports to be used by the partitioned database instance when running in MPP mode. The services file of the local machine will be updated with the following entries if this option is specified:

   DB2_InstName          baseport/tcp
   DB2_InstName_END      endport/tcp

InstName

Specifies the name of the instance.