Database Administration

Available in AQT Extended

This feature and a few others are available only with an Extended Edition license

Use the Administration Component to:

  • create, alter and drop database objects such as tables, indexes, tablespaces, functions, stored procedures.
  • run various admin actions against your objects (such as Rename, Runstats, Analyze)
  • generate full DDL for your objects (not just tables, but also tablespaces, triggers, procedures, etc).
  • manage security for your objects with the comprehensive security helper

As elsewhere in AQT, the Admin Component is driven entirely from configuration files. These define the structure of your database objects, and the actions that can be performed on them. This design has allowed us to configure the Admin Component for a large number of database types, and it allows you to define your own admin functions for any particular requirements.

The Admin component has been configured for Oracle, DB2 for LUW, DB2 for z/OS, DB2 for iSeries, Sybase ASE, Sybase Anywhere, Sybase IQ, SQL Server, MySQL, Informix, Pervasive.SQL, PostgreSQL, MS Access, SQLite, Ingres and SQLBase.

Create Table

This is an example of Create Table window for DB2 for LUW.

Creating a Table

Alter Table

AQT makes it very easy to alter a table, as demonstrated by the following example:

  • as you make changes, they are highlighted in yellow.
  • clicking on Preview will show you the SQL which AQT will run to alter the table
  • clicking on Run will apply the changes. If any of the changes fail, the values will remain highlighted in yellow for you to correct or cancel.
Altering a Table

Define other Objects

You can define a lot more than just tables. This screenshot shows creation of a foreign key.

Creating a Foreign Key Relationship

Creating a Stored Procedure

AQT is also able to create and alter Stored Procedures. Plus Triggers, Functions.

Creating a Stored Procedure

Actions Against Objects

You can run various actions against multiple objects. This example will change the comments of your tables. Many other functions have been defined.

Commenting multiple tables on a single window

Generate DDL

AQT has a comprehensive DDL Generator

  • Tables DDL can include primary key, indexes, foreign keys, check-constraints, triggers, dependent views and aliases, grant statements.
  • AQT generates well-formatted and readable DDL.
  • AQT can also generate DDL for other objects, such as tablespaces, bufferpools, stored procedures, functions.
  • You can generate the DDL for all objects in a schema in a single action.
  • You can generate the DDL to the window, or to a file, or to a separate file for each object.
  • You can generate DDL for another database type. For instance, you can generate DB2 for LUW using Oracle syntax. This is useful if you are migrating objects between different database types.
AQT's DDL Generator