Tim Rowe is the Business Architect for IBM i responsible for System Management and Application Development.
Scott Forstie is a Senior Technical Staff Member within IBM i development and spends most of his time working as the Db2 for i Business Architect. Read More
TechXchange Community Call: 25 July 2023 IBM TechXchange Community
Eliminate the Impact of Planned Downtime on your IBM i – 1626138 event.webcasts.com
Eliminate the Impact of Planned Downtime on your IBM i
Tue, Sep 19, 2023 12:00 PM CDT{LOCAL_TZ} Read More
Using SQL to make a list of defective PTFs Simon Hutchinson
This is something I know that System Admins should be checking, defective PTFs in their partitions. As part of the latest Technology Refreshes, IBM i 7.5 TR2 and 7.4 TR8, is a SQL View that allows me to generate a list of defective PTFs. Previously this was only available in QMGTOOLS, alas I am not authorized to that in any of the partitions I have access to, therefore, you’ll have to take my word that option 24, PTF Menu, then option 3, “Compare defective PTFs from IBM”, takes you to the same information.
The View DEFECTIVE_PTF_CURRENCY is found in the SYSTOOLS library. It returns a list of defective PTFs that do not have the corrective PTF applied.
If this is the first time you have encountered this View I suggest you use the following statement to see what defective PTFs there are in your partition, and what columns of information are returned to you:
Read more » Read More
DocM | Modernize Your IBM i Spooled Files and PC Reports Management Fortra
Join our Document & Forms Management expert Greg Schmidt as he introduces Webdocs and how you can use it to modernize the way you manage your spool files and PC-based reports – whether you’re on the IBM i or using any ERP that’s Windows or cloud based.
-Centralize the management and storage of IBM i spool Files and PC-based reports Read More