GROUP_PTF_CURRENCY view
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. The information is generally updated once a week.
When queried, the view uses the XMLTABLE and HTTPGETBLOB table functions to consume a live XML feed from IBM Preventive Service Planning (PSP). If the partition cannot connect to the PSP website, the PTF_GROUP_CURRENCY column will contain PSP INFORMATION NOT AVAILABLE. When querying this view, the job CCSID cannot be 65535 or the query will fail.
The results of the query show which PTF Groups installed on the partition match the latest level made available by IBM and those which have a more recent version available.
Authorization: See Note below.
The following table describes the columns in the view. The system name is GRPPTFCUR. The schema is SYSTOOLS.
Column name | System column name | Data type | Description |
---|---|---|---|
PTF_GROUP_CURRENCY | GRP_CRNCY | VARCHAR(46) Nullable
|
A description of the PTF group's status. Values returned are:
Returns the null value if not applicable to this PTF group. |
PTF_GROUP_ID | GRP_ID | CHAR(7) Nullable
|
The name of the PTF group. |
PTF_GROUP_TITLE | GRP_TITLE | VARCHAR(1000) Nullable
|
The descriptive name of the PTF group. |
PTF_GROUP_LEVEL_INSTALLED | GRP_LVL | INTEGER Nullable
|
The most recent level of this PTF Group installed on the partition. |
PTF_GROUP_LEVEL_AVAILABLE | GRP_IBMLVL | INTEGER Nullable
|
The PTF Group level which is available from IBM PSP. |
LAST_UPDATED_BY_IBM | GRP_UPDATE | DATE Nullable
|
The date that IBM made the latest PTF Group level available. |
PTF_GROUP_RELEASE | GRP_RLS | VARCHAR(6) Nullable
|
The release level of the PTF Group. For example, 'R730' indicates IBM i 7.3 release level. |
PTF_GROUP_STATUS_ON_SYSTEM | GRP_SYSSTS | VARCHAR(20) Nullable
|
This column will always contain the value 'INSTALLED'. |
PTF_GROUP_LAST_UPDATED_BY_IBM | GRP_LSTUPD | CHAR(10) Nullable
|
The date that IBM made the latest PTF Group level available. This is the character form of the date formatted as MM/DD/YYYY. |
Notes
- The PSP website
is:
To determine the IP address for your geography, ping www.ibm.com.https://public.dhe.ibm.com/services/us/igsc/PSP/xmldoc.xml
- If the PSP website is relocated, this view can be updated by the user. Use the Insert Generated SQL feature in ACS to extract the source for the SYSTOOLS.GROUP_PTF_CURRENCY view. Update the link and recreate the view.
- The PTF_GROUP_STATUS_ON_SYSTEM column is included in this view to demonstrate that it would be possible to create your own version of this query or view which includes information about PTF Groups that are loaded, but not installed.
- This view is provided in the SYSTOOLS schema as an example of how to retrieve live data using an SQL view and table function. Similar to other Db2® for i provided tools within SYSTOOLS, the SQL source can be extracted and used as a model for building similar interfaces, or to create a customized version within a user-specified schema.
Services provided in SYSTOOLS have authorization requirements that are determined by the interfaces used to implement the service. To understand the authority requirements, extract the SQL for the service and examine the implementation.
Example
Compare the PTF Group service level detail, ordering the results from furthest behind to current.
SELECT * FROM SYSTOOLS.GROUP_PTF_CURRENCY
ORDER BY PTF_GROUP_LEVEL_AVAILABLE - PTF_GROUP_LEVEL_INSTALLED DESC