Re: Elapsed processing time.
2002-03-27 13:39:04
In addition to the accounting log and actlog, you can also check the summary
table for recent entries (in 3.7 and later, I believe).
>select entity, start_time, end_time-start_time as elapsed_time from summary
where ....
>select colname, remarks from syscat.columns where tabname='SUMMARY'
COLNAME REMARKS
------------------ ------------------
START_TIME Start time
START_TIME Start time
END_TIME End Time
ACTIVITY Process or Session
Activity Name
NUMBER Process or Session
Number
ENTITY Associated user or
storage pool(s)
associated with
the activity
COMMMETH Communications
Method Used
ADDRESS Communications
Address
SCHEDULE_NAME Schedule Name
EXAMINED Number of objects
(files and/or
directories)
examined by the
process/session
AFFECTED Number of objects
affected (moved,
copied or
deleted) by the
process/session
FAILED Number of objects
that failed in
the
process/session
BYTES Bytes processed
IDLE Seconds that the
session/process
was idle
MEDIAW Seconds that the
session/process
was waiting for
access to media
(volume mounts)
PROCESSES Number of
processes used
for process
SUCCESSFUL Successful ?
VOLUME_NAME Volume Name
DRIVE_NAME Drive Name
LIBRARY_NAME Library Name
LAST_USE Last Use
|
|
|