LTRAC-DB2 trace entries

The DB2 Trace Entries display is a scrollable list of trace entries currently in the trace buffer.

BMC Software --------------   DB2 TRACE ENTRIES     -------------PERFORMANCE MGMT
SERV ==> LTRAC           INPUT    14:11:09 INTVL=> 3 LOG=> N TGT==> DB2D
PARM ==> PBCR02                                      ROW 1 OF 24 SCROLL=> CSR
EXPAND: MON(WKLD), TOTALS, HISTORY                   ENTRIES IN DATASET 1 - 132
         AUTH, CONNECT, PLAN, TIME, LOC, CORR, LINESEL(STRAC)
OPTION: CONNECT, CORRID; CLASS 1 CPU, ZIIP CPU, ALL CPU
  19SEP08                  PBCRCP - SQL/SCAN/IO
  END TIME     PLAN    AUTHID CONNECT   ELAPSED   CPU    # STMTS GETPAGE REASON
----------- -------- -------- -------- -------- -------- ------- ------- ------
09:17:52.76 DSNTIA21 CIR8X    BATCH       13 s    268 ms       4     459 OK TRM
09:18:10.33 DSNTIA21 CIR8X    BATCH       11 s    220 ms      12     168 OK TRM
09:18:32.78 DSNTIA21 CIR8X    BATCH    8,768 ms   218 ms      12     162 OK TRM
09:18:55.13 DSNTIA21 CIR8X    BATCH    9,225 ms   214 ms      12     162 OK TRM
09:19:19.80 DSNTIA21 CIR8X    BATCH       11 s    216 ms      12     162 OK TRM
09:19:44.59 DSNTIA21 CIR8X    BATCH       11 s    216 ms      12     162 OK TRM
09:20:09.28 DSNTIA21 CIR8X    BATCH       11 s    217 ms      12     162 OK TRM
09:20:34.83 DSNTIA21 CIR8X    BATCH       11 s    215 ms      12     162 OK TRM
09:21:00.54 DSNTIA21 CIR8X    BATCH       12 s    218 ms      12     162 OK TRM
09:21:24.18 DSNTIA21 CIR8X    BATCH       10 s    215 ms      12     162 OK TRM
09:21:47.62 DSNTIA21 CIR8X    BATCH       10 s    217 ms      12     162 OK TRM
09:22:05.21 DSNTIB21 CIR8X    BATCH    1,117 ms   112 ms      49      59 OK TRM
09:22:16.03 DSNUTIL CIR8X    UTILITY 2,907 ms   163 ms       0      64 OK TRM
09:22:17.93 DSNUTIL CIR8X    UTILITY 1,886 ms   107 ms       0      61 OK TRM
09:22:36.33 DSNTIA21 CIR8X    BATCH       10 s    204 ms       4     357 OK TRM
09:22:43.14 DSNTIB21 CIR8X    BATCH    1,981 ms    73 ms      49      32 OK TRM
09:22:59.79 DSNTIB21 CIR8X    BATCH    1,439 ms    69 ms      49      30 OK TRM

Select code

LTRAC

Parameter

You can specify the following parameters:

Parameter	Description
trace id	Unique ID identifying the trace A blank can be an identifier. Therefore, this parameter is positional and a comma delimits the next parameter. For example, if there is no identifier, a comma must precede any other parameter. However, if there is an ID, it must be in the first position.
,A \| AUTHID= xxxxxxxx	Selects a subset of the trace entries by AUTHID Specify one AUTHID, or a generic group of AUTHIDs by replacing character positions with a + (one position) or an * (multiple positions).
,C \| CONNECT= xxxxxxxx	Selects a subset of the trace entries by connection name Specify one connect type (TSO, BATCH, DB2CALL, imsid, cicsjobname), or a generic group of connections by replacing character positions with a + (one position) or an * (multiple positions).
,P \| PLAN= xxxxxxxx	Selects a subset of the trace entries by plan Specify one plan, or a generic group of plans by replacing character positions with a + (one position) or an * (multiple positions).
,L \| LOC= xxxxxxxx	Selects a subset of the trace entries by location Specify one location, or a generic group of locations by replacing character positions with a + (one position) or an * (multiple positions).
,R \| CORRID= xxxxxxxx	Selects a subset of the trace entries by correlation ID Specify one correlation ID, or a generic group of correlation IDs by replacing character positions with a + (one position) or an * (multiple positions).
,T \| TIME= hhmm [- hhmm ]	Selects a subset of the trace entries by a start time or time period, where hhmm indicates hours and minutes Midnight wrap is supported where the start time is higher than the end time; for example, TIME=2000-3000. The end time stamp of an accounting record is used to assign that record a time period.
,D \| DAY= nn [- nn ]	Selects a subset of the trace entries by a single day or range of days, where nn can be a relative number from the date of the first accounting record in the trace buffer (first date = 1, up to a maximum of 99) If a time period is selected without a DAY specification, the default value is the day of the most current record in the buffer. If there is data for only one day in the trace buffer, the format of the time stamp is hh:mm:ss. If there is data for more than one day, the format is dd-hh:mm, where dd is the relative day number from the date of the first accounting record in the trace buffer. Each accounting record traced is assigned to a time period based on its end time stamp. The processing done for that unit of work is assigned to one interval, but it may have partially occurred during one or more previous time intervals depending on its elapsed time. Warning Note Each keyword can be specified only once. If more than one selection keyword is specified, the result is ANDed.

