What's new in InformixHQ

This topic includes information about new features in InformixHQ.

What's new in InformixHQ 14.10.xC8

Administration

  • InformixHQ H2 Database migration: InformixHQ 2.0.0 (Informix Server 14.10.xC8) has upgraded its H2 Database version due to certain security vulnerabilities present in the older versions of H2 Database. Between H2 Database version 1.4.192 and the latest version 2.1.210, there have been considerable changes and direct upgrade of H2 Database is not possible. For existing users, H2 Database (InformixHQ 1.6.3 or lower) is created with version 1.4.192, hence data needs to be migrated to 2.1.210 manually.

    If users using InformixHQ 1.6.3 or lower try to move to InformixHQ 2.0.0 or above they will get an error and they will not be able to start InformixHQ until the data is migrated to the newer version of H2 Database.

    For new users who are using InformixHQ for the first time (version 2.0.0 or higher), no upgrade is needed as InformixHQ will create new H2db with the latest version.

    For more information, see H2 Database, H2 Database Migration

    Note: InformixHQ version 2.1.0 is available with the latest H2 database version 2.1.214. It is recommended to use the latest InformixHQ version.

Ease of use

  • View Agents drop-down and Shutdown button: View Agents feature in InformixHQ helps users to see consolidated view of all the agents. It displays the list of all the Agents' information and their status at one place, depending on user privilege to specific instance/server added in InformixHQ. A user can now shutdown an Agent based on user privileges using the new Shutdown button added to Informix HQ UI .

    For more information, see InformixHQ View Agents and Shutdown

  • Server Shutdown : Using the new Shutdown button is an easy way to shut down the InformixHQ server directly from the InformixHQ UI instead of command prompt.

    For more information, see InformixHQ Server Shutdown

What's new in InformixHQ 14.10.xC7

Administration

  • InformixHQ has been enhanced with HDR Secondary Operations through which InformixHQ allows or restricts certain actions on specific server types. HDR cluster consists of Primary and Secondaries. InformixHQ treats every server added as an individual server. Depending upon server type in cluster, Informix Server allows or restricts certain actions on specific server types. From 14.10.xC7 release, InformixHQ has handled all such operations on secondary servers in the cluster.

    For more information, see HDR Secondary Operations.

  • Documentation updates for starting the InformixHQ server with server.log4j.xml.

    For more information, see Starting the InformixHQ Server.

  • Documentation updates to include InformixHQ setup in secure mode (SSL).

    For more information, see InformixHQ in secure mode.

  • Documentation updates for logging in InformixHQ.

    For more information, see Logging in InformixHQ

Customization

  • Documentation updates to include Custom Reports sub-menu provided under InformixHQ UI. InformixHQ provides many built-in reports to monitor Informix server effectively. To provide further flexibility, there is an option of creating customized reports to meet specific needs of users.

    For more information, see Custom Reports

Ease of use

  • The Schema Manager has been enhanced with SQL Editor to enable user to write custom SQL and display query tree plan in the graphical format. To view execution plan, SQL tracing should be enabled on Informix Server. If it is disabled, SQL editor provides an option for easiness to enable it.

    For more information, see SQL Editor.

  • Documentation updates to include Sensors sub-menu provided under InformixHQ UI. Sensors are provided in InformixHQ to collect the data for metric which users want to monitor over a period. Once Sensor is configured, and InformixHQ agent is configured and Online, Sensor data will be collected at specified interval and stored in Repository database in Informix Server.

    For more information, see Sensors.

What's new in InformixHQ 14.10.xC6

Administration

  • The Schema Manager page has been enhanced to:
    • Create and Drop Table with advanced options

    For more information, see Schema Manager.

  • The InformixHQ server and agent now use the log4j2 library for logging. By default, the InformixHQ server and agent will log messages at INFO level to an informixhq-server.log file and an informixhq-agent.log file respectively. You can customize the logging behavior by providing a server.log4j.xml when starting the InformixHQ server or an agent.log4j.xml file when starting the InformixHQ agent in the current directory or classpath. Use these log4j2 configuration files to change the logging level (ERROR, WARN, INFO, or DEBUG), change the log file location, or enable rolling window logging.

    For more information, see ifxhq_logging_in.html .

