************************************************ *** IBM Database Systems Management Solution *** ************************************************ DATABASE SYSTEM MANAGEMENT CHALLENGES TODAY Business enterprises today are growing at a rapid pace -- so rapidly that they frequently must work with a variety of database management systems and platforms. These diverse systems have to be managed efficiently and effectively for optimal utilization of system and personnel resources. Effective and efficient systems management enable an enterprise to set up automated operations and remote systems management, which in turn make it possible to reduce resource costs. Thus, as an enterprise evolves, so too must its information management tools. Database management systems must be capable of growing along with the business -- system extensibility is just another way for an enterprise to keep costs down. THE SOLUTION TO TODAY'S DATABASE SYSTEMS MANAGEMENT CHALLENGES Database management systems are increasingly becoming a critical building block of a distributed environment and must be managed to ensure reliability, availability, and serviceability when mission critical applications are deployed. IBM* recognizes that businesses are searching for an optimal mix of heterogeneous platforms, operating systems, databases, and technologies as they attempt to reduce costs and improve the efficiency of business processes. As you go about these tasks, you are no doubt discovering that you have a lot of mixed data, multiple systems, and complex environments, and that these challenges require a broad range of skills. IBM's Database Systems Management solution addresses today's database systems management challenges with a comprehensive tool suite designed to offer an open, central point of control for managing simple as well as complex heterogeneous database systems with minimal skills and resources. THE SOLUTION IS COMPRISED OF FOUR TOOL CATEGORIES The IBM Database Systems Management solution is comprised of the following four categories, which offer a comprehensive suite of tools to help simplify database systems management. Database Administration (DBA) Tools DBA tools simplify administrative and operational tasks. You can use DBA tools to manage both IBM and non-IBM databases, facilitate expansion into a client/server environment, serve as an integration platform for management tools, and reduce requirements for additional staff. The DBA tools are: * DataHub* for OS/2* * DataHub for UNIX* Operating Systems Advisor Tools Advisor tools provide functions for performance and capacity prediction, as well as event monitoring, alert management, and network management integration. You can use the monitoring tools to manage your production applications. And you can use these tools for designing key transactions during stress testing of your performance critical applications. The Advisor tools are: * DB2 Visual Explain for OS/2 and for AIX* * DB2 Performance Monitor for OS/2 and for AIX * DB2 Performance Monitor for MVS (DB2 PM) * DB2 Estimator for Windows Data Replication Products IBM Data Replication products address the operational, informational and administrative requirements of data replication. The following replication products support a range of operating environments from mainframes to LANs to workstations, allowing client/server applications to work seamlessly with legacy and relational database management systems. The Data Replication products are: * DataPropagator* Relational * DataPropagator NonRelational * DataRefresher* * DataHub Utilities Database Systems Management utilities address routine operational utility requirements, including automated and remote utility invocation and scheduling. Utilities include LOAD, REORG, UNLOAD, RUNSTATS, BACKUP and RECOVER. Utilities are provided with the database engines. WHAT'S SO GREAT ABOUT THE DATABASE SYSTEMS MANAGEMENT SOLUTION? The IBM Database Systems Management solution makes possible database systems management of enterprise-wide, multi-vendor, multi-platform environments. For example, if an enterprise is composed of different business units performing individual processing of data, then management of these heterogeneous environments, as well as consolidation of database administration tasks within each business unit, is a must. Tools within the IBM Database Systems Management solution support heterogeneous, multi-vendor database management systems residing on multi-vendor hardware platforms and operating systems. Heterogeneous support gives you a single solution for your environment, and minimizes your support staff resource and training requirements. THE IBM DATABASE SYSTEMS MANAGEMENT SOLUTION OFFERS AUTOMATED, UNATTENDED OPERATIONS VIA THRESHOLD MONITORING. Managing your databases remotely and unattended means you can now set up, define events, rules (events you want notification on) and actions to be taken -- including corrective actions. And you can customize and extend these operations to tailor your systems operations to your business needs. THE IBM DATABASE SYSTEMS MANAGEMENT SOLUTION MAKES IT SIMPLE FOR ADMINISTRATORS TO MANAGE DATABASE SYSTEMS VIA A SINGLE CONTROL POINT. Administrators can now use a single workstation to manage all remote database management systems. Multiple control points with separate or overlapping domains also work within the solution. Administrators no longer have to be experts on the various systems they manage -- this helps an enterprise keep training costs down. THE IBM DATABASE SYSTEMS MANAGEMENT SOLUTION TOOLS ARE EASY TO USE. Administrators now have an easy-to-use, task-oriented, graphical user interface to manage all their database systems. Database management tools provided by IBM and other vendors are invoked in a consistent way, making it easier for your information technology personnel to transfer their skills to other database management systems. The object-based environment makes it easy to perform operations graphically, and ultimately, productivity increases while training costs decrease. THE IBM DATABASE SYSTEMS MANAGEMENT SOLUTION DELIVERS VALUABLE FUNCTIONS TO THE SMALL LAN ENVIRONMENT, AND YET IS SCALABLE TO LARGE, DISTRIBUTED ENTERPRISES. Typical business computing environments include networks of various size, along with various operating systems. This solution is applicable to a full spectrum of environments -- from single server LANs, to large, multiple server networks, to entire distributed operations. As your installation grows, your database system management needs to expand to match your organizational structure, supporting both centralized and decentralized management structures for your business. THE IBM DATABASE SYSTEMS MANAGEMENT SOLUTION ENABLES YOU TO LAUNCH ADDITIONAL TOOLS THAT ARE UNIQUE TO A PARTICULAR ENVIRONMENT. Want to develop a new tool unique to your business applications? Go ahead. This solution allows for third-party tools to be easily plugged in to the DataHub control point to launch other tools. Automation facilities are easily tailored and can be customized for your business. See, we -are- listening. For more information, contact your IBM authorized software reseller or IBM marketing representative. (c) International Business Machines Corporation 1995 IBM United States Santa Teresa Laboratory P.O. Box 49023 San Jose, CA 95161-9023 8-95 All Rights Reserved References in this publication to IBM products or services do not imply that IBM intends to make them available outside the United States. * IBM, DataHub, OS/2, AIX, DataPropagator and DataRefresher are trademarks or registered trademarks of the International Business Machines Corporation. All other product and company names used in this publication are trademarks or registered trademarks of their respective companies. UNIX is a registered trademark in the United States and other countries licensed exclusively through X/Open Company Limited.