Supported Target Versions
IBM Informix 14.10

Application Version Details

Application VersionBug fixes / Enhancements
2.0.0Conversion of SDK 1.0 into SDK 2.0.

Introduction

IBM® Informix® is a fast and scalable database server that manages traditional relational, object-relational, and dimensional databases. Its small footprint and self-managing capabilities are suited to embedded data-management solutions.

The IBM Informix database server runs on UNIX, Linux, Mac OS X, and Windows operating systems. It supports 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.

Prerequisites

  • Classic gateway version should be 14.0.0 and above.
  • Nextgen gateway version should be 14.0.0 and above.
    Note: OpsRamp recommends using the latest Gateway version for full coverage of recent bug fixes, enhancements, etc
    • Remote machine user credentials should have the administrator/root level access.

    • Server path in configuration is JSON field, need to provide the payload in below format:

      Server Path
          server path :
      {
        "informixServers": [
          {
            "serverName": "ol_informix1410",
            "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\ol_informix1410.cmd"
          },
          {
            "serverName": "test",
            "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\test.cmd"
          },
          {
            "serverName": "sample",
            "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\sample.cmd"
          }
        ]
      }

Application Migration

  1. Check for the gateway version as a prerequisite step - classic gateway-12.0.1 and above.
    Notes:

    • You only have to follow these steps when you want to migrate from sdk 1.0 to sdk 2.0.
    • For the first time installation below steps are not required.
  2. Disable all configurations associated with sdk 1.0 adaptor integration application.

  3. Install and Add the configuration to that sdk 2.0 application.
    Note: refer to Configure and Install the Informix Database Integration & View the Informix Database Details sections of this document.

  4. Once all discoveries are completed with the sdk 2.0 application, follow any one of the approaches.

    • Direct uninstallation of the sdk 1.0 adaptor application through the uninstall API with skipDeleteResources=true in the post request

      End-Point: https://{{host}}/api/v2/tenants/{tenantId}/integrations/installed/{installedIntgId}

      Request Body:
          {
          "uninstallReason": "Test",
          "skipDeleteResources": true
          }


      (OR)

    • Delete the configuration one by one through the Delete adaptor config API with the request parameter as skipDeleteResources=true

      End-Point: https://{{host}}/api/v2/tenants/{tenantId}/integrations/installed/config/{configId}?skipDeleteResources=true.

    • Finally, uninstall the adaptor application through API with skipDeleteResources=true in the post request.

      End-Point: https://{{host}}/api/v2/tenants/{tenantId}/integrations/installed/{installedIntgId}

      Request Body:
          {
          "uninstallReason": "Test",
          "skipDeleteResources": true
           }

Supported Metrics

Click here to view the supported metrics
Native TypeMetric NameMetric Display NameUnitsApplication VersionDescription
Informix DB ServerInformix_server_startupInformix server startupms1.0.0Monitors the Database Server Uptime
Informix_check_dbaliveInformix check dbalive1.0.0Monitors the Informix Availability
Informix_virtual_cpu_systemInformix virtual CPU systemmicrosec1.0.0Monitors the Informix virtual CPU system Time
Informix_virtual_cpu_userInformix virtual CPU usermicrosec1.0.0Monitors the Informix virtual CPU user Time
Informix_dbsize_size_mbInformix dbsize size mbMB1.0.0Monitors the Informix Free Dbspace Space
Informix_dbsize_size_pctInformix dbsize size pct%1.0.0Monitors the Informix Free Dbspace Space
Informix_database_countInformix database countcount1.0.0Monitors the Informix database count
Informix_dbspace_offlineInformix dbspace offline1.0.0Monitors the Database offline status
Informix_dbspace_inconsistentInformix dbspace inconsistent1.0.0Monitors the Database inconsistency status
Informix_lru_writesInformix lru writescount1.0.0Monitors the Informix LRU Writes
Informix_foreground_writesInformix foreground writescount1.0.0Monitors the Informix Foreground Writes
Informix_chunk_io_writeInformix chunk io writecount1.0.0Monitors the Informix Chunk I/O Writes
Informix_chunk_io_readInformix chunk io readcount1.0.0Monitors the Informix Chunk I/O Reads
Informix_deadlock_timeoutInformix deadlock timeoutcount1.0.0Monitors the Informix deadlock timeout
Informix_checkpoint_waitInformix checkpoint waitcount1.0.0Monitors the Informix checkpoint wait
Informix_lock_waitInformix lock waitcount1.0.0Monitors the Informix lock waits
Informix_buffer_waitInformix buffer waitcount1.0.0Monitors the Informix Buffer Waits
Informix_latch_waitInformix latch waitcount1.0.0Monitors the Informix Latch Waits
Informix_lock_userInformix lock usercount1.0.0Monitors the Informix Thread Overflow
Informix_lock_sessionInformix lock sessioncount1.0.0Monitors the Informix Lock Overflow
Informix_buf_cachehit_ratio_writeInformix buffer cachehit ratio write%1.0.0Monitors the Informix buffer cachehit ratio write
Informix_buf_cachehit_ratio_readxInformix buffer cachehit ratio read%1.0.0Monitors the Informix buffer cachehit ratio write

