Consider performance impact of each attribute group
Learn about the performance impact of each attribute group.
Table 1 lists the impact on performance (high, medium, or low) of each attribute group. The multiple-instance attributes have been classified at the lowest level. That is, the performance overhead will increase if you do not specify compare values for one or more key values.
When you want to prevent impact on performance by any of the attribute
groups listed in Table 1 you
must avoid referencing that attribute group, as suggested in this
list:
- Disable the attribute group.
- Never select workspaces that reference the attribute group.
- Disable situations that reference the attribute group by using the "Undistributed situations" option in the Situation Editor.
- Disable historical reporting that references the attribute group.
- Avoid using the "Auto Refresh" refresh feature in a Workspace because this option causes a refresh of data for all attribute groups.
| Attribute group | High | Medium | Low |
|---|---|---|---|
| Application00 (KUD_DB2_Application00 | x | ||
| Application00 (KUDDB2APPLGROUP00) (Superseded) | x | ||
| Application00U (KUDDB2APPLGROUP00_U) (Superseded) | x | ||
| Application01 (KUD_DB2_Application01) | x | ||
| Application01 (KUDDB2APPLGROUP01) (Superseded) | x | ||
| Apply Program (KUD_DB2_Apply_Program) | x | ||
| Apply Subscription (KUD_DB2_Apply_Subscription) | x | ||
| Buffer Pool (KUD_DB2_Buffer_Pool) | x | ||
| Buffer Pool (KUDBUFFERPOOL00) (Superseded) | x | ||
| Database00 (KUD_DB2_Database00) | x | ||
| Database00 (KUDDBASEGROUP00) (Superseded) | x | ||
| Database01 (KUD_DB2_Database01) | x | ||
| Database01 (KUDDBASEGROUP01) (Superseded) | x | ||
| Database02 (KUD_DB2_Database02) | x | ||
| DCS Database (KUD_DB2_DCS_Database) | x | ||
| Diagnostic Log (KUD_DB2_Diagnostic_Log) | x | ||
| Diagnostic Messages (KUD_DB2_Diagnostic_Messages) (Superseded) | x | ||
| Locking Conflict (KUDLOCKCONFLICT00) | x | ||
| Log (KUD_DB2_LOG) | x | ||
| Log Record (KUD_DB2_LOG_RECORD) | x | ||
| Network Info (KUD_DB2_IPADDR_TABLE) | x | ||
| System Overview (KUD_DB2_System_Overview) | x | ||
| System Overview (KUDINFO00) (Superseded) | x | ||
| System Resources (KUD_DB2_System_Resources) | x | ||
| Table (KUD_DB2_Table) | x | ||
| Tablespace (KUD_DB2_Tablespace) | x | ||
| Tablespace (KUDTABSPACE) (Superseded) | x |