Convert Performance tools graph's to excel graphs

[Guest.Visitor]

Is there a way to get to the data being generated by Performance Tools(DSPPFRGPH). I want to FTP the data up to a server then graph it using excel. Upper management doesn't like the AS/400 graph's.

[Guest.Visitor]

the data generated by the performance collection is typically collected in a group of flat files in QPFRDATA .. the performance monitor manual has file/field descriptions for these files ..

[Guest.Visitor]

Thanks Bruce, I see the files and fields. Is there a way to look at an IBM supplied graph and see where its grabbing the data from? Mainly all I want to do is take the ibm graph for QIBMCPUPTY and move that data up to a server and graph it using Excel.

[Guest.Visitor]

While it may vary by graph format and system release, on my r4m2 system the QIBMCPUPTY format utilizes the files QAPMSYS and QAPMJOBS and summarizes them into a file QAPGSUMD in QPFRDATA (default). You can display its field definitions with a DSPFFD and will find that at the granularity of the performance collection interval (say 10 minutes) you will get summary records for assorted classes of jobs (e.g. *ALL, *INT, *PCS, *PTH..etc) and a record for each numeric priority ... detail includes cpu seconds, disk stats, response time average ... This is the file which is used by some ibm program to produce the display .. it is created by producing the iSeries graph -- a query across it discarding the unwanted data should be relatively simple to provide Excel with just the data necessary for your reporting.

[Guest.Visitor]

Bruce, Thanks for all your help!!!!