Aquafold
Request Demo
Start for free

  • DBA Tool Instance Manager Summary in Aqua Data Studio
    1 of 16 – DB2 LUW – Instance Manager – Summary

  • DBA Tool Instance Manager Registry Parameters in Aqua Data Studio
    2 of 16 – DB2 LUW – Instance Manager – Registry Parameters

  • DBA Tool Instance Manager Database Parameters in Aqua Data Studio
    3 of 16 – DB2 LUW – Instance Manager – Database Parameters

  • DBA Tool Instance Manager Database Manager Parameters in Data Studio
    4 of 16 – DB2 LUW – Instance Manager – Database Manager Params

  • DBA Tool Storage Manager Tree in Aqua Data Studio
    5 of 16 – DB2 LUW – Storage Manager – Tree

  • DBA Tool Storage Manager Tablespaces in Aqua Data Studio
    6 of 16 – DB2 LUW – Storage Manager – Tablespaces

  • DBA Tool Storage Manager Buffer Pools in Aqua Data Studio
    7 of 16 – DB2 LUW – Storage Manager – Buffer Pools

  • DBA Tool Storage Manager Objects in Aqua Data Studio
    8 of 16 – DB2 LUW – Storage Manager – Objects

  • DBA Tool Storage Manager Datafiles in Aqua Data Studio
    9 of 16 – DB2 LUW – Storage Manager – Datafiles

  • DBA Tool Security Manager Tree in Aqua Data Studio
    10 of 16 – DB2 LUW – Security Manager – Tree

  • DBA Tool Security Manager Users in Aqua Data Studio
    11 of 16 – DB2 LUW – Security Manager – Users

  • DBA Tool Security Roles in Aqua Data Studio
    12 of 16 – DB2 LUW – Security Manager – Roles

  • DBA Tool Security Manager Groups in Aqua Data Studio
    13 of 16 – DB2 LUW – Security Manager – Groups

  • DBA Tool Session Manager Sessions in Aqua Data Studio
    14 of 16 – DB2 LUW – Session Manager – Sessions

  • DBA Tool Session Manager Session Stats in Aqua Data Studio
    15 of 16 – DB2 LUW – Session Manager – Session Stats

  • DBA Tool Session Manager Locks in Aqua Data Studio
    16 of 16 – DB2 LUW – Session Manager – Locks

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.