The GROUP_PTF_CURRENCY is a view containing a query which implements a live comparison of the PTF Groups installed on the partition against the service levels listed on the IBM Preventive Service Planning website.
Enhanced with IBM i 7.4 SF99704 Level 10 and IBM i 7.3 SF99703 Level 22:
- Add the LAST_UPDATED_BY_IBM column
- Support added for 'CURRENT AT THE NEXT IPL'
- Make sure the job CCSID of the database job is not 65535.
- Make sure your default Java version is not lower than 1.6.
- If WRKENVVAR LEVEL(*SYS) shows the JAVA_HOME system environment variable is set, make sure the variable points to a JVM that is not lower than 1.6.
- If a /QIBM/UserData/Java400/SystemDefault.properties file exists, make sure it does not specify a JVM that is lower than 1.6.
- If the user of the view has a SystemDefault.properties file in their home IFS directory, make sure it does not specify a JVM that is lower than 1.6.
- Confirm that Portable App Solutions Environment (PASE) is installed and in a good state by running this command:
CHKPRDOPT PRDID(5770SS1) OPTION(33)
- In order for the function to work, the system must have access to the internet. Verify that the system can connect to the internet. One way to this is to make sure the system can: ping www.ibm.com.
Make sure the appropriate PTF is applied.IBM i 7.2 -- 5770SS1 SI72641
IBM i 7.3 -- 5770SS1 SI72639
IBM i 7.4 -- 5770SS1 SI72640
Verify that the view is correct:
where table_name = 'GROUP_PTF_CURRENCY'
and view_definition like '%support/pages%';
If the count is zero (0), perhaps the PTF did not apply correctly.
Permanently remove the PTF and reapply, looking for an error message from the PTF apply. Also check the QDBSRVXR2 system job for error messages. A common error is that other jobs are using a view that the PTF is attempting to update. To correct, end the jobs using those views and reapply the PTF.
- Verify the response from the server using the following query. This query should return XML formatted data.
select responsemsg, responsehttpheader
from table (
The beginning of the RESPONSEMSG column should look like this.
<?xml version="1.0" encoding="UTF-8"?>
If it does not, the RESPONSEMSG may contain information from a firewall that is blocking access to the server. The RESPONSEHTTPHEADER may contain error information.
- Make sure the XML data can be parsed correctly. Run this query to verify the XML is correct.
select xmlparse(document systools.httpgetclob(
04 October 2020