Database Collector in Background Processing (SAP Library

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 R/3 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:

Choose Tools ® CCMS ® Control/Monitoring ® Performance Menu ® Workload ® Analysis.

Alternatively, use Transaction ST03 .

Choose Environment ® Data collector ® Display protocols.

See also:

Workload Monitor

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.

To be able to access current Oracle statistics, the Oracle parameter TIMED_STATISTICS (Oracle) must be set to true .