Product Announcement: Free GUI DBA Tools
Posted in 1997
Product Announcement: GUI Database Administration Tools, ROM 2.1. TABLE OF CONTENTS: 1.0 OVERVIEW 1.1 Product Positioning 1.2 Product Overview 2.0 PRODUCT DESCRIPTION 2.1 Product Features & Benefits 2.2 Compatibility Matrix 3.0 PRODUCT REQUIREMENTS 3.1 Hardware and Software Requirements 4.0 HOW TO OBTAIN THE PRODUCT 5.0 PRICING AND SUPPORT POLICIES 5.1 Pricing and Maintenance Information 5.2 Support Policies 6.0 MISCELLANEOUS 6.1 FAQ's 1.0 OVERVIEW IECC fundamentals for UNIX Servers management Informix Product Management & Product Marketing is proud to announce the immediate general availability (GA) of the enhancements to the INFORMIX-Enterprise Command Center (IECC) known as Relational Object Manager (ROM) 2.1. ROM 2.1 is only compatible with 7.1X and 7.2X *UNIX* and Windows NT DSA servers. This product, which runs on Microsoft Windows95 or Windows NT system administration workstation, is available via the Web at *no charge*, and contains the following items: 1) Database Explorer 2) SQL Editor 3) Table Editor 4) View Editor 5) Stored Procedure Editor 6) Trigger Editor 7) I-Connect for Win32 (Windows95 & Windows NT 4.0) 8) Managing Relational Objects User's Manual 9) On-line Help Informix has been shipping the first three tools (Database Explorer, SQL Editor, and Table Editor) as part of the INFORMIX-Enterprise Command Center (IECC) with OnLine Workgroup Server and OnLine Dynamic Server 7.22 on Windows NT. Now with this release, these tools and more are available as a stand alone product in support of UNIX & Windows NT DSA Servers! 1.1 PRODUCT POSITIONING Informix's top database administration goal is to provide easy-to-use graphical database administration capabilities for our mainstream UNIX and Windows NT DSA database servers. With this *No Charge* version of ROM 2.1, Informix continues to deliver on its vision of providing tools designed to satisfy advanced to novice DBA relational object management requirements. For usage instructions, refer to the Managing Relational Objects (ROM 2.1) User's Guide in Answers OnLine (http://www.informix.com/answers). An electronic copy of this manual is also included with the downloadable software. The key marketing messages for this product are: * Easy-to-install and use, graphical database change management utilities for novice and advanced DBAs supporting Informix's 7.1x-7.2x ODS and OWS for UNIX and Windows NT 4.0 database servers. * Precursor to upcoming utilities and components included within IECC 3.0. 1.2 PRODUCT OVERVIEW The Relational Object Manager 2.1 release for Windows95 and Windows NT 4.0 includes the following components: * ROM 2.1 utilities: Database Explorer, SQL Editor, Table Editor, Trigger Editor, Stored Procedure Editor, and View Editor * INFORMIX-Connect for Win32 (Windows95 & Windows NT 4.0) * ROM 2.1 on-line help * Managing Relational Objects User's Manual 2.10 * On-line files: ROM 2.10 release notes, ROM 2.10 user's manual README, and INFORMIX-Connect release notes. 2.0 PRODUCT DESCRIPTION 2.1 PRODUCT FEATURES AND BENEFITS ROM 2.1 is a graphical suite of database administration tools that support INFORMIX-OnLine Dynamic Server and INFORMIX-OnLine Workgroup Server, versions 7.1x through 7.23 on both UNIX and Windows NT platforms. Following is a detailed list of the individual components and attributes. * Database Explorer * SQL Editor * Table Editor * View Editor * Stored Procedure Editor * Trigger Editor * Installation * Connectivity * Localization and GLS Database Explorer ----------------- Database Explorer is the navigational component of ROM and is used to locate and manipulate relational objects on a database server. You can also use the Database Explorer to create databases and table synonyms, as well as to access the Table Editor and SQL Editor. SQL Editor ---------- The SQL Editor is used to create, edit, and execute SQL statements. You can also use this editor to query a database, manipulate data, and save SQL statements and returned data. Table Editor ------------ The Table Editor allows the user to create and edit relational database tables. This editor supports indexes, foreign keys, and constraints. View Editor ----------- The View Editor enables the user to modify an existing view and create new views using SQL. A template is provided for new view objects. Stored Procedure Editor ----------------------- The Stored Procedure Editor enables the user to modify an existing stored procedure and create new stored procedures using SQL. A template is provided for new stored procedure objects. Trigger Editor -------------- The Trigger Editor enables the user to modify an existing trigger and create new triggers using SQL. A template is provided for new trigger objects. Complete Installation --------------------- The ROM 2.1 product includes complete install and uninstall functionality. The file customers will download (rom21tc1.exe) is a self-extracting executable file that contains the installation files, and launches the installation application. This file is installed on the system administrator's Windows95 or Windows NT workstation, although it is used to manage both Windows and UNIX DSA databases. This file cannot be installed and executed on the UNIX server. Connectivity Included --------------------- Executing the installation program will automatically install all required runtime connectivity (I-Connect). I-Connect includes SetNet32, FindError (a help application that references Informix database error description), the I-Login demo, and the required ESQL/C runtime libraries. Localization and GLS Level 4 Compliance --------------------------------------- ROM 2.1 will be available in an English-only version (e.g., title bars are in English). However, any information provided by the server will be visible in the native language as defined on that particular server. Informix has no plans to localize this product since upcoming versions of these utilities will be made available within IECC. ROM 2.1 is GLS level 4 compliant. GLS level 4 compliance is the implementation of a coding standard that allows Informix products to support multibyte characters (i.e. Japanese, Chinese, etc.). The GLS modifications will enable Informix to maintain a single source for products it sells anywhere in the world. 2.2 COMPATIBILITY MATRIX ROM 2.1, which runs on Windows95 or Windows NT 4.0, supports the management of the following DSA servers. UNIX DSA Servers: * OnLine Dynamic Server, version 7.1x, 7.2x * OnLine Workgroup Server, versions 7.1x, 7.2x Windows NT 4.0 DSA Servers: * OnLine Dynamic Server, version 7.1x, 7.2x * OnLine Workstation, versions 7.1x, 7.2x * OnLine Workgroup Server, versions 7.1x, 7.2x 3.0. PRODUCT REQUIREMENTS 3.1 HARDWARE AND SOFTWARE REQUIREMENTS For optimal performance, verify that your system meets the followi