Updating the install name in the appsoftware table

Update the name of the installation within the appsoftware table.

1. Log in to the WebSphere® Application Server Administration Console.
2. Navigate to the Business Level Application for InfoSphere MDM: Application > Application Types > Business-level applications. Then look for the application with the description MDMBLA.
3. Open the composition unit.
4. Open the OSGi application console.
5. Note the bundle name: com.ibm.mdm..hub.server-XXXXXXX.
6. Log into the MDM database.
7. Select * from <SCHEMA>.APPSOFTWARE WHERE VERSION = '11.3.0'. After you run the SQL statement, note the name of the application in the NAME field. It will say com.ibm.mdm.hub.server.
8. Update the appsoftware table to add -[name] to the com.ibm.mdm.hub.server record. For example, if XXXXXXX is E001, then to update to InfoSphere® MDM Version 11.3:
   • DB2®: update appsoftware set NAME='com.ibm.mdm.hub.server-E001', last_update_dt = current timestamp where APPLICATION_ID = 1001;
   • Oracle: update appsoftware set NAME='com.ibm.mdm.hub.server-E001', last_update_dt = sysdate where APPLICATION_ID = 1001;
   • Microsoft SQL Server: insert into APPSOFTWARE values (10000,'com.ibm.mdm.hub.server-E001', '11.3.0', CURRENT_TIMESTAMP, 'unknown');