Updating the IBM Spectrum Symphony database schema

When you upgrade your IBM® Spectrum Symphony version, you use the same database for data from the original and new clusters. This can be either a DB2®, Oracle, or Microsoft SQL Server database. You must also upgrade the IBM Spectrum Symphony database schema to include any schema changes from your original and new clusters, if there are schema changes to your upgraded product version.

There are no schema updates for IBM Spectrum Symphony 7.3.2; you can use the IBM Spectrum Symphony database schema from your previous version of IBM Spectrum Symphony.

However, keep in mind these notes about specific features for specific versions of IBM Spectrum Symphony:
  • To use Explorer reports, offered starting from IBM Spectrum Symphony 7.2.0.2 Advanced Edition on Linux®, ensure your product schema is at least at the IBM Spectrum Symphony 7.2.0.2 level. For details, see Updating the IBM Spectrum Symphony® database schema to 7.2, as applicable.
  • To leverage the latest data loading, purger, and partitioning enhancements; and improvements to the speed of inserting and deleting data, ensure that you have an enterprise edition of your database (DB2®, Oracle, or Microsoft SQL Server) and that your IBM Spectrum Symphony schema is at least at the 7.2.1.1 level. For details, see Updating the IBM Spectrum Symphony database schema to 7.2.1, as applicable.
  • If you are upgrading from IBM Spectrum Symphony 7.3.1, to leverage the latest IBM Spectrum Symphony schema, including the new TASK_ATTRIBUTES partition database table, upgrade to the 7.3.1 schema level. For details, see Upgrading the IBM Spectrum Symphony database schema to 7.3.1, as applicable.