Problem determination enhancements
The Db2® 11.5.5 release extends the problem determination capabilities provided in previous releases.
- Db2 on-premises
- The single container deployments of Db2 Warehouse and IBM Integrated Analytics System (IIAS)
- The container micro-service deployment of Db2 on Red Hat OpenShift
| Enhancement | Description |
|---|---|
| New output row "Extraction Throttle Reason" in db2pd -logs | A new output row has been added to db2pd -logs. For more information, see db2pd - Monitor and troubleshoot Db2 database command |
| Db2 Historical Monitoring (db2histmon) |
To aid with problem determination and improve the availability of diagnostic and monitoring data at the first occurrence of a problematic event, deploy the Db2 Historical Monitoring (db2histmon) scripts. These scripts collect a broad set of monitoring and diagnostic data, at varying intervals, and manage the archival and purging of this historical data. Data collection sets can be customized as needed, and can be deployed on all modern versions of Db2. The new report script now generates reports similar to those in the MONREPORT module, using this historical data. The reports currently supported are: DBSUMMARY (similar to MONREPORT.DBSUMMARY), CONNECTION (similar to MONREPORT.CONNECTION), and PKGCACHE (similar to MONREPORT.PKGCACHE). Download the db2histmon scripts here. To learn more about deploying and using the db2histmon scripts, refer to: Enabling Db2 Historical Monitoring (db2histmon) - continuous diagnostic data collection and archival. |