1 of 17 – Sybase IQ – Instance Manager – General
2 of 17 – Sybase IQ – Instance Manager – Database Parameters
3 of 17 – Sybase IQ – Instance Manager – Server Parameters
4 of 17 – Sybase IQ – Instance Manager – Server History
5 of 17 – Sybase IQ – Instance Manager – Server License
6 of 17 – Sybase IQ – Instance Manager – Server Statistics
7 of 17 – Sybase IQ – Instance Manager – External Environments
8 of 17 – Sybase IQ – Instance Manager – External Environment Objects
9 of 17 – Sybase IQ – Security Manager – Tree
10 of 17 – Sybase IQ – Security Manager – Users
11 of 17 – Sybase IQ – Security Manager – Groups
12 of 17 – Sybase IQ – Session Manager – Sessions
13 of 17 – Sybase IQ – Session Manager – Session Stats
14 of 17 – Sybase IQ – Session Manager – Locks
15 of 17 – Sybase IQ – Storage Manager – Tree
16 of 17 – Sybase IQ – Storage Manager – Dbspaces
17 of 17 – Sybase IQ – Storage Manager – Objects
Sybase IQ DBA Tools
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 Include:
Sybase IQ1 Instance Manager
Provides GUI view and search access for:
- Instance Summary (Sybase Component, Value)
- Database Parameters(Name, Description, Value)
- Server Parameters(Name, Description, Value)
- Server History (Operation, Version, Details etc.)
- Server License View and Edit (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
References
- ^ Sybase IQ Wikipedia article. Sybase IQ is a relational database management system (RDBMS) used for business intelligence and data warehousing, produced by Sybase.
- ^ Sybase, an SAP Company Wikipedia article.