What's new in InformixHQ

What's new in InformixHQ 3.0.3

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.