Analyzing packages from MainView for DB2 traces
Trace Package views provide detailed and summary formatting of the Package Accounting (IFCID 239) data found in DB2 Data Collector active trace data sets and history (TLDS) traces. The views provide extensive totaling, including averages, minimums and maximums, and totals on a per event, per execution, and per thread basis.
You can access the views at various points when analyzing the data in a trace selected from list of traces in the HTLOGS view. You cannot directly access these views from the COMMAND line.
To analyze packages for a selected time interval
From HTLOGS, select a trace entry by clicking a hyperlink in that row on the Number Records field.The HTIQZ view showing the 15-minute time intervals available in that trace is displayed.
03JUN2013 15:39:52 ------ MAINVIEW WINDOW INTERFACE (V6.1.00) ----------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =HTIQZ=============JXODEFG==*========03JUN2013==15:39:50====MVDB2====D===83
- Thread Analysis - Query / Drilldown - Hide Header
Trace ID/Title: MVDB2DC,36 ROLLUP SUMMARY
Hyperlinks Row Hyperlinks Total Records (at Entry): 16886
. THREAD QUERY End Time >> Thread Summary-5 Min.
. Trace Details Date MM-DD >> 15-Minute Details
. BBI2 LTRAC-MV Connect Type >> Thread Summary-Connect
* TLDS All Recs Thread Count >> PACKAGE SUMMARY (15 Mins)
* TLDS All Pkgs Record Count >> THREAD LIST (15 Mins)
15M QRY >> THREAD QUERY (15 Mins)
End Date Connect Thread Record 15M Total Total Total TotInD
Time MM-DD Type Count Count QRY Elapsed CPU zIIP Elaps
15:45 06-03 CICS 207 207 * 1064.908 1.859 0.000 270.7
15:30 06-03 ******** 139 139 * 20500.144 6.568 0.000 683.1
15:15 06-03 ******** 142 142 * 2739.289 1.708 0.000 666.5
15:00 06-03 ******** 126 126 * 2184.720 1.382 0.000 678.5
14:45 06-03 ******** 334 334 * 2004.343 3.681 0.000 490.9
14:30 06-03 ******** 147 147 * 2001.813 1.701 0.000 672.0
14:15 06-03 CICS 138 138 * 1712.190 1.500 0.000 675.7
14:00 06-03 CICS 139 139 * 1772.052 1.530 0.000 684.9
13:45 06-03 CICS 158 158 * 1722.021 1.643 0.000 644.9Click a hyperlink on the Thread Count field to provide access to all packages executed in the threads of the selected 15-minute interval.
A summary package view (PKGZ) is displayed.
03JUN2013 15:35:06 ------ MAINVIEW WINDOW INTERFACE (V6.1.00) ----------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
W1 =PKGZ==============JXODEFG==*========03JUN2013==15:35:02====MVDB2====D====1
- *** Package Main *** - Hide Header
Trace ID: MVDB2DC,36
Sequence: 15 Minute Interval
Summaries: Hyperlinks:
. Package . Activity Name Pkg Count -> Package List
. Program Name . Activity Type Elapse Total -> Totals Per Execution
. AuthID
Pkg Thrd Elapsed CPU zIIP Wait Accel Wait
Count Count Total Total Total Total Total
137 137 680.883 1.355 640.006 39.559Non-zero Accelerator Wait Time values and Events values are highlighted for easier identification, as displayed in the following example:
- Hyperlink on the listed options for further information, such as summaries by package name, program name, activity name or activity type.For example, hyperlink on Pkg Count to see a complete list of packages. It also provides a hyperlink to drilldown to package detail data.
Alternatively, you can access the PKGZ view through Thread Query. In HTIQZ, hyperlink on either the Thread Query option in the header, or in the 15M QRY column for an interval.The Thread Query panel now allows retrieval of package data. Enter any character in the Package Query field to select package processing. Specify thread filters and any optional package qualifiers to limit the amount of data to be returned in the PKGZ view.
-------------------------- Select threads to display --------------------------
| COMMAND ===> SCROLL ===> CSR |
| MORE: + |
| Trace ID MVDB2DC,36 Trace Date 2013/05/27 |
| Record Count 16886 Trace Time 14:16:59.572 |
| Required Query Criteria: |
| Start Date 2013/05/27 (Local yyyy/mm/dd, default CURRENT) |
| Start Time 14:16:59 (Local hh:mm:ss, default 00:00:00) |
| Duration (hh:mm:ss, default 00:15:00) |
| Package Query (Select for Package Summary) |
| Optional Package Qualifiers (Package Query only): |
| Collection ID |
| Program Name |
| Activity Name |
| Activity Type (1=StorProc, 2=UDF, 3=Trigger, 4=NatvSQL, 5=Non-inln UDF) |
| Optional Qualifiers: |
| Authorization ID |
| Plan |
| Connection Name |
| Correlation ID |
| Correlation Name |
| Role |
| Remote Location |
| End User Name |
-------------------------------------------------------------------------------You can also access the PKGZ view when you are viewing detailed thread data in the TRSTRAC view by hyperlinking on the Packages field.
03JUN2013 15:47:56 ------ MAINVIEW WINDOW INTERFACE (V6.1.00) ----------------
COMMAND ===> SCROLL ===> CSR
CURR WIN ===> 1 ALT WIN ===>
>W1 =TRSTRAC===========JXODEFG==*========03JUN2013==15:47:55====MVDB2====D==130
- Summary Trace Entry TRACE ID: MVDB2DC - Hide Header
Hyperlinks SEQ#..... N/A Section Locates
. Monitors (WKLD) (Section Field Help)
MVDB2/DC Reports BASE SQLCNTS RTN
. Dynamic SQL Trace ENV BFRPOOL DDF
ELAPSED LOCKS PKG
. Packages PRLL ACC
** Scrollable View Lines **
STOP.....03JUN 15.45.11.82 PLAN..............TSMCOM1N TYPE..............ALLIED
START....03JUN 15.45.09.61 AUTHID............BOLWTN1 CONNECT....CICS68E1/CICS
ELAPSED...........2,218 ms ORIG PRIM AUTH....BOLWTN1 CORR ID.....ENTRTSN10003
TERM......NORMAL/RESIGN-ON COMMITS..................1 ROLLBACKS..............0
------------------------------------------------------------------------------
RUNTIME ANALYSIS IN DB2 IN APPL. TOTAL %IN DB2(=) TOTAL(*)
---------------- -------- -------- -------- 0 ...25...50...75..100%
ELAPSED TIME 1,046 ms 1,172 ms 2,218 ms | =========*********** |
CPU TIME 12 ms 129 us 12 ms | < |
DB2 WAIT TIME 743 ms | ====== |
Related topic