This chapter describes how to use db2icrt to create DB2 instance which will be used to connect to database residing on mainframe. The db2icrt command creates DB2 instances in the instance owner's home directory.

On Linux or UNIX operating systems, this utility is located in the DB2DIR/instance directory, where DB2DIR represents the location where the DB2 Connect is installed. On Windows operating system, this utility is located under the DB2PATH\bin directory where DB2PATH is the location where the DB2 Connect is installed.

• Command Syntax:

  db2icrt -[ h, d, p, a, s, u ] Instname

  Example:

  $DB2DIR/instance/db2icrt -u db2art db2art

The db2icrt command takes the following parameters:

-h | -?

Displays the usage information.

-d

Turns debug mode on. Use this option only when instructed by DB2 database support.

-a AuthType

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

-p PortName

Specifies the port name or number used by the instance. This option does not apply to client instances.

-s InstType

Specifies the type of instance to create. Use the -s option only when you are creating an instance other than the default associated with the installed product from which you are running db2icrt. Valid values are: Client, standalone, ese or wse.

-u Fenced ID

Specifies the name of the user ID under which fenced user-defined functions and fenced stored procedures will run. The -u option is required if you are not creating a client instance.

InstName

Specifies the name of the instance which is also the name of an existing user in the operating system. This has to be the last argument of the db2icrt command.