Show TOC

Configuring Process Monitoring of the DatabaseLocate this document in the navigation structure

Context

The monitoring of important database processes is described here as an example of process monitoring (see Monitoring Selected Processes with SAPOSCOL). A simple availability monitoring of the database is possible in this way. Process monitoring requires the operating system collector SAPOSCOL and a NetWeaver management agent.

Procedure


  1. Change to the working directory of SAPOSCOL; this is \\<host>\saploc\prfclog (Microsoft Windows) or /usr/sap/tmp (UNIX).

  2. Edit or create the file dev_proc. Ensure that the file begins with $PROC and ends with $. Enter the following new line(s) between the start mark $PROC and the end mark $, depending on your platform and database:

    MSSQL

    ORACLE

    UNIX

    *ora_arc*

    *ora_reco*

    *ora_smon*

    *ora_ckpt*

    *ora_lgwr*

    *ora_dbw* *ora_pmon*

    Microsoft Windows

    *sqlservr.exe*

    *oracle.exe*

  3. Save your entries.

  4. To activate your changes, restart SAPOSCOL. You can do this by restarting the host agent that contrls SAPOSCOL (more information: Restaritng SAP NetWeaver Management Agents).

Results

The specified process is monitored as of now. To display the results, start the monitor Operating System from the SAP CCMS Monitor Templates monitor set. The information for the process monitoring is in the subtree Start of the navigation path <host name> Next navigation step Monitored Processes End of the navigation path.