Evan Rudderow wrote (in part):
 
> If you've got system logging event 103 (job termination) enabled, then
> you're system log files contain all of the information you need (well, I'm
> *pretty* sure that job termination records have all the fields you want).
>  You can write a job that runs LOGTOOL in SYSDIAG to extract the records of
> interest then write them to your database.
 
Unless I missed a piece of you code, there is one potential problem.
The job termination records stats changed with the advent of the
CHGROUP command, and now contains only the connect/cpu times since
the last CHGROUP.  For complete stats you also need to extract and
summarize records type 143.
 
Guy "couldn't find the missing CPU for days" Smith
 =======================================================================
Guy Smith                                Voice:  804-527-4000 ext 6664
Circuit City Stores, Inc.                  FAX:  804-527-4008
9950 Mayland Drive                      E-Mail:  [log in to unmask]
Richmond, VA 23233-1464         Private E-Mail:  [log in to unmask]
 
The thoughts expressed herein are mine and do not reflect those of my
employer, or anyone with common sense.