ESP Workload Automation

 View Only

  • 1.  Database Monitoring question

    Posted 23 days ago

    Is there any way through ESP to monitor database free space and/or the number of sessions active on a db?  Looking through the documentation, I couldn't find anything.



    ------------------------------
    [MTS IV Spec - Engineering]
    [Verizon]
    [Pennsylvania]
    ------------------------------


  • 2.  RE: Database Monitoring question

    Broadcom Employee
    Posted 22 days ago

    Hi Joseph,

    I would suggest exploring DB_MON and DB_TRIG job types. While these do not directly monitor the database free space or active sessions. Some databases would have internal tables and views exposing such data which you could potentially monitor. 

    As an example, in Oracle Database the V$SESSION view seems to expose the data about active sessions and DBA_FREE_SPACE and USER_FREE_SPACE seem to be views that can get free space data.
    Please note that this is just a direction I would try exploring myself, but it is not something I've ever tried.

    Regards



    ------------------------------
    Jonáš Dusil
    Product Owner | ESP Workload Automation | Mainframe Software Division
    ------------------------------

    Original Message