![]() |
![]() |
[ Bottom of Page | Previous Page | Next Page | Contents ]
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 66 lists the SQL scripts, released with the different fix packs, to run 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 |
Table 67 lists the SQL scripts, released with the different fix packs, to run 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 |
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, or 5) scripts again.
For instance, if you use DB2 and install this fix pack, to update the Inventory schema, refer to the DB2 column of Table 66 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 ]