Default Monitoring Configurations

Informix Database has default Global Device Management Policies, Global Templates, Global Monitors and Global metrics in OpsRamp. Users can customize these default monitoring configurations as per their business use cases by cloning respective global templates and global Device Management Policies. OpsRamp recommends doing this activity before installing the app to avoid noise alerts and data.

  1. Default Global Device Management Policies

OpsRamp has a Global Device Management Policy for each Native Type of Informix Database. You can find those Device Management Policies at Setup > Resources > Device Management Policies, search with suggested names in global scope. Each Device Management Policy follows below naming convention:

{appName nativeType - version}

Ex: ibm-informix Informix DB Server - 2 (i.e, appName = ibm-informix, nativeType = Informix DB Server, version = 2)

  1. Default Global Templates

OpsRamp has a Global template for each Native Type of Informix Database. You can find those templates at Setup > Monitoring > Templates, search with suggested names in global scope. Each template follows below naming convention :

{appName nativeType 'Template' - version}

Ex: ibm-informix Informix DB Server Template - 2 (i.e, appName = ibm-informix, nativeType = Informix DB Server, version = 2)

  1. Default Global Monitors

OpsRamp has a Global Monitors for each Native Type which has monitoring support. You can find those monitors at Setup > Monitoring > Monitors, search with suggested names in global scope. Each Monitors follows below naming convention:

{monitorKey appName nativeType - version}

Ex: ibm-informix Informix DB Server Monitor ibm-informix Informix DB Server 2(i.e, monitorKey = Informix DB Server, appName = ibm-informix, nativeType = Informix DB Server, version = 2)

Configure and Install the Informix Database Integration

  1. From All Clients, select a client.
  2. Navigate to Setup > Account.
  3. Select the Integrations and Apps tab.
  4. The Installed Integrations page, where all the installed applications are displayed. If there are no installed applications, it will navigate to the Available Integrations and Apps page.
  5. Click + ADD on the Installed Integrations page. The Available Integrations and Apps page displays all the available applications along with the newly created application with the version.
  6. Search for the application using the search option available. Alternatively, use the All Categories option to search.
  1. Click ADD on the Informix Database tile.
  2. From the Configurations page, click + ADD. The Add Configuration page appears.
  3. Enter the below mentioned BASIC INFORMATION:
FunctionalityDescription
NameEnter the name for the configuration.
Informix Database Host Name/IP AddressIP address/host name of Informix Database.
Server PathServer path information
Note: By default {"informixServers": [{"serverName":"", "serverPath":""}]} is the server path.
Below are Server Path examples
Windows

        server path : 
        {
          "informixServers": [
            {
              "serverName": "ol_informix1410",
              "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\ol_informix1410.cmd"
            },
            {
              "serverName": "test",
              "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\test.cmd"
            },
            {
              "serverName": "sample",
              "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\sample.cmd"
            }
          ]
        }
    
Linux

            server path : 
        {
          "informixServers": [
            {
              "serverName": "ol_informix1410",
              "serverPath": "/opt/IBM/Informix_Software_Bundle/ol_informix1410.ksh"
            }
          ]
        }
  

