What's new in AQT v8.2

System Monitor

The most significant change is the System Monitor. This allows you to display active tasks and other internal information for DB2/UDB, Oracle, Sybase and SQL Server. It can be invoked from the Database Explorer window with Tools > System Monitor.

Admin System

There have been a lot of changes to the Admin system.

• You can now have multiple admin windows open at the same time - eg. you can have a Create Table window open at the same time as displaying the Properties of another table. This wasn't possible in AQT v8.1.
• The Create Procedure window for Oracle and DB2/UDB now has the Parameters on a separate tab.
• AQT now allows you to create a partitioned table (for Oracle and DB2 z/OS).
• The Create window now has a button Replace if exists. This allows you to create then replace an existing object. Previously, once you had created an object you had to exit the window then go into Alter mode. This feature is not available for Tables.
• When using the Copy From button on the Create Table window, AQT will ask you whether you want to copy the definition of the indexes, keys etc, or just the base table definition.
• If you decide to customize the admin component, you can hold your customizations in a separate cfg file (xxxx_adm_usr.cfg). This prevents the problem of your customizations being overwritten when we deploy new versions of the cfg files. This change is useful for the System Monitor feature, as it is expected that this would commonly be customized by users.
• You will no longer get the message "Insufficient Storage" if you try to open too many admin windows. We have redesigned the admin system so that this problem will no longer happen.

Other New Features

• Query Explorer. In the Database Explorer window, you can display all your Queries (click on View > Queries), rather than your Database Objects. This makes it easy to view and run your saved queries. The Query Explorer will also display your saved-results.
• You can now have a Saved Query or Saved Result as a Favorite.
• In the Data Display window, you can right-click a value and select Only show rows with this value or Exclude rows with this value. This makes it very quick to display the data you are interested in.
• AQT should now correctly set the maximum number of rows to be returned by a query. We have discovered that AQT was not setting this correctly. As a result, the options "For DB2, add FETCH FIRST X ROWS clause" and "For Sybase and SQL Server, use SET ROWCOUNT" options are no longer needed.
• You can now define a connection as being auto-connect when AQT starts.
• The Build Where Clause window has CONTAINS and STARTS WITH operators. This makes it easier to build string searches.
• AQT will now display up to 100,000 bytes of a large column (after this, you should use the LOB Options).