Event data

ACCEL-CALL*

SQL

2

378/381

Accelerator Call

• NAME= accelerator name

ALLOC-CURSOR*

SQL

2

273

ALLOCATE CURSOR statement

• STPROC=Stored procedure name

ASSOC-LOCATR*

SQL

2

272

ASSOCIATE LOCATORS statement

• STPROC=Stored procedure name

ASUTIME-EXCD*

D

2

173

Package name and cursor name

ASYNC-GBP*

IO

3

329

Asynchronous Group Buffer Pool

• GBP= group buffer pool name
• TYP= request type
  • CASTOUT-DATA
  • CONNECT
  • DELETE-NAME
  • DEL-NAME-LST-SEC
  • DEL-NAME-SEC
  • DISCONNECT
  • FORCE
  • IXLFCOMP-DEL_NAML
  • IXLFCOMP-WRT_DATA
  • PROCESS-REFLIST
  • READ-COCLASS
  • READ-COSTATS
  • READ-COSTATS-SEC
  • READ-DATA
  • READ-DIRINFO
  • READ-STGSTATS
  • READ-STGSTATS-SEC
  • REGISTER-PAGE-LST
  • RESET-REFBIT
  • SET-RECLVCTR
  • UNLOCK-CASTOUT
  • WRITE-DATA
  • WRITE-DATA-SEC

AUTH-FAIL*

D

1

140

Authorization ID not privileged to perform requested operation

Type of request:

• ALTER
• ALTER BUFFERPOOL
• ALTER INDEX
• ALTERIN
• BIND ADD
• BIND/REBIND/FREE
• BMAINTMONITOR 1
• CHECK UTILITY
• COMMENT ON
• COPY
• CREATE DBC
• CREATE GLOB TEM TBL
• CREATE INDEX
• CREATE STOGROUP
• CREATE SYNONYM
• CREATE TABLE
• CREATE TABLESPACE
• CREATE VIEW
• CREATEDBA
• CREATIN
• DBADM
• DBCTRL
• DEBUG SESSION
• DELETE
• DISPLAY
• DISPLAY ARCHIVE
• DISPLAY BUFFERPOOL
• DISPLAY DB
• DISPLAY PROCEDURE
• DISPLAY PROFILE
• DISPLAY RLF
• DISPLAY THREAD
• DISPLAY UTILITY
• DROP
• DROP INDEX

AUTH-FAIL* (continued)

D

1

140

• DROP SYNONYM
• DROPIN
• EXECUTE

AUTH-XLAT*

D

2

169

Authorization ID translation either OUTBOUND or INBOUND

• LOC ALIAS= location alias name received or sent
• DB ALIAS= database alias name that was received or sent
• OSA= and NSA= indicate that the IDs are system authorization IDs in a trusted context

BFR-SNDBFR-RCV

DDFVTAM

3

166

Buffer send or receive

• LU= logical unit name
• SIZE(999) = size of buffer in bytes

BIND*

D

1

108/109

Bind/rebind a plan or package

• PLAN= plan name
• PACKAGE= package name
• RC(nnn) = return code

BIND-TEXT*

SQL

2

063

Dynamic/static SQL BIND

• TYPE= DYNAMIC or static. Type of language when static:
  • ASM
  • COBOL
  • C
  • FORTRAN
  • PL/1
  • COBOL II
• TEXT= first 17 bytes of text of SQL statement. The first 5000 bytes of SQL text is available in a pop-up display.

CLAIM*

LOCKS

3

211

Claim request

• DB= database name
• OB= table space or index space name
• PART= partition number

CLAIM-WAIT*

D

2

215/216

Wait for pending claims to go to zero

• DB= database name
• OB= table space or index space name
• PART= partition number

CLOSE-TS

D

2

107

Close table space data set

• TS= table space name
• DB= database name

COMMIT-LSN*

D

2

218

Summary of COMMIT log sequence numbers

• LOCK AVOID= Y for successful lock avoidance technique for unit of work, N for unsuccessful
• PAGESETS= number of pagesets involved in unit of work
• TYPL= type of lock:
  • PAGE
  • ROW
  • IXEOF (index end-of-file)

CONV-QUEUED*

D

2

167

Conversation request queued

• LU= logical unit name
• MODE= VTAM mode name from communications database

CONV-REQ*

DDF

2

159

Conversation request

• TYPE= type of request:
  • CREATE
  • WAIT
