Command Reference

db2iupdt - Update Instances

On UNIX based systems, this command updates a specified DB2 instance to enable acquisition of a new system configuration or access to function associated with the installation or removal of certain product options.

On Windows NT and Windows 2000 operating systems, this command updates single-partition instances for use in a partitioned database system.

On UNIX based systems, this utility is located in the DB2DIR/instance directory, where DB2DIR represents /usr/lpp/db2_07_01 on AIX, /usr/IBMdb2/V7.1 on Linux, and /opt/IBMdb2/V7.1 on all other UNIX based systems. On Windows NT and Windows 2000 operating systems, it is located in the \sqllib\bin subdirectory.

Note:

This command is not available on OS/2.

For a complete description of this command, see the Administration Guide.

Authorization

Root access on UNIX based systems or Local Administrator on Windows NT and Windows 2000.

Command Syntax

For UNIX Based Systems

>>-db2iupdt----+----+---+-----+---+-----+---+-----+------------->
               +--h-+   '--d--'   '--k--'   '--s--'
               '--?-'
 
>-----+---------------+---+---------------+---+-InstName-+-----><
      '--a--AuthType--'   '--u--FencedID--'   '--e-------'
 

For Windows NT and Windows 2000

>>-db2iupdt---InstName---/u:--username,password----------------->
 
>-----+-----------------------------+--------------------------->
      '-/p:--instance profile path--'
 
>-----+------------------------+---+----------------+----------><
      '-/r:--baseport,endport--'   '-/h:--hostname--'
 

Command Parameters

For UNIX Based Systems

-h or -?

Displays the usage information.

-d

Turns debug mode on.

-k

Keeps the current instance type during the update.

-s

Ignores the existing SPM log directory.

-a AuthType

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

-u Fenced ID

Specifies the name of the user ID under which fenced user defined functions and fenced stored procedures will run.

InstName

Specifies the name of the instance.

-e

Updates every instance.

For Windows NT and Windows 2000

InstName

Specifies the name of the instance.

/u:username,password

Specifies the account name and password for the DB2 service.

/p:instance profile path

Specifies the new instance profile path for the updated instance.

/r:baseport,endport

Specifies the range of TCP/IP ports to be used by the partitioned database instance when running in MPP mode. When this option is specified, the services file on the local machine will be updated with the following entries:

   DB2_InstName       baseport/tcp
   DB2_InstName_END   endport/tcp

/h:hostname

Overrides the default TCP/IP host name if there are more than one TCP/IP host names for the current machine.