Home > IT Answers > Microsoft Windows > Performance files to Excel
DudleyShaw
15 pts.
 Performance files to Excel
excel, Excel Database, IBM 9406, iSeries performance, Performance management
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: January 2, 2011  4:16 PM
UPDATED: January 5, 2011  10:07 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all 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
 110,135 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,175 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.