Which Product is for You?
A great part of managing your IBM Informix infrastructure involves performing regular administration and maintenance tasks, responding to unexpected system events and keeping your database server tuned for optimal performance. AGS' Server Studio™ family of products provides various configurations of powerful, seamlessly integrated, state-of-the-art DBMS tools that help seasoned database professionals and novices alike manage with unprecedented ease day-to-day tasks such as 24X7 real-time monitoring of server’s performance, SQL development, database schema, physical storage and security management, enable autonomic event responses and keep IBM Informix DBMS servers performing at peak levels.
To assist you in choosing AGS product most suitable to your particular needs, the following high-level comparison matrix of functions and features available in each product edition is provided for your consideration.
Matrix Legends
— full functionality implementation
— full functionality implementation is available only when Server Studio™ JE Enterprise Edition
is deployed together with Sentinel™
— optional module functionality that can be added to any edition of
Server Studio™ JE
— limited functionality implementation (legacy product)
| FUNCTIONS AND FEATURES | Server Studio JE | Server Studio Win32 | ||
|---|---|---|---|---|
| Enterprise Edition | Developer Pack | Enterprise Edition | Professional Edition | |
| Performance Management | ||||
| Create | Edit | Delete Server Monitors | |
|||
| Create | Edit | Delete Tables and Indexes Monitors | |
|||
| Create | Edit | Delete Physical Storage Monitors | |
|||
| Create | Edit | Delete User Sessions Monitors | |
|||
| Create | Edit | Delete SQL Capture Monitors | |
|||
| Create | Edit | Delete multi-level Performance Threshold Alerts |
|
|||
| Alerts notification via email, mobile phone or pager text messages | |
|||
| Benchmark Performance testing under real-life work loads |
|
|||
| Performance Monitors and Threshold Alerts time-series data Historical Repository (built-in or external SQL database) |
|
|||
| Performance Monitors real-time and historical time-series data graphing charts | |
|||
| Export Performance Monitors historical time-series data for external analysis |
|
|||
| Examine SQL Query Execution Plan and Index usage statistics |
|
|
|
|
| Automation Management | ||||
| Create | Edit | Delete Custom Jobs | |
|||
| Execute any OS-level command or user script (SQL, shell, etc.) as a Job | |
|||
| Custom Schedules for Jobs execution | |
|||
| Execute Custom Jobs in response to Threshold Alerts | |
|||
| SQL Development and Schema Management | ||||
| Create | Edit | Delete Databases | |
|
||
| Graphical Editors and Wizards to Create | Edit Database Objects |
|
|
|
|
| Graphical Explorer to examine and navigate Database Schema |
|
|
|
|
| Database Objects' graphical Properties Examiner | |
|
|
|
| Single SQL statement, partial and full SQL script execution | |
|
|
|
| Multiple SQL Query results set displays | |
|
|
|
| SQL Query results export | |
|
|
|
| Stored Procedures and Triggers interactive Debugging |
|
|
|
|
| SPL and SQL Templates | |
|
|
|
| DB Object Search | |
|
|
|
| Examine Database Objects Dependencies | |
|
|
|
| Database Object change Impact Analysis | |
|
|
|
| Differential Analysis of DB Schemas | |
|
|
|
| DB Schemas Synchronization | |
|
||
| Import | Export | Copy I Print Full or Partial DB Schema | |
|
||
| Data Management | ||||
| Enter | Edit | Delete Table Data | |
|
|
|
| Examine | Sort | Filter Table Data | |
|
|
|
| Cell Editor for complex Data types and BLOBS | |
|
|
|
| Import | Export Data Wizard | |
|
|
|
| Test Data Generator | |
|
||
| Server Management | ||||
| Create | Edit | Delete multiple server configurations | |
|
|
|
| Create | Edit | Delete logical servers groups | |
|
||
| Secure Single Sign-on to multiple DBMS | |
|
||
| Examine Server Profile, Status and Logical Logs |
|
|
||
| Examine ONCONFIG parameters | |
|||
| UPDATE Server Statistics | |
|||
| Manage Virtual Processors | |
|||
| Manage Start | Stop | Quiescent Server Modes | |
|||
| Built-in Telnet/SSH terminal | |
|||
| Execute remotely IBM Informix-native utilities and OS-level scripts |
|
|||
| Preconfigured Operational Reports | |
|||
| User Sessions Management | ||||
| Examine User Sessions details (I/O, Locks, etc.) |
|
|
||
| Examine SQL statements executed by a particular User Session |
|
|
||
| Kill User Sessions | |
|||
| Database Security Management | ||||
| Create | Edit | Delete Users | |
|
||
| Create | Edit | Delete Roles | |
|
||
| Create | Edit | Delete Database Object Privileges | |
|
||
| Map Database Objects to Users or Roles | |
|
||
| Physical Storage Management | ||||
| Add | Delete | Examine DB Spaces, BLOB and Temporary Spaces | |
|||
| Add | Delete | Examine DB Chunks | |
|||
| Space and Chunks Usage Reports | |
|||
| Fragment Tables across multiple DB Spaces | |
|||
| Table Reorganization Wizard | |
|||
| Table Extent Size Calculator | |
|||
Learn more...