Start of Content Area

This graphic is explained in the accompanying text Configuring Process Monitoring of the Database  Locate the document in its SAP Library structure

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. The process monitoring requires the operating system collector SAPOSCOL and the CCMS agent SAPCCMSR.

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.      Under Microsoft Windows, open the Windows Service Manager and stop and restart the service SAPOsCol.

       5.      Under UNIX, restart SAPOsCol manually; to do this, change to /usr/sap/ccms/bin and enter the following commands:

saposcol –k (stops the process)

saposcol –k (starts the process)

Result

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 <Hostname>  →  Monitored Processes.

 

End of Content Area