![]() |
![]() |
[ Bottom of Page | Previous Page | Next Page | Contents ]
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.
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.
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.
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 ]