Working with Informix Database

This section guides you through setting up, configuring, and managing the Informix Database integration in OpsRamp.

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 example format:

  "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"
      },
      {
      "serverName": "testDemo",
      "serverPath": "C:\\Program Files\\IBM Informix Software Bundle\\testDemo.cmd"
      }
  ]
  }

The User must have CONNECT access privileges to both the sysmaster and sysadmin databases.
To rule out SSH accessability or specific failures like end device connectivity or authentication, try to establish connection with end device from gateway using below commands
- Try ping with IP Address provided in configuration ping <IP Address>.
- Try telnet using telnet <IP Address> <port>.
- Try ssh to the end device from gateway ssh <username>@<IP Address>.

Configure IBM Informix Integration

Click here to Configure and Install the IBM Informix Integration

To select your client, navigate to All Clients, and click the Client/Partner dropdown menu.
Note: You may either type your client’s name in the search bar or select your client from the list.
Navigate to Setup > Account. The Account Details screen is displayed.
Click Integrations. The Installed Integrations screen is displayed with all the installed applications.
Note
If you do not have any installed applications, you will be navigated to the Available Integrations and Apps page with all the available applications along with the newly created application with the version.
Click + ADD on the Installed Integrations page.
Note: Search for the integration either by entering the name of the integration in the search bar or by selecting the category of the integration from the All Categories dropdown list.
Click ADD in the IBM Informix application.
In the Configuration screen, click + ADD. The Add Configuration screen appears.
Enter the following BASIC INFORMATION:

Functionality	Description	Field Type
Name	Enter the name for the configuration.	String
Informix Database Host Name/IP Address	IP address/host name of Informix Database.	String
Server Path	Server path informationNote: By default `{"informixServers": [{"serverName":"", "serverPath":""}]}` is the server path. Below are Server Path examples Linux `server path : { "informixServers": [ { "serverName": "ol_informix1410", "serverPath": "/opt/IBM/Informix_Software_Bundle/ol_informix1410.ksh" } ] }`>	String
Informix Database Credential	Select 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.	Dropdown
App Failure Notifications	When selected, you will be notified in case of an application failure such as Connectivity Exception, Authentication Exception.	Checkbox

CUSTOM ATTRIBUTES: Custom attributes are the user-defined data fields or properties that can be added to the preexisting attributes to configure the integration.

Field Name	Description	Field Type
Custom Attribute	Select the custom attribute from the dropdown. You can add attributes by clicking the Add icon (+).	Dropdown
Value	Select the value from the dropdown.	Dropdown

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

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.
In the DISCOVERY SCHEDULE section, select recurrence pattern to add one of the following patterns:
- Minutes
- Hourly
- Daily
- Weekly
- Monthly
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.

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

13. Click NEXT.
14. (Optional) Click +ADD to create a new collector. You can either use the pre-populated name or give the name to your collector.
15. Select an existing registered profile.
16. Click FINISH.

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

Modify IBM Informix Integration

Click here to Modify the Configuration

See Modify an Installed Integration or Application article.

Note

Select IBM Informix.

Discover Resources in IBM Informix Integration

Click here to View the IBM Informix

Navigate to Infrastructure > Search > DATABASES > IBM Informix. The IBM Informix page is displayed.
Select the application on the IBM Informix page
The RESOURCE page appears from the right.
Click the ellipsis (…) on the top right and select View Details.

Navigate to the Attributes tab to view the discovery details.

View resource metrics

To confirm IBM Informix monitoring, review the following:

Metric graphs: A graph is plotted for each metric that is enabled in the configuration.
Alerts: Alerts are generated for metrics that are configured as defined for integration.

Click the Metrics tab to view the metric details for IBM Informix.