5761JV1 option 14 installation

I have a system that is running IBM i 7.1, and decided to install 5761JV1 option 14 for SE 7 32 bit, since I needed to load a Java based tool called Talend ETL in order to do a POC. The install went fine and I was unaware of any problems until the next day. Our BI reporting site was down and I discovered that DB2 Web Query (Std Ed) failed to start- siting various prerequisite PTFs were not installed. It mentioned a few, so I looked at the PTF group levels. Turns out that 4 groups had levels that now said "Not Installed'.

I reasoned there might be two causes. Either Web Query automatically switched to using Java 7, or perhaps it only checks PTF group levels at startup instead of only what it actually needs. I should be able to test this on the weekend, but in the interest of getting our BI site up as quickly as possible, I did not think to see which version it was using at the time. I did however check that the system default Java was still 1.6.

To get things up and running again, I uninstalling Java 7 and fortunately the PTF groups all went back to "installed" status. I restarted web query and it was fine. The four PTF groups that went to "uninstalled" after installing Java 7 were SF99710 (Cum), SF99647 (DB2 Web Query), SF99572 (Java) and SF99368 (HHTTP).

I've installed new LPP and/or options many times before, and never had previously installed LPP's fail by installing another new LPP or new option. I always realized I would have to apply PTF's again for newly installed products before using them, but never thought it would affect existing products. Have anyone ever experienced this before?


James Martin Global Applications Architect
[Description: Description: Description: Description: dm_logo_horizontal]
[cid:image002.png@01D050BE.B0344BD0] 100 Corporate Drive, Mahwah, NJ 07430
[cid:image003.png@01D050BE.B0344BD0] office 201.762.6515 cell 201.995.7123
[cid:image004.png@01D050BE.B0344BD0] fax 201.961.6855