Installing Service Pack from TIBCO MDM 9.1.0

If you have installed TIBCO MDM 9.1.0, perform the following steps to install TIBCO MDM 9.1.2 service pack.

1. Perform the steps from Step 1 to Step 12 listed in Installing Service Pack from TIBCO MDM 9.1.0 HF-006.
2. Perform the following steps for the REST AddModify activity samples:
   • From the extracted service pack TAR file, navigate to package/schema/RestService/1.0/samples/Repository directory.
   • Copy the AddModifyRecord samples and place it in the $MQ_HOME/schema/RestService/1.0/samples/Repository directory.
3. Copy the Common.xsd file from $MQ_HOME/customEAR/package/schema/DataService/2.0 and place it into $MQ_HOME/schema/DataService/2.0.
   Note: Before copying the latest file, take a back up of the existing Common.xsd file.
4. Copy the defaultdata.xml file from the extracted service pack TAR file package/config/security folder and place it in the $MQ_HOME/config/security folder.
   Note: Before copying the latest file, take a back up of the existing defaultdata.xml file.
5. Navigate to $MQ_HOME/customEAR/package/db/sqlserver/migration/Migrate91_91HF3 and run the following files:
   • alterForDateTime.sql: To alter a few columns from datetime2(0) to datetime2(3)
   • alterForSeq.sql: To alter INCREMENT BY for PRODUCT_SEQ sequence
   Note: This step is required only for the Microsoft SQL Server.
6. To create missing indexes on the GENERALDOCUMENT table, run the following database queries:
   For Oracle:

   CREATE INDEX XIF202GENDOCUMENT ON GENERALDOCUMENT(PARENTGENERALDOCUMENTID ASC) TABLESPACE VELODBINDX1;
   CREATE INDEX XIF204GENDOCUMENT ON GENERALDOCUMENT(DERIVEDID ASC) TABLESPACE VELODBINDX1;
   CREATE INDEX XIF205GENDOCUMENT ON GENERALDOCUMENT(ATTACHMENTID ASC) TABLESPACE VELODBINDX1;

   For PostgreSQL Server:

   CREATE INDEX XIF202GENDOCUMENT ON GENERALDOCUMENT(PARENTGENERALDOCUMENTID ASC) TABLESPACE VELODBINDX;
   CREATE INDEX XIF204GENDOCUMENT ON GENERALDOCUMENT(DERIVEDID ASC) TABLESPACE VELODBINDX;
   CREATE INDEX XIF205GENDOCUMENT ON GENERALDOCUMENT(ATTACHMENTID ASC) TABLESPACE VELODBINDX;

   For Microsoft SQL Server:

   CREATE INDEX XIF202GENDOCUMENT ON GENERALDOCUMENT(PARENTGENERALDOCUMENTID ASC);
   CREATE INDEX XIF204GENDOCUMENT ON GENERALDOCUMENT(DERIVEDID ASC);
   CREATE INDEX XIF205GENDOCUMENT ON GENERALDOCUMENT(ATTACHMENTID ASC);

7. Copy the create_FK.sql file from $MQ_HOME/customEAR/package/db/sqlserver/install/scripts/ddl to $MQ_HOME/db/sqlserver/install/scripts/ddl folder.
8. Restart the Application Server.