ManageEngine® Applications Manager


IBM Informix Database Servers

<< Prev

Home

Next >>

IBM Informix Database Monitoring

 

IBM Informix is one of the industry's most widely used database servers with a comprehensive set of high availability options, high levels of performance, data replication capabilities, scalability and minimal administrative overhead for both simple and complex IT infrastructures. Applications Manager performs effective monitoring, which is very critical in Informix administration, to collect system and database performance stats, session details and to identify problems at an early stage for proactive troubleshooting and performance tuning.

 

IBM Informix - Monitored Parameters

Go to the Monitors Category View by clicking the Monitors tab. Click on Informix under the Database Servers Table. Displayed is the Informix Database bulk configuration view distributed into three tabs:

Click on the monitor name to see all the server details listed under the following tabs:

Overview

Parameter Description
Response time

The time taken to establish a JDBC connection with the Informix Server.

Database Space Details
Dbspace Name The unique name of the Database Space.
Allocated (MB) The total physical disk size allocated for the Database Space in MB.
Free (MB) The free physical disk size for the Database Space in MB.
Used % The percentage of physical disk utilization by the Database Space.
Disk Reads/sec The number of Disk Reads happening in the Database Space per second.
Disk Writes/sec The number of Disk Writes happening in the Database Space per second.

Top

 

Database

Parameter Description
Name The name of the Database
Dbspace Name The Database Space which stores data for this database.
Owner The User ID of the creator of the database.
Created On The time at which the Database was created.

Is Logging

Is Buff Log

Is ANSI

Is NLSIs Case Insens

The current logging modes of a database:

  • Unbuffered logging. Values are 1=Yes, 0=No
  • Buffered logging. Values are 1=Yes, 0=No
  • ANSI mode database. Values are 1=Yes, 0=No
  • NLS support. Values are 1=Yes, 0= No1
  • Values are: I if case-insensitive for NCHAR and NVARCHAR columns, 0 if not

Top

 

Sessions

Parameter Description
Session Id A unique identifier number assigned to the session.
User Name The User name of the Informix user account.
Host Name The host from which the user is connecting to the Informix database
Login Time

The time at which the user connected to the database server.

Top

 

<< Prev

Home

Next >>

IBM DB2 DB Servers

Sybase DB Servers