Error processing SSI file
Error processing SSI file

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         


Server Studio™ JE V.5.0
a comprehensive, multi-platform solution for DBAs and SQL application developers is released. Examine its new powerful features now.

Information about Sentinel

Automate 24 x 7 real-time monitoring of your IBM Informix® server operations, use highly interactive diagnostics to optimize performance parameters and manage autonomic responses to server events.

Important Upgrade

Server Studio™ Win32 is a legacy product for IBM Informix® back-end SQL application development and stored procedure debugging. This product has been superceded by a more comprehensive multi-platform solution for DBAs and SQL application developers — Server Studio™ JE. AGS will continue to support Server Studio™ Win32 for existing customers and business partners until December 31, 2005.

Current customers of Server Studio™ Win32 products are strongly encouraged to upgrade to Server Studio™ JE. Learn more about the benefits of upgrading....

Our Customers

Click to see who uses AGS products and what do they say about them.

Learn more...

"It brings Informix Database Administration into the 21st Century, replacing ancient command line tools with modern graphical tools. I really can't image how Informix DBA's survived without it!"

Kevin Godsman
Musto Ltd, UK

"I have enjoyed working with Server Studio. It makes everything very easy to manage. This is the best product I have used in daily working with Informix."

Linwood Jarratt
Lake County Administration, Illinois

"It is simple. Server Studio is the perfect product. It covers all our needs and what is most important it is simple to use. We mainly use it to create manage and test/debug Stored Procedures. The SPL Debugger is a wonderful tool that have saved us a lot of work."

Throstur Jonsson

"It is a good tool for us as we are developers and DBAs at the same time. For one application that we wrote (using many stored procedures), it was the only way we could have gotten it done. Our old methods (dbaccess, ftp, etc.) would have been suicide."

Sean Durity
CornerCap Investment Counsel

"Before Server Studio, I was using several different tools to perform maintenance tasks with the database. Today, I use Server Studio 80% of the time and I wish I could tell you how much easier my job has been. The amount of time savings from using all the other little utilities is immeasurable. All in all, I will most definitely endorse it to any Informix administrator and developer. Server Studio boost the power of Informix 100 times!!!"

Roy de-Silva
IT Consultant
Toronto, Ontario

"I'm new to Informix. I come exclusively from a SQL Server background. However, after using the product for a while it has many features that are more powerful than MS Enterprise Manager and MS SQL Query Analyzer."

Jim Kodet
Talk America

"I user Server Studio extensively on a daily basis. Our criminal justice system database is extremely complex and extensive. Without Server Studio, SQL development for reporting purposes would be nightmarish. It is not unusual to see a set of queries involving more that 200 separate steps, required for producing a single report. ... Thank you and congratulations on a very powerful and comprehensive product."

Peter Fuentes
Maricopa County, Arizona