Aqua Data Studio for
LUWAqua Data Studio provides a management tool for the DB2 LUW[1] relational database with administration capabilities and a database query tool.
The visual administration features provide users the ability to browse and modify
database structures, including schema objects and database storage, as well as maintain
database security. An integrated query tool allows you to quickly create, edit and
execute SQL queries and scripts. Aqua Data Studio further provides import and export
tools to move data easily both in and from different data formats, as well as in
and out of the DB2 LUW database. Integrated within these tools is the DB2 LUW SQL
Support: Schema Navigation | Visual Editing | DDL Scripting
Browsing | Visual Editing | DDL Scripting | |
Schema | |||
Tables | ![]() |
![]() |
![]() |
Views | ![]() |
![]() |
![]() |
Aliases | ![]() |
![]() |
![]() |
Sequences | ![]() |
![]() |
![]() |
Indexes | ![]() |
![]() |
![]() |
Triggers | ![]() |
![]() |
![]() |
Packages | ![]() |
||
Procedures | ![]() |
![]() |
![]() |
Functions | ![]() |
![]() |
![]() |
User Datatypes | ![]() |
![]() |
![]() |
Constraints | ![]() |
![]() |
|
Materialized View | ![]() |
||
Management | |||
Sessions | ![]() |
||
Locks by Session ID | ![]() |
||
Locks by Object | ![]() |
||
Storage | |||
Tablespaces | ![]() |
![]() |
![]() |
Containers | ![]() |
![]() |
![]() |
Bufferpools | ![]() |
![]() |
![]() |
Security | |||
Users | ![]() |
![]() |
![]() |
Groups | ![]() |
![]() |
![]() |
Roles | ![]() |
![]() |
![]() |
>DB2 LUW Database Toolkit
References
- ^ DB2 Database Wikipedia article. IBM DB2 LUW – IBM DB2 Database for Linux, Unix and Windows edition.
IBM Corporation Wikipedia article.