Dialog work process status in sm50

 

Waiting: The process is waiting "Available" to serve the user..

Running: The process is executing the task.

Sleep mode: Waiting for resources( RFC problems).

ON hold: The user request is on hold by process for waiting certain resources on the other systems(RFC CPIC).

PRIV Mode: The process goes in to heap mode, it will be completed only after the task completion/ Timeout.

Stopped: The process is stopped due to an error.

Shutdown: The process is killed/shutdown but restart mode set to NO.

How to use dpmon tool - to monitor work process status @OS

 Dpmon - Dispatcher monitoring 

Dpmon tool is use to check the status of  work process or dispatcher queue @ operating system level without login to SAP GUI.

use cases:

1. To get the status of work process @ OS level, when the SAP GUI login is not possible.

Practical steps:

1.login to putty session using <sid>adm user.

2.To list down the available profiles, issue command- cdpro or (/sapmnt/<SID>/profile)

3.follow by command - ls

4.dpmon pf=<use_the_profile_used_for_application_server> - results shows dispatcher queue statistics.

5.type 'm' to display all the menu available for the dpmon.

6.type 'I' to display work process overview.

7.step 4,5,6 can be replace with command - dpmon m i

8.if all the work process are full take the PID of the work process and kill the process id with command- kill -9 <PID>

How to check the HDB present status

1. su - <sid>adm
2. cd /usr/sap/hostctrl/exe/ 
3. ./sapcontrol -nr 02 -function GetProcessList

08.01.2020 05:49:11
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2020 01 08 05:22:16, 0:26:55, 84174
hdbcompileserver, HDB Compileserver, GREEN, Running, 2020 01 08 05:22:22, 0:26:49, 84370
hdbindexserver, HDB Indexserver, GREEN, Running, 2020 01 08 05:22:25, 0:26:46, 84418
hdbnameserver, HDB Nameserver, GREEN, Running, 2020 01 08 05:22:17, 0:26:54, 84197
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2020 01 08 05:22:22, 0:26:49, 84372
hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2020 01 08 05:22:39, 0:26:32, 84877
hdbxsengine, HDB XSEngine, GREEN, Running, 2020 01 08

Different cmd's for tracking HANA Database status

hostname:HDB:phsadm /usr/sap/PHS/HDB04 31> HDB Start

Usage: /usr/sap/PHS/HDB04/HDB { start|stop|reconf|restart|version|info|proc|admin|kill|kill-<sig>|term }
  kill or kill-9 should never be used in productive environment!