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 places files named inv_<db>_schema.sql, inv_<db>_421_FP03.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.

You can use all of these scripts to either update or reinstall your database schema.

If you have already run the full schema scripts inv_<db>_schema.sql and you want to preserve your existing data, then you need to run the inv_<db>_421_FP03.sql scripts to update your database without losing any data.

Note:
Running the full schema scripts removes all existing data.

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 install the schema scripts.

DB2(R) only: Create the temporary tablespace "usertemp1" by running the inv_db2_admin_patch.sql script as a DB2 administrator. If you are installing a new DB2 database and using the inv_db2_admin.sql script, you do not need to run the patch script as it is now contained in the latest version of the admin script.

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 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 ]