DB2 for LUW DBA Tools (Revision #18)

New DBA Tools for DB2 for LUW , including Instance Manager, Storage Manager, Security Manager and Session Manager.

DB2 for LUW DBA Tools	Instance Manager	Storage Manager	Security Manager	Session Manager

• Instance Manager: Provides manageability of DB2 for LUW instances allowing the user to view and modify server parameters and viewing server version information.
• Storage Manager: Provides manageability of DB2 for LUW databases, database devices, dump devices and caches, allowing a user to visualize and maintain storage.
• Security Manager: Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of DB2 for LUW databases.
• Session Manager: Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.

Instance Manager is the latest DBA Tools feature for DB2 UDB which provides a simple view of

• System Configuration

• Registry Parameters

• Database Parameters

• Database Manager Parameters

With the latest Storage Manager for DB2 UDB, a user can visualize and maintain storage. This feature provides a tree view of objects which includes the path, size and usage. Users can allocate storage to the the following objects

• Tablespaces

• Buffer Pools

• Datafiles

Security Manager is another new feature for DB2 UDB which provides a simple view of Users and Roles. This is designed specifically to

• Create Users and Roles in a Server

• Alter either a single User or group of Users and Roles

• Generate authority and privileges for a Role across all objects in a database

• Provide a simple tree view of Users and Roles

Session Manager is Aqua Data Studio's latest feature which provides manageability of database sessions including user locks. This tool can quickly identify locks and avoid unnecessary overheads. Session Manager allows the user to monitor and kill sessions. The various parameters that are captured in this tool are

• Sessions

• Session Details

• Current Statement which is getting executed.

• Application Status

• Session Statistics

• Agent

• Authorization ID

• Application

• Client

• Inbound Address

• Locks

• Session

• User

• Lock Type

• Tablespace

• Table

• Application

• Client Workstation