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

The fix pack installation places a file named inv_<db>_421_FP04.sql on the managed nodes where the patch is installed, in the following directory:

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

where <db> is the shortname for the database. For each of these scripts, there is also an equivalent history script for updating the history tables, and these scripts have the same names with a h_ prefix.

With this fix pack, you download an update SQL file for the Oracle database only.

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

Using SQL scripts to upgrade the schema

This section contains additional information about SQL scripts you need to run.

APAR IY52718: To install the fix for APAR IY52718, upgrade the Tivoli(R) Configuration Management, Version 4.2.1 DB2(R) schema on MVS by running the inv/SCRIPTS/RDBMS/inv_db2_mvs_421_fp01.sql script.

APAR IY52431: Run the h_inv_<db>_FP01.sql and inv_<db>_FP01.sql on an existing Tivoli Configuration Manager, Version 4.2.1 configuration repository, where db corresponds to db2, db2_mvs, or infx.

Note:
These patch scripts affect the PTF_INFO table, which is populated by a scan of OS/400(R) systems. Use the following guidelines:

APAR IY53445: Run the h_inv_ora_421_fp01.sql script on a Tivoli Configuration Manager, Version 4.2.1 configuration repository only if the schema was upgraded from an Tivoli Inventory, Version 4.0 configuration repository using the h_inv_ora_upgrade_40_421.sql script.


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