Show TOC

 Database Collector in Background ProcessingLocate this document in the navigation structure

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.

    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.

See also: Configuring the Data Collector