1 of 17 – Sybase Anywhere – Instance Manager – General
2 of 17 – Sybase Anywhere – Instance Manager – Options
3 of 17 – Sybase Anywhere – Instance Manager – Database Parameters
4 of 17 – Sybase Anywhere – Instance Manager – Server Parameters
5 of 17 – Sybase Anywhere – Instance Manager – Collations
6 of 17 – Sybase Anywhere – Instance Manager – Server History
7 of 17 – Sybase Anywhere – Instance Manager – External Environments
8 of 17 – Sybase Anywhere – Instance Manager – External Environment Objects
9 of 17 – Sybase Anywhere – Security Manager – Tree
10 of 17 – Sybase Anywhere – Security Manager – Users
11 of 17 – Sybase Anywhere – Security Manager – Roles
12 of 17 – Sybase Anywhere – Session Manager – Sessions
13 of 17 – Sybase Anywhere – Session Manager – Session Stats
14 of 17 – Sybase Anywhere – Session Manager – Locks
15 of 17 – Sybase Anywhere – Storage Manager – Tree
16 of 17 – Sybase Anywhere – Storage Manager – Dbspaces
17 of 17 – Sybase Anywhere – Storage Manager – Objects
Sybase Anywhere DBA Tools
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 Include:
Sybase Anywhere1 Instance Manager
Provides GUI view and search access for:
- Instance Summary (Property, Value)
- Options (UserName, Option, Setting)
- Database Parameters(Parameter, Description, Value)
- Server Parameters View, Edit (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
References
- ^ Sybase SQL Anywhere Wikipedia article. SQL Anywhere is a relational database management system (RDBMS) produced by Sybase.
- ^ Sybase, an SAP Company Wikipedia article.