Create historical data collections
Tips
To ensure that ODP forwards attributes to Elastic as soon as you start collecting them, update the ODP collection configuration member KAYOPEN before creating the corresponding historical data collections.
Create the following historical data collections for the Db2 bundle:
table_name field value | Attribute group | Collection interval (minutes) |
|---|---|---|
| dp_srm_sub | Db2 SRM Subsystem Attributes | 1 |
| db2msg | Db2 Message Attributes | 1 |
| dp_srm_log | Db2 SRM Log Manager Attributes | 1 |
| dp_sy_exc | Db2 System States Attributes | 1 |
| edmpool | EDM Pool Attributes | 1 |
| gstqxst | DSG SQL Count Attributes | 1 |
| opersys | z/OS CPU Utilization Attributes | 1 |
| real225 | Db2 Memory Attributes | 1 |
| real2252 | Db2 Memory Attributes | 1 |
| real230 | Db2 Group Buffer Pool (GBP) Attributes | 1 |
| real254 | Db2 GBP CF Statistics Attributes | 1 |
| realqbst | Db2 Buffer Pool Statistics Attributes | 1 |
| realsqlc | SQL Counts Attributes | 1 |
| statedmp | EDM Statistics Attributes | 1 |
| statlogs | Log Statistics Attributes | 1 |
| statlokc | Lock Statistics | 1 |
| statqxst | Statistics SQL Count Attributes | 1 |