Create historical data collections
TIP
To ensure that ODP forwards attributes to Instana as soon as you start collecting them, update the ODP collection configuration member KAYOPEN before creating the corresponding historical data collections.
WARNING
With higher granularity (a smaller interval means more data collected) there are 2 obvious considerations:
- CPU overhead on data collection and retrieval;
- DASD space to hold historical tables.
Should you grow in CPU usage or Persistent Data Store, consider raising the interval and/or skipping warehousing for certain tables on PDS and just go with open data.
Create the following historical data collections for the Db2 agent. This can be done via the E3270UI or the Tivoli Enterprise Portal within the Db2 workspace.
table_name field value | Attribute group | Collection interval (minutes) |
|---|---|---|
| opersys | z/OS CPU Utilization Attributes | 1 |
| db2lkconf | Db2 Lock Contention | 1 |
| dp_ci_excs | DB2_CICS_Exceptions | 1 |
| dp_im_conn | DB2_IMS_Connections | 1 |
| dp_sy_exc | DB2_System_States | 1 |