Adding Servers and Groups

After logging in to InformixHQ for the very first time, you will be taken to a group dashboard for the root group. This dashboard will initially contain zero servers and zero groups.

Your first step will likely be to add servers and groups. Click the Add Server button to add connection information for your Informix database server instances.

When adding a server to InformixHQ, you can provide two sets of credentials. The monitoring credentials are used by the InformixHQ server whenever a user navigates to any part of the UI that issues a REST query which needs to gather data from the live Informix database server instance. The admin credentials are used whenever a user in the UI requests that an administration action be performed on the database server, for example create a dbspace or edit an onconfig parameter.

Required privileges for the monitoring user
  • CONNECT access to sysmaster
Optional privileges for the monitoring user
  • CONNECT access to the sysadmin database
  • select privileges on the sysconblock, syssqltrace, syssqltrace_info, syssqltrace_hvar, and syssqltrace_iter tables in the sysmaster database.
  • select privileges on the ph_task, ph_run, ph_alert, ph_threshold, ph_bg_jobs, and ph_bg_jobs_results tables in the sysadmin database.
Note: Providing these optional privileges to the monitoring user enables the UI to show information about the server's the storage pool, sql tracing, auto update statistics, and scheduler tasks.
Required privileges for the admin user
  • Part of the DBSA group
  • CONNECT access to the sysadmin database
  • Privilege to run SQL Admin API commands

It is required that you provide monitoring credentials when adding your Informix database server information to InformixHQ. Admin credentials need only be provided if you want to use InformixHQ to run administrative actions on your database server or if you want the InformixHQ server to automatically deploy your agents.

From the dashboard, you can also click the Add Group button to create groups of servers to make it easier to monitor and manage multiple servers.

Copyright© 2018 HCL Technologies Limited