Business Intelligence (BI) is a broad term relating to applications designed to analyze data for purposes of understanding and acting on the key metrics that drive profitability in an enterprise. Key to analyzing that data is providing fast, easy access to it while delivering it in formats or tools that best fit the needs of the end user. At the core of any business intelligence solution are end user query and reporting tools that provide intuitive access to data supporting a spectrum of end users from executives to "power users," from spreadsheet aficionados to the external Internet consumer. IBM® DB2 Web Query for i offers a set of modernized tools for a more robust, extensible, and productive reporting solution than the popular Query for System i tool (also known as Query/400). IBM DB2 Web Query for i preserves investments in the reports developed with Query/400 by offering a choice of importing definitions into the new technology or continuing to run existing Query/400 reports as-is. But it also offers significant productivity and performance enhancements by leveraging the latest in DB2 for i query optimization technology. This IBM Redbooks® publication provides a broad understanding of the new DB2 Web Query product. It entails a group of self-explanatory tutorials to help you get up to speed quickly. Overall, this book is designed for IT users. You can use Part 2, "Tutorials for DB2 Web Query" on page 161, as stand-alone tutorials for anyone who is developing their own queries.

This IBM® Redbooks® publication provides introductory, planning, migration, and management information about InfiniBand coupling links on IBM System z® servers. The book will help you plan and implement the migration from earlier coupling links (ISC3 and ICB4) to InfiniBand coupling links. It provides step-by-step information about configuring InfiniBand connections. Information is also provided about the performance of InfiniBand links compared to other link types. This book is intended for systems programmers, data center planners, and systems engineers. It introduces and explains InfiniBand terminology to help you understand the InfiniBand implementation on System z servers. It also serves as a basis for configuration planning and management.

This IBM® Redbooks® publication for the Tivoli® Storage Productivity Center for Replication for the Open environment walks you through the process of establishing sessions, and managing and monitoring copy services through Tivoli Storage Productivity Center for Replication. The book introduces enhanced copy services and new session types that are used by the latest IBM storage systems. Tips and guidance for session usage, tunable parameters, troubleshooting, and for implementing and managing Tivoli Storage Productivity Center for Replication’s latest functionality up to v5.2 also are provided. Tivoli Storage Productivity Center for Replication’s integration and latest functionality includes Global Mirror Pause with Consistency, Easy Tier® Heat Map Transfer, and IBM System Storage® SAN Volume Controller Change Volumes. As of v5.2, you can now manage z/OS® Hyperswap function from an Open System. IBM Tivoli Storage Productivity Center for Replication for Open Systems manages copy services in storage environments. Copy services are used by storage systems, such as IBM System Storage DS8000®, SAN Volume Controller, IBM Storwize® V3700, V3500, V7000, V7000 Unified, and IBM XIV® Storage systems to configure, manage, and monitor data-copy functions. Copy services include IBM FlashCopy®, Metro Mirror, Global Mirror, and Metro Global Mirror. This IBM Redbooks publication is the companion to the draft of the IBM Redbooks publication Tivoli Storage Productivity Center V5.2 Release Guide, SG24-8204. It is intended for storage administrators who ordered and installed Tivoli Storage Productivity Center version 5.2 and are ready to customize Tivoli Storage Productivity Center for Replication and connected storage. This publication also is for anyone that wants to learn more about Tivoli Storage Productivity Center for Replication in an open systems environment.