OS PlatformSelect the Operating System.
Notes:
  • Select Linux or Windows from the drop-down listbox.
  • By default Linux is selected.
Informix Database CredentialSelect the Credential from the drop-down list.

Notes:
  • Click + Add to create a credential. The ADD CREDENTIAL window is displayed. Enter the following information.
    • Name: Credential name.
    • Description: Brief description of the credential.
    • User Name: User name.
    • Password: Password.
    • Confirm Password: Confirm password.

Notes:

  • Ip Address/Host Name and Port should be accessible from Gateway.
  • Select the following:
    • App Failure Notifications: if turned on, you will be notified in case of an application failure that is, Connectivity Exception, Authentication Exception.
  1. Select the below mentioned Custom Attribute:
FunctionalityDescription
Custom AttributeSelect the custom attribute from the drop down list box.
ValueSelect the value from the drop down list box.

Note: The custom attribute that you add here will be assigned to all the resources that are created by the integration. You can add a maximum of five custom attributes (key and value pair).

  1. In the RESOURCE TYPE section, select:

    • ALL: All the existing and future resources will be discovered.
    • SELECT: You can select one or multiple resources to be discovered.
  2. In the DISCOVERY SCHEDULE section, select Recurrence Pattern to add one of the following patterns:

    • Minutes
    • Hourly
    • Daily
    • Weekly
    • Monthly
  3. Click ADD.

Now the configuration is saved and displayed on the configurations page after you save it.
Note: From the same page, you may Edit and Remove the created configuration.

  1. Under the ADVANCED SETTINGS, Select the Bypass Resource Reconciliation option, if you wish to bypass resource reconciliation when encountering the same resources discovered by multiple applications.

    Note: If two different applications provide identical discovery attributes, two separate resources will be generated with those respective attributes from the individual discoveries.

  2. Click NEXT.

  3. (Optional) Click +ADD to create a new collector by providing a name or use the pre-populated name.

Veeam
  1. Select an existing registered profile.
Veeam
  1. Click FINISH.

The application is installed and displayed on the INSTALLED INTEGRATION page. Use the search field to find the installed integration.

Modify the Configuration

View the Informix Database Details

To discover resources for Informix Database:

  1. Navigate to Infrastructure > Search > Databases > Informix Database.
  2. The Informix Database page is displayed, select the application name.
  3. The RESOURCE DETAILS page appears from the right.
  4. Click the ellipsis () on the top right and select View details.
  5. Navigate to the Attributes tab to view the discovery details.
  • Click the Metrics tab to view the metric details for Informix Database Server.

Resource Filter Input Keys

Click here to view the Supported Input Keys
Resource TypeResource Type
All TypesresourceName
hostName
aliasName
dnsName
ipAddress
macAddress
os
make
model
serialNumber
Informix DB Serverversion

Supported Alert Custom Macros

Customise the alert subject and description with below macros then it will generate alert based on customisation. Supported macros keys:

Click here to view the alert subject and description with macros

                                ${resource.name}

                                ${resource.ip}

                                ${resource.mac}

                                ${resource.os}

                                ${resource.type}

                                ${resource.make}

                                ${resource.model}

                                ${resource.serialnumber}

                                ${Custome Attributes in the resource}

Risks, Limitations & Assumptions

  • Application can handle Critical/Recovery failure notifications for below two cases when user enables App Failure Notifications in configuration:
    • Connectivity Exception
    • Authentication Exception
  • Application will send any duplicate/repeat failure alert notification for every 6 hours.
  • Using metric for monitoring the resources and generate alerts when the threshold values are breached.
  • Application cannot control monitoring pause/resume actions based on above alerts
  • Component level thresholds can be configured on each resource level.
  • No support of showing activity log and applied time.
  • Latest snapshot metric is available from gateway version 14.0.0.
  • OpsRamp provides Informix Database discovery and monitoring support for only Windows and Linux operating systems.
  • Monitoring data regarding metrics is pulled from SYSMASTER database
  • Not provided Monitoring support for Informix Database Native Type.
  • Privileges required for the monitoring user:
    • CONNECT access to the sysmaster database.
    • CONNECT access to the sysadmin database.