DEFECTIVE_PTF_CURRENCY view
The DEFECTIVE_PTF_CURRENCY is a view which returns a list of defective PTFs on the system that do not have the corrective PTF applied.
The data returned by this view is the same data that is returned by GO QMGTOOLS/MG option 24 (PTF Menu), then taking option 3 (Compare DEFECTIVE PTFs from IBM). This information is generally refreshed one time each week.
Authorization: See Note below.
The following table describes the columns in the view. The system name is DEFPTF_CUR. The schema is SYSTOOLS.
| Column name | System column name | Data type | Description |
|---|---|---|---|
| PARTITION_NAME | PART_NAME | VARGRAPHIC(255) CCSID 1200 | The name of the partition as it is known to the HMC. |
| HOST_NAME | HOST_NAME | VARCHAR(256) | Name of the system. |
| SERIAL_NUMBER | SERIAL | CHAR(8) | The machine serial number. |
| OS_RELEASE_LEVEL | OS_RELEASE | VARCHAR(10) | The operating system release level in VxRxMx format. |
| DEFECTIVE_PTF | DEF_PTF | CHAR(7) | The PTF identifier of the defective PTF. |
| APAR_ID | APAR_ID | CHAR(7) | The APAR associated with the fixing PTF. |
| PRODUCT_ID | LICPGM | CHAR(7) | The product ID. |
| FIXING_PTF | FIXING_PTF | CHAR(7) | The PTF identifier of the corrective PTF. Returns the value UNKNOWN if the corrective PTF cannot be determined. |
Note
This view is provided in the SYSTOOLS schema as an example of how to retrieve live data from a service using SQL. 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
List any defective PTFs on the current system that have not had the corrective PTF installed.
SELECT * FROM SYSTOOLS.DEFECTIVE_PTF_CURRENCY;
