DB2 databases manage application data in terabyte size. Application security, stability and performance are heavily dependent on the availability and throughput of simultaneous access to the database instances.

DB2 is a professional RDBMS with corresponding storage units on disks, corresponding processes and buffer structures in order to efficiently manage users and their access.

 

System behavior is determined by the settings of various configuration parameters and settings of catalogue and environment variables. All of these units have to be permanently monitored and analyzed in order to guarantee safe operation and efficient use existing resources.

The following attributes are monitored and analyzed in detail:

 

• database status
• number and status of application connections
• size of application related memory
• buffer pools (read/writes)
• table space (size, fill level)
• transaction logs (size, fill level)
• locks (waiting situations)
• direct and indirect read / write operations
• sorting operations
• diagnostic logs
• configuration parameters

 

In addition to this, various database values and configurations can be directly displayed in lists.

 

theGuard! ApplictionManager includes pre-configured thresholds for the monitoring of DB2.

• availability, performance and analysis of DB2 systems and applications on Oracle
• capacity planning and control
• storage optimization