Take the guesswork out of the PTF history
Don?t guess what was installed on your machine. Learn how to pull up the PTF history.
When things go wrong on an iSeries or AS/400, one thing you might check is what PTFs were installed recently. Unless you keep a written log of all items installed on your machine (yeah, right) or have a REALLY good memory, it's hard to determine exactly when a PTF was installed over the last month or two.
As was presented elsewhere, you can get more out of the DSPPTF command by directing the output to an *OUTFILE instead of the screen or a print queue:
DSPPTF OUTPUT(*OUTFILE) OUTFILE(QTEMP/PTFINFO)
Then start interactive SQL and run the following query:
select scstdate, scsttime, scppid, scptfid, sclib, scxpfid, scstatus, scsptf from ptfinfo where substr(scstdate, 7, 2) = '02' order by scstdate desc, scsttime desc
The resulting display will be all PTF activity in the year '02' in descending order by date and time.
If you want to see a history of your cumulative PTF installs, run this query:
select scstdate, scsttime, scppid, scptfid, sclib, scxpfid, scstatus, scsptf from ptfinfo where substr(scstdate, 7, 2) = '02' and scptfid like 'TC%' order by scstdate desc, scsttime descMORE INFORMATION ON THIS TOPIC
==================================
The Best Web Links: Tips, tutorials and more.
Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.
Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.
Read this Search400 Featured Topic: Managing your iSeries.