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 a file named inv_<db>_schema.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 this script, there is also a history equivalent script for updating the history tables, h_inv_<db>_schema.sql.

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

Note:
Installing the full schema scripts will remove 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.

DB2 and Informix(R) only: Run the inv_<db>_FP02.sql script as a DB2 inventory user.

Notes:
  1. 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.
  2. You should run a "Replace with Current(R) Results" scan when scanning a new endpoint and after installing a new schema.

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 either db2, db2_mvs or infx.

Note:
These patch scripts affect the PTF_INFO table, which is populated by a scan of OS/400 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 ]