AquaFold, Inc.

DB2 LUW DBA Database Administration Tools

Aqua Data Studio offers a suit of DB2 LUW Database Administration Tools for the monitoring, maintaining and tuning of the DB2 LUW server. It includes an Instance Manager, Storage Manager, Security Manager and Session Manager. These managers allow the monitoring and maintenance of Tablespaces, Database Objects, Sessions, Users and Permissions via GUI.



Aqua Data Studio DB2 LUW Administration Tools Include:

DB2 LUW1 Instance Manager

Provides GUI view and Search for:

- Instance Summary (Instance Name, Database Name, Hardware Parameters, Version etc.)
- Registry Parameters
- Database Parameters (118 entries)
- Database Manager Parameters (80 entires)

DB2 LUW Session Manager

Provides GUI view and Search access for:

- Session Details
- Session Statistics
- Session Locks

Auto refresh data in specified intervals

Views for dynamically changed data such as Session Manager can be set for automatic refresh with intervals from 1 second and up.

DB2 LUW Storage Manager

Provides GUI view Search and Modify access for:

- Tablespace and Datafiles Tree View
- Tablespace Properties, Create, Alter, Drop
- Buffer Pool Properties, Create, Alter, Drop
- Objects Properties
- Datafiles Properties, Create, Alter

DB2 LUW Security Manager

Provides GUI view Search and Modify access for:

- Tree View for Users, Roles, Groups
- View Properties of User, Role, Group
- Create User, Role, Group
- Alter User, Role, Group
- Drop User, Role, Group

References

  1. ^ DB2 Database Wikipedia article. IBM DB2 LUW - IBM DB2 Database for Linux, Unix and Windows edition.
    IBM Corporation Wikipedia article.

Home • Aqua Data Studio • Aqua Data Server • AquaClusters • Support • Store • Company • Privacy

Copyright © 2001–2012 AquaFold, Inc. All Rights Reserved.