Description

Provides a scrollable list of all the active entries for the selected trace. Each DB2 accounting record has an entry. A record is written for each DB2 thread and is available to the trace facility when the thread terminates. For more information, see the IBM publication, DB2 Administration Guide.

Note

If the target for a historical trace is not equal to the current TGT field, it is displayed in a HIST TGT field. An asterisk (*) is used in this display to indicate the following circumstances:

An asterisk preceding the PLAN column indicates that this entry is a parallel query or utility subtask.
An asterisk preceding the CONNECT column indicates that this entry is a Database Access Thread (DBAT).

Scrolling

CSR in the SCROLL field indicates that the display is scrollable. Active entries are copied to a separate storage area in the BBI-SS PAS extended private area when this service is first invoked. Thus, you can scroll the data and it does not change. This scrollable buffer is refreshed whenever Enter is pressed in the LTRAC service and no line is selected by cursor placement. If the number of entries do not fit on one screen, the list can be scrolled as described in Using MainView products.

Service message

A message in the parameter field of the service shows the sequence number of the first trace entry displayed and the total number of entries that can be displayed in a scrollable list. A message just below it shows the sequence number of the first and last trace entries currently available in the buffer. When displaying a history trace, this value is the number of trace entries in that data set.

Note

These sequence numbers are internally assigned, in sequence, to each trace entry from the start of tracing. If the entries have wrapped in the buffer (WRAP=YES) and have overlaid earlier entries, the first sequence number in the buffer is no longer 1.

Expand

The LTRAC display can be EXPANDed to the following displays:

EXPAND option	Display
MON(WKLD)	Active Timer Requests display of all active monitors in the DB2 workload (WKLD) area
TOTALS	DB2 Trace Statistics display (TSTAT) for this trace
HISTORY	Data from the current trace log data set for this trace (if you are viewing a current trace with logging, this provides access to data no longer in the online buffer) (only shown when logging is active)
CURRENT	Active trace data still in the buffers (if you are viewing a trace log data set for a still-active trace or a complete trace that has not yet been purged)
AUTH	Trace Summary by AUTHID display (TSUMA) for this trace
CONNECT	Trace Summary by Connect display (TSUMC) for this trace
PLAN	Trace Summary by Plan display (TSUMP) for this trace.
TIME	Trace Summary by Time (TSUMT) display for this trace (default of one-hour intervals)
LOC	Trace Summary by Location display (TSUML) for this trace
CORR	Trace Summary by Correlation ID display (TSUMR) for this trace
LINESEL(STRAC)	Detailed display of information about a specific entry (STRAC) that you can select from this list by positioning the cursor anywhere in the line for that entry and pressing Enter

Option

Use the following options to toggle the display of certain columns:

Option	Description
CONNECT	Displays the connection type (default).
CORRID	Displays 8 bytes of the correlation ID. The information shown varies for each of these connection types: IMS (the last 8 bytes of the correlation ID, which is equivalent to the PSB name that the transaction is using) Database Access Thread —DBAT (the first 8 bytes of the correlation ID for the requesting connection) All others (the first 8 bytes of the correlation ID) For TSO and batch users, this value is equivalent to the TSO ID and the job name For CICS users, contains the thread type, thread number, and transaction name Warning Note The correlation ID is a better identifier than connection type for CICS and Database Access Threads.
CLASS 1 CPU	Displays the class 1 CPU time recorded in the DB2 accounting record. The time is displayed in seconds (s), milliseconds (ms), or microseconds (us), depending on the value. CPU time includes all TCB and SRB time in all address spaces for processing the transaction.
ZIIP CPU	Displays the zIIP CPU time.
ALL CPU	Displays the sum of class 1 CPU time and zIIP CPU time.