IBM Support

Updating the IBM SDK, Java™ Technology Edition for Optim Data Server Tools Desktop Products

Troubleshooting


Problem

Optim data server tools desktop products use the IBM SDK, Java™ Technology Edition. When security vulnerabilities are discovered in the IBM SDK, Java™ Technology Edition, the only remediation is to replace the IBM SDK, Java™ Technology Edition that is installed with these products with a newer version which does not contain the vulnerability. This technote describes how to replace the IBM SDK, Java™ Technology Edition for the following Optim data server tools desktop products: IBM Data Studio client IBM InfoSphere Optim Query Workload Tuner for DB2 for LUW IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS InfoSphere Data Architect

Resolving The Problem

See the table below to find the IBM SDK, Java™ Technology Edition download link that matches your product version and platform. If you cannot find the download link for your product version and platform, contact IBM Technical Support and refer to this technote.

On Windows:

  1. Download the the compressed archive zip package (such as ibm-java-sdk-71-win-x86_64.zip) that matches the product architecture, either 64-bit or 32-bit, from IBM Technical Support.
  2. Extract it to a folder on a local file system (for example: C:\jdk\java71).
  3. If the product is open and running, exit out of the product.
  4. Open the eclipse.ini file located in the product install directory (for example: C:\Program Files\IBM\DS4.1.1\eclipse.ini).
  5. Change the -vm argument to point to the new IBM SDK, Java™ Technology Edition that was just installed. For example: -vm C:\jdk\java71\jre\bin\javaw.exe
  6. Save and close the file. Note: editing the eclipse.ini file may require administrator privileges.
  7. Restart the product

On Linux:
  1. Download the installable package (such as ibm-java-x86_64-sdk-7.1-2.0.bin) from IBM developerWorks.
  2. Extract it to a folder on a local file system (for example: /tmp/ibm-jdk-7.1-2.0).
  3. If necessary change the file permission (for example: chmod 755 ibm-java-x86_64-sdk-7.1-2.0.bin).
  4. For installable package, run the installer. For example: ./ibm-java-x86_64-sdk-7.1-2.0.bin. The IBM SDK, Java™ Technology Edition will be installed on your local file system, for example: /opt/ibm/java-x86_64-71. For compressed archive package, skip this step.
  5. If the product is open and running, exit out of the product.
  6. Open the eclipse.ini file located in the product install directory (for example /opt/IBM/DS4.1.1).
  7. Change the -vm argument to point to the new IBM SDK, Java™ Technology Edition that was just installed or extracted For example: -vm /opt/ibm/java-x86_64-71/jre/bin/javaw.exe
  8. Save and close the file.
  9. Restart the product.

* NOTE: You might have to repeat steps 4 through 8 for Windows or 5 through 9 for Linux after you install an APAR or upgrade to a newer version of an Optim data server tools desktop product, if the version of the IBM SDK, Java™ Technology Edition that is installed with the product is older than the version of Java that you installed following the instructions in this technote.

You can determine the version of the IBM SDK, Java™ Technology Edition that is installed with the product by looking at the version.properties file:

  • Windows: C:\Program Files\IBM\DS4.1.1\jdk\jre\lib\version.properties
  • Linux:  /opt/IBM/DS4.1.1/jdk/jre/ lib/version.properties

Alternatively, you can run the command java -version command:
  • Windows: C:\Program Files\IBM\DS4.1.1\jdk\jre\bin\java -version
  • Linux: /opt/IBM/DS4.1.1/jdk/jre/bin/java -version

Download links for the IBM SDK, Java™ Technology Edition for the following products on Linux:

    • IBM Data Studio Client
    • IBM InfoSphere Optim Query Workload Tuner for DB2 for LUW
    • IBM InfoSphere Optim Query Workload Tuner for DB2 for z/OS
VersionIBM SDK download link
V3.1.0, 3.1.1http://www.ibm.com/developerworks/java/jdk/linux/download.html#java6
V3.2.0, 4.1.0, 4.1.0.1, 4.1.1http://www.ibm.com/developerworks/java/jdk/linux/download.html#java7
V4.1.2http://www.ibm.com/developerworks/java/jdk/linux/download.html#java8

For Windows platforms, contact IBM Technical Support.

Download links for the IBM SDK, Java™ Technology Edition for the following products on Linux:

    • InfoSphere Data Architect
VersionIBM SDK download link
V7.5.3 http://www.ibm.com/developerworks/java/jdk/linux/download.html#java5
V7.6, 8.1http://www.ibm.com/developerworks/java/jdk/linux/download.html#java6
V8.5, 9.1, 9.1.1, 9.1.2http://www.ibm.com/developerworks/java/jdk/linux/download.html#java7
V9.1.3 http://www.ibm.com/developerworks/java/jdk/linux/download.html#java8

For Windows platforms, contact IBM Technical Support.

[{"Product":{"code":"SS62YD","label":"IBM Data Studio"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1;3.1.1;3.2;4.1;4.1.0.1;4.1.1.0;4.1.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS9UM9","label":"IBM InfoSphere Data Architect"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"General Information","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"7.5.3;7.5.3.1;7.6;8.1;8.5;9.1;9.1.1;9.1.2;9.1.3","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS7LB8","label":"InfoSphere Optim Query Workload Tuner for DB2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.1;3.1.1;3.2;4.1;4.1.0.1;4.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SS7L9Q","label":"InfoSphere Optim Query Workload Tuner for DB2 for z\/OS"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"","Platform":[{"code":"","label":""}],"Version":"3.1;3.1.1;3.2;4.1;4.1.0.1;4.1.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21691806