DBMS - January 1997 - DBA Tools Today

DBA Tools Today

January 1997

TABLE 1. DBA Tools
BMC Software Inc. Houston, TX 800-841-2031, 713-918-8800, or fax 713-918-5010; www.bmc.com	Patrol Patrol automates and centralizes the control of all of the critical elements in distributed application management, including data, databases, servers, middleware, networks, and applications. Patrol consists of intelligent agents, management consoles, and Knowledge Modules.
Bradmark Technologies Inc. Houston, TX 800-275-2723, 713-621-2808, or fax 713-621-1639 www.bradmark.com	DBGeneral Object Manager for Oracle A Windows-based tool for automating database administration tasks. Features include restructuring of tables, rebuilding tablespaces, complete user and role management, complete object privilege management, maintenance of triggers, and sophisticated database navigation. DBGeneral Performance Monitor for Oracle & Sybase A Windows-based performance monitor for Oracle, Sybase, and Microsoft SQL Servers. Retrieves and displays key performance statistics in real time. DBGeneral Tablespace Manager for Oracle A Windows-based tool for graphically displaying all objects and extents in any Oracle tablespace. Identifies objects that are space-bound and will analyze space utilization within selected tables to determine the percentage of fullness for any table.
BrainTree Technology Inc. Norwell, MA 800-232-5215, 617-982-0200, or fax 617-982-8076 www.sqlsecure.com	SQL Secure 3.1 A suite of client/server security management software products for Oracle7: SQL Secure Password Manager, SQLSecure Audit Manager, and SQLSecure Policy Manager
Cast Software Inc. San Francisco, CA 415-296-1300 or fax 415-296-1313 www.castsoftware.com sales@castsoftware.com	CW-Doc Generates technical documentation for SQL Server databases; produces a complete set of technical documentation and diagrams that explain client/server objects and dependencies. CW-Server Provides an advanced editor, Transact-SQL debugger, code-building tools, non-regression testing, and version control for Transact-SQL.
Common Sense Computing East Malvern, Victoria, Australia 61-3-9885-5829 or fax 61-3-9885-0116 www.comsense.com	I/Watch I/Watch uses several low-level DBMS and operating-system monitoring tools to keep a continuous watch on specified exception conditions or performance characteristics. Data gathered may be used to trigger alarms, written to files for statistical analysis, or graphed in real time.
Compuware Corp. Farmington Hills, MI 810-737-7300 or fax 810-737-7199	EcoTools An integrated systems management product for monitoring and managing production of Unix applications running on Oracle, Sybase, or Informix. It includes EcoConnect, EcoChargeback, and EcoPMON.
Data Integration Inc. Los Angeles, CA 310-313-9150 or fax 310-313-9151	InterViso IVBuild Assists DBAs in developing one or more unified views, or federated schemas, across existing databases. Each federated schema is stored in a Sybase, Oracle, DB2, or CA-OpenIngres database.
DataTools Inc. Palo Alto, CA 800-721-8665, 415-842-9100, or fax 415-842-9101 www.datatools.com info@datatools.com	DataTools SQL-BackTrack for Sybase A database-aware backup and recovery product that supports Sybase 4.2 and later, including System 10. Supports both physical- and logical-format backups. DataTools-BackTrack for Oracle A database-aware backup and recovery tool that supports Oracle version 6.0.37 and later, including Oracle7. Integrates all aspects of Oracle backup and recovery by automating backup, improving performance, and providing data security.
Embarcadero Technologies Inc. San Francisco, CA 415-834-3131 or fax 415-434-1721 www.embarcadero.com	DBArtisan A Windows-based tool that simplifies server and database administration. Consists of three major components: a set of customized visual editors that let users administer any server or database object without knowing Transact-SQL commands; an MDI-scripting environment for intensive SQL scripting and data retrieval; and utilities to enhance productivity, including copy management, extended-table alter, integrated PowerBuilder support, SQL code generation, space estimation, script generation, and bulk import or export of data. ER/1 An advanced entity-relationship modeling tool. Inheritance engine ensures the proper migration and unification of foreign keys between entities, building referential integrity into ER diagrams automatically. Rapid SQL A server-side development tool for SQL Server. Provides three customizable MDI desktops, each capable of holding multiple script windows and result sets. Team SQL/Developer A comprehensive SQL programming and object management workbench that supports all industry-standard databases. Supports graphical object creation and alteration for more than 10 server- specific database object types. Team SQL/Project A version-control system for SQL databases. Directly creates and manages Intersolv PVCS and MKS Source Integrity archives containing the data definition language (DDL) components used to define SQL database objects such as tables, views, stored procedures, and triggers.
Eventus Software Inc. San Bruno, CA 800-871-4871, 415-871-4871, or fax 415-871-0189 www.eventus.com info@eventus.com	AdHawk A Windows-based online monitoring and diagnostics tool for Oracle databases. Monitors Oracle on any platform using Oracle's SQLNet as the communication link. Lets users monitor information from a high level (such as user activity and I/O activity) down to a lower, more specific level of data (such as the actual session, user, and SQL statement). AdHawk Spacer* A Windows-based space-management tool for Oracle that provides detailed information on the condition of tablespaces and individual database objects such as tables and indexes.
IBM Software Solutions Somers, NY 800-426-3333 or 520-574-4600 www.software.ibm.com	DataHub DataHub enables management of database systems across the enterprise from a single control point and allows integration of database system management tools from IBM, other vendors, and in-house programmers. DB2 Performance Monitor Provides performance data collection, viewing, reporting, analysis, and alerting for DB2/2 and DB2/6000 databases. DB2 Visual Explain Provides detailed graphical information about the SQL access plan chosen by a DB2/2 and DB2/6000 optimizer. Provides users with a what-if modeling capability for SQL statements, allowing them to model the impact of various changes in the database environment.
INFOgy Inc. Pasadena, CA 818-564-2684 or fax 818-564-2687 www.infogy.com	DBView Analysis and debugging tool for Oracle that helps users develop, reengineer, and maintain databases and applications. DBView retrieves and analyzes information about all objects in any Oracle version 6 or Oracle7 database.
Informix Software Inc. 4100 Bohannon Dr. Menlo Park, CA 94025 415-926-6300 or fax 415-926-6593 www.informix.com	Command Center Monitors and facilitates the day-to-day tasks required by a database server. Lets you view the status of the database server and change the accessibility of the database server to users; monitor the active sessions of your users; manage alerts and customize the criteria and notification methods of alerts to inform users of a specific activity or state of the database server; and generate system reports to determine system use.
Logic Works Inc. Princeton, NJ 800-783-7946, 609-514-1177, or fax 609-514-1175 www.logicworks.com	ERwin product family ERwin is a database design tool that helps users design a graphical, entity-relationship model of the business rules governing an application's data. ERwin's Server Forward- and Reverse-Engineering connection allows it to generate a database directly from the data model, or reverse-engineer an existing database into a model. ERwin/OPEN extends ERwin's capabilities by speeding front-end application development in Visual Basic, PowerBuilder, and Progress. ERwin/Navigator provides developers with cost-effective, read-only access to ERwin models.
Mercury Interactive Corp. Sunnyvale, CA 800-837-8911, 408-523-9900, or fax 408-523-9911 www.merc-int.com	DBProfiler JET Inspector 2.0 for MS Access and Visual Basic A performance-tuning and trace utility for Visual Basic and Access (with or without source code). Shows the Microsoft JET Database Engine operations, data access object operations, parameters, return values, and performance information. DBProfiler SQL Inspector 2.0 for Oracle7 Oracle7 performance-tuning and trace utility for PowerBuilder, Visual C++, Visual Basic, Access, and SQLWindows programs, or other data-access Windows applications. Enables realtime monitoring of SQL queries, connects and disconnects, and other client-side operations. DBProfiler SQL Inspector for MS or Sybase SQL Server Microsoft and Sybase client performance-tuning and trace utility for PowerBuilder, Microsoft Visual C++, Visual Basic programs, or other Windows data-access applications. Enables realtime monitoring of SQL queries, connects and disconnects, and other client-side operations.
Microsoft Corp. Redmond, WA 800-426-9400, 206-882-8080, or fax 206-936-7329 www.microsoft.com	SQL Enterprise Manager The SQL Enterprise Manager provides visual controls to help you manage database resources, user activities, server configurations, database backups, and more. New SNMP enhancements allow monitoring of SQL Server with SNMP-based management tools.
ObjectWorks Inc. Calgary, Alberta Canada 403-237-7333 or fax 403-237-7380 www.objectworks.com	DORS for Windows Helps users manage changes to their database as it evolves from customer usage. Allows for direct database comparisons, a process that identifies items that are different between the two databases, and enables database synchronization. *SQLPAD** Designed to simplify and streamline the creation and testing of stored procedures and triggers. Features a graphical interface, debugging features, and shortcuts to speed the development process. Also offers a database object repository, which allows full version control.
Oracle Corp. Redwood Shores, CA 415-506-7000, 415-506-4176, or fax 415-506-7200 www.oracle.com	Enterprise Manager Automates routine database administration and enables software asset management for administrators to deploy applications written to Oracle's Installer API. It handles license and configuration management and database replication scheduling.
Platinum Technology Inc. Oakbrook Terrace, IL 708-620-5000 or fax 708-691-0407 www.platinum.com	Platinum DBVision Lets DBAs continuously monitor and manage multiple, complex RDBMS environments simultaneously on different platforms. Can be programmed to automatically correct problems it identifies or notify specific personnel via email or pager. Platinum Desktop DBA Database administration and migration utility for SQL database servers. It features management of multiple databases/servers in separate windows and lets users perform multiple administrative tasks simultaneously. Platinum Fast Unload for Oracle Exports data by directly accessing Oracle database files, completely bypassing the SQL engine and Oracle kernel. Fast Unload lets users tailor the format of the data output, ensuring that the file is ready for its intended purpose without further manipulation. Platinum Plan Analyzer for Oracle GUI-based tool that automates SQL capture and tuning. It helps users determine which SQL optimization plan is faster and consumes least resources. Platinum Plan Analyzer for DB2 Provides information for managing, controlling, and optimizing DB2 application plans. It combines Explain output, DB2 catalog statistics, and rule-based Platinum Expert System to provide analysis of SQL usage and access path choices. Platinum TSreorg Improves the efficiency of large Oracle databases by restructuring objects that have become disorganized because of heavy use without rebuilding the entire database structure.
Powersoft Corp. (a Sybase company) Concord, MA 800-395-3525, 508-287-1994, or fax 508-369-3997 www.powersoft.com	S-Designor A comprehensive modular toolset for building client/server databases and applications. Modules are: S-Designor ProcessAnalyst, S-Designor DataArchitect, S-Designor AppModeler, and S-Designor MetaWorks.
Red Brick Systems Inc. Los Gatos, CA 800-777-2585, 408-399-3200, or fax 408-399-3277 www.redbrick.com	Red Brick Warehouse Enterprise Control and Coordination Software for tactical warehouse administration needs, including query monitoring and control security and administration, copy management, and metadata management.
Stro-Ware Inc. Los Angeles, CA 800-278-7876, 310-312-8099, or fax 310-312-8268	SQL Director 2.1 A DBA and SQL Server toolkit that lets customers manage databases, tables, devices, logins, users, permissions, and more on Microsoft SQL Server and Sybase database servers.
Sybase Inc. Emeryville, CA 800-685-8225, 510-596-3500, or fax 510-922-9441 www.sybase.com	SQL Monitor A graphical client/server tool for monitoring and tuning the performance of any number of networked multiplatform distributed SQL Servers. *SQLDebug** A graphics-based, source-level debugger for Transact SQL. Applies 3GL debugging technology to help database developers identify and correct logic and performance problems in their SQL code early in the development process. Offers step-level execution, breakpoint setting, conditional tracing and variable examination, and control to identify logic and naming bugs.
Sylvain Faust Inc. Hull, Quebec, Canada 800-567-9127, 819-778-5045, or fax 819-778-7943 www.sfi-software.com	SQL-Programmer for Windows A test-while-you-edit development environment, featuring a virtual editor for SQL Server programmers. Users can create, edit, test, and assess impacts with all SQL Server programmable objects: stored procedures, triggers, tables, and so on.
The Database Solutions Company Richmond, VA 800-933-7668, 804-794-0354, or fax 804-794-0813 www.dbsol.com	TPM 96 TPM 96 manages the client/server database environment. It includes: DBScope, Configuration Forecaster, DBTune, Control Center, and CCAlarm.
Treehouse Software Inc. Sewickley, PA 412-741-1677 or fax 412-741-7245	Auditre and AutoLoader Auditre is a generalized auditing facility that uses the Adabas Protection Log to identify changes to ADABAS data. Extensive reporting and selection criteria are provided. AutoLoader is an automatic file reload/dump facility for Adabas, helping maintain performance and freeing DBA time for other duties. Delphi The Delphi product line consists of Delphi for MVS and Delphi for Windows. Delphi for Windows is a cross-platform Oracle performance desktop that provides a Windows GUI to display and analyze Oracle performance information on a PC. Delphi for MVS is a realtime performance monitor for Oracle on the MVS platform. Tabex/2 A relational table data management facility that acts as a "database in RAM" for a site's applications. Loads table data into an ESA dataspace (or storage above the 16MB line) and makes it available to applications on demand.

Return to "DBA Tools Today" by Robin Schumacher.

Please send questions or comments to dbms@mfi.com
Updated Friday, December 13, 1996.