Administration Component of AQT

This feature is part of the Extended Edition of AQT.

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.

All screenshots shown are for DB2/UDB; displays will vary depending on database type.

As elsewhere in AQT, the Admin Component is driven entirely from configuration files. These define the structure of your database objects, and what actions can be performed on them. By doing this, we can configure the Admin Component for a large number of database types, and allow you to define your own admin functions for any particular requirements.

• You can only alter those parts of the table definition that can be changed.
• Any changes are highlighted in yellow.
• Click on Preview to see the SQL that AQT has generated to alter the table.
• Click on Run to apply the changes. If any of the changes fail, the values will remain highlighted in yellow for you to correct or cancel.

• AQT generates full DDL for tables including 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/UDB DDL using Oracle syntax. This is useful if you are migrating objects between different database types.