Building on the business intelligence (BI) framework and capabilities that are outlined in InfoSphere Warehouse: A Robust Infrastructure for Business Intelligence, SG24-7813, this IBM® Redbooks® publication focuses on the new business insight challenges that have arisen in the last few years and the new technologies in IBM DB2® 10 for Linux, UNIX, and Windows that provide powerful analytic capabilities to meet those challenges. This book is organized in to two parts. The first part provides an overview of data warehouse infrastructure and DB2 Warehouse, and outlines the planning and design process for building your data warehouse. The second part covers the major technologies that are available in DB2 10 for Linux, UNIX, and Windows. We focus on functions that help you get the most value and performance from your data warehouse. These technologies include database partitioning, intrapartition parallelism, compression, multidimensional clustering, range (table) partitioning, data movement utilities, database monitoring interfaces, infrastructures for high availability, DB2 workload management, data mining, and relational OLAP capabilities. A chapter on BLU Acceleration gives you all of the details about this exciting DB2 10.5 innovation that simplifies and speeds up reporting and analytics. Easy to set up and self-optimizing, BLU Acceleration eliminates the need for indexes, aggregates, or time-consuming database tuning to achieve top performance and storage efficiency. No SQL or schema changes are required to take advantage of this breakthrough technology. This book is primarily intended for use by IBM employees, IBM clients, and IBM Business Partners.

This IBM® Redbooks® publication describes the concepts, architecture, and implementation of the IBM XIV® Storage System. The XIV Storage System is a scalable enterprise storage system that is based on a grid array of hardware components. It can attach to both Fibre Channel Protocol (FCP) and IP network Small Computer System Interface (iSCSI) capable hosts. This system is a good fit for clients who want to be able to grow capacity without managing multiple tiers of storage. The XIV Storage System is suited for mixed or random access workloads, including online transaction processing, video streamings, images, email, and emerging workload areas, such as Web 2.0 and storage cloud. The focus of this edition is on the XIV Gen3 hardware Release 3.4, running Version 11.4 of the XIV system software. With this version, XIV Storage System offers 4 TB drives, and enhanced caching with optional 800 GB flash cache devices (solid-state drives (SSDs)) per module. IBM XIV software Version 11.4, XIV Gen3 supports encryption for all capacity points. This version also scales XIV snapshot management out with the new Hyper-Scale Consistency, by coordinating concurrent snapshots of volumes that are spread across multiple XIV systems and belong to one application. In the first few chapters of this book, we describe many of the unique and powerful concepts that form the basis of the XIV Storage System logical and physical architecture. We explain how the system is designed to eliminate direct dependencies between the hardware elements and the software that governs the system. In subsequent chapters, we explain the planning and preparation tasks that are required to deploy the system in your environment by using the intuitive, yet powerful XIV Storage Manager GUI or the XIV command-line interface (XCLI). We describe the performance characteristics of the XIV Storage System and present options that are available for alerting and monitoring, including an enhanced secure remote support capability. This book is intended for IT professionals who want an understanding of the XIV Storage System. It also targets readers who need detailed advice on how to configure and use the system.

DFSMShsm provides space, availability, and tape mount management functions in a storage device hierarchy for both system-managed, and non-system-managed storage environments. DFSMShsm allows you to automate your storage management tasks, improving the productivity by effectively managing the storage devices. This IBM® Redbooks® publication provides technical storage specialists and storage administrators with the basic DFSMShsm knowledge for implementing and customizing DFSMShsm at the IBM z/OS® V1.13 level. Hints and tips about the daily operation, monitoring, and tuning are included. Sysplex environment considerations are also included. If you are implementing DFSMShsm for the first time, you will find valuable information for exploiting the DFSMShsm functions. If you are experienced, you will find that this publication can be used as an update to the latest DFSMShsm functions, and it shows how to use those functions in an existing DFSMShsm installation.

This IBM® Redbooks® publication gives a broad understanding of IBM IMS™ integration and connectivity solutions to access applications and data stores across your enterprise architecture. As an application developer, architect, systems integrator, or systems programmer, there is important information that is available in this book that pertains to your responsibilities to continue to include the proven performance, data integrity, and workload distribution that is available from IMS in to selected projects that are related to your entire enterprise. This book updates and adds to the information in the following IBM Redbooks publications: IMS e-business Connectors: A Guide to IMS Connectivity, SG24-6514 IMS Connectivity in an On Demand Environment: A Practical Guide to IMS Connectivity, SG24-6794 Powering SOA Solutions with IMS, SG24-7662 IBM IMS Version 12 Technical Overview, SG24-7972 IMS 12: The IMS Catalog, REDP-4812 Rethink Your Mainframe Applications: Reasons and Approaches for Extension, Transformation, and Growth, REDP-4938 Please note that the additional material referenced in the text is not available from IBM.

