Quick Beginnings

Creating an Instance of the Product

Use the db2icrt command to create an instance of the product. Where you find db2icrt 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

When an instance is created, its name is also added to the list of instances on the system.

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

You should not create files or directories under INSTHOME other than those created by DB2 products. This avoids a potential loss of data if an instance is deleted. There is one exception. If your system supports fenced User Defined Functions and fenced Stored Procedures, put the fenced User Defined Functions and the fenced Stored Procedures applications in the INSTHOME/sqllib/function directory.

[ DB2 List of Books | Search the DB2 Books ]