1 of 7 – Netezza – Instance Manager – Parameters
2 of 7 – Netezza – Instance Manager – System Defaults
3 of 7 – Netezza – Instance Manager – Query History
4 of 7 – Netezza – Security Manager – Tree
5 of 7 – Netezza – Security Manager – Users
6 of 7 – Netezza – Security Manager – Groups
7 of 7 – Netezza – Session Manager – Sessions
Netezza Database IDE
Aqua Data Studio offers a suite of Netezza DBA Tools for monitoring, maintaining, and tuning the Netezza server. It includes an Instance Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Sessions, Users, and Permissions via GUI. A Query History view is also provided.
Netezza DBA Tool
Netezza1 Instance Manager
Provides GUI view and search access for:
- Parameters Summary (Name, Value)
- System Defaults (Name, Value)
- Query History (DDL, Query, UTILITY SQL executed on Server within Last 1/3/6/12/24 hours,3 days,1/2 weeks,Custom)
Netezza Session Manager
Provides GUI view and search access for:
- Session Details with current statement
- Session Grouping (By Session ID, Type, and more)
Netezza Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop