Entering content frame

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 Structure linkMonitoring Selected Processes with SAPOSCOL). A simple availability monitoring of the database is possible in this way. The process monitoring requires the Structure linkoperating system collector SAPOSCOL and the Structure linkCCMS agent SAPCCMSR.

Procedure

...

       1.      Change to the Structure linkworking 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.

 

Leaving content frame