Skip to main content

Informix

Pre-requisites​

Check the supported versions​

DBmarlin supports versions of Informix from 14.10 and above. Please check the list of supported platforms before continuing and contact us if you are not sure.

Create a monitoring user with the correct permissions​

Before adding a target Informix instance in the UI you should first create a dbmarlin user in the target database instance. Note you can choose to use a name other than dbmarlin if you prefer.

For Informix you can create a monitoring user at the operating system level as you would normally for Informix and then grant the following:

GRANT SELECT ON informix.sysfeatures TO dbmarlin;
GRANT SELECT ON informix.syssessions TO dbmarlin;
GRANT SELECT ON informix.sysrstcb TO dbmarlin;
GRANT SELECT ON informix.systcblst TO dbmarlin;
GRANT SELECT ON informix.syssqlstat TO dbmarlin;
GRANT SELECT ON informix.sysprofile TO dbmarlin;
GRANT SELECT ON informix.sysconfig TO dbmarlin;
GRANT SELECT ON informix.sysdatabases TO dbmarlin;
GRANT SELECT ON informix.syssqltrace TO dbmarlin;
GRANT SELECT ON informix.syssscelem TO dbmarlin;

Adding the Database Target​

This is done through the User Interface using the Add Database screen