Performance Database Collectors (SAP Library

Performance Database Collectors

A short description follows of the ABAP programs that can be started from the RSCOLL00 data collection program. Using the descriptions you can decide which the programs you should run in your system by scheduling them in the TCOLL table (see also Configure the Performance Monitor Collector).

You can find recommendations about which report should be executed, and how often, in SAP Note 0127642.

RSHOSTDB

The program updates the MONI performance database with operating system data. The program reads data for the Operating System Monitor from the main memory of the host and writes it to database tables OSMON and MONI.

Use

As the data is retained for a maximum of 24 hours in the main memory, the program should be scheduled in table TCOLL on every system so that it runs at least once a day in every SAP instance. If several instances of the same SAP system are on the same host, the data collector starts the program only once on this host.

RSHOSTPH

The program checks whether system parameters of the host operating system have been changed since the last time this program ran and logs any changes that have been made to database table PAHI.

As the parameter changes are only stored once per day, it is sufficient to schedule this program in table TCOLL on each system so that it runs on every SAP instance once a day. If several instances of the same SAP system are on the same host, the data collector starts the program only once on this host.

RSORASNP

RSORASNP collects database statistics (such as the number of user calls, searches of long tables, and so on). For this, it reads the current database statistics from the Oracle table V$SYSSTAT and stores them in table DBSNP. At the same time, the program deletes obsolete entries from this table. The number of entries that it deletes depends on the setting for parameter STATS$TABLES_DAYS_TO_KEEP in table TSEXC; the default value is 120 days.

This report is called for Oracle indirectly through the report RSDBPREV, which means you do not need to schedule it directly in table TCOLL.

RSDBPREV

The program calls a database-specific report that generates and stores current statistics for the database system. For an Oracle database, this report is RSORASNP.

RSDB_TDB

This program replaces RSORATDB (see also SAP Note 12103). It analyzes the growth of certain tables, indexes and tablespaces and writes the results to performance database MONI. This program creates forecasts on the basis of values from the past, in order to be able to issue warnings in good time of any storage bottlenecks that may occur.

The results are stored with a time stamp. This means that you should execute the program on the database system at least once a day (entry in table TCOLL with System = C). If there is no dialog instance active on the database server, the data collector switches to the first available application server.

Considerable CPU resources are required on the database server to run RSDB_TDB, depending on the database size. This means that you should not schedule this program too frequently. Therefore the determined data will not always be up-to-date, but will reflect the status at the time of the collector run.

RSDB_PAR

This program replaced RSORAPAR (see also SAP Note 12103). It logs changes to database parameters. RSDB_PAR checks whether database system parameters have been changed since the last time this program was executed and logs the changes to database table PAHI.

As these parameter changes are saved only once per day, it is sufficient to run this program once a day on the database server (entry in table TCOLL with system = C). If there is no dialog instance active on the database server, the data collector switches to the first available application server.

RSORA811

This program deletes old backup logs generated by the SAP utility programs BRBACKUP and BRARCHIVE. It deletes obsolete log entries in the database tables SDBAH and SDBAD. For more information about the SAP utility programs BRBACKUP and BRARCHIVE, see Structure link CCMS: Oracle.

RSSTATPH

Like programs RSHOSTPH and RSORAPAR, the program RSSTATPH logs changes to SAP parameters. You should run this program daily in each SAP instance (in table TCOLL, system = *).

RSSTAT60

This program reorganizes the performance database MONI. If data is older than specified by the appropriate parameters, it is deleted.

Due to the number of affected database accesses, schedule RSSTAT60 in table TCOLL so that it runs on the database server (Entry in table TCOLL, system = C). A dialog instance must be active on the database server.

RSEFA350

This program updates the statistics for tables with major changes in Informix systems. On Oracle platforms, it analyzes the size of SAP tables. Running RSEFA350 requires a lot of time and causes a high workload. You should therefore only run this program when it is absolutely necessary.

RSHOSTDC

This program reads the operating system workload on a database server with no SAP instance and stores the data in the MONI performance database.

RSDB_WDB

This program replaced RSORAWDB (see also SAP Note 12103). It is responsible for analyzing databases on DB2/6000 platforms and should normally only be scheduled for one run per week.

RSSTAT83

The program RSSTAT83 replaced RSSTAT80. Unlike RSSTAT80, it runs on all hosts simultaneously and only sequentially on the instances of a host. For more information, see SAP Note 127642.

The program transfers local statistics. It reads the local statistics for the various SAP instances and writes the statistics data to the performance database (Entry in table TCOLL, System = *). The program makes a record which data has already been read, thus ensuring that no data is read or transferred more than once.

Schedule this program hourly using the table TCOLL. RSSTAT83 writes its own log, which you can view in transaction ST03N in Expert user mode by choosing Collector and Performance Database ® Workload Collector ® Log.

RSSTAT81

This program stores specific performance analysis data in the MONI performance database.

RSSTAT90

This program reads table access statistics and stores them in the MONI performance database.

RSSTAT98

This program logs active instances in table SAPWLSERV.

RSSTAT89

This program reads application statistics records, compresses them and writes them to the MONI performance database.

RSTUNE80

This program reads buffer statistics and stores them in the MONI performance database.

RSRFCDLT

This program deletes certain entries in the RFC statistics table.

RSORAVSH

This program analyzes wait situations on the database (ORACLE only) and stores this data in the MONI performance database.

Parameters for RSSTAT80/83 and RSSTAT87/88/89