Tuesday, 2 March 2021

command pidof- To list all the process ID of one service @ OS level

 pidof - To list all the process id (PID) of one service at operating system(OS) level use the below commad.

$ pidof  <service_name>


------------------------------------------------------------------------------------------------------------

eg:

$ pidof  sapstartsrv              

result:

list of PID running for sapstartsrv

--------------------------------------------------------------------------------------------------------------

use cases:

to kill all the PID of one service @ OS level, need to collect all the pid numbers of running service.by the above pidof command, can collect list of pid of the service.




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>




Different kinds of HA DR replication modes and operation modes

 


Friday, 12 February 2021

SQL Ports for HANA 2.0 to connect system database and tenant database

 in MDC, hdbuserstore keys need to be set based on the SQL port.


  • Keys for Systemdb must be set using SQL port 3<02>13
  • Keys for Tenant DB must be set using SQL port 3<02>13@<Tenant_DB>


here <02> is instance number.