Home > IT Answers > Networking > Performance files to Excel
DudleyShaw
15 pts.
 Performance files to Excel
Performance management, iSeries performance, excel, IBM 9406, Excel Database
I know how to run performace tools on Iseries but how can I download the Iseries performance files into Excel and create a graph on the data? Thanks

Software/Hardware used:
Iseries 9406 - 595
ASKED: Jan 2, 2011  4:16 PM GMT
UPDATED: January 5, 2011  10:07:32 PM GMT
RELATED QUESTIONS
DudleyShaw
15 pts.
Answer Wiki:
Last Wiki Answer Submitted:  Jan 2, 2011  4:16 PM (GMT)  by  DudleyShaw   15 pts.
To see other answers submitted to the Answer Wiki View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



 

I’m not quite sure what the question is asking. You download performance files like any other (multi-member) file. Are you familiar with using QDBC for Excel?

Or do you need to know how to interpret performance files? Or something else…?

Performance data files aren’t exactly well suited for processing with Excel, but it can be done. I’d suggest that there are better ways of creating charts from those files though.

Tom

TomLiotta
 66,990 pts.
 

Check out Midrange Performance Group - Performance Navigator. It does a great job of creating graphs and reports. Price was $5,600 last Oct.

HMSSL2K
 3,150 pts.
 

Tom,

I am not familiar with ODBC and trying to figure out how to setup ODBC for the Iseries so I can download performance files to create graphs in EXCEL. Any links to documentation that will help I haveWindows 7 ony PC…

Thanks dudley

DudleyShaw
 15 pts.