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 50 lists the SQL scripts, released with the different fix packs, to run for updating the Inventory schema:

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

inv_db_422_FP01.sql

X X X X X X X

inv_db_422_FP02.sql

X X X X X X X

inv_db_422_FP03.sql

X X X X X X X

inv_db_422_FP04.sql

inv_db_422_FP05.sql

X X X X X

inv_db_422_FP06.sql

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

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

inv_db_422_FP01.sql

X X X X X X X

inv_db_422_FP02.sql

inv_db_422_FP03.sql

inv_db_422_FP04.sql

inv_db_422_FP05.sql

X X X X X

inv_db_422_FP06.sql

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_422_FP0x.sql and h_inv_db_vendor_422_FP0x.sql (where x = 1, 2, 3, 4, or 5) scripts again.

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

For instance, if you use DB2 and install this fix pack, to update the Inventory schema, refer to the DB2 column of Table 50 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 ]