Work identification

The first stage of implementing a DB2® workload manager solution identifies the work that runs on your data server. You identify work either by its origin or by its type.

Use workloads to identify work by where it originates or who submits it. You identify work by the application name or system authorization ID that submitted it, for example.

Work can be identified by type by pinpointing certain characteristics of the work with work classes. You identify statements such as those that only modify data on the data server, such as INSERT, UPDATE or DELETE statements, for example.

The following figure shows a number of different sources of work, coming from different users, groups, and applications.

Figure 1. Various sources and types of database activities on a data server