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