Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
InformixHQ GuideInformixHQ is a modern web console for visualizing, monitoring, and managing your Informix server instances. It is purpose built for ease-of-use, scaling out, and optimizing DevOps needs. It provides critical performance management capabilities, monitoring how key performance metrics are changing over time and tracking how efficiently Informix is running your workload even when you’ve stepped away from your screen. Its monitoring system feeds directly into a customizable alerting system so you can be immediately alerted via email, Twilio, or PagerDuty whenever an issue occurs on one of your Informix database server instances. InformixHQ is designed to be scalable to efficiently manage and monitor as many Informix database server instances as you need. Moreover, it's a tool that can be shared by the DBAs, the app developers, the ops engineers, and management and accessed from any desktop, laptop, or mobile device. InformixHQ is the centralized hub for graphical monitoring, alerting, and administration of your Informix database servers.
InformixHQ Server
InformixHQ UI
Schema Manager
SQL Editor

SQL Editor

Why use the SQL Editor?

The SQL editor allows user to run Structured Query Language (SQL) statements in a InformixHQ for the Informix database server. User may use SQL editor to retrieve, create, change, or delete data in a database, if user has database permissions to perform these actions. In short, it creates a way for managing and manipulating data in the database.

Note: SQL Editor supports single query execution only. Execution of multiple queries and other editor features will be considered for forthcoming releases.

How to use the SQL Editor?

Follow the steps given below to navigate to the SQL editor:

Select server in informixHQ on which you have to run SQL query.
Select Schema Manager from side menu.
Once user clicks on Schema Manager menu, Schema Manager page shows below tabs:
1. Info : Tab will show all the details (Properties) for selected database & table.
2. SQL Editor : Tab allows user to run SQL query for selected database & table.

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.