PM/400e

440 pts.
Tags:
AS/400
AS/400 performance
PM/400
QMPGDATA
Hi friends. How can I generate report like this http://www-03.ibm.com/systems/i/support/pm/pdf/FeeReport.pdf using EXCEL selecting the files on the lib QMPGDATA ? Regards to all, SILVARB
ASKED: July 1, 2008  1:48 PM
UPDATED: July 3, 2008  2:46 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You can write a Query off of the QAPMJOBL file in QMPGDATA library and save to an outfile, then transfer the file into Excel.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Gilly400
    Hi Silvarb, I need to do something like this as well. Unfortunately I'm useless with excel and even worse with getting graphics out of excel. If / When you get something like this working, can you let me know how you did it? Thanks in advance, Martin Gilbert.
    23,730 pointsBadges:
    report
  • Tpinky
    First write you query. File . . . . . . . . . QAPMJOBL Library . . . . . . QMPGDATA Member . . . . . . . . *FIRST Format . . . . . . . . QAPMJOBR ....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8....+....9....+...10....+...11... Interval Elapsed Subsystem Job Interval date interval Subsystem library Job Job Job accounting Job number time seconds name name name user number code type 1 030819113715 14 QSYSWRK QSYS QYPSJSVR QYPSJSVR 061587 B 1 030819113716 16 QSYSWRK QSYS QYPSJSVR QYPSJSVR 061587 B 1 030819113902 121 QSYSWRK QSYS CRTPFRDTA QSYS 061583 B 1 030819114014 193 QUSRWRK QSYS QRWTSRVR QUSER 061572 B 1 030819114500 480 PDDISKPROB V Send to a database file... In some cases, you can go into Excel and pull directly from you iSeries. Other cases you may have to use Client Access transfer to transfer the file to your PC as a .CSV file and then pull into Excel. What I do in some cases, due to data not being clear is to send to a spool file, use iSeries Navigator to send to my PC in a .TXT file, open the file with Excel and convert text to table. TPinky
    4,165 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following