Thread History Summary
This panel provides summary information about thread activity within a report interval.
________________ ZHATACT VTM O2 V540.#P DA41 11/06/13 12:08:30 3
> Help PF1 Back PF3 Up PF7 Down PF8 Zoom PF11
>
> Enter a selection letter on the top line.
>
> *-Summary B-Buffer Pool C-DB2 Time D-Lock/Scan/Sort E-Alt Summary
> O-OPTIONS
===============================================================================
> Thread History Summary
HATH
+ Report Interval: 15 mins Start: 11/06 10:15:00.000000
+ Report Filtered: NO End: 11/06 10:29:59.999999
act
+
+ Elapsed CPU Term
+ End Time Plan Authid Time Time SQL Commit Abrt Pkg Status
+ ------------ -------- -------- ------- ------ ----- ------ ---- --- ------
+ 10:29:44.922 D DISTSERV MIS .25 .005 23 10 0 1 LIMIT
+ 10:29:43.020 D DISTSERV MIS 2.20 .008 40 10 0 1 LIMIT
+ 10:28:46.916 D DISTSERV MIS .33 .005 24 10 0 1 LIMIT
+ 10:27:44.895 D DISTSERV MIS .25 .005 23 10 0 1 LIMIT
+ 10:26:46.850 D DISTSERV MIS .33 .006 23 10 0 1 LIMIT
+ 10:25:46.527 D DISTSERV MIS .33 .005 24 10 0 1 LIMIT
+ 10:24:46.868 D DISTSERV MIS .36 .005 24 10 0 1 LIMIT
+ 10:23:56.423 D DISTSERV MIS .16 .001 2 1 0 1 STALE
+ 10:23:44.839 D DISTSERV MIS .27 .005 23 10 0 1 LIMIT
+ 10:22:46.739 D DISTSERV MIS .37 .005 24 10 0 1 LIMIT
+ 10:21:53.019 D DISTSERV MIS .44 .006 24 10 0 1 LIMIT
+ 10:21:43.725 D DISTSERV MIS 1.20 .006 21 10 0 1 LIMIT
+ 10:20:46.830 D DISTSERV MIS .45 .005 24 10 0 1 LIMIT
+ 10:19:44.924 D DISTSERV MIS .28 .005 23 10 0 1 LIMIT
+ 10:19:42.953 D DISTSERV MIS 1.34 .007 40 10 0 1 LIMIT
+ 10:18:47.089 D DISTSERV MIS .35 .005 24 10 0 1 LIMIT
+ 10:17:45.072 D DISTSERV MIS .37 .005 23 10 0 1 LIMIT
+ 10:16:45.779 D DISTSERV MIS .26 .005 23 10 0 1 LIMIT
+ 10:15:45.582 D DISTSERV MIS .35 .005 24 10 0 1 LIMIT
===============================================================================Navigation
For additional information about
- a particular thread, move the cursor to the thread information line and press F11 (Zoom).
- related topics, choose on of the options at the top of the panel.
- other topics, use the PF keys.
Fields
- Report Interval
- The time interval by which the report period is partitioned. For more information, see the description of panel Near-Term Thread History Filter Options.
- Start
- The start date and time of the interval currently displayed.
- Report Filtered
- This field shows
YESif thread filter values were used to create this display. Otherwise,NOis displayed. - End
- The end time of the interval currently displayed.
- End Time
- The end time of the DB2 thread execution. If this thread involves parallel processing or if it invokes autonomous procedures, one of the following identifiers is displayed after the elapsed time to provide more information about this thread:
- *
- This thread is a parallel task initiated on behalf of another (originating) thread to process a query request in parallel.
- A
- This thread is an autonomous procedure rollup record.
- D
- This thread is a RRSAF/DDF rollup record due to
ZPARM ACCUMACC >= 2. - O
- This thread is the originating thread that invokes autonomous procedures.
- P
- This thread is the parent or the originating thread of the parallel tasks that are created to process a query request in parallel. Activity that is performed for this (originating) thread is reflected under the parallel tasks.
- R
- This thread is a parallel task rollup record due to
ZPARM PTASKROL = YES.
- Plan
- The Db2 plan name.
- Authid
- The Db2 authorization identifier of the thread.
- Elapsed Time
- The total elapsed time for the thread.
- CPU Time
- The amount of CP time used by the thread. This value reflects MVS TCB time for non-database access threads and SRB time for database access threads and parallel tasks. This time represents CP time only and does not include SE (Specialty Engine) time.
- SQL
- The total number of DCL, DDL, and DML SQL calls issued by the thread. COMMIT and ROLLBACK/ABORT are not included.
- Commit
- The number of Commits performed by the thread.
- Abrt
- The number of aborts performed by the thread.
- Pkg
- The number of package and DBRM executions for the thread. Accounting classes 7 and 8 are required. Displays N/A if accounting classes 7 and 8 are not available.
- Term Status
- The status that indicates the reason for the thread
termination.
- READS
- IFI READ request.
- RESIGN
- Same user signed on with same authentification identifier.
- NEWUSE
- User signon.
- DDFINA
- The distributed thread went inactive.
- DEALLO
- Thread termination.
- COMMIT
- RRSAF thread specified accounting interval = COMMIT.
- EOT/TE
- End of task, application terminated normally.
- EOT/AB
- End of task, application terminated abnormally.
- EOM/AB
- End of memory, application terminated abnormally.
- RES/IN
- Resolve indoubt processing.
- FORCE
- Stop forced, MVS canceled DB2 or MVS forced DB2.
- IEOT/T
- End of task, application terminated normally and is indoubt.
- IEOT/A
- End of task, application terminated abnormally and is indoubt.
- IEOM/A
- End of memory, application terminated abnormally and is indoubt.
- IFORCE
- Stop forced, MVS canceled DB2 or MVS forced DB2, and the thread is indoubt.
- STALE
- Staleness Threshold exceeded for DDF or RRSAF thread.
- LIMIT
- DDF ROLLUP threshold limit exceeded.
- STORAG
- Internal Db2 storage threshold was reached for DDF or RRSAF thread.
- INACT
- Distributed database access thread termination.