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. | |
Only Stored Procedures |
| 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. | |
800 Kb |
| 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. |
|
One-to-one import only |
| 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. | |
|
Learn more...