After installing Java 7.0 (1.7) and reapplying PTF's on a working Showcase 9 server the server failed to start. Per KBA-33283-S4H9W2, the showcasecorp.scserver.jvm.path parameter in the showcase.cfg was used to force the server to use Java 7, and the server started successfully. Batch queries began to fail while iInteractive queries ran fine. The BATCHQUERY job logs indicate that Java 6 (1.6) is being used. No logs or artifacts indicate a problem or record an error.
This is apparently a Java-related issue, and it is known that:
The IBMi system where this occurred was using V7R2, but it is thought that this could affect OS versions V7R1 and V7R3, as well.
It's possible to force batch queries to start a specific version of Java. Batch queries use the same module to submit queries via the IBM DB2 JDBC Driver that Warehouse Builder does. Therefore, this setting affects both Warehouse Builder and batch queries simultaneously.
Near the top, under Server Properties, insert a couple of blank lines and paste this on one of those lines:
showcasecorp.whb.jvm.path=/QOpenSys/QIBM/ProdData/JavaVM/jdk70/32bit
Still have questions? We can help. Submit a case to Technical Support.