Aqua Data Studio offers a suite of Sybase IQ DBA Tools for the monitoring, maintaining and tuning of the Sybase server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Database Objects, Sessions, Users and Permissions via GUI.

Aqua Data Studio Sybase IQ Administration Tools

Sybase IQ Instance Manager

Provides GUI view and search access for: 

• Instance Summary (Sybase Component, Value)
• Database Parameters (Parameter, Description, Value)
• Server Parameters (Parameter, Description, Value)
• Server History (Operation, Version, Details etc.)
• Server License (Component, Value)
• Server Statistics (Name, Description, Value, Unit)
• External Environments (Name, Scope, Location etc.)
• External Environment Objects (Name, Owner etc.)

Sybase IQ Session Manager

Provides GUI view and search access for: 

• Session Details with current statement, Kill Session
• Session Statistics
• Session Locks
• Session Grouping (By Process ID, IP Address, and more)

Sybase IQ Storage Manager

Provides GUI view and search access for: 

• Tree View for Databases, Device Usage, Dbspaces
• Properties of Dbspaces, Device Usage
• Table, Index Storage View

Sybase IQ Security Manager

Provides GUI view and search access for: 

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