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 must update the Inventory schema.

A fix pack does not necessarily contain fixes on SQL scripts and, if present, these fixes do not necessarily apply to all database vendors.

Table 78 lists the SQL scripts, released with the different fix packs, to run for updating the Inventory schema:

Table 78. SQL scripts for updating the Inventory schema
Oracle DB2 MSSQL Sybase Informix DB2 MVS DB2 MVS custom

inv_db_423_FP01.sql

X X X X X X X

inv_db_423_FP02.sql

X X X X X X X

inv_db_423_FP03.sql

X X X X X X X

inv_db_423_FP04.sql

X X X X X X X

inv_db_423_FP05.sql

X X X X X X X

inv_db_423_FP06.sql

X X X X X X X

inv_db_423_FP07.sql

X X X X X X X

inv_db_423_FP08.sql

X X X X X X X

inv_db_423_FP09.sql

X X X X X X X

Table 79 lists the SQL scripts, released with the different fix packs, to run for updating the Historical Inventory schema:

Table 79. SQL scripts for updating the Historical Inventory schema
Oracle DB2 MSSQL Sybase Informix DB2 MVS DB2 MVS custom

h_inv_db_423_FP01.sql

X X X X X X X

h_inv_db_423_FP02.sql

X X X X X X X

h_inv_db_423_FP03.sql

X X X X X X X

h_inv_db_423_FP04.sql

X X X X X X X

h_inv_db_423_FP05.sql

X X X X X X X

h_inv_db_423_FP06.sql

X X X X X X X

h_inv_db_423_FP07.sql

X X X X X X X

h_inv_db_423_FP08.sql

X X X X X X X

h_inv_db_423_FP09.sql

X X X X X X X

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 SQL connectivity) to run the schema scripts. If you have already installed and configured the previous fix packs, you do not need to run the inv_db_vendor_423_FP0x.sql and h_inv_db_vendor_423_FP0x.sql (where x = 1, 2, 3, 4, 5, 6, 7, or 8) scripts again.

Notes:
  1. Error or information messages might be displayed when running the database scripts. Each database has unique behavior, so some messages can be expected.
  2. The inv_db2_mvs_custom_*.sql script might contain some customizable variables such as: Whose description can be found inside the inv_db2_mvs_admin.sql script.

For instance, if you use DB2 and install this fix pack, to update the Inventory schema, refer to the DB2 column of Table 78 and run the scripts identified in the table rows by X in the order specified:

If you already ran one of these scripts because you already installed the related fix pack, you do not need to run it again.


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