Prerequisites for upgrading to 10.0.2406.0-amd64

If you are upgrading the IBM Sterling Intelligent Promising to 10.0.2406.0-amd64, you must create a job column in inv_upgrade table.

Procedure

  1. Log in to Cassandra instance.
  2. Run the following command to select the keyspace. 
    USE <iv_keyspace>;
    This is the name of the keyspace that is defined in SIPEnvironment. For more information, see keyspace in cassandra parameter.
  3. Run the following query to add a column. 
    ALTER TABLE INV_UPGRADE ADD job text;
  4. Run the following query to verify if the job column is created. 
    DESCRIBE TABLE INV_UPGRADE ;