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. You can execute the db2iupdt command as follows:
DB2DIR/instance/db2iupdt InstName
where | DB2DIR | = /usr/lpp/db2_05_00 | on AIX |
|
| = /opt/IBMdb2/V5.0 | on HP-UX or Solaris |
|
| = /usr/IBMdb2/V2.1 | on SCO OpenServer |
|
| = /opt/IBMdb2/V2.1 | on SINIX or SGI |
Example:
db2iupdt db2inst1
The db2iupdt command updates the files in the INSTHOME/sqllib directory, where INSTHOME is the home directory of the instance owner.