This extension remotely connects to your Informix instances and collects the following metrics:

Metrics

• Availability
• Sessions
• Buffer Cache Hit Ratio (Read)
• Buffer Cache Hit Ratio (Write)
• Database Used
• Scans
• Memory - Count
• Memory - Size
• Memory - Blocks Free
• Memory - Blocks Used
• Checkpoints
• CPU System
• CPU User
• Overflow - User
• Overflow - Transaction
• Overflow - Lock
• Lock Waits
• Least-recently used (LRU) writes
• Locks - Database
• Chunk - Reads
• Chunk - Writes
• Chunk - Pages Read
• Chunk - Pages Written
• Table Used Pages
• Table Scans

Requirements

• Network access from an Environment Activegate to the Informix Host
• Informix Username with permissions to run SELECT statements on the tables:
  • syscheckpoint
  • syschktab
  • sysdatabases
  • sysdbspaces
  • syslocks
  • sysmchktab
  • sysprofile
  • sysptprof
  • sysseglst
  • syssesprof
  • sysshmvals
  • systables
  • sysvpprof

The Extension must be installed both on an ActiveGate and on the Dynatrace Cluster. See Deploy an extension in our full documentation for more details.

1. Install the Extension on an Environment ActiveGate

Extract the extension zip file to the plugin_deployment folder at the root of the remote plugin module.

Linux:

• A default installation can be done with the following command: unzip -o -d /opt/dynatrace/remotepluginmodule/plugin_deployment custom.remote.python.informix.zip
• Adjust the path if the Activegate was installed somewhere other than /opt/dynatrace

Windows:

• Unzip the Extension to: %PROGRAMFILES%\dynatrace\remotepluginmodule\plugin_deployment
• Adjust the path if the Activegate was installed somewhere other than %PROGRAMFILES%\dynatrace

2. Upload the Extension to the Dynatrace Cluster via UI in the browser

Upload the same extension zip file to your tenant. The Extension configuration and upload UI is located at:

Settings > Monitored technologies > Custom extensions > Upload extension

For every Informix instance, create an endpoint under Settings > Monitored Technologies > Custom extensions > Informix

Note

We recommend monitoring up to 20 Informix endpoints on a single Activegate machine

The parameters are:

• Informix Hostname
• Informix Port
• Informix Username
  • Needs to be able to run SELECT on the tables:
  • syscheckpoint
  • syschktab
  • sysdatabases
  • sysdbspaces
  • syslocks
  • sysmchktab
  • sysprofile
  • sysptprof
  • sysseglst
  • syssesprof
  • sysshmvals
  • systables
  • sysvpprof
• Informix Password
• Informix Server (same as Instance)
• Group name – A name for the Custom Device Group that will be created for this database, something like “Production DBs”
• Custom device name – The name for the Custom Device, something that identifies this database