# IBM Informix Database Monitoring

- [IBM Informix - An Overview](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#informixOverview)
- [Creating a new Informix monitor](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#newmonitor)
- [Monitored Parameters](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#parameters)

## IBM Informix - An Overview

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.

## Creating a new Informix monitor

**Supported versions:** Informix 10.x & above.

**Prerequisites for monitoring IBM Informix metrics:** [Click here](https://www.manageengine.com/products/applications_manager/help/prerequisites-for-applications-manager.html#ibminformix)

**Using the REST API to add a new IBM Informix monitor:** [Click here](https://www.manageengine.com/products/applications_manager/help/database-servers.html#ibminformix)

To add a new Informix server monitor, follow the steps given below:

1. Click on **New Monitor** link.
2. Select **Informix** under **Database Servers**.
3. Specify the **Display Name** of the Informix monitor.
4. Enter the **Host Name / IP Address** of the host where Informix server is installed.
5. Enter the **Port** number of the Informix server. Default port is ***1526***.
6. Enter the **Database Server** name, i.e., the name of the Informix database server to which you want to connect.
7. Enter the credential details like **user name and password** of the Informix server for authentication, or select the required credentials from the **Credential Manager** list by enabling the ***Select from Credential list*** option.
8. Specify the [Polling Interval](https://www.manageengine.com/products/applications_manager/help/glossary-applications-manager.html#polling-interval) in minutes.
9. Enable the **SSH-based Monitoring** checkbox (optional) to collect additional database and operating system metrics that are not available through JDBC connectivity alone. Once enabled, specify the following details:
   - **OS Username:** Username of the operating system.
   - **OS Password:** Password of the operating system.
   - **SSH Port:** The SSH port used to collect Informix metrics.

   **Note:** Make sure to provide the user name and password of the operating system that has permissions to execute Informix commands (such as onstat and onmode) and the OS commands required for monitoring. [Learn more](https://pitstop.manageengine.com/portal/en/kb/articles/prerequisites-for-adding-an-informix-monitor-with-command-line-monitoring)
10. If you are adding a new monitor from an Admin Server, [select a Managed Server](https://www.manageengine.com/products/applications_manager/help/enterprise-managed-server.html).
11. Choose the **Monitor Group** from the combo box with which you want to associate Informix Server Monitor (optional). You can choose multiple groups to associate your monitor.
12. Click **Add Monitor(s)**. This discovers Informix server from the network and starts monitoring them.

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

- **Availability** tab gives the Availability history for the past 24 hours or 30 days.
- **Performance** tab gives the Health Status and events for the past 24 hours or 30 days.
- **List view** enables you to perform [bulk admin configurations](https://www.manageengine.com/products/applications_manager/help/bulk-config.html).

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

- [Overview](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#overview)
- [Database](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#database)
- [Sessions](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#sessions)
- [Transaction & Logs](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#transaction&logs)
- [Storage & Memory](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#storage&memory)
- [CPU & Processing](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#cpu&processing)
- [IPC](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#ipc)
- [Replication](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#replication)
- [Backup & Restore](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#backup&restore)
- [System](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#system)
- [Configuration](https://www.manageengine.com/products/applications_manager/help/ibm-informix-db-servers.html#configuration)

**Note:** Metrics marked with **\*** are shown only when SSH-based Monitoring is enabled.

### Overview

| Parameter | Description |
|---|---|
| **SERVER STATUS** |  |
| Product Name **\*** | Displays the name and version of the Informix Dynamic Server installed. |
| Server State **\*** | Shows whether the Informix server is currently running. **On-Line** means that the server is active and accepting connections. Other states, such as Off-Line, Quiescent, and Shutdown, indicate that the server is unavailable or in a transitional mode and may need attention. |
| Uptime **\*** | Shows the duration for which the Informix server has been continuously running. |
| Shared Memory **\*** | Displays the amount of shared memory allocated to the Informix server. |
| **RESPONSE TIME** |  |
| Response time | The time taken to establish a JDBC connection with the Informix Server (in ms). |
| **DB Space Details** |  |
| DBSpace Name | The unique name of the Database Space. |
| DBSpace Owner | The owner of the Database Space. |
| DBSpace Number | The unique identifier number assigned to the Database Space. |
| DBSpace Address **\*** | The in-memory address of the chunk structure. |
| First Chunk Number **\*** | The number of the first chunk belonging to this DBSpace. |
| DBSpace Page Size(bytes) **\*** | The size of each page in the DBSpace (in bytes). |
| Allocated (MB) | The total physical disk size allocated for the Database Space (in MB). |
| Free (MB) | The free physical disk size available for the Database Space (in MB). |
| Used % | The percentage of physical disk utilization by the Database Space (in %). |
| Disk Reads | The total number of disk read operations performed in the Database Space. |
| Disk Writes | The total number of disk write operations performed in the Database Space. |
| Total Chunks in DBSpace | The total number of chunks present in the Database Space. |
| DBSpace Status Code **\*** | The status code that indicates the current state of the DBSpace. |
| DBSpace Type Flags **\*** | The status flags that define specific attributes or properties of the Database Space. |

### 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 **\*** | Indicates whether unbuffered logging is enabled for the database. |
| Is Buff Log **\*** | Indicates whether buffered logging is enabled for the database. |
| Is ANSI **\*** | Indicates whether the database uses ANSI mode. |
| Is NLS **\*** | Indicates whether NLS support is enabled for the database. |
| Is Case Insens **\*** | Indicates whether NCHAR and NVARCHAR columns are case-insensitive. |
| DB Accessibility **\*** | Indicates whether the database is currently accessible to users and applications. |

### Sessions

| Parameter | Description |
|---|---|
| **ACTIVE LOCKS COUNT** |  |
| Active Locks Count **\*** | Shows the number of locks currently held on the Informix server over time. |
| **ACTIVE SESSIONS COUNT** |  |
| Active Sessions Count **\*** | Shows the total number of active sessions on the server. |
| **Session Statistics** |  |
| 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. |
| Process ID | The process ID associated with the front-end for this session. |
| Number of RSAM Threads **\*** | The number of RSAM threads allocated for this session. |
| Total Memory(MB) **\*** | The amount of memory allocated for this session. |
| Used memory(MB) **\*** | The amount of memory actually used by this session. |
| Used Percentage(%) **\*** | The percentage of memory used by this session. |
| Teletype terminal **\*** | The tty associated with the front-end for this session. |
| Dynamic Explain **\*** | Indicates whether Dynamic Explain is enabled for the session. ***on*** - Informix captures SQL execution plan details for performance analysis and query tuning. ***off*** - Dynamic Explain is disabled. |
| Login Time | The time at which the user connected to the database server. |
| **User Session Details** |  |
| Session ID | A unique identifier number assigned to the session. |
| User Name **\*** | The user login name. |
| Address **\*** | The shared memory address of the session thread. |
| Flags **\*** | Describes the status of the user thread. **Position 1:** ***B*** - Waiting on a buffer; ***C*** - Waiting on a checkpoint; ***G*** - Waiting for the Logical Log buffer to be written; ***L*** - Waiting on a lock; ***S*** - Waiting on a mutex; ***T*** - Waiting on a transaction; ***X*** - Waiting for transaction cleanup; ***Y*** - Waiting on a condition; ***DEFUNCT*** - The thread encountered a serious assertion failure and was suspended so that other threads can continue working. **Position 3:** ***A*** - DBSpace backup thread; ***B*** - Begin work; ***P*** - Preparing or prepared; ***X*** - XA prepare; ***C*** - Committing or committed; ***R*** - Aborting or aborted; ***H*** - Heuristic aborting or aborted. **Position 4:** ***P*** - Primary thread for a session. **Position 5:** ***R*** - Reading (RSAM call); ***X*** - Critical write. **Position 7:** ***B*** - B-tree clean thread; ***C*** - Terminated user thread waiting for cleanup; ***D*** - Daemon thread; ***F*** - Page cleaner thread (flusher); ***M*** - On-Monitor thread. |
| Waiting On **\*** | The address of the resource for which this session thread is waiting. |
| Wait Time Remaining(s) **\*** | The number of seconds remaining from a call to `SET LOCK MODE TO WAIT n`. ***0*** - The thread is not waiting on a lock. ***-1*** - The thread is waiting indefinitely. |
| Locks held **\*** | The number of locks currently held by this user thread. |
| Number of Reads **\*** | The number of disk reads executed by the user thread. |
| Number of Writes **\*** | The number of disk writes executed by the user thread. |
| Teletype terminal **\*** | The tty the user is using. |
| **I/O and Buffer Activity** |  |
| Session ID | A unique identifier assigned to the session. |
| Read Operations | The total number of read operations performed during the session. |
| Write Operations | The total number of write operations performed during the session. |
| Re-Write Operations | The total number of re-write operations performed during the session. |
| Delete Operations | The total number of delete operations performed during the session. |
| Page Reads | The total number of database pages read during the session. |
| Page Writes | The total number of database pages written during the session. |
| Buffer Reads | The total number of buffer read operations performed during the session. |
| Buffer Writes | The total number of buffer write operations performed during the session. |
| Buffer Cache Hit Ratio (%) | Indicates the percentage of data page reads served from the memory instead of disk, displaying the overall cache efficiency (in %). |
| **Lock Details by SQL Queries** |  |
| Session ID | A unique identifier assigned to the session. |
| Row ID | The unique identifier of the specific row involved in the lock operation. |
| Process ID | The unique identifier of the process associated with the session. |
| Database Name | The name of the database where the lock has been applied. |
| Table Name | The name of the table on which the lock has been placed. |
| Lock Type | The type of lock applied on the database object (e.g., shared, exclusive). |
| Lock Request | The type of lock requested by the session or process. |
| Locks Held | The total number of locks currently held by the session or process. |
| Locks Wait | The number of locks for which the session is currently waiting. |
| Dead Locks | The number of deadlock occurrences detected for the session. |
| Locks Timeout | The number of lock requests that have timed out due to unavailability of resources. |
| **Lock Details by Command Line** |  |
| Database Name **\*** | The name of the database where the lock has been applied. |
| Table Owner **\*** | The owner of the table on which the lock is currently held. |
| Table Name **\*** | The name of the table on which the lock has been placed. |
| Lock Owner **\*** | The address corresponding to the user thread that holds this lock. If the address is in parentheses, it indicates a two-phase commit transaction branch that does not have an associated thread. |
| Lock Type **\*** | The type of lock applied on the database object (e.g., shared, exclusive). |
| Lock Address **\*** | The in-memory address of the lock structure. |
| Table Space Number **\*** | The tablespace number for the item that is locked. |
| Wait List **\*** | The address of the first userthread waiting for this lock. |
| Lock List **\*** | The address of the next lock owned by this userthread. A zero indicates the end of the list. |
| Row ID **\*** | The unique identifier of the specific row involved in the lock operation. |
| Key#/BSize **\*** | The index key number or the number of bytes locked for a VARCHAR. |
| DML **\*** | Shows the type of DML operation associated with the lock, along with the table on which it is held. |
| **SQL Session Details** |  |
| Session ID **\*** | A unique identifier assigned to the session. |
| Database Name **\*** | The name of the database to which this session is connected or in which the lock is applied. |
| SQL Statement Type **\*** | The type of SQL statement that this session is currently running. |
| Isolation level **\*** | The current isolation level of the session, such as Dirty Read, Committed Read, Cursor Stability, Last Committed, Repeatable Read, or Database Without Transactions. |
| Lock Mode **\*** | The current setting for the SET LOCK MODE statement for this session. |
| Front End Version **\*** | The version of the front-end application currently connected to Informix. |
| Explain **\*** | The `SET EXPLAIN` setting. |
| SQL Error **\*** | The SQL error, if any, for the last statement executed. |
| ISAM Error **\*** | The ISAM error, if any, for the last statement executed. |
| **Thread CPU Details** |  |
| Thread Name **\*** | The name of the thread. |
| Thread ID **\*** | The thread id incrementally assigned by OnLine. |
| Thread Status **\*** | The current status of the thread, including important thread states. |
| Thread Control Block **\*** | The in-memory address of the thread control block. |
| RSAM Thread Control Block **\*** | The in-memory address of the RSAM thread control block. |
| Priority **\*** | The internal priority of the thread. |
| Virtual Processor Class **\*** | The VP class and number on which the thread is running. |

### Transaction & Logs

| Parameter | Description |
|---|---|
| **Transaction Details** |  |
| Session ID **\*** | A unique identifier assigned to the session. |
| Total Commits | The total number of commit operations executed during the session. |
| Total Rollbacks | The total number of rollback operations executed during the session. |
| Commit Ratio | The ratio of successful commit operations to total transactions (in %). |
| Long Running Transactions | The total number of transactions that have been running longer than the expected duration. |
| Total Log Records | The total number of log records generated during the session. |
| Used Logical Log Space (MB) | The amount of logical log space currently utilized (in MB). |
| Total Logical Log Space (MB) | The total available logical log space (in MB). |
| Logical Log Space Usage (%) | The percentage of logical log space utilized by the session (in %). |
| **LOGICAL VS PHYSICAL LOGS FLUSHED** |  |
| Physical Logs Flushed | The total number of flushed physical logs. |
| Logical Logs Flushed | The total number of flushed logical logs. |
| **PAGE WRITES TO LOGICAL VS PHYSICAL LOSS** |  |
| Page Writes to Physical Log Buffer | The number of pages written to the physical log buffer during transactions. |
| Page Writes to Logical Log Buffer | The number of pages written to the logical log buffer to record transaction details. |
| **Log Details** |  |
| Log Number | The unique sequence number assigned to the log file. |
| Log ID | The unique identifier of the specific log entry or file. |
| Address **\*** | The in-memory address of the log. |
| Physical Address **\*** | The physical address of the log on disk. |
| Flags **\*** | Describes the status of the Logical Log. **Position 1:** ***A*** - Newly added; ***F*** - Free log; ***U*** - Used log. **Position 2:** Level 0 backup protection - Prevents log overwrites during Level 0 backups; ***G*** - Staged for Enterprise Replication; ***R*** - Not needed by the currently active archive; ***W*** - Records are currently being flushed to this log; ***X*** - Still needed by an active archive; ***Z*** - Will be cleared before use. **Position 3:** ***B*** - Backed up. **Position 5:** ***C*** - Currently active log. **Position 7:** ***L*** - Contains the last checkpoint record. |
| Total Log Pages | The total number of pages available in the log file. |
| Used Log Pages | The number of log pages currently used for recording transactions. |
| Utilized Log Pages (%) | The percentage of log pages utilized within the log file (in %). |
| Logs Fill Time | The time taken to fill the log file with transaction data. |
| Chunk Number | The identifier of the chunk where the log data is stored. |
| Offset | The starting point or position of the log within the chunk. |
| **Physical Log** |  |
| Buffer **\*** | Of the two physical log buffers in memory, the one that is currently in use. |
| Begin **\*** | The physical address identifying the location of the Physical Log on disk. |
| Size(pages) **\*** | The size of the Physical Log in pages as defined by the PHYSFILE parameter in the configuration file. |
| Position(pages) **\*** | The offset into the Physical Log in pages where the next buffer write will occur. |
| Log Used(pages) **\*** | The number of pages used in the Physical Log. |
| Log Used(%) **\*** | The percentage of the Physical Log that is full, calculated as (phyused / physize) * 100.0. |
| **Physical Log Buffer** |  |
| Buffer **\*** | Of the two physical log buffers in memory, the one that is currently in use. |
| Buffer Used(pages) **\*** | The number of buffer pages currently used. |
| Buffer Size(pages) **\*** | The total configured buffer capacity. |
| Buffer Used (%) **\*** | The physical log buffer utilization (in %). |
| Number of pages **\*** | The number of pages processed in physical log buffer statistics. |
| Number of Writes **\*** | The number of write operations in physical log buffer statistics. |
| Pages per I/O **\*** | The average number of pages per I/O operation for the physical log buffer. |
| **Logical Log** |  |
| Subsystem **\*** | The type of log subsystem used under the Extensible Log Manager. Possible values are: ***OLDRSAM*** - The legacy RSAM subsystem; ***RSAM*** - The RSAM subsystem; ***SBLOB*** - The smart large object subsystem; ***RTREE*** - The R-tree subsystem. |
| Number of Records **\*** | The number of records of this subsystem type written to the logical logs. |
| Log Space used(MB) **\*** | The total amount of log space used by this subsystem (in MB). |
| **Logical Log Buffer** |  |
| Buffer **\*** | Of the three logical log buffers in memory, the one that is currently in use. |
| Buffer Used(pages) **\*** | The number of pages written to the logical log buffers since initialization or `onstat -z`. |
| Buffer Size(pages) **\*** | The size of the buffer in pages as identified by the **LOGBUFF** parameter in the configuration file. |
| Buffer Used(%) **\*** | The logical log buffer utilization (in %). |
| Number of Records **\*** | The number of logical log records written to the logical log buffers since initialization or `onstat -z`. |
| Number of pages **\*** | The number of pages used to hold logical log records. |
| Number of Writes **\*** | The number of logical records written to the logical log buffers since initialization or `onstat -z`. |
| Records per Page **\*** | The average number of logical log records per page. |
| Pages per I/O **\*** | The average number of pages written to the logical log, expressed as **numpages / numwrites**. |
| **CHECKPOINT SUMMARY** |  |
| Max Diskflush Time **\*** | The maximum disk flush time observed during checkpoint processing. |
| Blocked Time **\*** | The time blocked during checkpoint progression. |
| Max Plog Pages/Sec **\*** | The peak physical log pages written per second during checkpoint activity. |
| Max Llog Pages/Sec **\*** | The peak logical log pages written per second during checkpoint activity. |
| Avg Dskflush Pages/Sec **\*** | The average number of pages flushed to disk per second during checkpoint processing. |
| Avg Dirty Pages/Sec **\*** | The average number of dirty pages handled per second during the checkpoint window. |
| **Checkpoint History** |  |
| Checkpoint Clock Interval **\*** | The checkpoint interval index or marker. |
| Clock Time **\*** | The checkpoint event time. |
| Clock Trigger **\*** | The trigger reason or type for the checkpoint. |
| Clock LSN **\*** | The logical sequence number associated with the checkpoint. |
| Critical Total Time(s) **\*** | The total time spent in the checkpoint critical phase. |
| Critical Flush Time(s) **\*** | The flush time inside the critical checkpoint phase. |
| Critical Block Time(s) **\*** | The blocked duration inside the critical checkpoint phase. |
| Critical Waits **\*** | The number of wait events in the critical checkpoint phase. |
| Critical Checkpoint Time(s) **\*** | The checkpoint-specific critical section duration. |
| Critical Wait Time(s) **\*** | The cumulative wait time in the critical phase. |
| Critical Long Time(s) **\*** | The longest critical delay or time slice observed. |
| Dirty Buffers **\*** | The dirty-buffer count at checkpoint observation time. |
| Dskflush/Sec(pages/s) **\*** | The disk flush throughput per second. |
| Physical Log Total Pages **\*** | The total physical-log pages counted for the checkpoint sample. |
| Physical Log Avg/Sec(pages/s) **\*** | The average physical-log page rate per second. |
| Logical Log Total Pages **\*** | The total logical-log pages used in the checkpoint sample. |
| Logical Log Avg/Sec(pages/s) **\*** | The average logical-log page rate per second. |

### Storage & Memory

| Parameter | Description |
|---|---|
| **Chunk Details** |  |
| Chunk Path | The file system path where the chunk is located. |
| Chunk Address **\*** | The in-memory address of the chunk structure. |
| DBSpace Name | The name of the Database Space (DBSpace) to which the chunk belongs. |
| Chunk Number | The unique identifier assigned to the chunk within the database space. |
| Chunk Offset **\*** | The offset of the chunk within its associated storage structure. |
| Chunk Size (MB) | The total size of the chunk (in MB). |
| Free Chunk Size (MB) | The amount of free space available in the chunk (in MB). |
| Chunk Utilization (%) | The percentage of space utilized within the chunk (in %). |
| Page Size (KB) | The size of each page within the chunk (in KB). |
| Free Pages | The total number of free pages available in the chunk. |
| Free Pages (%) | The percentage of pages available as free space within the chunk (in %). |
| BLOB Pages **\*** | The number of pages used to store BLOB data. |
| Chunk Flags | The flags indicating specific properties or status details of the chunk. |
| Chunk Status | The current operational status of the chunk. |
| **DEAD LOCK** |  |
| Dead Locks | The total number of Dead Locks that occurred during the poll interval. |
| **BUFFER & MEMORY I/O** |  |
| Buffer Waits | The total number of Buffer Waits that occurred during the poll interval. |
| Buffer Reads | The total number of Buffer Reads that occurred during the poll interval. |
| Buffer Writes | The total number of Buffer Writes that occurred during the poll interval. |
| **DISK I/O** |  |
| Disk Reads | The total number of Disk Reads that occurred during the poll interval. |
| Disk Writes | The total number of Disk Writes that occurred during the poll interval. |
| **PAGE I/O** |  |
| Page Reads | The total number of Page Reads that occurred during the poll interval. |
| Page Writes | The total number of Page Writes that occurred during the poll interval. |
| **SCAN & SORT** |  |
| Sequential Scans | The total number of Sequential Scans that occurred during the poll interval. |
| Total Sorts | The total number of sorts that occurred during the poll interval. |

### CPU & Processing

| Parameter | Description |
|---|---|
| **CPU Details** |  |
| Virtual Processor ID | The unique identifier assigned to the virtual processor. |
| Virtual Processor Type | The type or category of the virtual processor (e.g., CPU, AIO, or network). |
| User CPU Time (sec) | The total amount of CPU time spent executing user-level processes (in seconds). |
| System CPU Time (sec) | The total amount of CPU time spent executing system-level operations (in seconds). |
| **Scan and Sorting Activity** |  |
| Session ID **\*** | A unique identifier assigned to the session. |
| Sequential Scans | The total number of sequential scan operations performed during the session. |
| Total Sorts | The total number of sort operations executed during the session. |
| Disk Sorts | The total number of sort operations that required disk usage. |
| Disk Sort Ratio | The ratio of disk-based sorts to total sorts (in %). |
| Max Disk Space (KB) | The maximum disk space utilized for sort operations (in KB). |

### IPC

| Parameter | Description |
|---|---|
| **Interprocess Communication Facility** |  |
| Segment Address | The memory address where the segment is located. |
| Class | The category or type of the memory segment (e.g., data, index, temp). |
| User ID | The unique identifier of the user owning the segment. |
| Process ID **\*** | The unique identifier of the process associated with the segment. |
| OS ID | The operating system identifier linked to the process using the segment. |
| Total Size (MB) | The total size of the memory segment (in MB). |
| Used Blocks | The number of memory blocks currently in use within the segment. |
| Free Blocks | The number of memory blocks available for use within the segment. |
| Used Blocks (%) | The percentage of memory blocks utilized within the segment (in %). |
| **Message Queues** |  |
| Message Queue ID **\*** | Kernel ID of the message queue. |
| Owner **\*** | The operating system user that owns the message queue. |
| Key **\*** | The IPC key used to create the queue. `0x0` indicates a private key. |
| Used Bytes **\*** | The number of bytes currently occupied by messages waiting in the queue. |
| Permission **\*** | Specifies the Unix access mode and the read/write permissions for the queue. |
| **Shared Memory** |  |
| Shared Memory ID **\*** | The kernel ID of the shared memory segment. |
| Owner **\*** | The operating system user that owns the segment. |
| Key **\*** | The IPC key used to create the segment. `0x0` indicates a private key. |
| Permission **\*** | Specifies the Unix access mode and the read/write permissions for the segment. |
| Bytes(MB) **\*** | The size of the segment (in MB). |
| Attached Processes **\*** | The number of processes currently using the segment. |
| Status **\*** | Indicates the segment state. `dest` means that the segment is marked for removal when it is detached for the last time. |
| **Semaphores** |  |
| Semaphore ID **\*** | The kernel ID of the semaphore set. |
| Owner **\*** | The operating system user that owns the semaphore set. |
| Key **\*** | The IPC key used to create the semaphore set. `0x0` indicates a private key. |
| Permission **\*** | Specifies the Unix access mode and the read/write permissions for the semaphore set. |
| Semaphore Count **\*** | The number of semaphores grouped under this ID. |

### Replication

| Parameter | Description |
|---|---|
| **Replication Configuration** |  |
| Type | The replication type configured for the server, such as SDS, RSS, or HDR. |
| State | The current operational state of the replication server. |
| Paired Server **\*** | The name or address of the server paired with this replication server. |
| Last DR Checkpoint ID **\*** | The identifier of the most recent disaster recovery checkpoint. |
| Last DR Checkpoint Page **\*** | The page number of the most recent disaster recovery checkpoint. |
| Supports Proxy Writes **\*** | Indicates whether proxy writes are supported by the replication server. |
| Replication Poll Interval(s) **\*** | The interval at which the server performs replication checks (in seconds). |
| Replication Timeout(s) **\*** | The maximum wait time before a replication operation is considered failed (in seconds). |
| Auto-Recovery for DR **\*** | Indicates whether automatic recovery for disaster recovery is enabled. |
| DR Lost-and-Found File Path **\*** | The file system path where lost-and-found data for disaster recovery is stored. |
| Automatic Index Replication/Rebuild **\*** | Indicates whether automatic index replication or rebuild is enabled. |
| HDR Replication Encryption Enabled **\*** | Indicates whether encryption is enabled for HDR replication. |
| Backlog(pages) **\*** | The number of replication backlog pages waiting to be processed. |
| **RS SECONDARY SERVER INFORMATION** |  |
| Local Server Type **\*** | The type of the local replication server. |
| Index Page Logging Status **\*** | The current status of index page logging. |
| Number of RSS Servers **\*** | The number of RSS servers configured for replication. |
| **HDA Details** |  |
| Name | The name of the High-Availability server. |
| Type **\*** | The replication type configured for the server (SDS, RSS, HDR). |
| State **\*** | The current operational status of the replication server. Possible values are: ***inactive*** - Replication is not active; ***active*** - Replication is active. |
| Time Interval (sec) | The time interval at which the server performs replication checks (in seconds). |
| Timeout (sec) | The maximum wait time before the operation is considered failed (in seconds). |
| Automative Failover | Indicates whether automatic failover is enabled for the server. |
| Auto Index Rebuild | Specifies whether index auto-rebuild is enabled for the server. |
| Directory | The directory path where the lost-found data for the replication server is stored. |

### Backup & Restore

| Parameter | Description |
|---|---|
| **Backup / Restore Information** |  |
| Action ID | The unique identifier assigned to each backup or restore action. |
| Action Type | The type of action performed. Possible values are: ***Backup*** - Creates a backup; ***Restore*** - Restores data from a backup; ***Verify*** - Verifies the backup or restore operation. |
| Object ID | The identifier of the database object on which the action was executed. |
| Action Status | The current status of the action. Possible values are: ***Success*** - The action completed successfully; ***Failed*** - The action did not complete successfully; ***In Progress*** - The action is currently running. |
| Action Start Time | The timestamp indicating when the action began. |
| Action End Time | The timestamp indicating when the action completed. |

### System

| Parameter | Description |
|---|---|
| **SYSTEM LOAD DETAILS** |  |
| System Load 1 min **\*** | The average system load over the last 1 minute. |
| System Load 5 min **\*** | The average system load over the last 5 minutes. |
| System Load 15 min **\*** | The average system load over the last 15 minutes. |
| System Users **\*** | The number of users currently logged in to the operating system. |
| **Disk Space Details** |  |
| Mount Path **\*** | The directory where the filesystem is mounted and accessible. |
| Filesystem **\*** | The filesystem device or type associated with the mount point. |
| Disk Space 1K Blocks(GB) **\*** | The total size of usable space in the file system, measured in 1K blocks and GB. |
| Disk Space Used(GB) **\*** | The amount of space used (in GB). |
| Disk Space Available(GB) **\*** | The amount of space available for use (in GB). |
| Used % **\*** | The number of pages used in the Physical Log. |

### Configuration

| Parameter | Description |
|---|---|
| **CONFIGURATION DETAILS** |  |
| Informix Version **\*** | The installed version of the Informix server. |
| Shared Memory Server Number | The identifier number assigned to the shared memory server instance. |
| Message Log File Path | The file system path where the database server’s message log is stored. |
| Log Files | The list or count of log files used by the Informix server. |
| Logical Log Size | The total size allocated for logical logs (in MB). |
| Physical Log Size | The total size allocated for physical logs (in MB). |
| Tape Device Path | The path to the tape device used for database backups. |
| Log Tape Device Path | The path to the tape device used specifically for storing log backups. |
| Bar Activity Log Path | The path where the Backup and Restore (BAR) activity log is stored. |
| Root Path | The file system path of the root chunk of the database server. |
| Root Size | The total size of the root chunk (in MB). |
| Temporary DBSpace Name | The name of the temporary DBSpace used for temporary tables and sorting operations. |
| Total Shared Memory Size | The total amount of shared memory allocated to the Informix server (in MB). |
| Auto Recovery Setting | Indicates whether automatic recovery is enabled for the server. |
| HDR Log Shipping Interval | The interval at which log data is shipped to the HDR secondary server (in seconds). |
| HDR/SDR Timeout | The timeout duration for HDR or SDR connections (in seconds). |
| Diagnostic Log Path | The file system path where the diagnostic log files are stored. |
| Audit Mode **\*** | Current audit operating mode configured on the server. |
| Audit Error Handling **\*** | Current audit error handling state/result. |
| Audit File Path **\*** | Filesystem path used by the audit subsystem. |
| Audit File Size Limit **\*** | Configured or observed audit file size threshold. |
| Audit File Count **\*** | Audit file status/counter returned by monitor command output. |
| Audit Rows **\*** | Audit row/event counter from audit subsystem output. |
| Auditing Status **\*** | Whether server-side auditing is enabled. |
| Database Single Sign-On audit status **\*** | Audit setting/state for DBSSO. |
| Database Security Administrator audit status **\*** | Audit setting/state for DBSA. |
| Audit-to-Syslog Identifier **\*** | Specifies the ASL syslog tag or identifier. |
| Audit-to-Syslog Options **\*** | Active ASL forwarding options. |
| Audit-to-Syslog Facility **\*** | Syslog facility used for ASL output. |
| Audit-to-Syslog Priority **\*** | Syslog/event priority used for ASL output. |
| Audit-to-Syslog Enabled **\*** | Whether audit-to-syslog forwarding is enabled. |