IBM Support

SYSTOOLS.DEFECTIVE_PTF_CURRENCY_LOCAL()

News


Abstract

The DEFECTIVE_PTF_CURRENCY_LOCAL table function returns a list of defective PTFs on the system that do not have the corrective PTF applied. It uses an integrated file system (IFS) file that contains a downloaded version of the publicly available information in XML format.

For an IBM i that cannot connect to the internet to directly access the XML feed, use some other device to manually download the file from this URL, where the Rxx0 is the operating system release: https://public.dhe.ibm.com/services/us/igsc/has/Rxx0DEFECT.txt

For example, to access the information for IBM i 7.6 use this URL: https://public.dhe.ibm.com/services/us/igsc/has/R760DEFECT.txt

The local copy of the XML feed needs to be copied to the IBM i and located within the IFS. Once established in the IFS, DEFECTIVE_PTF_CURRENCY_LOCAL can be queried. The local copy of the XML feed will be compared to the PTF Group detail found on the current IBM i.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > IBM i Services (SQL) > SYSTOOLS.DEFECTIVE_PTF_CURRENCY_LOCAL()
 
For complete detail, visit this IBM Documentation page: DEFECTIVE_PTF_CURRENCY_LOCAL table function
 

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001go6AAA","label":"IBM i Db2-\u003ESQL Services \/ table functions"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"and future releases;7.5.0"}]

Document Information

Modified date:
27 October 2026

UID

ibm17292000

Page Feedback