The popularity of the Internet and the affordability of IT hardware and software have resulted in an explosion of applications, architectures, and platforms. Workloads have changed. Many applications, including mission-critical ones, are deployed on various platforms, and the IBM® System z® design has adapted to this change. It takes into account a wide range of factors, including compatibility and investment protection, to match the IT requirements of an enterprise. This IBM Redbooks® publication addresses the new IBM zEnterprise® System. This system consists of the IBM zEnterprise EC12 (zEC12), an updated IBM zEnterprise Unified Resource Manager, and the IBM zEnterprise BladeCenter® Extension (zBX) Model 003. The zEC12 is designed with improved scalability, performance, security, resiliency, availability, and virtualization. The superscalar design allows the zEC12 to deliver a record level of capacity over the prior System z servers. It is powered by 120 of the world's most powerful microprocessors. These microprocessors run at 5.5 GHz and are capable of running more than 75,000 millions of instructions per second (MIPS). The zEC12 Model HA1 is estimated to provide up to 50% more total system capacity than the IBM zEnterprise 196 (z196) Model M80. The zBX Model 003 infrastructure works with the zEC12 to enhance System z virtualization and management. It does so through an integrated hardware platform that spans mainframe, IBM POWER7®, and IBM System x® technologies. Through the Unified Resource Manager, the zEnterprise System is managed as a single pool of resources, integrating system and workload management across the environment. This book provides information about the zEnterprise System and its functions, features, and associated software support. Greater detail is offered in areas relevant to technical planning. It is intended for systems engineers, consultants, planners, and anyone who wants to understand the zEnterprise System functions and plan for their usage. It is not intended as an introduction to mainframes. Readers are expected to be generally familiar with existing IBM System z® technology and terminology.

This IBM® Redbooks® publication provides information about how you can connect mobile devices to IBM Customer Information Control System (CICS®) Transaction Server (CICS TS), using existing enterprise services already hosted on CICS, or to develop new services supporting new lines of business. This book describes the steps to develop, configure, and deploy a mobile application that connects either directly to CICS TS, or to CICS via IBM Worklight® Server. It also describes the advantages that your organization can realize by using Worklight Server with CICS. In addition, this Redbooks publication provides a broad understanding of the new CICS architecture that enables you to make new and existing mainframe applications available as web services using JavaScript Object Notation (JSON), and provides support for the transformation between JSON and application data. While doing so, we provide information about each resource definition, and its role when CICS handles or makes a request. We also describe how to move your CICS applications, and business, into the mobile space, and how to prepare your CICS environment for the following scenarios: Taking an existing CICS application and exposing it as a JSON web service Creating a new CICS application, based on a JSON schema Using CICS as a JSON client This Redbooks publication provides information about the installation and configuration steps for both Worklight Studio and Worklight Server. Worklight Studio is the Eclipse interface that a developer uses to implement a Worklight native or hybrid mobile application, and can be installed into an Eclipse instance. Worklight Server is where components developed for the server side (written in Worklight Studio), such as adapters and custom server-side authentication logic, run. CICS applications and their associated data constitute some of the most valuable assets owned by an enterprise. Therefore, the protection of these assets is an essential part of any CICS mobile project. This Redbooks publication, after a review of the main mobile security challenges, outlines the options for securing CICS JSON web services, and reviews how products, such as Worklight and IBM DataPower®, can help. It then shows examples of security configurations in CICS and Worklight.

