IBM Tivoli Software IBM Tivoli Software

[ Bottom of Page | Previous Page | Next Page | Contents ]


Updating the inventory schema

When you install a new fix pack, you need to update the Inventory schema.

This fix pack installation places files named inv_db_vendor_421_FP05.sql and h_inv_db_vendor_421_FP05.sql on the managed nodes where the patch is installed, in the following directory:

$BINDIR/../generic/inv/SCRIPTS/RDBMS 

where db_vendor is the shortname for the database.

If you have already installed and configured the previous fix packs, you do not need to run the inv_db_vendor_421_FP0x.sql and h_inv_db_vendor_421_FP0x.sql (where x = 1, 2, 3, or 4) scripts again.

For instance, if you use DB2 and install this fix pack over a 4.2.1 GA Version you need to run the following scripts:

If you have already run one of these scripts because you have already installed the related fix pack, you do not need to run it again.

Copy the appropriate schema scripts to any system where SQL access is available (such as the database server or the database client workstation if the client allows for SQL connectivity) to run the schema scripts.

Notes:
  1. Error or information messages might be displayed when running the database scripts. Each database has unique behavior, so some messages can be expected .
  2. When you run the inv_db2_mvs_custom_421_FP03.sql script the alter table NATIV_SWARE alter column PACKAGE_NAME set data type varchar(128) instruction might not alter the NATIV_SWARE table. To avoid this problem you must perform the following steps:
    1. Backup the table and the related views
    2. Delete the table and all related views
    3. Recreate table and related views

[ Top of Page | Previous Page | Next Page | Contents | ]