Automic Workload Automation

Hi everyone,

struggling with the issue SMGR Service name vs. AE process name described here:

https://communities.ca.com/ideas/235740280-ucybsmcl-c-getprocesslist-should-return-process-names
and here
https://communities.ca.com/thread/241811924-idetifying-hung-ae-server-processes#comment-242125824

I discovered a workaround lately -- unfortunately its only a half workaround....

In DB Table HOST the field HOST_SMDISPLAYNAME holds the SMGR Service name entry for the agent or WP and CP
e.g. UC4_WP1, UC4_WP3!

so the SQL for identifying SMGR Service Names AND AE process names would be:

select HOST_SMDISPLAYNAME,ah_processid,ah_info,HOST.HOST_HOSTATTRTYPE from ah, HOST
where ah_otype = 'SERV'
and ah_timestamp4 is null
--disable line below if you want CPs in result
--and ah_info is not null
and ah_oh_idnr = host_oh_idnr

Limitations:
Unfortunately#1 for JPWs the field HOST_SMDISPLAYNAME is empty.
Unfortunately#2 for JPWs the field AH_PROCESSID does not have leading zeros to the Process number, all other types do haveleading zeros.
Unfortunately#3 for CPs the field AH_INFO is empty.

hope it helps.

cheers, Wolfgang

Hi Wolfgang,

Thanks for the suggestion. I tried at my end, and... 

Unfortunately#1 for JPWs the field HOST_SMDISPLAYNAME is empty.

I do not have this issue under 12.2 w/ PostGre. Maybe it's version-related ? 

Unfortunately#2 for JPWs the field AH_PROCESSID does not have leading zeros to the Process number, all other types do haveleading zeros.

You can overcome this with  LPAD - format the output so it also contains leading zeros.

Unfortunately#3 for CPs the field AH_INFO is empty.

True, but AH_Name on the other hand, contains the desired information.

I did a few adjustments to your query:

SELECT HOST_SMDISPLAYNAME,AH_Name, HOST.HOST_HOSTATTRTYPE, lpad (AH_ProcessID, 10,'0') PROCESS_ID
from dbo.ah, dbo.HOST
where ah_otype = 'SERV'
and ah_timestamp4 is null
and ah_oh_idnr = host_oh_idnr;

And here are the results :

Tested on PostGre, the syntax might be different on MS SQL / DB2 / Oracle.

Hope this helps.

Best regards,

Antoine