Update DB2 schema names in the case of a manual installation
In this step, update the DB2 schema if you are using DB2 for the runtime database or the reports database.
For the runtime database and the reports database, IBM MobileFirst Platform Foundation v6.3.0 expects the schema name without surrounding double quotation marks.
Perform one of the following steps, based on your installation.
- WebSphere Application Server Liberty profile:
- Edit the server.xml file in the usr/servers/serverName directory.
- Look for the <properties.db2.jcc .../> element in the <dataSource jndiName="contextroot/jdbc/WorklightDS" ...> and <dataSource jndiName="contextroot/jdbc/WorklightReportsDS" ...> elements.
- Optional: If there are double quotation marks around the value of the currentSchema attribute, you must remove them. For example, change currentSchema='"wrkschem"' or currentSchema=""wrkschem"" to currentSchema='wrkschem'.
- WebSphere Application Server full profile:
- Sign in to WebSphere Application Server administrative console.
- Click Resources > JDBC > Data sources
- For each database with the JNDI name jdbc/WorklightDS or jdbc/WorklightReportsDS, possibly with a suffix:
- Select the data source
- Click Additional properties > Custom properties.
- Select the currentSchema property.
- If the value is not empty, remove the double quotation marks around the value. For example, change the value "wrkschem" to wrkschem.
- Click OK.
- Click Save to save the changes.
- Tomcat:
- Edit the server.xml file in the conf directory.
- In the <Resource name="jdbc/WorklightDS" .../> and <Resource name="jdbc/WorklightReportsDS" .../> elements, remove the double quotation marks around the value of the currentSchema connection property in the url attribute, if this property is present. For example, change url='jdbc:db2://dbserver.example.com:50000/WRKLGHT:currentSchema="wrkschem";' to url='jdbc:db2://dbserver.example.com:50000/WRKLGHT:currentSchema=wrkschem;'.
Parent topic: Additional MobileFirst Server v6.3.0 upgrade information