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.
- — 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.|
|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|
|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.|
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.|