Aqua Data Studio offers a suite of Sybase Anywhere 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 Anywhere Administration Tools
Sybase Anywhere Instance Manager
Provides GUI view and search access for:
- General (Property, Value)
- Options (UserName, Option, Setting)
- Database Parameters (Parameter, Description, Value)
- Server Parameters (Parameter, Description, Value)
- Collations (ID, Label, Name)
- Server History (Operation, Version etc.)
- External Environments (Name, Scope etc.)
- External Environment Objects (Object Name, Owner etc.)
Sybase Anywhere 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 etc.)
Sybase Anywhere 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 Anywhere Security Manager
Provides GUI view and search access for:
- Tree View for Users, Roles
- Users View, Create, Alter, Drop
- Roles View, Create, Alter, Drop