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