Automic Workload Automation

Expand all | Collapse all

SMGR Service name vs. AE process name - half workaround

  • 1.  SMGR Service name vs. AE process name - half workaround

    Posted 09-11-2018 09:13 AM

    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



  • 2.  Re: SMGR Service name vs. AE process name - half workaround

    Posted 09-12-2018 05:36 AM

    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