Linux on System z offers many advantages to customers who rely on the IBM® mainframe systems to run their businesses. Linux on System z makes use of the qualities of service in the System z® hardware and in z/VM®, making it a robust industrial strength Linux. This provides an excellent platform for hosting Oracle solutions that run in your enterprise. This IBM Redbooks® publication is divided into several sections to share the following experiences that are gained while Oracle Database 11gR2 is installed and tested: Setting up Red Hat Enterprise Linux 6 for Oracle Managing an Oracle on Linux on System z environment Provisioning Linux guests using several tools Interested readers include database consultants, installers, administrators, and system programmers. This book is not meant to replace Oracle documentation but to supplement it with our experiences while Oracle products are installed and used. Please note that the additional material referenced in the text is not available from IBM.

This IBM® Redbooks® publication shows the power of IBM System z® virtualization and flexibility in sharing resources in a flexible production environment. In this book, we outline the planning and setup of Linux on System z to move from a development or test environment into production. As an example, we use one logical partition (LPAR) with shared CPUs with memory for a production environment and another LPAR that shares some CPUs, but also has a dedicated one for production. Running in IBM z/VM® mode allows for virtualization of servers and based on z/VM shares, can prioritize and control their resources. The size of the LPAR or z/VM resources depends on the workload and the applications that run that workload. We examine a typical web server environment, Java applications, and describe it by using a database management system, such as IBM DB2®. Network decisions are examined with regards to VSWITCH, shared Open Systems Adapter (OSA), IBM HiperSockets™ and the HiperPAV, or FCP/SCSI attachment used with a storage area network (SAN) Volume Controller along with performance and throughput expectations. The intended audience for this IBM Redbooks publication is IT architects who are responsible for planning production environments and IT specialists who are responsible for implementation of production environments.

This IBM® Redbooks® publication describes the positioning of the IBM Systems Director in the complete management range. It also compares the IBM Systems Director with the IBM Flex Systems Manager (FSM) and describes the environments for which each tool is best suited. This publication helps you plan, install, tailor, and configure the IBM Systems Director on different platforms. It contains information about required system resources and which network ports are used. It shows how to use the Workload Estimator to select the appropriate hardware for IBM Systems Director server and provides information about the IBM Systems Director Editions. Best practices are covered for the basic management tasks that are available in IBM Systems Director, including how to perform discovery; how to collect inventory on discovered resources; how to deploy agent, driver, and firmware updates; how to manage hardware events; and other miscellaneous tasks. An overview of best practices is provided for using IBM Systems Director VMControl™. Systems Director VMControl is a cross-platform product that assists you in rapidly deploying virtual appliances to create virtual servers that are configured with the operating system and software applications that you want. It also enables you to group resources into system pools, which enable you to centrally manage and control the different workloads in your environment. The following plug-in offerings are described: Energy monitoring and management features offered by IBM Systems Director Active Energy Manager™ along with the best practice, which needs to be followed in using the IBM Systems Director Active Energy Manager. The IBM AIX® Profile Manager is a tool that can help implement and monitor the security of all AIX servers in a production environment but also implement and monitor the system compliance of those AIX servers. Best practices and the most important questions to ask before creating Workload Partition Manager (WPAR) and WPAR Manager infrastructure. In addition, how you can manage and relocate WPARs using WPAR Manager graphical interface and the command-line interface. Network Control basic functionalities and how to plan for Network Control deployments and also a number of common scenarios with best practices. The IBM Systems Director Service and Support Manager describes how to set up and how to handle serviceable events. Best practices for the Storage Monitoring and Management capabilities offered by IBM Systems Director server. This book is for IBM IT specialists and IT architects, IBM Business Partners, and clients, who are utilizing or considering implementing IBM Systems Director.

IBM® Informix® Warehouse Accelerator is a state-of-the-art in-memory database that uses affordable innovations in memory and processor technology and trends in novel ways to boost query performance. It is a disruptive technology that changes how organizations provide analytics to its operational and historical data. Informix Warehouse Accelerator uses columnar, in-memory approach to accelerate even the most complex warehouse and operational queries without application changes or tuning. This IBM Redbooks® publication provides a comprehensive look at the technology and architecture behind the system. It contains information about the tools, data synchronization, and query processing capabilities of Informix Warehouse Accelerator, and provides steps to implement data analysis by using Informix Warehouse Accelerator within an organization. This book is intended for IBM Business Partners and clients who are looking for low-cost solutions to boost data warehouse query performance.

