Automic Workload Automation

Hier finden Sie eine Anfrage, um Ihre Prozesse direkt in der Datenbank zu überprüfen :

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

FrankMuffke : Danke für das Update !

Hi Cyril_Delplanque_2297

I am afraid there is a typo in your when-clauses. Think WP=2 and PWP=4 are mismatched...

https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/12.0/DB%20Schema/db/_structure/HTML/MQSRV.html

cheers, Wolfgang

Hi @Wolfgang,

Es sieht eher so aus dass sich der Tippfehler in die Dokumentation eingeschlichen hat. Wenn die oben erwähnte Abfrage auf eine MSSQL Datenbank ausgeführt wird (WP=2 and PWP=4), dann erhalten wir das folgende Ergebnis :

https://us.v-cdn.net/5019921/uploads/editor/qd/4453pc53mqbd.png" width="402">
In der Systemübersicht dagegen derselben AE Instanz sehen wir das Wertebelegung in der Abfrage mit den Rollen der jeweiligen WPs überein stimme :

https://us.v-cdn.net/5019921/uploads/editor/7m/adiwglj00gb7.png" width="967">

In Wirklichkeit sollte die Unstimmigkeit in der Dokumentation an die entsprechende Fachabteilung gemeldet werden.

Hi Pascal_Osthus-bugat_1753

Jetzt müsste das SQL stimmen, davor waren PWP und WP vertauscht.





lg Wolfgang

And here an updated version for AE 12.1:

SELECT   MQSRV_Name,   MQSRV_System,   MQSRV_TcpIpAddr,   MQSRV_TcpIpPort,   (CASE mqsrv_type       WHEN 1      THEN 'CP'       WHEN 2      THEN 'WP'       WHEN 4      THEN 'PWP'       WHEN 16     THEN 'JWP'       WHEN 32     THEN 'JCP'       ELSE to_char(mqsrv_type)     END) "Process Type" FROM   MQSRV WHERE   MQSRV_Name IN   (SELECT OH_Name FROM OH WHERE OH_OType='SERV')

Josef_Scharl_103: Do you know how to read the WP role from the DB?

Michael_Lowry

Please have a look here:
https://community.automic.com/discussion/8199/where-is-the-pwp

Best Regards
Christian Glaser

Thanks, Christian_Glaser_7453. Do you know how to get the info from the DB using SQL?

Hi Michael_Lowry and Christian_Glaser_7453

Unfortunately the current WP role (O and/or R) arenotstored in the Database.

Ways to determine the current distribution:

• System Overview (aka Administration Perspective) via the (Web-) UI.
  It’s also possible via the AE.ApplicationInterface:
  Integration Guide > AE.ApplicationInterface > Classes for the Administration Perspective 
  
  
• The PWP logs the role distribution with the message U00003345. E.g.:
  

  U00003345 Role 'R' has been passed to Server 'WO121#WP004'.

  However here is the tricky part to read the right (= PWP) log files …
  
  
• From a DB trace (level 2 and higher)

Cheers, Josef

This SQL will return the short name of the PWP.

SELECT substr(MQSRV_Name,instr(MQSRV_Name,'#') + 1) as Process_Name
FROM MQSRV
WHERE
  MQSRV_Name IN
  (SELECT OH_Name FROM OH WHERE OH_OType='SERV')
  AND MQSrv_Type = 4

Perhaps this could be combined with a query of the MELD table to look for the most recent U00003345 message for each role.

Looks like this message is not stored in MELD   :/

I just tried without success to find any instances of message 3345 in the MELD table of two of our systems. My guess is that once a system has been up and running for a while, these messages will have expired from the table and will reside only in the log files.

select * from MELD
where MELD_MsgNr = 3345

If the message were there, finding the WPs that have a particular role would be straightforward:

select substr(MELD_MsgInsert,instr(MELD_MsgInsert,'|') + 1)
from MELD
where MELD_MsgNr = 3345
and MELD_MsgInsert like 'R|AE_DEV#WP%'