2.2 Enabling the Database for the Data Collection Framework
2.2.2 Maintaining Templates for the DCF
The data collection framework is based on predefined templates. These templates ensure a homogeneous setup of the history data collectors in your system landscape. You can only maintain these templates on the Template Definition screen in the DBA Cockpit.
On the Template Definition screen, you can perform the following actions: Create new templates
Change single history data collectors in a template Set a default template
Delete a template
Note
In the SAP Solution Manager setup wizard for managed systems for the database, the templates are available for use but cannot be maintained.
End of the note.
SAP provides two default templates as described in Enabling the Database for the Data
Collection Framework [page 32].
You can access the Template Definition screen by calling the DBA Cockpit and choosing Configuration Data Collection Framework Template Definition on the Database tab page of the DBA Cockpit.
From the Template dropdown list, choose the appropriate template for your setup. The following information is displayed:
Column Description
Data Collector
Name of the history data collector
Typically, the name refers to the data that is collected, for example, the data collector Tables stores table-related metrics in the history tables.
Type
The following data collector types are available:
SAP Data Collection and Preparation (STP)
These history data collectors have their own mechanism for delta calculation of the different snapshots.
DB2 Event Monitor and Preparation (STP)
A DB2 event monitor is used to store the data in tables.
Cleanup of Message Logs (STP)
The Framework data collector is not a typical data collector type, but a cleanup job for the messages generated by the above mentioned data collector types.
Column Description
Release (min) Minimum database release required for the history data collector
Release
(max) Maximum database release supported by the history data collector
Setup
Indicates the setup status: Green:
The history data collector is set up as intended. Yellow:
The history data collector is not set up properly. We recommend that you repair it.
Red:
The history data collector is not set up. Set up the history data collector according to the assigned template.
Gray:
The history data collector is not set up and the assigned template also marks this data collector to be deactivated.
Collection
Interval Schedule of the history data collector
Event Monitor Active
State of the DB2 event monitor: Green:
The DB2 event monitor is set up as intended. Yellow:
The DB2 event monitor is not set up properly. We recommend that you repair the history data collector.
Red:
The DB2 event monitor is not set up. Set up the data collector according to the assigned template.
Gray:
No DB2 event monitor is used by the data collector.
Days Kept in History
Number of days of the sliding history window
Creating a New Data Collector Template
You can create a new data collector template either by copying an existing template or by generating a template that is based on the configuration of an individual system as follows:
Copying an existing template:
1. On the Template Definition screen, choose a template from the Template dropdown list and choose the Save As New Template pushbutton. The Save As New Template dialog box appears.
2. Enter a unique name and a description of the new template. 3. Save the template.
Creating a template based on a system configuration:
1. On the Database tab page of the DBA Cockpit, choose Configuration
Data Collection Framework Collector Configuration .
2. On the Collector Configuration screen, choose the Save as New Template pushbutton.
Note
The Save As New Template pushbutton is only enabled if the respective system configuration fulfills the minimum template requirements of SAP that are defined by the SAP Default template. This means that every new template must determine a finer granularity or a longer retention time for the history data than the SAP Default template does.
End of the note.
3. In the Save As New Template dialog box, enter a unique name and a description of the new template.
4. Save the template.
Changing a Single History Data Collector in a Template
The Setup status of the history data collector must be green.
1. Choose a non-SAP template from the Template dropdown list.
2. On the Configuration tab page in the content detail area, choose the Change Settings pushbutton.
Note
You cannot change an SAP template. Instead, you can create a custom template based on the SAP template and change this newly created template.
End of the note.
3. In the content detail area, enter your changes in the respective fields. 4. Apply your changes.
Note
If you want to discard your changes, choose the Reset Changes pushbutton. End of the note.
In some areas, the DBA Cockpit joins data from different data collectors on the time dimension. We, therefore, recommend that you have the same configuration for the schedules for these groups of data collectors:
General data collectors o Buffer Pools o Containers o Configuration o Database o Tablespaces Database Objects o Indexes o Tables
Setting a Default Template
The default template is preselected in the template-based setup and in the SAP Solution Manager setup wizard for managed systems.
To change a default template, choose a template from the Template dropdown list and choose the Set As Default pushbutton.
Note
The current default template is marked with an asterisk (*). If the default template is currently selected, the Set As Default pushbutton is disabled.
End of the note.
Deleting a Template
You can delete a template by choosing it from the Template dropdown list and choosing the
Delete pushbutton.
A list of all systems is displayed that are assigned to this template. If there are entries in the list, the default template is assigned to these systems before the template is deleted.
Note
You cannot delete SAP templates or the current default template.
If you want to delete the current default template, you first have to unmark it as the default by setting a different template as the new default.
End of the note.