This IBM® Redbooks® publication highlights IBM Technical Computing as a flexible infrastructure for clients looking to reduce capital and operational expenditures, optimize energy usage, or re-use the infrastructure. This book strengthens IBM SmartCloud® solutions, in particular IBM Technical Computing clouds, with a well-defined and documented deployment model within an IBM System x® or an IBM Flex System™. This provides clients with a cost-effective, highly scalable, robust solution with a planned foundation for scaling, capacity, resilience, optimization, automation, and monitoring. This book is targeted toward technical professionals (consultants, technical support staff, IT Architects, and IT Specialists) responsible for providing cloud-computing solutions and support.

Continuing its commitment to developing and delivering industry-leading storage technologies, IBM is introducing the IBM Real-time Compression Appliances for NAS, an innovative new storage offering that delivers essential storage efficiency technologies, combined with exceptional ease of use and performance. In an era when the amount of information, particularly in unstructured files, is exploding, but budgets for storing that information are stagnant, IBM Real-time Compression technology offers a powerful tool for better information management, protection, and access. IBM Real-time Compression can help slow the growth of storage acquisition, reducing storage costs while simplifying both operations and management. It also enables organizations to keep more data available for use rather than storing it offsite or on harder-to-access tape, so they can support improved analytics and decision making. IBM Real-time Compression Appliances provide on-line storage optimization through real-time data compression, delivering dramatic cost reduction without performance degradation. This IBM® Redbooks® publication is an easy-to-follow guide that describes how to design solutions successfully using IBM Real-time Compression Appliances (IBM RTCAs). It provides practical installation examples, ease of use, remote management, high availability, and administration techniques. Furthermore, it explains best practices for RTCA solution design, application integration, and practical RTCA use cases.

Organizations of all sizes are faced with the challenge of managing massive volumes of increasingly valuable data. But storing this data can be costly, and extracting value from the data is becoming more difficult. IT organizations have limited resources but must stay responsive to dynamic environments and act quickly to consolidate, simplify, and optimize their IT infrastructures. The IBM® Storwize® V5000 system provides a smarter solution that is affordable, easy to use, and self-optimizing, which enables organizations to overcome these storage challenges. Storwize V5000 delivers efficient, entry-level configurations that are specifically designed to meet the needs of small and midsize businesses. Designed to provide organizations with the ability to consolidate and share data at an affordable price, Storwize V5000 offers advanced software capabilities that are usually found in more expensive systems. This IBM Redbooks® publication is intended for pre-sales and post-sales technical support professionals and storage administrators. The concepts in this book also relate to the IBM Storwize V3700. This book was written at a software level of Version 7 Release 1.

This IBM® Redbooks® publication provides a practical guide to the design, installation, configuration, and maintenance of IBM Content Manager OnDemand Version 9.0. Content Manager OnDemand manages high-volume storage and retrieval of electronic statements and provides efficient enterprise report management. Content Manager OnDemand transforms formatted computer output and printed reports, such as statements and invoices, into electronic information for easy report management. Content Manager OnDemand helps eliminate costly, high-volume print output by capturing, indexing, archiving, and presenting electronic information for improved customer service. This publication covers the key areas of Content Manager OnDemand, some of which might not be known to the Content Manager OnDemand community or are misunderstood. The book covers various topics, including basic information in administration, database structure, storage management, and security. In addition, the book covers data indexing, loading, conversion, and expiration. Other topics include user exits, performance, retention management, records management, and many more. Because many other resources are available that address subjects on different platforms, this publication is not intended as a comprehensive guide for Content Manager OnDemand; rather, it is intended to complement the existing Content Manager OnDemand documentation and provide insight into the issues that might be encountered in the setup and use of Content Manager OnDemand.

