Showing documents 31 to 40 of 135  Previous  Next

Results per page: 5 | 10 | 20


cover image

IBM DB2 11 for z/OS Buffer Pool Monitoring and Tuning
Information Management

Redpaper, published 10 Jul 2014, last updated 31 Jul 2014

IBM® DB2® buffer pools are still a key resource for ensuring good performance. This has become increasingly important as the difference between processor speed and disk response time for a random access I/O widens in each new generation of processor. An IBM System z® processor can be configured with large amounts of storage, which if used wisely, can help compensate by using storage to avoid synchronous I/O. Several changes in buffer pool management have been provided by DB2 10 and DB2 11. The purpose of this IBM Redpaper™ is to cover the following topics:
- Describe the ... [more]


cover image

IBM DB2 with BLU Acceleration
Information Management

Solution Guide, published 17 Jul 2014

Available with the IBM DB2®10.5 release, BLU Acceleration delivers unparalleled performance improvements for analytic applications and reporting using dynamic in-memory optimized columnar technologies. BLU Acceleration is one of the most significant pieces of technology that has ever been delivered in DB2 and arguably in the database market in general. This IBM® Redbooks® Solution Guide provides an overview of the DB2 with BLU Acceleration ... [more]


cover image

DB2 10 for z/OS Technical Overview
Information Management

Redbooks, published 30 Dec 2010, last updated 16 Jul 2014

IBM® DB2® Version 10.1 for z/OS® (DB2 10 for z/OS or just DB2 10 throughout this book) is the fourteenth release of DB2 for MVS™. It brings improved performance and synergy with the System z® hardware and more opportunities to drive business value in the following areas:
- Cost savings and compliance through optimized innovations
- DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditional workloads and up to 20% CPU savings for nontraditional workloads, depending on the environments. Synergy with other IBM System z platform components ... [more]


cover image

Oracle to DB2 Conversion Guide: Compatibility Made Easy
Information Management

Redbooks, published 13 Sep 2013, last updated 3 Jul 2014

This IBM® Redbooks® publication describes IBM DB2® SQL compatibility features. The latest version of DB2 includes extensive native support for the PL/SQL procedural language, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, and more. These features can help with developing applications that run on both DB2 and Oracle and can help simplify the process of moving from Oracle to DB2. In addition, IBM now provides tools to simplify the enablement process, such as the highly scalable IBM Data Movement Tool for moving schema and data into DB2, and an Editor ... [more]


cover image

Leveraging DB2 10 for High Performance of Your Data Warehouse
Information Management

Redbooks, published 8 Jan 2014

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 ... [more]


cover image

SAP Integration with IBM DB2 Analytics Accelerator for z/OS
Information Management

Redpaper, published 18 Nov 2013

The IBM® DB2® Analytics Accelerator for z/OS® is a powerful appliance that delivers near real time analytics to SAP on System z with DB2. SAP, a highly integrated business management application, supports most of an enterprise's business processes and usually is a mission-critical application. This IBM Redpaper™ publication offers a review of the SAP on IBM System z®, SAP Business Information Warehouse and the need for accelerated processing of the queries. This paper also describes the use of IBM DB2 Analytics Accelerator (Accelerator) in SAP on System z landscapes. For details about the ... [more]


cover image

DB2 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration
Information Management

Redbooks, published 27 Aug 2013

IBM® DB2® tools for z/OS® support and exploit the most current versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and optimization of data performance. DB2 Administration Solution Pack for z/OS V1.1 (5697-DAM) offers features, functions, and processes that database administrators (DBAs) can use to more effectively and efficiently manage DB2 environments. DB2 Administration Solution Pack for z/OS is composed of the following tools:
- IBM DB2 Administration Tool for z/OS
- IBM DB2 Object Comparison Tool for z/OS
- IBM ... [more]


cover image

DB2 10 for z/OS Performance Topics
Information Management

Redbooks, published 21 Jun 2011, last updated 23 Aug 2013

DB2® 10 for z/OS can reduce the total DB2 CPU demand from 5-20%, compared to DB2 9, when you take advantage of all the enhancements. Many CPU reductions are built in directly to DB2, requiring no application changes. Some enhancements are implemented through normal DB2 activities through rebinding, restructuring database definitions, improving applications, and utility processing. The CPU demand reduction features have the potential to provide significant total cost of ownership savings based on the application mix and transaction types. Improvements in optimization reduce costs by ... [more]


cover image

DB2 for z/OS and WebSphere Integration for Enterprise Java Applications
Information Management

Redbooks, published 7 Aug 2013

IBM DB2® for z/OS® is a high-performance database management system (DBMS) with a strong reputation in traditional high-volume transaction workloads that are based on relational technology. IBM WebSphere® Application Server is web application server software that runs on most platforms with a web server and is used to deploy, integrate, execute, and manage Java Platform, Enterprise Edition applications. In this IBM® Redbooks® publication, we describe the application architecture evolution focusing on the value of having DB2 for z/OS as the data server and IBM z/OS® as the platform for ... [more]


cover image

Managing DB2 for z/OS Utilities with DB2 Tools Solution Packs
Information Management

Redbooks, published 16 Jul 2013

IBM® DB2® Tools for z/OS® support and take advantage of the latest versions of DB2 for z/OS. These tools are integral for the administration of the DB2 for z/OS environment and for optimization of data performance. In addition, the IBM portfolio addresses additional client requirements in the areas of data governance and version upgrade acceleration. Underlying the operation of any database management system are the utilities. With the number of database objects growing exponentially, managing utility jobs, meeting service level agreements (SLAs), and ensuring recoverability can be ... [more]


The above is a list of IBM Redbooks and Redpapers on Information Management, showing most recently published first. Most of these publications are available in Adobe PDF format and may be viewed online or downloaded for offline viewing and printing. Read our How to buy page for details on how to order a bound hardcopy.



Follow IBM Redbooks

Follow IBM Redbooks