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 also need to update the inventory schema.

The fix pack installation stores several files named inv_db_vendor_schema.sql and inv_db_vendor_4.2.2_schema.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

History scripts are provided for each of the scripts listed above for updating the history tables. The history scripts are named according to the following convention: h_inv_<db_vendor>_schema.sql, where:

db_vendor
Is the shortname for the database

Running the full schema scripts removes all existing data from the database. To maintain the existing data in the database, run the inv_db_vendor_422_FP01 scripts.

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.

Note:
Error or information messages might be displayed when running the database scripts. Each database has unique behavior, so some messages can be expected.

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