Database Monitoring question

[Joseph Mendygral]

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]
------------------------------

[Jonas Dusil]

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
------------------------------