DB2 for LUW DBA Tools (Revision #40)

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 is the latest DBA Tools feature for DB2 UDB which provides a simple view of

• System Configuration - Server component values
• Registry Parameters - DB2 registry settings
• Database Parameters - DB2 database configuration
• Database Manager Parameters - DB2 database manager configuration parameters

With the latest Storage Manager for DB2 UDB, a user can visualize and maintain storage. This feature provides a tree view of objects, such as tablespaces and datafiles(containers),  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, alter, drop and view Users and Roles in a Server
• View authorities for Users and Roles
• View database access such as Tablespace and Schema privileges for Users and Roles
• Generate permissions for Users and Roles 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 and system locks. This tool can quickly identify locks and avoid unnecessary overheads. The various parameters that are captured in this tool are

• Sessions - shows Sessions as a tree
  • Session Details
  • Current Statement which is getting executed and Execution Plan

• Session Statistics - shows Session detais
  • Session Parameter values

• Locks - shows Lock details
  • User Locks
  • System Locks

Documentation -> DB2 for LUW DBA Tools -> Instance Manager

Documentation -> DB2 for LUW DBA Tools -> Storage Manager

Documentation -> DB2 for LUW DBA Tools -> Security Manager

Documentation -> DB2 for LUW DBA Tools -> Session Manager