Work identification
A key part of successfully implementing a Db2® workload management solution is identifying the work.
There are three approaches to work identification: workloads, work classes, and data tags.
- Workloads can be used to identify the source of work. You can identify the source at the connection or transaction level by using key session attributes, such as the application name or the system authorization ID that submitted the work, for example.
- A work class enables you to identify work by pinpointing certain characteristics of the work. You can define a work class to identify the work of interest, such as statements that only modify data on the data server, for example (INSERT, UPDATE, or DELETE statements, for example).
- Data tags are available as table space and storage group data tags. They enable you to identify work indirectly by the type of data it accesses during execution. By tagging data of interest, you can identify the work that is accessing that data.