DB2 is a SQL-based commercial database of IBM that offers the ability to efficiently manage large amounts of data. This database is available in separate versions for Linux, Unix and Windows environments (LUW for short), z/OS, cloud environments, etc. By monitoring DB2 for z/OS environment using Moein monitoring system we can ensure its health. For this database, thread performance indicators such as ADBAT, DSCDBAT, offload statistics, databases, storage groups, table space and volumes performance metrics are monitored. Performance indicators of this database are listed below.

1. Total Connect Request Time
2. QUEDBAT
3. MDBAT
4. Offload Log Max
5. Offload Log Num
6. Active Log Percent
7. INADBAT
8. INACONN
9. DSCDBAT
10. CONQUED
11. CONDBAT
12. ADBAT Used Percentage
13. ADBAT Rate
14. ADBAT

Databases:

1. List Of Databases
2. Status
3. Create Date

Storage Groups:

1. List Of Storage Groups
2. Status
3. Allocated Space
4. Update Date

Table Spaces:

1. List Of Table Spaces
2. Status
3. Table Count
4. Page Count
5. Allocated Space
6. Update Date

Provide a list of volumes with parameters such as:

1. Storage Group Name
2. Storage Group Creator
3. IBMREQD
4. RELCREATED

Communication Protocols:

• JDBC