Automic Workload Automation

 View Only
  • 1.  How to determine the number of connections?

    Posted Nov 26, 2014 11:56 AM
    Hi all..
    Within UC4 Operations Manager database, does anyone know where I might find information on the number of open connections to our UC4 Environment?

    From the Service Manager Dialog utility for example, I can see a number of connectons to the WP & CP processes.

    We'd like to query the database to find out these numbers.

    Anyone know where it may be held within which table?

    Thanks!
    Colin.


  • 2.  How to determine the number of connections?
    Best Answer

    Posted Dec 01, 2014 06:10 PM
    That info would most likely be found in the MQ* tables. (DB Schema)

    Another location could be in the AH tables, look for WP or CP entries with no 'AH_Timestamp4' (End Time).


  • 3.  How to determine the number of connections?

    Posted Dec 10, 2014 04:27 AM
    Thanks Jennifer...  We also raised a support call & found out that the info we want to find is not all held in the database.
    Regards,
    Colin.