Quick Beginnings for DB2 Extended Enterprise Edition for UNIX

Create an Instance of the Product

Use the db2icrt command to create an instance of the product. The location of the db2icrt command depends on your operating system:

• On SCO OpenServer, go to the /usr/IBMdb2/V2.1/instance directory.

• On SINIX and Silicon Graphics IRIX operating systems, go to the /opt/IBMdb2/V2.1/instance directory.

The syntax of the db2icrt command is:

where:

InstName

Is the login name of the instance owner.

-a AuthType

Is an optional parameter that specifies the authentication type for the instance. Valid authentication types are SERVER, CLIENT, and DCS. If the -a parameter is not specified, the authentication type defaults to SERVER, if a server product is installed. Otherwise, the AuthType is set to CLIENT.

Note:

The authentication type of the instance applies to all databases under the instance.

-u FencedID

Is the user under which the fenced UDFs and stored procedures will execute. This is not required if you install the DB2 Client Application Enabler or the DB2 Software Developer's Kit. For other products, this is an required parameter.

Note:

FencedID may not be root or bin.

To create an instance for the DB2 client, you can use the following command:

   db2icrt db2inst1

The db2icrt command creates the INSTHOME/sqllib directory, where INSTHOME is the home directory of the instance owner.

To avoid a potential loss of data if an instance is deleted, you should not create user files or directories under the INSTHOME/sqllib directory, other than those created by DB2. The only exceptions is if your system supports fenced user defined functions and fenced stored procedures, put the fenced applications in the INSTHOME/sqllib/function directory.

[ DB2 List of Books | Search the DB2 Books ]