• LOC= sixteen-character location name.

CREATE-THD

D

2

072/073

CREATE THREAD

DEADLOCK*

D

1

172

Deadlock details

• RESOURCES INVOLVED= number of locked resources in the deadlock

DIST-SQL*

D

1

168

Distributed SQL statement

DRAIN*

LOCKS

3

212

Drain request

• DB= database name
• OB= table space or index space name
• PART= partition number

DRAIN-WAIT*

D

2

213/214

Wait for drain request

• DB= database name
• OB= table space or index space name
• PART= partition number

EDM-FULL

D

1

031

EDM pool full condition

Type of request that received condition

• CT= plan name for cursor table
• XT= plan name for cursor table extension
• SKCT-HDR= skeleton cursor table header
• SKCT-DIR= skeleton cursor table directory
• DB= database name (zeros in this field indicate an internal latch)
• PT= package name
• SKPT= skeleton package table entry
• SKPT-DIR= skeleton package table directory

EDM-REQ

D

2

029/030

EDM I/O Request

• CT= or XT= plan name for the cursor table or extended cursor table respectively
• SKCT-DIR= skeleton cursor table directory
• SKCT-HDR= skeleton cursor table header
• RDS-SECTION= cursor table sections
• DB= Database name (zeros in this field indicate an internal latch)
• PT= Collection ID and package ID

End SQL*:

• COMMIT/DESC
• SQL-ERROR

SQL

1

053

