(This article is part of our Db2 Guide. Use the right-hand menu to navigate.)
Trace Type | Class | IFCID | Description |
ACCOUNTING | 1 | 3 | ALL ACCOUNTING |
106 | SYSTEM PARAMETERS IN EFFECT | ||
200 | UDF ENTRY/EXIT SIGNAL | ||
239 | OVERFLOW FOR PACKAGE ACCOUNTING | ||
2 | 200 | UDF ENTRY/EXIT SIGNAL | |
232 | DB2 THREAD ENTRY/EXIT SIGNAL | ||
3 | 6 | BEGINNING OF A READ 1/O OPERATION | |
7 | CC AFTER READ I/O OPERATION | ||
8 | BEGINNING OF SYNCHRONOUS WRITE I/O | ||
9 | CC OF SYNC OR ASYNC WRITE I/O | ||
32 | BEGIN OF WAIT FOR LOG MANAGER | ||
33 | END OF WAIT FOR LOG MANAGER | ||
44 | LOCK SUSPEND OR IDENTITY CALL IRLM | ||
45 | LOCK RESUME | ||
51 | SHARED LATCH RESUME. SERVICEABILITY | ||
52 | SHARED LATCH WAIT. SERVICEABILITY | ||
56 | ECXL. LATCH WAIT. SERVICEABILITY | ||
57 | EXCL. LATCH RESUME. SERVICEABILITY | ||
117 | BEGIN THREAD WAIT TIME FOR LOG I/O | ||
118 | END THREAD WAIT TIME FOR LOG I/O | ||
127 | AGENT READY TO SUSPEND PAGE WAIT | ||
128 | PAGE REQUESTOR RESUMED BY I/O UNIT | ||
170 | SUSPEND FOR SYNC EXEC. N UNIT SWITCH | ||
171 | RESUME AGENT WAITING DB2 SERV. TASK | ||
174 | BEGIN ARCHIVE LOG MODE (QUIESCE) | ||
175 | END ARCHIVE LOG MODE (QUIESCE) | ||
213 | BEGIN OF WAIT FOR CLAIM REQUEST | ||
214 | END OF WAIT FOR CLAIM REQUEST | ||
215 | BEGIN OF WAIT FOR DRAIN REQUEST | ||
216 | END OF WAIT FOR DRAIN REQUEST | ||
226 | BEGIN OF SUSPEND FOR PAGE LATCH | ||
227 | END OF SUSPEND FOR PAGE LATCH | ||
242 | BEGIN WAIT FOR SCHED. STORED PROC. | ||
243 | END WAIT FOR SCHED. STORED PROC. | ||
313 | MESSAGES FOR LONG-RUNNING URS. | ||
382 | SUSPEND OPERATIOINS FOR PARALLEL TASK SYNC | ||
383 | RESUME OPERATIOINS AFTER PARALLEL TASK SYNC | ||
4 | 151 | USER-DEFINED ACCOUNTING TRACE | |
5 | 187 | ENTRY TO AND EXIT FROM IFI | |
7 | 200 | DB2 THREAD ENTRY/EXIT SIGNAL | |
232 | FOR PACKAGE/DBRM LEVEL ACCOUNTING | ||
240 | EVENT SIGNAL FOR PACKAGE ACCOUNTING | ||
8 | 6 | BEGINNING OF A READ I/O OPERATION | |
7 | CC AFTER READ I/O OPERATION | ||
8 | BEGINNING OF SYNCHRONOUS WRITE I/O | ||
9 | CC OF SYNC OR ASYNC WRITE I/O | ||
32 | BEGIN OF WAIT FOR LOG MANAGER | ||
33 | END OF WAIT FOR LOG MANAGER | ||
44 | LOCK SUSPEND OR IDENTITY CALL IRLM | ||
45 | LOCK RESUME | ||
51 | SHARED LATCH RESUME. SERVICEABILITY | ||
52 | SHARED LATCH WAIT. SERVICEABILITY | ||
56 | EXCL. LATCH WAIT. SERVICEABILITY | ||
57 | EXCL. LATCH RESUME. SERVICEABILITY | ||
117 | BEGIN THREAD WAIT TIME FOR LOG I/O | ||
118 | END THREAD WAIT TIME FOR LOG I/O | ||
127 | AGENT READY TO SUSPEND PAGE WAIT | ||
128 | PAGE REQUESTOR RESUMED BY I/O UNIT | ||
170 | SUSPEND FOR SYNC EXEC.N UNIT SWITCH | ||
171 | RESUME AGENT WAITING DB2 SERV. TASK | ||
174 | BEGIN ARCHIVE LOG MODE (QUIESCE) | ||
175 | END ARCHIVE LOG MODE (QUIESCE) | ||
213 | BEGIN OF WAIT FOR CLAIM REQUEST | ||
214 | END OF WAIT FOR CLAIM REQUEST | ||
215 | BEGIN OF WAIT FOR DRAIN REQUEST | ||
216 | END OF WAIT FOR DRAIN REQUEST | ||
226 | BEGIN OF SUSPEND FOR PAGE LATCH | ||
227 | END OF SUSPEND FOR PAGE LATCH | ||
241 | BEGIN/END SUSPENSION OF PACK/DBRM | ||
242 | BEGIN WAIT FOR SCHED. STORED PROC. | ||
243 | END WAIT FOR SCHED. STORED PROC. | ||
382 | SUSPEND OPERATIOINS FOR PARALLEL TASK SYNC | ||
383 | RESUME OPERATIOINS AFTER PARALLEL TASK SYNC | ||
10 | 339 | PACKAGE DETAIL | |
AUDIT | 1 | 140 | AUTHORIZATION FAILURES |
2 | 141 | EXPLICIT GRANT AND REVOKES | |
3 | 142 | CREATES, ALTERS, DROPS – AUDIT | |
4 | 143 | FIRST ATTEMPTED WRITE AUDITED OBJ. | |
5 | 144 | FIRST ATTEMPTED READ AUDITED OBJ. | |
6 | 145 | AUDIT LOG RECORD OF SOME SQL STMTS | |
7 | 55 | ISSUANCE OF SET CURRENT SQLID | |
83 | END IDENTIFY REQUEST | ||
87 | ENDING OF SIGNON REQUEST | ||
169 | DISTRIBUTED AUTHID TRANSLATION | ||
312 | DCE SECURITY | ||
8 | 23 | UTILITY START INFORMATION | |
24 | UTILITY OBJECT OR PHASE CHANGE | ||
25 | UTILITY END INFORMATION | ||
219 | LISTDEF DATA SET INFORMATION | ||
220 | UTILITY OUTPUT DATA SET INFORMATION | ||
9 | 146 | USER-DEFINED AUDIT TRACE | |
11 | 361 | AUDIT ADMINISTRATIVE AUTHORITIES | |
MONITOR | 1 | 1 | SYSTEM SERVICES |
2 | DATABASE SERVICES | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
124 | CURRENT SQL STATEMENT | ||
129 | VSAM CI’S – DB2 RECOVER LOG | ||
147 | SUMMARY THREAD STATUS RECORD | ||
148 | DETAILED THREAD STATUS RECORD | ||
149 | LOCK INFORMATION FOR A RESOURCE | ||
150 | LOCK INFORMATION FOR AN AGENT IFCID | ||
202 | SYSTEM PARAMETERS | ||
230 | DATA SHARING GLOBAL STATISTICS | ||
254 | GROUP BUFFER POOL USAGE | ||
306 | LOG RECORD RETRIEVAL | ||
316 | PREPARED STMT. CACHE STATISTICS | ||
317 | PREPARED STMT. CACHE STMT. TEXT | ||
2 | 232 | DB2 THREAD ENTRY EXIT SIGNAL | |
3 | 6 | BEGINNING OF A READ I/O OPERATION | |
7 | CC AFTER READ I/O OPERATION | ||
8 | BEGINNING OF A SYNCHRONOUS WRITE I/O | ||
9 | CC OF A SYN OR ASYNC WRITE I/O | ||
32 | BEGIN OF WAIT FOR LOG MANAGER | ||
33 | END OF WAIT FOR LOG MANAGER | ||
44 | LOCK SUSPEND OR IDENTIFY CALL IRLM | ||
45 | LOCK RESUME | ||
51 | SHARED LATCH RESUME. SERVICEABILITY | ||
52 | SHARED LATCH WAIT. SERVICEABILITY | ||
56 | EXCL. LATCH WAIT. SERVICEABILITY | ||
57 | EXCL. LATCH RESUME. SERVICEABILITY | ||
117 | BEGIN THREAD WAIT TIME FOR LOG I/O | ||
118 | END THREAD WAIT TIMR FOR LOG I/O | ||
127 | AGENT READY TO SUSPEND PAGE WAIT | ||
128 | PAGE REQUESTOR RESUMED BY I/O UNIT | ||
170 | SUSPEND FOR SYNC EXEC. UNIT SWITCH | ||
171 | RESUME AGENT WAITING DB2 SERV. TSK | ||
174 | BEGIN ARCHIVE LOG MODE (QUIESCE) | ||
175 | END ARCHIVE LOG MODE (QUIESCE) | ||
213 | BEGIN OF WAIT FOR CLAIM REQUEST | ||
214 | END OF WAIT FOR CLAIM REQUEST | ||
215 | BEGIN OF WAIT FOR DRAIN REQUEST | ||
216 | END OF WAIT FOR DRAIN REQUEST | ||
226 | BEGIN OF SUSPEND FOR PAGE LATCH | ||
227 | END OF SUSPEND FOR PAGE LATCH | ||
242 | BEGIN WAIT FOR SCHED. STORED PROC. | ||
243 | END WAIT FOR SCHED. STORED PROC. | ||
382 | SUSPEND OPERATIOINS FOR PARALLEL TASK SYNC | ||
383 | RESUME OPERATIOINS AFTER PARALLEL TASK SYNC | ||
4 | 155 | USER-DEFINED MONITOR TRACE | |
5 | 187 | ENTRY OR EXIT TO IFI | |
6 | 185 | DATA CAPTURE INFORMATION | |
7 | 232 | DB2 THREAD ENTRY/EXIT SIGNAL | |
232 | FOR PACKAGE/DBRM-LEVEL ACCOUNTING | ||
240 | EVENT SIGNAL FOR PACKAGE ACCOUNTING | ||
8 | 6 | BEGINNING OF A READ I/O OPERATION | |
7 | CC AFTER READ I/O OPERATION | ||
8 | BEGINNING OF SYNCHRONOUS WRITE I/O | ||
9 | CC OF SYN OR ASYNC WRITE I/O | ||
32 | BEGIN OF WAIT FOR LOG MANAGER | ||
33 | END OF WAIT FOR LOG MANAGER | ||
44 | LOCK SUSPEND OR IDENTIFY CALL IRLM | ||
45 | LOCK RESUME | ||
51 | SHARED LATCH RESUME. SERVICEABILITY | ||
52 | SHARED LATCH WAIT. SERVICEABILITY | ||
56 | EXCL. LATCH WAIT. SERVICEABILITY | ||
57 | EXCL. LATCH RESUME. SERVICEABILITY | ||
117 | BEGIN THREAD WAIT TIME FOR LOG I/O | ||
118 | END THREAD WAIT TIME FOR LOG I/O | ||
127 | AGENT READY TO SUSPEND PAGE WAIT | ||
128 | PAGE REQUESTOR RESUMED BY I/O UNIT | ||
170 | SUSPEND FOR SYNC EXEC. UNIT SWITCH | ||
171 | RESUME AGENT WAITING DB2 SERV.TSK | ||
174 | BEGIN ARCHIVE LOG MODE (QUIESCE) | ||
175 | END ARCHIVE LOG MODE (QUIESCE) | ||
213 | BEGIN OF WAIT FOR CLAIM REQUEST | ||
214 | END OF WAIT FOR CLAIM REQUEST | ||
215 | BEGIN OF WAIT FOR DRAIN REQUEST | ||
216 | END OF WAIT FOR DRAIN REQUEST | ||
226 | BEGIN OF SUSPEND FOR PAGE LATCH | ||
227 | END OF SUSPEND FOR PAGE LATCH | ||
241 | BEGIN/END SUSPENSION OF PACK/DBRM | ||
242 | BEGIN WAIT FOR SCHED. STORED PROC. | ||
243 | END WAIT FOR SCHED. STORED PROC. | ||
382 | SUSPEND OPERATIOINS FOR PARALLEL TASK SYNC | ||
383 | RESUME OPERATIOINS AFTER PARALLEL TASK SYNC | ||
9 | 124 | ENABLE STATEMENT LEVEL ACCOUNTING | |
10 | 339 | PACKAGE DETAIL | |
29 | 316 | CACHED STATEMENT STATISTICS | |
318 | CACHED STATEMENT STATISTICS | ||
400 | STATIC SQL IN EDM POOK STATISTICS | ||
401 | STATIC SQL IN EDM POOK STATISTICS | ||
PERFORMANCE | 1 | 1 | SYSTEM SERVICES |
2 | DATABASE SERVICES | ||
31 | EDM POOL FULL CONDITION | ||
42 | A CHECKPOINT STARTED | ||
43 | A CHECKPOINT ENDED | ||
76 | BEGINNING OF END OF MEMORY REQUEST | ||
77 | ENDING OF AN END OF MEMORY REQUEST | ||
78 | BEGINNING OF AN END OF TASK REQUEST | ||
79 | ENDING OF AN END OF TASK REQUEST | ||
102 | DETECTION OF SHORT ON STORAGE | ||
103 | SETTING OFF OF SHORT ON STORAGE | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
153 | USER-DEFINED EXCEPT-CONDITION TRACE | ||
2 | 3 | ALL ACCOUNTING | |
68 | BEGINNING OF A ROLLBACK REQUEST | ||
69 | ENDING OF A ROLLBACK REQUEST | ||
70 | BEGIN COMMIT PHASE 2 REQUEST | ||
71 | END COMMIT PHASE 2 REQUEST | ||
72 | BEGINNING OF CREATE THREAD REQUEST | ||
73 | ENDING OF A CREATE THREAD REQUEST | ||
74 | BEGINNING OF A TERM. THREAD REQUEST | ||
75 | ENDING OF A TERM. THREAD REQUEST | ||
80 | BEGINNING OF AN ESTABLISH EXIT REQ. | ||
81 | ENDING OF AN ESTABLISH EXIT REQUEST | ||
82 | BEGIN IDENTIFY REQUEST | ||
83 | END INDENTIFY REQUEST | ||
84 | BEGIN PHASE 1 COMMIT REQUEST | ||
85 | END PHASE 1 COMMIT REQUEST | ||
86 | BEGINNING OF SIGNON REQUEST | ||
87 | ENDING OF SIGNON REQUEST | ||
88 | BEGINNING OF A SYNC REQUEST | ||
89 | ENDING OF A SYNC REQUEST | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
174 | BEGIN ARCHIVE LOG MODE (QUIESCE) | ||
175 | END ARCHIVE LOG MODE (QUIESCE) | ||
3 | 22 | MINIPLANS GENERATED | |
53 | END OF DESCR., COMMIT, RLBCK OR ERR | ||
55 | ISSUANCE OF SET CURRENT SQLID | ||
58 | END OF SQL STATEMENT EXECUTION | ||
59 | START OF FETCH SQL STATEMENT EXEC. | ||
60 | START OF SELECT SQL STATEMENT EXEC. | ||
61 | START OF INSERT, UPDATE, DELETE SQL | ||
62 | START OD DDL STATEMENT EXECUTION | ||
63 | SQL STATEMENT TO BE PARSED | ||
64 | START PREPARE SQL STATEMENT EXEC. | ||
65 | START OPEN CURSOR STATIC/DYN SQL | ||
66 | START CLOSE CURSOR STATIC/DYN SQL | ||
92 | START AN ACCESS METHOD SERVICES | ||
95 | SORT STARTED | ||
96 | SORT ENDED | ||
97 | ACCESS METHOD SERVICES CMD COMPL. | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
112 | ATTRIBUTES PLAN AFTER THREAD ALLOC | ||
177 | SUCCESSFUL PACKAGE ALLOCATION | ||
233 | START/END CALL TO USER ROUTINE | ||
237 | SET CURRENT DEGREE INFORMATION | ||
272 | ASSOCIATE LOCATORS INFORMATION | ||
273 | ALLOCATE LOCATORS INFORMATION | ||
324 | FUNCTION RESOLUTION INFORMATION | ||
325 | START/END TRIGGER ACTIVATION | ||
350 | COMPLETE SQL STATEMENT | ||
4 | 6 | BEGINNNG OF A READ I/O OPERATION | |
7 | COMPLETION CODE AFTER READ I/O | ||
8 | BEGINNING OF SYNCHRONOUS WRITE I/O | ||
9 | CC OF SYN OR ASYNC WRITE I/O | ||
10 | BEGINNING OF ASYNC WRITE I/O | ||
29 | START EDM I/O REQ. LOAD DBD OR CT | ||
30 | END OF EDM I/O REQUEST | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
127 | AGENT READY TO SUSPEND PAGE WAIT | ||
128 | PAGE REQUESTOR RESUMED BY I/O UNIT | ||
226 | BEGIN OF SUSPEND FOR PAGE LATCH | ||
227 | END OF SUSPEND FOR PAGE LATCH | ||
5 | 32 | BEGIN OF WAIT FOR LOG MANAGER | |
33 | END OF WAIT FOR LOG MANAGER | ||
34 | LOG MANAGER WAIT FOR READ I/O BEGIN | ||
35 | LOG MANAGER WAIT FOR READ I/0 END | ||
36 | LOG MANAGER WAIT FOR NON-I/O BEGIN | ||
37 | LOG MANAGER WAIT FOR NON-I/O END | ||
38 | LOG MGR WAIT ACT. LOG WRITE BEGIN | ||
39 | LOG MGR WAIT ACT. LOG WRITE I/O END | ||
40 | LOG MANAGER ARCHIVE WRITE I/O BEGIN | ||
41 | LOG MANAGER ARCHIVE WRITE I/O END | ||
104 | LOG DATA SET MAPPING | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
114 | START ARCHIVE READ I/O WAIT | ||
115 | END READ ARCHIVE I/O WAIT ON DASD | ||
116 | END READ ARCHIVE I/O WAIT ON TAPE | ||
117 | BEGIN ARCHIVE READ | ||
118 | END ARCHIVE READ | ||
119 | BSDS WRITE I/O BEGINNING | ||
120 | BSDS WRITE I/O END | ||
228 | START ARCHIVE ALLOCATION WAIT | ||
229 | END ARCHIVE ALLOCATION WAIT | ||
6 | 20 | LOCKING SUMMARY | |
44 | LOCK SUSPEND OR AN ID. CALL TO IRLM | ||
45 | LOCK RESUME | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
172 | UNITS OF WORK INVOLVED IN DEADLOCK | ||
196 | LOCK TIMEOUT DETAILS | ||
213 | BEGINNING OF WAIT FOR DRAIN LOCK | ||
214 | END OF WAIT FOR DRAIN LOCK | ||
218 | SUMMARY OF LOCK AVOIDANCE TECHNIQUE | ||
337 | LOCK ESCALATION OCCURED | ||
7 | 21 | DETAIL LOCK REQ FROM IRLM | |
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
199 | BUFFER POOL DATA SET STATISTICS | ||
223 | DETAIL OF LOCK AVOIDANCE TECHNIQUE | ||
8 | 13 | INPUT TO HASH SCAN | |
14 | END OF HASH SCAN | ||
15 | INPUT MATCH./NON-MATCH INDEX SCAN | ||
16 | INPUT TO THE FIRST INSERT | ||
17 | INPUT TO SEQUENTIAL SCAN | ||
18 | END INDEX SCAN, INSERT, SEQ. SCAN | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
125 | RID LIST PROCESSING USAGE | ||
221 | PARALLEL DEGREE FOR PARALLEL GROUP | ||
222 | PARALLEL GROUP ELAPSED TIME | ||
231 | PARALLEL GROUP COMPLETION | ||
305 | TABLE CHECK CONSTRAINTS | ||
311 | TEMPORARY TABLES | ||
9 | 26 | WORK FILE OBTAINED FOR SORT | |
27 | NUMBER OF ORDERED RECORDS SORT RUN | ||
28 | DETAILED SORT INFORMATION | ||
95 | SORT STARTED | ||
96 | SORT ENDED | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
10 | 23 | UTILITY START INFORMATION | |
24 | UTILITY OBJECT OR PHASE CHANGE | ||
25 | UTILITY END INFORMATION | ||
90 | COMMAND TEXT OF ENTERED DB2 COMMAND | ||
91 | COMPLETION STATUS OF A DB2 COMMAND | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
108 | BEGINNING OF FREE PLAN | ||
109 | END OF BIND/REBIND | ||
110 | BEGINNING OF FREE PLAN | ||
111 | END OF FREE PLAN | ||
201 | STATUS BEF/AFT ALTER BUFFERPOOL | ||
256 | ATTRIBUTES BEF/AFT ALTER BUFFERPOOL | ||
11 | 46 | AGENT BEGIN EXEC. UNIT SWITCH | |
47 | NEW SRB EXECUTION UNIT STARTED | ||
48 | NEW SRB EXECUTION UNIT COMPLETED | ||
49 | BEGIN NEW TCB | ||
50 | END NEW TCB | ||
51 | SHARED LATCH RESUME | ||
52 | SHARED LATCH WAIT | ||
56 | EXCLUSIVE LATCH WAIT | ||
57 | EXCLUSIVE LATCH RESUME | ||
93 | SUSPEND WAS CALLED | ||
94 | EVENT RESUMED | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
113 | ATTIRBUTES PLAN AFTER AGENT ALLOC. | ||
12 | 98 | BEGIN GETMAIN/FREEMAIN (NONPOOL) | |
99 | END GETMAIN/FREEMAIN (NONPOOL) | ||
100 | BEGIN GETMAIN/FREEMAIN (POOL) | ||
101 | END GETMAIN/FREEMAIN (POOL) | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
13 | 11 | RESULTS OF A VALIDATION EXIT CALL | |
12 | RESULTS OF EDIT EXIT CALL ENCODE RECRD | ||
19 | RESULTS OF EDIT EXIT CALL DECODE A ROW | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
107 | DATA SET OPEN/CLOSE INFORMATION | ||
14 | 67 | START OF ACCOUNTING COLLECTION | |
106 | SYSTEM PARAMETERS IN EFFECT | ||
121 | ENTRY ALLOCATING DB2 CONNECTION | ||
122 | EXIT ALLOCATING DB2 CONNECTION | ||
15 | 154 | USER-DEFINED ROUND COND. PERF. | |
16 | 157 | DRDS INTER. WITH RDS RDI CALL TYPES | |
158 | DRDS INTER. WITH CONVERSATION MGMR | ||
159 | DRDS REQUESTING LOCATION DATA | ||
160 | REQUESTING AGENT DATA | ||
161 | SERVING AGENT DATA | ||
162 | DISTRIB TRANS. MGR REQ. AGENT DATA | ||
163 | DISTRIB TRANS. MGR RESP. AGENT DATA | ||
167 | CONVERSATION ALLOC. REQUEST QUEUED | ||
183 | DRDS RDS/SCC INTERFACE DATA | ||
17 | 211 | INFORMATION ABOUT CLAIMS | |
212 | INFORMATION ABOUT DRAINS | ||
213 | BEGINNING OF WAIT FOR DRAIN LOCK | ||
214 | END OF WAIT FOR DRAIN LOCK | ||
215 | BEGIN OF WAIT OF CLAIM COUNT TO 10 | ||
216 | END OF CLAIM COUNT TO GO TO 0 | ||
20 | 249 | EDM POOL DBD INVALIDATION | |
250 | GROUP BUFFER POOL CON/DISCON | ||
251 | P-LOCK OPERATIONS | ||
256 | ALTER BUFFERPOOL COMMAND | ||
257 | DETAILS OF IRLM NOTIFY REQUEST | ||
261 | GROUP BUFFERPOOL CHECKPOINT | ||
262 | GBPOOLT CASTOUT THRESHOLD PROCESSING | ||
267 | BEGIN CF STRUCT REBLD/EXPAND/CONTR | ||
268 | END CF STRUCTURE REBLD/EXPLAND/CONTR | ||
21 | 255 | BUFFER REFRESH DUE TO XI | |
259 | P-LOCK REQUEST/NEGOTIATION REQUEST | ||
263 | PAGE SET AND PARTITION CASTOUT DATA | ||
314 | AUTHORIZATION EXIT PARAMETERS | ||
327 | LANGUAGE ENVIRONMENT RUN-TIME INFO | ||
22 | 314 | AUTHORIZATION EXIT PARAMETERS | |
STATISTICS | 1 | 1 | SYSTEM SERVICES |
2 | DATABASE SERVICES | ||
105 | INTERNAL DBID OBID TO DB/TS | ||
106 | SYSTEM PARAMETERS IN EFFECT | ||
202 | BUFFER POOL ATTRIBUTES | ||
225 | SYSTEM STORAGE STATISTICS FOR DBM1 | ||
2 | 152 | USER-DEFINED STATISTICS TRACE | |
3 | 172 | UNITS OF WORK INVOLVED IN DEADLOCK | |
196 | LOCK TIMEOUT DETAILS | ||
250 | CONNECT/DISCONNECT FROM GBP | ||
258 | DATA SET EXTEND INFORMATION | ||
330 | ACTIVE LOG SHORTAGE | ||
337 | LOCK ESCALATION OCCURRED | ||
4 | 191 | DATA CAPTURE FOR DDIS ERRORS | |
192 | DDM LEVEL 6A HEADER ERRORS | ||
193 | UOW DISPOSITION/SQLCODE MISMATCH | ||
194 | INVALID SNA FMH-5 RECEIVED | ||
195 | FIRST FAILURE DATA CAPTURE FOR DRDS | ||
203 | HEURISTIC DECISION OCCURRED | ||
204 | PARTNER COLD START DETECTED | ||
205 | INCORRECT LOGNAME/SYNC. PARMS | ||
206 | SNA COMPARE STATES PROTOCOL ERROR | ||
207 | HEURISTICDAMAGE OCCURRED | ||
208 | SNA SYNC POINT PROTOCOL ERROR | ||
209 | SYNC POINT COMMUNICATION FAILURE | ||
210 | LOG NAME CHANGED ON WARM START | ||
235 | CONDITIONAL RESTART DATA LOSS | ||
236 | EXCHANGE LOG NAMES PROTOCOL ERROR | ||
267 | START OF CF STRUCTURE REBUILD | ||
268 | END OF CF STRUCTURE REBUILD | ||
5 | 230 | DATA SHARING GLOBAL STATISTICS | |
6 | 225 | STORAGE USAGE DETAILS | |
7 | 326 | WLM DELAY MONITOR SUPPORT | |
8 | 199 | DATA SET I/O STATISTICS |
Disclaimer: This Db2® 12 for z/OS Reference Guide was developed to help users in their daily activities in administrating and programming in Db2 for z/OS. There are no guarantees expressed or implied with the contents in this guide. We want to provide a quality and useful reference for users. Please notify us of any mistakes or errors in this reference guide at [email protected]. Db2 is a registered trademark of the IBM Corporation.