Ease of use

  • Provision is made for the user to specify connection properties for InformixHQ agent separately.

    For more information, see InformixHQ Agent Setup.

What's new in InformixHQ 14.10.xC5

Administration

  • Enhanced to support stronger hash algorithm for passwords by adding a new config property user.password.algorithm.

    For more information, see InformixHQ Server Configuration.

Customization

  • Customized to save dashboard preferences in Custom Dashboard page

    For more information, see Custom Dashboards.

Ease of use

  • Script to start or stop the server has been enhanced to support AIX platform.

    For more information, see Getting Started.

What's new in InformixHQ 14.10.xC4

Administration

  • The Schema Manager page has been enhanced to:
    • Browse and view detailed information about database information like Stored Procedures, Sequences, User Defined Types, Data Blades
    • Browse and view detailed information about table information like Indexes, References, Constraints, Triggers
    • Create Database and Drop Database
    • Create Demo Database and Drop Demo Database
    • Create, Enable, Disable and Drop Index with advanced options

    For more information, see Schema Manager.

  • The Connection Manager page allows you to visualize and manage CM unit, SLA and FOC for any CM.

    For more information, see Connection Manager.

Ease of use

  • New script has been added to start or stop the server which is available in ${INFORMIXDIR}/HQ directory.

    For more information, see Getting Started.

What's new in InformixHQ 14.10.xC2

Administration

  • The Schema Manager page allows you to browse and view detailed information about the various tables and indexes in each of your databases.
  • The Storage > Tables and Indexes page allows you to analyze the storage characteristics of the tables and indexes in each of your databases, perform storage optimization actions such as compress, shrink, repack, defragment, and manage your automatic storage optimization policies.
  • The High Availability page makes it easy to visualize and monitor the functioning of your high availability cluster.
  • The Enterprise Replication page visualizes and provides details drill-down statistics about each Informix node participating in replication.
  • The Auto Update Statistics pages allows you to manage your automatic update statistics policies, ensuring your queries continue to run efficiently as your data changes over time.
  • The Privileges page allows you to manage privileges on your database server, including database level privileges, table level privileges, SQL Admin API privileges, and internal users.
  • The System Reports page provides a full set of detailed reports on various aspects of your database server's performance.
  • The Task Scheduler pages allows you to manage and customize tasks for your database server.
  • The Memory Manager page allow you to visualize and monitor your database server's memory usage as well as configure its Low Memory Manager configuration.
  • The Backups page has been enhanced to display a history timeline of your most recent database server backups.

Ease of use

  • Centralized user permission management, on the redesigned System Settings > User Management page, allows you to view and manage user's permissions within InformixHQ in a single place.
  • The group incidents page allows you to view all the alerting incidents that occurs on an entire group of Informix servers from one centralized page.
  • The new logging framework allows not only for a better out of the box logging experience, but also provides enhanced options for logging customization.

    For more information, see Logging in InformixHQ.

Customization

  • Build custom dashboards for a single database server or for multiple database servers, configuring what monitoring data is displayed on the dashboard and how that data is arranged and visualized. Custom dashboards allow you to define UI pages that show you the Informix monitoring data that is most important to you.

    For more information, see Custom Dashboards.

  • Create your own custom SQL sensors for monitoring your Informix instances. Any sysmaster SQL query can now be turned into a sensor that will integrate directly into InformixHQ's monitoring and alerting systems.

    For more information, see Custom SQL Sensors.

  • A new extensible alerting option allows you to define a custom script to be executed whenever an alerting incident occurs.

    For more information, see Alerting incident.