Finding wait statistics for a job, task, or thread

During the running of a job, task, or thread, conditions arise that cause that process to wait (for example, while the system resolves a lock or hold on a required object).

Collection Services can collect data on the cause and duration of the time a process spends waiting. This data is reported in the Collection Services database files QAPMJOBWT and QAPMJOBWTD.

Another tool that shows job wait statistics is Job Watcher. Job Watcher is a component of the iDoctor for iSeries™ software product. Job Watcher returns realtime information about a selected set of jobs, threads, and Licensed Internal Code (LIC) program tasks. At specified time intervals, Job Watcher samples anywhere from one thread per job to all threads per job. Job Watcher gathers a variety of performance data, including detailed wait statistics for jobs, tasks, and threads.

Two types of wait buckets accumulate wait state data:

Static wait buckets

A set of 16 statistical buckets, which accumulate wait state data. Static wait buckets, used by Collection Services, provide a stable view of the wait state data. Data from the static buckets is reported in the QAPMJOBWT file.

Dynamic wait buckets

A set of up to 32 statistical buckets, which accumulate wait state data. Initially, dynamic wait buckets are mapped to contain the same data as the static wait buckets. However, you can remap dynamic wait buckets.