Quick Beginnings

Updating Instances on UNIX Systems

Existing instances are designed to be as independent as possible from the effects of subsequent installation and removal of products.

In most cases, existing instances will automatically inherit or lose access to the function of the product being installed or removed. However, if certain executables or components are installed or removed, existing instances do not automatically inherit the new system configuration parameters or gain access to all the additional function. The instance must be updated.

If a DB2 product is updated by installing a PTF or a patch, all the existing DB2 instances should be updated using the db2iupdt command.

Running the db2iupdt script will update the specified instance by performing the following processing:

1. Replace the files in INSTHOME/sqllib directory, where INSTHOME is the home directory of the instance.

2. If the node type is changed, then a new database manager configuration file is created. This is done by merging relevant values from the existing database manager configuration file with the default database manager configuration file for the new node type. If a new database manager configuration file is created the old file is backed up to:

      INSTHOME/sqllib/backup/db2systm.old
   

The db2iupdt command is available in the DB2DIR/instance directory, where:

where	DB2DIR	= /usr/lpp/db2_05_00	on AIX
		= /opt/IBMdb2/V5.0	on HP-UX or Solaris

The syntax of the db2iupdt command is:

where:

-h | -?

display a help menu for this command.

-d

sets the debug mode that you can use for problem determination

-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.

Notes:

1. The authentication type of the instance applies to all databases owned by the instance.

2. Authentication type, DCE, is valid. However, it is not valid to choose DCE as an AuthType for this command. To enable DCE authentication for a DB2 instance, refer to the Administration Guide.

-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. For other products, this is an required parameter.

Note:

FencedID may not be root or bin.

InstName

is the login name of the instance owner.

If a server product is installed, the syntax is:

   db2iupdt -u FencedID InstName

Examples:

• If you installed the DB2 Connect Enterprise Edition after creating the instance, you can use following command to update that instance:

     db2iupdt -u db2inst1 db2inst1
  

• To update all other instances, you can use the following command:

     db2iupdt db2inst1
  

The db2iupdt command updates the files in the INSTHOME/sqllib directory, where INSTHOME is the home directory of the instance owner.

[ DB2 List of Books | Search the DB2 Books ]