This IBM® Redbooks® publication describes the architecture and components of IBM InfoSphere® Optim™ Performance Manager Extended Edition. Intended for DBAs and those involved in systems performance, it provides information for installation, configuration, and deployment. InfoSphere Optim Performance Manager delivers a new paradigm used to monitor and manage database and database application performance issues. It describes product dashboards and reports and provides scenarios for how they can be used to identify, diagnose, prevent, and resolve database performance problems. IBM InfoSphere Optim Query Workload Tuner facilitates query and query workload analysis and provides expert recommendations for improving query and query workload performance. Use InfoSphere Optim Performance Manager to identify slow running queries, top CPU consumers, or query workloads needing performance improvements and seamlessly transfer them to InfoSphere Optim Query Workload Tuner for analysis and recommendations. This is done using query formatting annotated with relevant statistics, access plan graphical or hierarchical views, and access plan analysis. It further provides recommendations for improving query structure, statistics collection, and indexes including generated command syntax and rationale for the recommendations. Please note that the additional material referenced in the text is not available from IBM.

This IBM® Redbooks® publication highlights TS7700 Virtualization Engine Release 3.0. It is intended for system architects who want to integrate their storage systems for smoother operation. The IBM Virtualization Engine TS7700 offers a modular, scalable, and high-performing architecture for mainframe tape virtualization for the IBM System z® environment. It integrates 3592 Tape Drives, high-performance disks, and a new disk cache subsystem into a storage hierarchy. This storage hierarchy is managed by robust storage management firmware with extensive self-management capability. It includes the following advanced functions: Policy management to control physical volume pooling Cache management Dual copy, including across a grid network Copy mode control The TS7700 Virtualization Engine offers enhanced statistical reporting. It also includes a standards-based management interface for TS7700 Virtualization Engine management. The new IBM Virtualization Engine TS7700 Release 3.0 continues the next generation of TS7700 Virtualization Engine servers for System z tape: IBM Virtualization Engine TS7720 Server Model VEB with 3956-CS9 and 3 TB disk drive modules (DDMs) IBM Virtualization Engine TS7740 Server Model V07 with 3956-CC9 with 600 GB DDMs These Virtualization Engines are based on IBM POWER7® technology. They offer improved performance for most System z tape workloads compared to the first generation of TS7700 Virtualization Engine servers. TS7700 Virtualization Engine Release 3.0 builds on the existing capabilities of the TS7700 family. It also introduces the following capabilities: Up to 4,000,000 logical volumes per grid domain Disk cache refresh utilizing 3956-CC9 for TS7740 Model V07 and 3956-CS9 for TS7720 Model VEB Virtualization Engines IPv4 or IPv6 support for customer network and IP Security for grid communication

Organizations of all sizes are faced with the challenge of managing massive volumes of increasingly valuable data. But storing this data can be costly, and extracting value from the data is becoming more and more difficult. IT organizations have limited resources but must stay responsive to dynamic environments and act quickly to consolidate, simplify, and optimize their IT infrastructures. The IBM® Storwize® V3700 system provides a smarter solution that is affordable, easy to use, and self-optimizing, which enables organizations to overcome these storage challenges. Storwize V3700 delivers efficient, entry-level configurations that are specifically designed to meet the needs of small and midsize businesses. Designed to provide organizations with the ability to consolidate and share data at an affordable price, Storwize V3700 offers advanced software capabilities that are usually found in more expensive systems. Built upon innovative IBM technology, Storwize V3700 addresses the block storage requirements of small and midsize organizations. Providing up to 240 TB of capacity packaged in a compact 2U, Storwize V3700 is designed to accommodate the most common storage network technologies to enable easy implementation and management. This IBM Redbooks® publication is intended for pre- and post-sales technical support professionals and storage administrators. The concepts in this book also relate to the IBM Storwize V3500. This book was written at a software level of Version 7 Release 1.