2. SAMPLE PLANNING APPLICATIONS › 2.11 DB2 Resource Planning › 2.11.1 Usage Guidelines

2.11.1 Usage Guidelines

 
The DB2 Resource Planning Sample Application provides a
capacity planning database file with the database elements
you need for basic tracking, reporting, and forecasting of
the DB2 workloads on your system.  The information for this
application is derived from either the DETAIL, DAYS, WEEKS,
or MONTHS timespan of the following CA MICS files: the DB2
System Activity (DB2DSY) file, the DB2 Database Activity
(DB2DSD) file, and the DB2 User Activity (DB2DSU) file.

The DB2 Resource Planning Sample Application permits your
installation to track and forecast DB2 usage at a high level
of summarization (that is, at the SYSID and ZONE, HOUR or
DAYNAME level).  Because the data is derived from the DB2DSY
and DB2DSD files, this Sample application provides
information about system-wide DB2 usage.

WORKLOAD GROUPS
 
The DB2 Resource Planning Sample Application allows you to
divide your DB2 workloads into groups based on DB2 System
Identifier (DB2ID) or to aggregate all DB2 systems (NONE).
For each defined workload, the application stores measures
such as CPU time, lock escalations, and synchronous I/O
activity in the capacity planning database file.

A workload group, represented by the application unit
(CAPAPU) data element, allows each DB2 system to be tracked
as an entity for capacity planning purposes. If you choose
not to utilize workload groups, all individual DB2 systems
will have their information summarized into the capacity
planning database file.