HP OpenView Smart Plug-in for Oracle Rdb on OpenVMS Product brief The HP OpenView Smart Plug-in (SPI) for Oracle® Rdb helps administrators efficiently monitor distributed enterprise-wide Rdb Database environments from a central, best-in-class console. The SPI helps you increase Rdb availability and performance and lower the overall cost of maintaining your Oracle Rdb databases. To maximize your return on investment, HP provides high-quality software services that address all aspects of your software application life-cycle needs and align with your business goals. The OpenView SPI for Rdb has the same structure as the Database SPIs for the other database products (Oracle, Sybase, Informix and MS SQL). The metrics that are monitored are many of the ones monitored by the Online Analysis section of Rdb’s RMU SHOW STATISTICS tool. Key features and benefits • Proactively reduce Rdb database down time — The Rdb SPI - with more than 40 predefined event conditions that are easily deployed to Rdb instances - works to proactively identify database problems before they affect end-users. • Get answers, not just data — The Rdb SPI informs administrators of the tasks to perform to optimize their Rdb database environment. Rather than providing thresholds for raw data such as Synchronous Reads, the SPI provides thresholds for ratios and percentages so administrators know which commands or actions to subsequently use. • Facilitate fast recoveries — The Rdb SPI reduces mean time to recovery (MTTR) through intuitive instructional text available to the operator with the notification of the problem. The HP OpenView Smart Plug-in for Rdb helps administrators efficiently monitor distributed enterprise-wide Rdb environments from a central, best-in-class console. Other benefits • Flatten the learning curve — The Rdb SPI is configured and operated through the familiar interfaces of the HP OpenView Operations family, enabling operators to confidently assume routine database monitoring activities without learning a new management paradigm. • Delegate without losing control — The Rdb SPI allows database and IT administrators to precisely configure each database operator’s environment. • Monitor without intrusion — The Rdb SPI adopts a hands-off, non- intrusive approach to monitoring and does not create objects or interfere with the databases being managed. • Efficiently transfer change management tasks — The Rdb SPI allows administrators to configure events to page or e-mail a database administrator, who in turn can launch a web-based event browser from any location to drill down to the problem details. The Rdb SPI increases database availability and performance, lets administrators visualize capacity shortages and trends, and consequently lower the overall cost of maintaining the Rdb environment. Product Functionality Overview The HP OpenView Smart Plug-in for Rdb brings market-leading HP OpenView management and control capabilities to Rdb environments. It enables you to perform business-centric service management, event management and performance monitoring on your Rdb environment, in support of your critical business processes by monitoring many of the same conditions as Rdb’s RMU Show Statistics tool. Event /Action HP OpenView Operations monitors key operational activities and events to ensure always on availability. It checks key settings and notifies the operator if they are not set in the way that delivers the best performance on AlphaServer and Integrity Systems, for example: * the status of asynchronous pre-fetch * whether an adequate number of after-image journals exists * whether the database is configured as a single-file database rather than a multi-file database * whether the AIJ Backup Server (ABS) is able to function * whether Emergency AIJ creation is enabled * whether row cache is enabled Performance The OpenView SPI for Rdb monitors many critical Rdb database areas, for example: * Buffer Analysis such as local and global buffer effectiveness * Transaction Analysis such as the verb rollback percentage * AIJ Analysis such as the after-image journal throughput, whether the ARB pool has been exhausted, whether an adequate number of ARBs are being formatted in the background * RUJ Analysis such as the average number of synchronous write operations to the RUJ file and the average number of file extension operations * Recovery Analysis of process failure and database recovery performance such as number and duration of Database Recovery (DBR) processes * Record Analysis of storage and retrieval performance such as page discard rates, SPAM page fetch rates, and the average number of fragmented records * Area analysis of storage area performance such as the average number of synchronous and asynchronous I/O stalls and the number of times that a storage area has extended * Index Analysis of B-tree and hash index performance such as duplicate b-tree or hash index fetch and store operations and average number of b-tree leaf node retrievals A complete solution Through the combination of multiple HP OpenView Smart Plug-ins, HP OpenView provides a comprehensive solution covering Rdb and non-Rdb components of your business process. Get the most from your software investment HP provides high-quality software services that address all aspects of your software application life-cycle needs. With HP, you have access to standards-based, modular, multi-platform software coupled with best-in-class services and support. The wide range of HP service offerings—from online self-solve support to proactive mission-critical services—enables you to choose the services that best match your business needs. For an overview of HP software services, visit: www.managementsoftware.hp.com/service To access technical interactive support, visit Software Support Online at: www.hp.com/managementsoftware/services To learn more about HP Software Customer Connection, a one-stop information and learning portal for software products and services, visit: www.hp.com/go/swcustomerconnection Comprehensive training HP provides a comprehensive curriculum of HP OpenView and IT Service Management courses. These offerings provide the training you need to realize the full potential of your HP solutions, increase your network optimization and responsiveness, and achieve better return on your IT investments. With more than 25 years experience meeting complex education challenges worldwide, HP knows training. This experience, coupled with unique insights into HP OpenView software, positions HP to deliver the optimum training experience. For more information about these educational courses, visit: www.hp.com/learn The smartest way to invest in IT HP Financial Services provides innovative financing and financial asset management programs to help you cost-effectively acquire and manage your HP solutions. For more information on these services, contact your HP sales representative or visit: www.hp.com/go/hpfinancialservices Technical specifications Managed Rdb Nodes Supported Rdb releases OpenVMS Alpha: Oracle Rdb 7.1.4 and above OpenVMS Integrity: Oracle Rdb 7.2 and above Supported Operating Systems OpenVMS Integrity 8.2-1, 8.3 and above OpenVMS Alpha 7.3-2, 8.2, 8.3 and above Supported OpenView Platforms HP OpenView Operations Agent V2.0, ECO 9 or later Management Server Supported OpenView Platforms HP OpenView Operations Supported Operating Systems Microsoft Windows, HP-UX Supported Smart Plug-In HP OpenView Smart Plug-In for Databases 8.10 Ordering information Part number Product name BA802AA HP OpenView Smart Plug-in for Rdb, Tier 0 BA803AA HP OpenView Smart Plug-in for Rdb, Tier 1 BA804AA HP OpenView Smart Plug-in for Rdb, Tier 2 BA805AA HP OpenView Smart Plug-in for Rdb, Tier 3 BA806AA HP OpenView Smart plug-in for Rdb, Tier 4 Media and manuals are included with the media kit for HP OpenView Operations. For more information about hp OpenView smart plug-in for Rdb, visit http://h71000.www7.hp.com/openvms/system_management.html or contact your local HP reseller or HP sales office: Australia/New Zealand: +61 3 8877 4097, openview_events@hp.com; China: +86 10 6564 3678, software_china@hp.com ; Europe: openview_ccc@hp.com ; Hong Kong: +85 2 2805 3551, software_solutions@hp.com ; India: +91 11 690 6176, software_india@hp.com ; Japan: +81 3 3331 6111; Korea: +82 2 2199 0913, software_korea@hp.com ; Malaysia: +603 2698 6555, software_malaysia@hp.com ; Philippines: +63 2 894 1451; Singapore: +65 6275 3888, software_singapore@hp.com ; Thailand: +662 661 3900; Taiwan: +886 2 2712 0404, software_taiwan@hp.com ; United States of America: 1-877-OV-OWNER or visit www.openview.com The HP OpenView Smart Plug-in for Rdb is the intelligent choice for managing Rdb environments of any size, from a single Rdb database managed with local tools to a distributed environment of hundreds of databases managed from a central, best-in-class console. © Copyright 2007 Hewlett-Packard Development Company, L.P. All Rights Reserved. Reproduction, adaptation or translation without prior written permission is prohibited except as allowed under the copyright laws. Microsoft and Windows are U.S. registered trademarks of Microsoft Corporation. Oracle is a registered trademark of Oracle Corporation, Redwood City, California. UNIX is a registered trademark of the Open Group. For more information, visit http://h71000.www7.hp.com/openvms/system_management.html May 2007