IFCID changes in Db2 11
Db2 11 introduces IFCID changes.
This information briefly describes the new IFCIDs and the changes to the existing IFCIDs for each new function. For a detailed description of the fields in each IFCID record, refer to the mapping macros data set library DSN1110.SDSNMACS.
New trace records
The following tables gives an overview of new IFCIDs. Serviceability trace records are not included.
| IFCID | Trace | Class |
Mapping macro
|
Description |
|---|---|---|---|---|
| 0377 | None | None | DSNDQW05 | Records information about indexes for which pseudo-deleted index entries are automatically cleaned up. |
| 0382 | Accounting, Monitor | 3, 8 | DSNDQW05 | Records suspend operations for parallel task synchronization. |
| 0383 | Accounting, Monitor | 3, 8 | DSNDQW05 | Records resume operations after parallel task synchronization. |
Changes to selected trace records
The following table gives an overview of changes to specific IFCIDs. Changes to IFCID 0106, the system parameters record, are not included.
| Enhancement | IFCID | Description of changes |
|---|---|---|
| Array support | 0002, 0225 | Fields are added to record information about storage use by arrays. |
| Autonomous transactions | 0003, 0239 | Fields are added to record information about autonomous transactions, and on their effect on parallel groups. |
| Application compatibility | 0366 | Field values are added to record incompatibilities between Db2 11 and previous versions. |
| Castout enhancements | 0230, 0256 | Fields are added to record class castout queue threshold values, which are based on the number of pages. |
| Hybrid Transactional Analytical Processing support for accelerated queries (APAR PI90239) | 0002 | Fields are added to monitor the effect of Hybrid Transactional Analytical Processing. |
| IBM zHyperLink exploitation for database synchronous read I/O (APAR PH01123) | 0002 | Fields are added to record:
|
| 0003, 0148 | Fields are added to record:
|
|
| 0003, 0148, 0239 | Fields are added to record:
|
|
| 0006 | A flag is added to indicate whether a synchronous read I/O request occurred with or without IBM zHyperLink processing. | |
| 0007 | A flag is added to indicate whether a synchronous read I/O request with IBM zHyperLink processing was successful. | |
| 0199 | Fields are added to record the average and maximum delay and total number of pages read with synchronous read I/O and IBM zHyperLink processing. | |
| Larger RBA and LRSN support | 0001, 0032, 0034, 0043, 0114, 0119, 0143, 0144, 0185, 0188, 0203, 0204, 0206, 0207, 0208, 0209, 0235, 0261, 0306, 0313, 0335 | Fields that contain RBAs and LRSNs are expanded from 6 or 8 bytes to 10 bytes. Fields other than QW0204UR are moved to avoid changes in other offsets. Field QW0204UR is expanded but not moved. Therefore, the offsets of all fields in IFCID 0204 that follow it are changed. |
| Parallelism performance enhancements | 0002, 0003, 0316, 0401 | Fields are added to track the effect of changes to the degree of parallelism after parallel system negotiation that occurs because of resource constraints. |
| Statement-level monitoring for accelerated Hybrid Transactional and Analytical Processing (HTAP) support (APAR PH00574) | 0003, 0316 | Fields are added to record:
|
| Temporal support | 0053, 0058, 0060, 0061, 0065, 0316, 0401 | Fields are added to indicate the impacts of the CURRENT TEMPORAL BUSINESS_TIME special register, the CURRENT TEMPORAL SYSTEM_TIME special register, and the SYSIBMADM.GET_ARCHIVE built-in global variable. |
| Miscellaneous changes | 0002 | Fields are added to record:
|
| 0002, 0003 | Fields are added to record:
|
|
| 0003 |
|
|
| 0003, 0148, 0239 | Sysplex query parallelism is no longer supported. Fields that are related to Sysplex query parallelism are not populated. | |
| 0127, 0128 | Fields are added to record the time spent waiting for buffer manager force write I/O. | |
| 0148 | A field is added to record an additional DDF enclave. | |
| 0201 | Fields are added to record the virtual pool size, minimum pool size, maximum pool size, and frame size before and after the ALTER BUFFERPOOL command. | |
| 0217, 0225 | Fields are added to record IRLM private storage limits. | |
| 0225 | The following changes are made:
|
|
| 0239 |
|
|
| 0313 | New fields are added to record:
|