Informix Database

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

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)

2. 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)

3. 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.

7. Click ADD on the Informix Database tile.
8. From the Configurations page, click + ADD. The Add Configuration page appears.
9. Enter the below mentioned BASIC INFORMATION:

        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"
            }
          ]
        }
    

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

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.

10. Select the below mentioned Custom Attribute:

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).

11. 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.

12. In the DISCOVERY SCHEDULE section, select Recurrence Pattern to add one of the following patterns:

    • Minutes
    • Hourly
    • Daily
    • Weekly
    • Monthly

13. 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.

13. 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.

14. Click NEXT.

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

16. Select an existing registered profile.

17. 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

• See Modify an Installed Integration or Application article.

  Note: Select the Informix Database application.

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

Supported Alert Custom Macros

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

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.

Version History