End DESCRIBE, COMMIT, ROLLBACK, or SQL statement error (see 'SQL statement pop-up display' in Event-pop-up-displays

EXPLAIN*

SQL

2

022

Explain the data access path for an SQL statement (see 'EXPLAIN pop-up display (IFCID 022)' in Event-pop-up-displays)

• PLAN/PKG= plan name or package ID
• COST(n.n)= relative cost assigned by the Db2 optimizer for the execution of the SQL statement; for large numbers, a unit of measure (K, M, or B) is appended

FREE*

D

1

110/111

Free a plan or package

• PACKAGE= package name
• PLAN= plan name
• RC(nnn)= return code

FRST-INSRT (n)*

SCAN

3

016/018

Internal INSERT of rows where (n) identifies the number of grouped scan entries, if any

• IX= index name
• TS= table space name
• DB= database name

HASH-SCAN*

SCAN

3

013/014

Hash scan

• TS= table space name
• DB= database name

HJOIN-FAIL*

D

2

190

Hybrid join failure

This failure is a single-event record with no elapsed or CPU time.

• #RIDS= number of record ID entries (RIDs) in the RID list
• type-of-failure= type of failure described in a short phrase

INCR-REBIND*

D

2

360

Incrementally Rebound Queries

• PLAN= plan name
• PKG= package name

INDEX-SPLIT*

D

2

359

Index Split

• DB= database name
• OB= table space or index space name

INDX-SCAN ( n )*

SCAN

3

015/018

Matching or nonmatching index scan, where (n) identifies the number of grouped scan entries, if any

• IX= index page set name
• TS= table space name
• DB= database name

INPUT-VAR*

SQL

3

247

Program name

INV-SELECT

D

1

224

Invalid SELECT procedure

• COL=nnn Total columns bypassed, followed by plan name, package ID, or collection ID

LATCH WAIT

D

2

052/051056/057

SHARED

EXCLUSIVE

LOCK*UNLOCK*LOCK CHG*LOCK QRY*

LOCKS

3

021

Lock request

• OB= table space or index space name
• DB= database name
• PLAN = plan name
• TYP= type of lock (see Lock-types-for-detail-trace-events)

LOCK-ESCAL*

D

3

337

Database, table space, and lock state

• IS = intent shared
• IX = intent exclusive
• SH = shared
• UP = update
• SX = shared intent exclusive
• EX = exclusive

LOCK-SUMMARY*

D

2

020

Lock summary at COMMIT/ABORT

• MAXPG(nnn)= maximum page locks held concurrently
• ESCL(nnn) = total lock escalations
• TS(nnn)= number of table spaces in which locks were held

LOCK-SUSP*

D

2

044/045

Lock suspension

• OB= table space or index space name
• DB= database name
• TYP= type of lock (see Lock-types-for-detail-trace-events)

LSN-DETAIL*

LOCKS

3

223

Detail of successful COMMIT-LSNs (lock avoidance)

• OB= table space or index space name
• DB= database name

MAXTMP-LIM*

SQL

2

343

Maxtemps Limit

• PKG= package name
• USED= current workfile storage used

NONEST-STMT*

SQL

2

497/499

Non-Nested External Function Detail

• REASON= reason for externalizing
  • MAX UNIQUE STMT IDS COLLECTED
  • ACCOUNTING INTERVAL ENDED
  • STORED PROCEDURE STARTED
  • STORED PROCEDURE ENDED
  • USER-DEFINED FUNCTION STARTED
  • USER-DEFINED FUNCTION ENDED

OPEN-TS

D

2

107

Open table space data set

• TS= table space name
• DB= database name

PAGE P-LOCK*

LOCKS

2

259

Page physical lock (P-lock) request

• DB= database name
• PS= page set name
• IRLM function= LOCK, UNLOCK, CHANGE, or EXITCH (change from P-lock exit). If the field is blank, it is not displayed.

PGLAT-WAIT

D

2

226/227

Page latch wait

• OB= table space or index space name
• DB= database name
• POOL= buffer pool ID

PH1-COMMIT

D

2

084/085

Phase 1 commit

PH2-COMMIT

D

2

070/071

Phase 2 commit

PKG-ALLOC*

D

2

177

Package allocated

• ISO= type of isolation, either CS (cursor stability), RR (repeatable read), or UR (uncommitted read)
• ACQ= acquire locks at ALLOC (allocation) or USE (first use)
• REL= release level of the package, determining when resource are released; possible values are DEALLOC (deallocation) or COMMIT

PLAN-ALLOC*

D

2

112

Plan allocated

• ISO= type of isolation, either CS (cursor stability) or RR (repeatable read)
• ACQ= acquire locks at ALLOC (allocation) or USE (first use)
• REL= release locks at DEALLOC (deallocation) or COMMIT

P-LOCK*

LOCKS

2

251

Physical lock (P-lock) operation

• DB= database name
• PS= page set name
• IRLM function= LOCK, UNLOCK, CHANGE, or EXITCH (change from P-lock exit). If the field is blank, it is not displayed

PRLL-DEGREE*

SCAN

3

221

Degree of parallel I/O processing for group

• PLANNED= degree planned at run time
• ACTUAL= actual parallel I/O degree
• GROUP#= parallel group number

PRLL-ELAP*

SCAN

3

222

Elapsed time of parallel group

• ELAP= elapsed time of parallel group pipe
• ROWS= number of rows processed

PRLL-GROUP*

D

3

231

Individual task information for a parallel group

• ELAP= elapsed time of parallel group
• GROUP= parallel group number

PRLL-INDX*

IO

2

357/358

Index Insert with Parallelism

• DB= database name
• OB= table space or index space name

PRLL-STRAW*

D

2

363

Straw Model for Workload Distribution

• PKGCOLL= package collection ID
• PGM= program name

PRLL-SUSP

SCAN

2

382/383

Parellel Task Suspended

• TASK= PARENT or CHILD

READ-I/O*

IO

3

006/007

READ I/O

• DB= database name
• TS= table space name

BP nnnn = buffer pool in use

One of four possible descriptions is reported:

• SYNC-RD= synchronous read of one page
• SEQ-PF= asynchronous read for sequential prefetch
• LIST-PF= asynchronous read for list prefetch
• DYN-SEQ= asynchronous read for dynamic sequential detection prefetch

REQ-AGNT*

DDF

2

183

Requesting agent data

• RC= return code from event
• Function= function type; possible values are:
  • BEGIN BIND
  • BIND CONNECT
  • BIND STMT
  • CONNECT EXTRACT
  • CONNECT RESET
  • CONNECT RESET FOR BIND
  • CONNECT RESET TYPE 2
  • CONNECT TYPE 2
  • END BIND
  • EXPLICIT CONNECT

REQ-DRDS*

DDF

2

157

DRDS request at requesting site

• TYPE= type of request:
  • AUXCALL
  • DSCRBCAL
  • OPENCALL
  • SETUPCAL
• LOC= sixteen-character location name

REQ-DTM*

DDF

2

162

Distributed transaction manager request at requesting site

• TYPE= type of request:
  • MIGRATE TRANSACTION
  • COMMIT MESSAGE SENT
  • DEALLOCATION INITIATED
  • READ RESPONSE RECV'D
  • BACKOUT REQUEST SENT
  • COMMIT RESPONSE RECV'D
  • BACKOUT RESPONSE RECV'D
  • PREPARE REQUEST SENT

REQ-VTAM*

DDF

3

160

VTAM request at requesting site.

• TYPE= type of request:
  • SEND REQUEST MESSAGE
  • ALLOCATE CONVERSATION
  • CREATE CONVERSATION
  • DEALLOCATE CONVERSATION
  • RESET CONVERSATION
  • RECEIVE RESPONSE MESSAGE
  • TERMINATE CONVERSATION
  • WAIT FOR RESPONSE MESSAGE

RIDLIST*

D

2

125

Multiple index access path processing of RID lists, reporting one of three possible descriptions:

• RIDS IN FINAL LIST (nnn)
• NOT USED - NO RID STORAGE
• NOT USED - RIDS > MAXIMUM LIMIT

ROLLBACK

D

1

068/069

Rollback thread

SEQ-SCAN (n)*

SCAN

3

017/018

Sequential table space or work file scan, where (n) identifies the number of grouped scan entries, if any

• TS= table space name.
• DB= database name.

SERV-DRDS*

DDF

2

158

RDS request at serving site

• TYPE= type of request:
  • AUXCALL
  • SETUPCAL
  • DSCRBCAL
  • OPENCALL

SERV-DTM*

DDF

2

163

Distributed transaction manager request at serving site

• TYPE= type of request:
  • ACKNOWLEDGE COMMIT SENT (UP LOCATION)
  • BACKOUT REQUEST RECV'D
  • BACKOUT RESPONSE SENT
  • COMMIT MESSAGE RECEIVED
  • COMMIT RESPONSE SENT
  • DB ACCESS AGENT CREATE Q'D
  • DBAA CREATION QUEUED
  • DEALLOCATION INITIATED
  • LAST AGENT REQUEST RECV'D
  • MIGRATE TRANSACTION RECEIVED
  • NEW USER BROADCAST
  • NEW USER BROADCAST RECEIVED
  • PREPARE REQUEST RECV'D
  • RESPONSE SENT (READ LOCATION)

SERV-VTAM*

DDF

3

161

VTAM request at serving site

• TYPE= type of request:
  • DEALLOCATE CONVERSATION
  • RECEIVE CONVERSATION
  • RECEIVE REQUEST MESSAGE
  • SEND RESPONSE MESSAGE

SET DEGREE

D

1

237

Set current degree

• DEGREE= OLD | NEW, where OLD is previous degree and NEW is attempted degree. Only valid values are 1 or ANY
• SUCCESS= Y for YES, N for NO

SET SQLID

SQL

1

055

SET SQLID

• STATUS= S (successful), F (failed), or X (successful with SYSADM AUTH)
• TO= new SQL ID
• FROM= old SQL ID

SORT*

D

2

095/096

Db2 internal sort

• REC(nnn)= number of records
• RECSZ(nn)= record size
• WKFILE(n)= number of work files

SORTWRK-GET

SCAN

3

026

Sort work file obtained

SORTWRK-INFO*

SCAN

3

028

Detailed sort information, including number of work files and sort phase start/end

• TYP= type of information
• WKFILE= number of work files created during input phase
• REC= number of records sorted into work files after input phase, or number of records on the partition work file, or number of records read into group at start of GROUPBY phase for multiple distinct sort
• WKREQ= number of work files requested during merge phase
• WKACQ= number of work files actually acquired during merge phase
• CURPASS= current merge pass
• PRTWKF= partitioning degree of parallelism
• DSRT= number of multiple distinct sorts
• DGRP= number of multiple distinct groups
• CSRT= current multiple distinct sort being processed

SORTWRK-RECS

SCAN

3

027

Number of sequential records in this sort work file

• T= one of the following types:
  • T merge pass end - sparse index in use
  • O merge pass end - in-memory data caching in use
  • W merge pass or input phase end - neither spare index nor in-memory data caching is use
• MWFS= size of in-memory data caching in KB (only if T=O)

SQL*

• FETCH
• SELECT

INSERT/UPDATE/

• DELETE
• DDL
• PREPARE
• OPEN CURSOR
• CLOSE CURSOR

SQL

1

059/058

060/058

061/058

062/058

064/058

065/058

066/058

SQL statement type followed by the SQL precompiler statement number (see 'SQL statement pop-up display' in Event-pop-up-displays)

For grouped SQL statements, the number of grouped events is shown in parentheses in front of the statement number. The statement number has a unique character appended to it to identify the program. The first program is assigned a blank. Additional programs for the same plan are assigned the characters A - Z; for example, FETCH 120A. The program name can be seen in the pop-up display (a series of periods (.) indicates an unidentifiable program name).

• RC(snnn)= SQL return code for the statement
• C= cursor name, if applicable
• D= data scan was done
• X= index scan was done
• W= work scan was done
• PS(nnnn)= pages scanned; includes pages scanned for referential integrity
• Object type= for DDL, the object type (TABLE) followed by the table name.

SQL-TEXT*

SQL

2

350

• Dynamic/static SQL BIND
• TYPE= DYNAMIC or static. Type of language when static:
  • ASM
  • C
  • COBOL
  • COBOL II
  • FORTRAN
  • PL/1
• TEXT= first 17 bytes of text of SQL statement. Full text is available in a pop-up display.
• If the SQL text is larger than 5000 bytes, multiple SQL-TEXT events are generated and the full text of the event is available in a pop-up display.

STORPROC*

SQL

2

380/381

Stored procedure CALL statement

• MODE= ENTRY (upon entry to the stored procedure) or EXIT (upon exit back to the caller of the stored procedure)
• PROC= stored procedure name

SYNC

D

2

088/089

Synchronization event as part of explicit or implicit commit processing

SYNC-WRITE*

IO

3

008/009

Synchronous write

• DB= database name
• TS= table space name
• BPnnnn = buffer pool in use

TBL-CONSTR*

SQL

2

305

Table check constraint activity

• DB= database name
• OB= table space or index space name

TEMPTABLE*

SQL

2

311

Temporary table information

• TABLE= temporary table name

TERM-THD

D

2

074

Terminate thread

TIMEOUT*

D

1

196

Lock timeout details

• DB= database name
• OB= table space or index space name
• NUMBER= number of lock holders/waiters

TLOBMW-BEGIN

SQL

3

351

Beginning of TCP/IP LOB materialization wait

Type of GET, CLOSE, or CLOSEALL

TLOBMW-END

SQL

3

352

End of TCP/IP LOB materialization wait

• I=Unique LOB number
• L=LOB length
• R/R= return and reason codes

TRIGGER*

SQL

2

325

Trigger activation

• MODE= ENTRY (upon the start of trigger activation) or EXIT (upon the end of trigger activation)
• TRIG= trigger name

TRUST-CTXT*

SQL

3

269

Establishment or reuse of a trusted context

• TYPE= establishment or reuse
• STAT= status
• TC= trusted context name

TRUST-CTXT-DDL*

SQL

3

270

Creation or alteration of a trusted context

• TYPE = creation or alteration
• SQL= beginning of statement

UDF*

SQL

2

324

User-defined function resolution information

• APPL= application name
• PLAN= plan name

UDF-STMT*

SQL

2

498/499

User Defined Function Detail

• REASON= reason for externalizing
  • MAX UNIQUE STMT IDS COLLECTED
  • ACCOUNTING INTERVAL ENDED
  • STORED PROCEDURE STARTED
  • STORED PROCEDURE ENDED
  • USER-DEFINED FUNCTION STARTED
  • USER-DEFINED FUNCTION ENDED

Utility name*

D

1

023/024

024/024

024/025

Utility name, such as RUNSTATS or RECOVER

• ID= sixteen-character utility ID
• PH= phase name

VTAM-EXIT*

DDFVTAM

3

164

VTAM exit entered

• TYPE= type of request:
  • ATTN|RPL with SUBTYPE= CNOS LOSS FMH5
  • TPEND with SUBTYPE= HALT NET HALT QUICK HALT CANCEL

VTAM-MACRO*

DDFVTAM

3

165

VTAM macro issued

• RC(xx) return code from macro; type of macro:OPENCLOSESETLOGONAPPCCMD......

WAIT-I/O*

IO

3

127/128

Page wait for I/O in progress

• DB= database name
• TS= table space name
• BPnnnn = buffer pool in use
• SYNC-RD= synchronous read I/O

WAIT-SERVER

D

2

170/171

Wait for Db2 server task, and records the beginning of a suspend for a synchronous (either related or unrelated) execution unit

• RMID= subcomponent name that corresponds to the Resource Manager the server task is calling. This field might be blank when displaying an old trace data set.