Brand

DB2 LUW DBA Database Administration Tools

Aqua Data Studio offers a suite 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 access for:

  • Instance Summary (DB2 Server Component, Value)
  • Registry Parameters (Partition,Parameter, Value etc.)
  • Database Parameters (159 entries)
  • Database Manager Parameters (106 entires)

DB2 LUW Session Manager

Provides GUI view and search access for:

  • Session Details
  • Session Statistics
  • Session Locks
  • Session Grouping (By Agent ID, Auth ID, and more)

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 and search access for:

  • Tablespace and Containers Tree View
  • Tablespace Properties, Create, Alter, Drop
  • Buffer Pool Properties, Create, Alter, Drop
  • Table, Index Storage View
  • Datafiles Properties, Create, Alter, Drop

DB2 LUW Security Manager

Provides GUI view and search access for:

  • Tree View for Users, Roles, Groups
  • Users View, Create, Alter, Drop
  • Roles View, Create, Alter, Drop
  • Groups View, Create, Alter, Drop

References

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