What's new in InformixHQ

What's new in InformixHQ 3.1.1

Role Management: Enhanced to create, assign, and grant roles on the Manage Privileges page.
Backup support: InformixHQ 3.1.0 supports automatic and manual backup of the H2DB.
Database utilities support: InformixHQ 3.1.0 supports database utilities (dbimport, dbexport, and dbschema) through its user interface.

PWA support: InformixHQ 3.1.0 supports Progressive Web App (PWA) installation for quick access and a seamless app-like experience.
DBspace List Enhancement: Enhanced to support the physical dbspace type, with indication of critical dbspaces in the dbspaces list.
Sensor Chart Enhancement: Sensor charts on the main page are now available for viewing in fullscreen mode.
InformixHQ server log enhancements: Enhanced to filter InformixHQ server logs by log level and server on the Monitoring Server Logs page and also displays server ID and name in InformixHQ logs for better traceability.
System Report Enhancement: Ensures consistent database filter selection and includes system catalog tables across all table reports on the System Reports page.

Default Role Handling Enhancement: Modifying a user’s privilege from CONNECT to RESOURCE will no longer delete the default role unexpectedly.

Task Cleanup Enhancement: The cleanup process now effectively deletes orphaned ph_task entries that does not have the corresponding records in command_history.
Space Usability Optimization : InformixHQ 3.0.3 has been improved to preserve the search input under Tables & Indexes when any Optimize Space option is executed, eliminating the need to re-enter the search.
Schema Manager Enhancement: InformixHQ 3.0.3 provides the ability to create an index when the database has a different owner.

Sequential scan is improved to properly populate pages when executed.
An option has been added to show or hide system tables in the Table Extents report, allowing for easier focus on user-defined tables.

SSL connection issue addressed: InformixHQ 3.0.2 addresses an Informix server SSL connection failure issue (seen with IBM Java).

Java 11 or Higher Requirement: InformixHQ 3.0.0 (both the server and agent) now mandates Java 11 or higher for proper functionality.
Account Lockout Policy: To enhance security, InformixHQ 3.0.0 now implements an account lockout policy. User accounts will be automatically locked after 5 consecutive failed login attempts.

Support for Large Tables: For Informix 15.0.0 or later, InformixHQ now supports the creation of large tables through the "Create Table" option. Additionally, users can view whether a table is categorized as SMALL or LARGE on the table information page.
Dropping Constraints: InformixHQ now provides the ability to drop constraints directly from the user interface.
Server Refresh Functionality: Users can now refresh specific servers or multiple servers simultaneously within InformixHQ. This feature allows loading the most recent information from the selected servers.