How-to check CP / WP Processes in database ?

Discussion created by Julia_Buchner_9324 on Sep 29, 2017
Latest reply on Oct 3, 2017 by Josef_Scharl_103
You can find here the request to check process directly in the database:

select MQSRV_Name, MQSRV_System, MQSRV_TcpIpAddr, MQSRV_TcpIpPort, (case mqsrv_type
when 1 then 'CP'
when 2 then 'PWP'
when 4 then 'WP'
when 16 then 'JWP'
end) as 'Process Type'
from MQSRV where MQSRV_Name in (select OH_Name from OH where OH_OType='SERV');