Home > Ask the AS/400 Experts > iSeries Systems Management Questions & Answers > Analyzing job run information
Ask The iSeries 400 Expert: Questions & Answers
EMAIL THIS

Analyzing job run information

Glen H. Bunnell EXPERT RESPONSE FROM: Glen H. Bunnell

Pose a Question
Other iSeries 400 Categories
Meet all iSeries 400 Experts
Become an Expert for this site


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


>
QUESTION POSED ON: 31 May 2004
How can I track jobs as they flow through the system? For instance, I need to know when a job was submitted, how long it was in the jobq, how long it took to execute and when it completed. Short of turning on joblogs for all jobs, I haven't found an easy way to do this. I can programmatically analyze QHST to get run times. It's the part about how long it sits in the job queue that has me baffled.

My purpose for this is to record this information and then analyze it to see if there are job queues that are getting too backed up and also to analyze run times on jobs to get trending information on how long they take to run. To make it a little more complicated, we use JDEdwards, and many jobs are the same job name but are submitted with different parameters for different versions of Dreamwriters and Worldwriters, so I also need to be able to get to the parameter level to track this information by version. Thanks for any help or insight you can give me.


>
When reading through QHST, the message that you receive that the job started also gives the date and time the job entered the system. With this information, you should be able to retrieve how long the job "sat" in the job queue before it actually started in the system.

As far as parameters submitted with, it can get al little extravagant, but here is an option. Hold the job queue that these jobs get submitted into. Have a program running constantly that monitors the job queue for entries. Use the job number as the key for this. As each job is placed in the job queue, execute the following command through the running job: WRKUSRJOB USER(*ALL) STATUS(*JOBQ) OUTPUT(*PRINT)

Copy the spool file generated to a physical file. Read the physical file by job number and then do a DSPJOB job(&number/User/Jobname) output(*print) option(*joblog) which will give you the parameters that the job was submitted with. This should give you the parameters that you are looking for. Hope this helps.

==================================
MORE 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.

Read this Search400.com Featured Topic: Monitoring your iSeries system .

Ask the Experts yourself: Our systems management gurus are waiting to answer your technical questions.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
Performance
Will overloaded discs impact iSeries performance?
Extend storage capacity on an IBM i without negatively effecting system performance
Database drivers on the i: MySQL vs. IBM Toolbox
Performance tuning for IBM i: The basics and beyond
IBM releases new Power products for the midrange
Top System i admin tips for 2006
Catholic Charities keeps track of homeless with iSeries
i5 error messages: What you need to know
IBM races for clock speed
System shutting down after cleanup

iSeries Systems Management
Transfer files from one environment to another without closing all other AS/400 sessions
Send a *LMSG successfully on AS/400 using the SNDDST command
Extend storage capacity on an IBM i without negatively effecting system performance
Configure the iSeries v5r4 to open the HTTPS port for incoming connections
Changing system CCSID
Changing user password expiration
Detecting system changes made by outside IP address
HIPER PTF installation and cover letters for SF99097
Library QUSRSYS not completely installed
SQL statement history storage

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



iSeries Networking - Printing, Remote Access, TCP/IP
HomeNewsTopicsITKnowledge ExchangeTipsBlogsAsk the ExpertsMultimediaWhite PapersProducts
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 1999 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts