| ATRAC collection category | | | Description and detail information |
|---|
| | | | |
| | | | ALLOCATE CURSOR statement - STPROC=Stored procedure name
|
| | | | ASSOCIATE LOCATORS statement - STPROC=Stored procedure name
|
| | | | Package name and cursor name |
| | | | 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
|
| | | | 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
|
| | | | - DROP SYNONYM
- DROPIN
- EXECUTE
|
| | | | 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
|
| | | | Buffer send or receive - LU= logical unit name
- SIZE(999) = size of buffer in bytes
|
| | | | Bind/rebind a plan or package - PLAN= plan name
- PACKAGE= package name
- RC(nnn) = return code
|
| | | | 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 request - DB= database name
- OB= table space or index space name
- PART= partition number
|
| | | | Wait for pending claims to go to zero - DB= database name
- OB= table space or index space name
- PART= partition number
|
| | | | Close table space data set - TS= table space name
- DB= database name
|
| | | | 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)
|
| | | | Conversation request queued - LU= logical unit name
- MODE= VTAM mode name from communications database
|
| | | | Conversation request - TYPE= type of request:
- LOC= sixteen-character location name.
|
| | | | |
| | | | Deadlock details - RESOURCES INVOLVED= number of locked resources in the deadlock
|
| | | | Distributed SQL statement |
| | | | Drain request - DB= database name
- OB= table space or index space name
- PART= partition number
|
| | | | Wait for drain request - DB= database name
- OB= table space or index space name
- PART= partition number
|
| | | | 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 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 DESCRIBE, COMMIT, ROLLBACK, or SQL statement error (see 'SQL statement pop-up display' in Event-pop-up-displays |
| | | | 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 a plan or package - PACKAGE= package name
- PLAN= plan name
- RC(nnn)= return code
|
| | | | 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 - TS= table space name
- DB= database name
|
| | | | 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
|
| | | | Incrementally Rebound Queries - PLAN= plan name
- PKG= package name
|
| | | | Index Split - DB= database name
- OB= table space or index space name
|
| | | | 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
|
| | | | |
| | | | Invalid SELECT procedure - COL=nnn Total columns bypassed, followed by plan name, package ID, or collection ID
|
| | | | |
LOCK*UNLOCK*LOCK CHG*LOCK QRY* | | | | Lock request WarningImportant If there is no OB or DB information, the IRLM request token is displayed. |
| | | | Database, table space, and lock state - IS = intent shared
- IX = intent exclusive
- SH = shared
- UP = update
- SX = shared intent exclusive
- EX = exclusive
|
| | | | 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 suspension WarningImportant If there is no OB or DB information, the IRLM request token is displayed. |
| | | | Detail of successful COMMIT-LSNs (lock avoidance) - OB= table space or index space name
- DB= database name
|
| | | | Maxtemps Limit - PKG= package name
- USED= current workfile storage used
|
| | | | 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 table space data set - TS= table space name
- DB= database name
|
| | | | 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.
|
| | | | Page latch wait - OB= table space or index space name
- DB= database name
- POOL= buffer pool ID
|
| | | | |
| | | | |
| | | | 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 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
|
| | | | 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
|
| | | | Degree of parallel I/O processing for group - PLANNED= degree planned at run time
- ACTUAL= actual parallel I/O degree
- GROUP#= parallel group number
|
| | | | Elapsed time of parallel group - ELAP= elapsed time of parallel group pipe
- ROWS= number of rows processed
|
| | | | Individual task information for a parallel group - ELAP= elapsed time of parallel group
- GROUP= parallel group number
|
| | | | Index Insert with Parallelism - DB= database name
- OB= table space or index space name
|
| | | | Straw Model for Workload Distribution - PKGCOLL= package collection ID
- PGM= program name
|
| | | | |
| | | | 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
|
| | | | 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
|
| | | | DRDS request at requesting site - TYPE= type of request:
- AUXCALL
- DSCRBCAL
- OPENCALL
- SETUPCAL
- LOC= sixteen-character location name
|
| | | | 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
|
| | | | 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
|
| | | | 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
|
| | | | |
| | | | 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.
|
| | | | RDS request at serving site - TYPE= type of request:
- AUXCALL
- SETUPCAL
- DSCRBCAL
- OPENCALL
|
| | | | 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)
|
| | | | VTAM request at serving site - TYPE= type of request:
- DEALLOCATE CONVERSATION
- RECEIVE CONVERSATION
- RECEIVE REQUEST MESSAGE
- SEND RESPONSE MESSAGE
|
| | | | 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 - STATUS= S (successful), F (failed), or X (successful with SYSADM AUTH)
- TO= new SQL ID
- FROM= old SQL ID
|
| | | | Db2 internal sort - REC(nnn)= number of records
- RECSZ(nn)= record size
- WKFILE(n)= number of work files
|
| | | | |
| | | | 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
|
| | | | 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* INSERT/UPDATE/ - DELETE
- DDL
- PREPARE
- OPEN CURSOR
- CLOSE CURSOR
| | | 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.
|
| | | | - 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.
|
| | | | 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
|
| | | | Synchronization event as part of explicit or implicit commit processing |
| | | | Synchronous write - DB= database name
- TS= table space name
- BPnnnn = buffer pool in use
|
| | | | Table check constraint activity - DB= database name
- OB= table space or index space name
|
| | | | Temporary table information - TABLE= temporary table name
|
| | | | |
| | | | Lock timeout details - DB= database name
- OB= table space or index space name
- NUMBER= number of lock holders/waiters
|
| | | | Beginning of TCP/IP LOB materialization wait Type of GET, CLOSE, or CLOSEALL |
| | | | End of TCP/IP LOB materialization wait - I=Unique LOB number
- L=LOB length
- R/R= return and reason codes
|
| | | | Trigger activation - MODE= ENTRY (upon the start of trigger activation) or EXIT (upon the end of trigger activation)
- TRIG= trigger name
|
| | | | Establishment or reuse of a trusted context - TYPE= establishment or reuse
- STAT= status
- TC= trusted context name
|
| | | | Creation or alteration of a trusted context - TYPE = creation or alteration
- SQL= beginning of statement
|
| | | | User-defined function resolution information - APPL= application name
- PLAN= plan name
|
| | | | 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, such as RUNSTATS or RECOVER - ID= sixteen-character utility ID
- PH= phase name
|
| | | | 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 issued - RC(xx) return code from macro; type of macro:OPENCLOSESETLOGONAPPCCMD......
|
| | | | 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 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.
|
