DB2 Version 9.7 for Linux, UNIX, and Windows

Creating an instance using db2icrt

Before you begin

On Linux® or UNIX® operating systems, you must have root authority.

Procedure

To create an instance using db2icrt:

1. Log in with proper authority.
2. Run the db2icrt command. For example, on Linux or UNIX operating systems:

   DB2DIR/instance/db2icrt -a AuthType -u FencedID InstName

   where:

   DB2DIR

   is the DB2 installation directory.

   • On AIX®, HP-UX, or Solaris operating systems, the default DB2 installation directory is /opt/IBM/db2/V9.7.
   • On Linux operating systems, the default installation directory is /opt/ibm/db2/V9.7.

   -a AuthType (Linux or UNIX)

   Represents the authentication type for the instance. AuthType can be one of SERVER, CLIENT, or SERVER_ENCRYPT. SERVER is the default. This parameter is optional.

   -u FencedID

   Represents the name of the user under which fenced user defined functions (UDFs) and fenced stored procedures will run. This flag is not required if you are creating an instance on a client. Specify the name of the fenced user you created.

   InstName

   Represents the name of instance. The name of the instance must be the same as the name of the instance owning user. Specify the name of the instance owning user you created. The instance will be created in the instance owning user's home directory.

Example

For example, if you are using server authentication, your fenced user is db2fenc1, and your instance owning user is db2inst1, use the following command to create an instance on an AIX system:

  /opt/IBM/db2/V9.7/instance/db2icrt -a server -u db2fenc1 db2inst1

What to do next

(Optional) After you create an instance you can configure notification for health monitoring. This task can be performed using the Health Center or CLP.