Should You Upgrade?

Server Studio™ Win32 is a legacy product for IBM Informix back-end SQL application development and stored procedure debugging. This product line has been retired, however AGS will continue to support Server Studio™ Win32 for existing customers and business partners until December 31, 2005.
Server Studio™ Win32 is superceded by a more comprehensive multi-platform solution for DBAs and SQL application developers — Server Studio™ JE.
To assist you in deciding why you need to upgrade, the following high-level comparison matrix of functions and features available in Server Studio™ Win32 and Server Studio™ JE product editions is provided for your consideration.
Matrix Legends
— full functionality implementation
— limited functionality implementation (legacy product)
FUNCTIONS AND FEATURES | Server Studio JE | Server Studio Win32 |
---|---|---|
SQL Development and Schema Management | ||
DB Difference Analyzer performs comparative analysis on all database object properties including table structures, referential integrity, fragmentation, along with syntax of stored procedures, triggers and views. | ![]() |
![]() |
DB Schema Synchronization script generation, based on comparison results of two databases. | ![]() |
|
Import | Export | Copy I Print Full or Partial DB Schema. Manages DDL script files for the entire database or user-defined sub-schemas that may be comprised of particular types or groups of database objects. Schema Manager can directly deploy database schemas or sub-schemas and allows to specify how to map DB spaces and BLOB spaces from the source to the target server. |
![]() |
|
Non-blocking Query Execution – switch to other editors or documents and continue working while long queries are executing. | ![]() |
|
Unlimited size of SQL scripts. | ![]() |
![]() |
Examine execution time for each query. | ![]() |
|
Pin selected query result set in the SQL Editor. | ![]() |
|
Query Execution Plan Analyzer – runs without the need to mount UNIX drives on Windows networks. | ![]() |
|
Table-level details drill-down in the Object Explorer | ![]() |
|
Edit stored procedure syntax directly in the SPL Debugger window, without the need to close the debugger and edit the procedure's syntax in a separate editor if any modifications are required. | ![]() |
|
Data Management | ||
Import | Export Data Wizard. Visually maps multiple external data files to database objects and manages data transformation rules. |
![]() |
![]() |
Test Data Generator. Create large data sets to test SQL queries performance and back-end application logic. |
![]() |
|
Enter | Edit | Delete Table Data | ![]() |
![]() |
Examine | Sort | Filter Table Data | ![]() |
![]() |
Cell Editor for complex Data types and BLOBS | ![]() |
![]() |
Server Management | ||
Create | Edit | Delete multiple server configurations | ![]() |
|
Create | Edit | Delete logical servers groups | ![]() |
|
Secure Single Sign-on to multiple DBMS | ![]() |
|
Examine server's Profile, Status and Logical Logs | ![]() |
|
Examine ONCONFIG parameters | ![]() |
|
Compare servers' configurations | ![]() |
|
UPDATE Server Statistics | ![]() |
|
Manage Virtual Processors | ![]() |
|
Manage Start | Stop | Quiescent Server Modes | ![]() |
|
Examine Table-level locks and I/O activity | ![]() |
|
Built-in Telnet/SSH terminal | ![]() |
|
Execute remotely IBM Informix-native utilities and OS-level scripts | ![]() |
|
Preconfigured Operational Reports for accessing server's performance and data storage space utilization statistics. | ![]() |
|
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 | ![]() |
|
Examine | Sort Tables based on a number of extents and/or data rows | ![]() |
|
Table Reorganization Wizard | ![]() |
|
Table Extent Size Calculator | ![]() |
|
Determine current size of the database | ![]() |
|
Performace Management and Optimization | ||
Integrates with Sentinel™ which provides 24 x 7 monitoring of server operations with integrated historical time-series performance data repository, autonomic event management, alerting, scheduled database administration task execution and highly interactive performance diagnostics. | ![]() |
|
Benchmark Runner. Perform application stress testing under user-defined real-life load scenarios (hundreds of concurrent user sessions) and measure execution statistics such as average, minimum and maximum response times. |
![]() |
|
SQL Capture based on user login name, client host, Informix session ID, or SQL statements execution statistics. | ![]() |