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

Begin program-specific programming interface information.

The following tables gives an overview of new IFCIDs. Serviceability trace records are not included.

Table 1. New IFCIDs
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.
End program-specific programming interface information.

Changes to selected trace records

Begin program-specific programming interface information.

The following table gives an overview of changes to specific IFCIDs. Changes to IFCID 0106, the system parameters record, are not included.

Table 2. Changed IFCIDs
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:
  • The number of successful synchronous read I/O operations that were performed using IBM zHyperLink processing.
  • The number of synchronous read I/O operations that resulted in disk cache hits, and did not use IBM zHyperLink processing.
  0003, 0148 Fields are added to record:
  • Wait time for synchronous read I/O operations that resulted in disk cache hits
  • The number of synchronous read I/O operations that resulted in disk cache hits.
  0003, 0148, 0239 Fields are added to record:
  • The number of synchronous read I/O operations that used IBM zHyperlink processing.
  • The number of synchronous read I/O operations that resulted in disk cache hits.
  • The amount of CPU time for successful synchronous read I/O operations that used IBM zHyperlink processing.
  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:
  • The amount of time in milliseconds that statements waited for execution on an accelerator because the statements needed changes that were not yet applied to a referenced table.
  • The number of times that statement execution did not complete because changes were not applied to a referenced table before the delay protocol time period expired.
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:
  • The amount of storage that is allocated to shareable, static SQL statements.
  • The number of pages that are written to disk through group-buffer-pool write-around protocol
  0002, 0003 Fields are added to record:
  • Additional IRLM system information
  0003
  • Fields are added to record the wait time and number of waits for parallel queries to synchronize.
  • Existing fields that record accumulated wait time for write I/O that is done under another thread and the number of wait trace events that were processed for write I/O under another thread now include time that is consumed by DFSMS Media Manager calls when buffers are written to disk.
  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:
  • Fields are added to record the common storage that is used by log manager buffers and control structures.
  • Data is no longer recorded for the number of log manager write buffer frames in auxiliary storage.
  • Fields that record shareable storage use for SQL statements are moved and expanded to 8 bytes. The corresponding 4-byte fields are no longer used.
  0239
  • Package detail information is rolled up and associated with a rollup QPAC record if an accounting class 10 trace or a monitor class 10 trace is enabled.
  • Fields are added to record the wait time and number of waits for parallel queries to synchronize.
  0313 New fields are added to record:
  • User IDs that are longer than 16 bytes
  • Transaction names that are longer than 32 bytes
  • Workstation names that are longer than 18 bytes
End program-specific programming interface information.