Database Collector in Background
Processing
The data collector RSCOLL00 is started every hour as a background job (name of the job: COLLECTOR_FOR_PERFORMANCEMONITOR or SAP_COLLECTOR_FOR_PERFMONITOR) (Configuring the Data Collector). When this happens, the ABAP programs that belong to the database collector are also started.
Check that the configuration of the data collector allows the programs of the database collector to be started at the required times:
· Entries in table TCOLL:
Each entry corresponds to a report executed within the execution of report RSCOLL00. The reports are executed on the days and at the times specified on the database instance of the SAP system (entry system = C) if there is a dialog system available there. Otherwise the first available dialog system is automatically used (Scheduling Data Collector Reports).
Table: Entries in TCOLL that are relevant to the database collector
Report |
Task of the report |
Day |
Time of day |
RSDBPREV |
Calls the database-specific report in order to receive current statistics from the database system (RSDBPREV) |
Daily |
Every two hours |
RSORATDB |
Analyzes the tablespaces, tables and indexes and stores the results in table MONI (RSORATDB) |
Daily |
Once a day |
RSORAPAR |
Reads the database parameters and stores them in table PAHI (RSORAPAR) |
Daily |
Once a day |
RSORA811 |
Deletes old BRBACKUP and BRARCHIVE logs (RSORA811) |
Daily |
Once a day |
To change the specifications in table TCOLL:
Call Transaction ST03 and choose Environment ® Data collector ® Collector frequency.
· Scheduling the data collector
Check that the job COLLECTOR_FOR_PERFORMANCEMONITOR or SAP_COLLECTOR_FOR_PERFMONITOR is scheduled correctly.
Using the Graphical
Job Scheduling Monitor
Make sure that the user under whose ID the job is running has the necessary authorization (user DDIC)
· Program: RSCOLL00
· Variant: no
· Repetition period: hourly
· Client-dependent: no
If you want
to change these job scheduling specifications, choose
Scheduling Background
Jobs.
· You can display the logs of the data collector.
To display using the Workload Monitor:
1. Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Workload ® Analysis.
Alternatively, use Transaction ST03.
2. Choose Environment ® Data collector ® Display protocols.
See also:
Or start report RSCOLL20.
The logs are deleted automatically after a time period which you can set. You can set the retention time in the Workload Monitor under Goto ® Parameters ® Performance database, entry Time comparison data - Days.
See also: Configuring the Data Collector
· To be able to access current Oracle statistics, the Oracle parameter TIMED_STATISTICS (Oracle) must be set to true.