The IBM® DB2® for z/OS® utilities and utility management tools are the most comprehensive on the market. They are unique in that they provide critical solutions to today’s most complex business problems across many functional areas to deliver the highest ROI from a customer’s software investment.

The DB2 Utilities Solution Pack gives customers the ability to manage their DB2 Utility processing and manage their data growth challenges. The DB2 u

The IBM® DB2® for z/OS® utilities and utility management tools are the most comprehensive on the market. They are unique in that they provide critical solutions to today’s most complex business problems across many functional areas to deliver the highest ROI from a customer’s software investment.  The DB2 Utilities Solution Pack gives customers the ability to manage their DB2 Utility processing ...

Streamlining Operations of IBM DB2 Utilities with IBM DB2 Utilities Solution Pack for z/OS

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

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 Administration Solution Pack for z/OS: Streamlining DB2 for z/OS Database Administration

This IBM Redbooks publication shows the different techniques customers can use to clone their DB2 system. Although the scenarios in the book use an SAP workload, the DB2 cloning techniques we describe are not specific to SAP. Those techniques can apply to any DB2 system and the applications running on that DB2. The book describes hands-on details of selected DB2 database cloning scenarios, typically the most popular techniques currently used by c

This IBM Redbooks publication shows the different techniques customers can use to clone their DB2 system. Although the scenarios in the book use an SAP workload, the DB2 cloning techniques we describe are not specific to SAP. Those techniques can apply to any DB2 system and the applications running on that DB2. The book describes hands-on details of selected DB2 database cloning scenarios, ...

SAP on DB2 for z/OS and OS/390: DB2 System Cloning

This document briefly describe the  XQuery enhancement to IBM DB2 10 for z/OS pureXML provided through the maintenance stream.

XQuery in IBM DB2 10 for z/OS

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 pr

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 ...

Oracle to DB2 Conversion Guide: Compatibility Made Easy

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 

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 ...

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

As IBM® continues to enhance the functionality, performance, and availability of IBM Db2®, the utilities have made significant strides towards self-management.

IBM Db2 for z/OS utilities is leading the trend towards autonomics. During the last couple of versions of Db2 for z/OS, and through the maintenance stream, new features and enhancements have been delivered to further improve the performance and functionality of the Db2 utilities.

The

As IBM® continues to enhance the functionality, performance, and availability of IBM Db2®, the utilities have made significant strides towards self-management.  IBM Db2 for z/OS utilities is leading the trend towards autonomics. During the last couple of versions of Db2 for z/OS, and through the maintenance stream, new features and enhancements have been delivered to further improve the ...

Db2 for z/OS Utilities in Practice

You ask yourself, "So I have downloaded DB2 UDB Version 8 for Linux or Windows. What's next?" This IBM Redbooks publication helps you journey through the experiences of discovering the new DB2 UDB V8.1. This journey introduces you to existing features and enhancements that make the DB2 family of products a superb choice for a relational database.

We start out by showing you how to install DB2 in both the Linux and Windows environments. Next, w

You ask yourself, "So I have downloaded DB2 UDB Version 8 for Linux or Windows. What's next?" This IBM Redbooks publication helps you journey through the experiences of discovering the new DB2 UDB V8.1. This journey introduces you to existing features and enhancements that make the DB2 family of products a superb choice for a relational database.  We start out by showing you how to install DB2 ...

DB2 UDB Evaluation Guide for Linux and Windows

DB2®  provides various installation methods as well as features and tools to deploy a large number of clients and servers. Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux® , UNIX® , and Windows®  (DB2 for LUW). 

Focusing on the DB2 V9.5 deployment methodology, this IBM®  Redbooks®  publication provides general guidance and serves as a reference reso

DB2®  provides various installation methods as well as features and tools to deploy a large number of clients and servers. Database administrators, application developers, and application architects have a number of available options when deploying DB2 9.5 for Linux® , UNIX® , and Windows®  (DB2 for LUW).   Focusing on the DB2 V9.5 deployment methodology, this IBM®  Redbooks®  publication ...

DB2 Deployment Guide

Designed for organizations that run online transaction processing (OLTP) applications, the IBM® DB2® pureScale® Feature provides clustering technology that helps deliver high availability and exceptional scalability that is transparent to applications. DB2 pureScale leverages the industry standard for OLTP scalability and reliability that is set by IBM DB2 for z/OS® and its IBM Parallel Sysplex® architecture and brings a highly scalable architect

Designed for organizations that run online transaction processing (OLTP) applications, the IBM® DB2® pureScale® Feature provides clustering technology that helps deliver high availability and exceptional scalability that is transparent to applications. DB2 pureScale leverages the industry standard for OLTP scalability and reliability that is set by IBM DB2 for z/OS® and its IBM Parallel Sysplex® ...

Continuous Availability with the IBM DB2 pureScale Feature

IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVS™. The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only. 

This IBM Redbooks® publication describes enhancements that are available with DB2 11 for z/OS. The contents help database administrators to understand the new extensions and performance

IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVS™. The DB2 11 environment is available either for new installations of DB2 or for migrations from DB2 10 for z/OS subsystems only.   This IBM Redbooks® publication describes enhancements that are available with DB2 11 for z/OS. The contents help database ...

Managing Ever-Increasing Amounts of Data with IBM DB2 for z/OS: Using Temporal Data Management, Archive Transparency, and the DB2 Analytics Accelerator

This IBM Redbooks publication provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution. 

This publication documents procedures for monitoring existing DB2 II implementations for the purposes of capacity planning. It also documents a methodo

This IBM Redbooks publication provides an overview of DB2 Information Integrator V8.2 key performance drivers; best practices to achieve optimal performance; and guidelines for monitoring a DB2 Information Integrator environment for capacity planning, problem diagnosis, and problem resolution.   This publication documents procedures for monitoring existing DB2 II implementations for the ...

DB2 II: Performance Monitoring, Tuning and Capacity Planning Guide

DB2 Express Edition for Community (DB2 Express-C) is a no charge data server for use in development and deployment. DB2 Express-C supports a full range of APIs, drivers, and interfaces for application development including PHP, C/C++, and .NET. In addition, DB2 Express-C V9 contains advanced XML features. DB2 Express-C provides ISVs an ideal starting database server for Web, enterprise, and eBusiness applications.

This IBM Redbooks publication

DB2 Express Edition for Community (DB2 Express-C) is a no charge data server for use in development and deployment. DB2 Express-C supports a full range of APIs, drivers, and interfaces for application development including PHP, C/C++, and .NET. In addition, DB2 Express-C V9 contains advanced XML features. DB2 Express-C provides ISVs an ideal starting database server for Web, enterprise, and ...

DB2 Express-C: The Developer Handbook for XML, PHP, C/C++, Java, and .NET

DB2 Workload Manager (WLM) introduces a significant evolution in the capabilities available to database administrators for controlling and monitoring executing work within DB2. This new WLM technology is directly incorporated into the DB2 engine infrastructure to allow handling higher volumes with minimal overhead. It is also enabled for tighter integration with external workload management products, such as those provided by AIX WLM. This IBM Re

DB2 Workload Manager (WLM) introduces a significant evolution in the capabilities available to database administrators for controlling and monitoring executing work within DB2. This new WLM technology is directly incorporated into the DB2 engine infrastructure to allow handling higher volumes with minimal overhead. It is also enabled for tighter integration with external workload management ...

DB2 Workload Manager for Linux, UNIX, and Windows

IBM® Db2® 13 for z/OS delivers innovations that can improve your ability to make well-informed business decisions. As the industry's first relational database that integrates artificial intelligence (AI) into SQL queries, Db2 13 combines deep-learning capabilities with advanced IBM Z® technologies to reveal hidden relationships across tables and views in your Db2 data.

As with earlier releases of Db2, Db2 13 continues to enhance availability, 

IBM® Db2® 13 for z/OS delivers innovations that can improve your ability to make well-informed business decisions. As the industry's first relational database that integrates artificial intelligence (AI) into SQL queries, Db2 13 combines deep-learning capabilities with advanced IBM Z® technologies to reveal hidden relationships across tables and views in your Db2 data.  As with earlier releases ...

IBM Db2 13 for z/OS Performance Topics

Business Intelligence and OLAP systems are no longer limited to the privileged few business analysts: they are being democratized by being shared with the rank and file employee demanding a Relational Database Management System (RDBMS) that is more OLAP-aware. 

DB2 Cube Views and its cube model provide DB2 the ability to address multidimensional analysis and become an actor in the OLAP world. 

This IBM Redbooks publication focuses on the in

Business Intelligence and OLAP systems are no longer limited to the privileged few business analysts: they are being democratized by being shared with the rank and file employee demanding a Relational Database Management System (RDBMS) that is more OLAP-aware.   DB2 Cube Views and its cube model provide DB2 the ability to address multidimensional analysis and become an actor in the OLAP world. ...

DB2 Cube Views: A Primer

This IBM Redpaper documents an installation and configuration of IBM Tivoli®  System Automation on IBM AIX®  to provide high availability for a DB2®  Universal Database™  (UDB) Balanced Configuration Unit (BCU). It provides the information that is needed to enable high availability quickly for an AIX DB2 environment. It is of special interest to those who intend to provide high availability for a DB2 database BCU that is running on the AIX platfo

This IBM Redpaper documents an installation and configuration of IBM Tivoli®  System Automation on IBM AIX®  to provide high availability for a DB2®  Universal Database™  (UDB) Balanced Configuration Unit (BCU). It provides the information that is needed to enable high availability quickly for an AIX DB2 environment. It is of special interest to those who intend to provide high availability for a ...

Installing Tivoli System Automation for High Availability of DB2 UDB BCU on AIX

This IBM® Redbooks® publication can help you tailor and configure DFSMS constructs to be used in an IBM DB2® 9 for z/OS® environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.

This book addresses both the DB2 administrator and the storage administrator. The DB2 administrator can find information about how to use DFSMS for managing DB2 data sets;

This IBM® Redbooks® publication can help you tailor and configure DFSMS constructs to be used in an IBM DB2® 9 for z/OS® environment. In addition, it provides a broad understanding of new disk architectures and their impact in DB2 data set management for large installations.  This book addresses both the DB2 administrator and the storage administrator. The DB2 administrator can find information ...

DB2 9 for z/OS and Storage Management

The IBM® DB2® Analytics Accelerator Version 2.1 for IBM z/OS® (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documentation) is a marriage of the IBM System z® Quality of Service and Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance deployment provide an ideal solution for complex analys

The IBM® DB2® Analytics Accelerator Version 2.1 for IBM z/OS® (also called DB2 Analytics Accelerator or Query Accelerator in this book and in DB2 for z/OS documentation) is a marriage of the IBM System z® Quality of Service and Netezza® technology to accelerate complex queries in a DB2 for z/OS highly secure and available environment. Superior performance and scalability with rapid appliance ...

Optimizing DB2 Queries with IBM DB2 Analytics Accelerator for z/OS

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 featu

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 ...

IBM DB2 with BLU Acceleration

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 o

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 ...

SAP Integration with IBM DB2 Analytics Accelerator for z/OS

This IBM®  Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2®  data sharing group or a subset of the group members.
The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers.
We show how to use the functions of DB2 sysplex workload balancing functions, supported by DB2 Connect™  Server and the I

This IBM®  Redpaper provides information about exploiting client load balancing and fail over capabilities across a DB2®  data sharing group or a subset of the group members. The information provided will help network specialists and data base administrators in appropriately configuring data sharing groups as TCP/IP servers. We show how to use the functions of DB2 sysplex workload balancing ...

DB2 9 for z/OS Data Sharing: Distributed Load Balancing and Fault Tolerant Configuration

IBM® Data Server Manager is a web-based, integrated database management tools platform that manages IBM Db2® and IBM Db2 for z/OS® databases. With IBM Data Server Manager, you can manage and administer IBM Db2 Analytics Accelerator (Accelerator).

This IBM Redbooks® Analytics Support web document describes the various functions that are available in Data Server Manager to manage the Accelerator server.

This document is targeted at database a

IBM® Data Server Manager is a web-based, integrated database management tools platform that manages IBM Db2® and IBM Db2 for z/OS® databases. With IBM Data Server Manager, you can manage and administer IBM Db2 Analytics Accelerator (Accelerator).  This IBM Redbooks® Analytics Support web document describes the various functions that are available in Data Server Manager to manage the Accelerator ...

Managing IBM Db2 Analytics Accelerator by using IBM Data Server Manager

This IBM Redbooks publication will help you to migrate the Siebel 2000 V6.2.1 database from:
  DB2 for NT V6 to DB2 for OS/390 V6
  Oracle for NT V8.1.6 to DB2 for NT V6
  Oracle for NT V8.1.6 to DB2 for OS/390 V6
The book describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the UK.
It provides an overview of Siebel architecture

This IBM Redbooks publication will help you to migrate the Siebel 2000 V6.2.1 database from:   DB2 for NT V6 to DB2 for OS/390 V6   Oracle for NT V8.1.6 to DB2 for NT V6   Oracle for NT V8.1.6 to DB2 for OS/390 V6 The book describes the migration experiences gained while migrating a Siebel 2000 database at the IBM ITSO Poughkeepsie Center in New York, and at the IBM Hursley Laboratory in the ...

Migrating Siebel Database from DB2/Oracle for NT to DB2 for OS/390

The IBM® DB2® pureScale® feature offers clustering technology that helps deliver high availability and exceptional scalability transparent to applications. The DB2 pureScale feature helps you to meet your business needs around availability and scalability, and is also easy to configure and administer.

This IBM Redbooks® publication addresses the DB2 pureScale feature that is available in IBM DB2 10.1 for Linux, UNIX, and Windows operating syst

The IBM® DB2® pureScale® feature offers clustering technology that helps deliver high availability and exceptional scalability transparent to applications. The DB2 pureScale feature helps you to meet your business needs around availability and scalability, and is also easy to configure and administer.  This IBM Redbooks® publication addresses the DB2 pureScale feature that is available in IBM ...

Delivering Continuity and Extreme Capacity with the IBM DB2 pureScale Feature

Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitori

Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information ...

Up and Running with DB2 on Linux

This IBM Redbooks publication explores the DB2 OLAP Server on OS/390 system. It takes a close look at the tasks and considerations in installing, tailoring and configuring the brand-new DB2 OLAP Server for OS/390 Ver. 1.1. that is specific for the OS/390 environment, rather than the DB2 OLAP Server generic task. This book is designed to assist technical specialists and DB2 OLAP Server consultants in implementing this product for OS/390. 

This IBM Redbooks publication explores the DB2 OLAP Server on OS/390 system. It takes a close look at the tasks and considerations in installing, tailoring and configuring the brand-new DB2 OLAP Server for OS/390 Ver. 1.1. that is specific for the OS/390 environment, rather than the DB2 OLAP Server generic task. This book is designed to assist technical specialists and DB2 OLAP Server consultants ...

Getting Started with DB2 OLAP Server on OS/390

IBM® DB2® 10 for z/OS® provided a strong performance improvement that drove great value for IBM clients. DB2 11 for z/OS continues the trend by focusing on further CPU savings and performance improvement through innovations within DB2 and the synergy with IBM System z® hardware and software. Most of CPU reductions are built in directly to DB2, requiring no application changes. Enhancements often take effect after the REBIND in the case of static 

IBM® DB2® 10 for z/OS® provided a strong performance improvement that drove great value for IBM clients. DB2 11 for z/OS continues the trend by focusing on further CPU savings and performance improvement through innovations within DB2 and the synergy with IBM System z® hardware and software. Most of CPU reductions are built in directly to DB2, requiring no application changes. Enhancements often ...

IBM DB2 11 for z/OS Performance Topics

Db2 12 for IBM z/OS® delivers several significant business values, such as cost reductions, scalability improvement, and improved application enablement for cloud and mobile environment. 

Db2 12 also introduces a foundation of continuous delivery. In continuous delivery, new capabilities and enhancements, including performance features, are delivered through function levels without waiting for a new release. 
Function levels 100 and 500 activ

Db2 12 for IBM z/OS® delivers several significant business values, such as cost reductions, scalability improvement, and improved application enablement for cloud and mobile environment.   Db2 12 also introduces a foundation of continuous delivery. In continuous delivery, new capabilities and enhancements, including performance features, are delivered through function levels without waiting for ...

IBM Db2 12 for z/OS Performance Topics

DB2 Performance Expert (PE) for Multiplatforms V2.2 is a workstation-based performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 PE simplifies DB2 performance management by providing you with the ability to monitor applications, system statistics, and system parameters using a single tool. 

This IBM Redbooks publication provides an overview of the architecture of DB2 Performa

DB2 Performance Expert (PE) for Multiplatforms V2.2 is a workstation-based performance analysis and tuning tool for managing a heterogeneous mix of DB2 systems with a single end-user interface. DB2 PE simplifies DB2 performance management by providing you with the ability to monitor applications, system statistics, and system parameters using a single tool.   This IBM Redbooks publication ...

DB2 Performance Expert for Multiplatforms V2.2

This IBM Redbooks publication discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS), including design considerations, best practices, operation, monitoring, and performance tuning.

We provide an overview of the architecture and main components of both WebSphere Application Server V5.0.2 and DB2 UDB V8. We introduce their key application and system performance tuning parameters. 

We discuss the general steps 

This IBM Redbooks publication discusses the integrated environment of DB2 UDB and WebSphere Application Server (WAS), including design considerations, best practices, operation, monitoring, and performance tuning.  We provide an overview of the architecture and main components of both WebSphere Application Server V5.0.2 and DB2 UDB V8. We introduce their key application and system performance ...

DB2 UDB V8 and WebSphere V5 Performance Tuning and Operations Guide

This IBM Redbooks publication describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use, automated recovery solution that enables database recovery operations with minimal disruption. Its graphical user interface (GUI) provides powerful reporting and automated recovery capabilities for pro

This IBM Redbooks publication describes the procedures for using IBM DB2 Recovery Expert for z/OS to manage the recovery of DB2 for z/OS objects in a data sharing and non-data sharing environment. IBM DB2 Recovery Expert for z/OS is an easy-to-use, automated recovery solution that enables database recovery operations with minimal disruption. Its graphical user interface (GUI) provides powerful ...

DB2 Recovery Expert for z/OS User Scenarios

IBM DB2 Recovery Expert manages the recovery of DB2 for z/OS V8 and V9 objects in a data sharing and non-data sharing environment.

The major focus of IBM DB2 Recovery Expert V2.1 for z/OS (5697-N92) is on DB2 system level backup and restore. The tool provides the ability to create a consistent full system backup with no impact on DB2 availability, comprehensive backup and recovery reporting capabilities, and robust database and storage validit

IBM DB2 Recovery Expert manages the recovery of DB2 for z/OS V8 and V9 objects in a data sharing and non-data sharing environment.  The major focus of IBM DB2 Recovery Expert V2.1 for z/OS (5697-N92) is on DB2 system level backup and restore. The tool provides the ability to create a consistent full system backup with no impact on DB2 availability, comprehensive backup and recovery reporting ...

Optimizing Restore and Recovery Solutions with DB2 Recovery Expert for z/OS V2.1

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 si

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 ...

DB2 10 for z/OS Performance Topics

IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVS™. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas.

DB2 11 can provide unmatched reliability, availability, and scalability
- Improved data sharing performance and efficiency
- Less downtime by removing growth limitations
- Simplif

IBM® DB2® Version 11.1 for z/OS® (DB2 11 for z/OS or just DB2 11 throughout this book) is the fifteenth release of DB2 for IBM MVS™. It brings performance and synergy with the IBM System z® hardware and opportunities to drive business value in the following areas.  DB2 11 can provide unmatched reliability, availability, and scalability - Improved data sharing performance and efficiency - Less ...

DB2 11 for z/OS Technical Overview

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you a single, comprehensive tool to help assess the efficiency of and optimize performance from your DB2 Universal Database in the z/OS environment. It automates the analysis of your database performance in real time and also adds e

IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS represents the effort on converging OMEGAMON XE for DB2 and DB2 Performance Expert into one product that retains the best features of each. This new tool gives you a single, comprehensive tool to help assess the efficiency of and optimize performance from your DB2 Universal Database in the z/OS environment. It automates the analysis of ...

A Deep Blue View of DB2 Performance: IBM Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS

This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery, such as adding a new catalog table and changing existing catalog tables. Also the paper covers the effects on applications and how to take advantage of new function provided using the continuous delivery model.

This IBM® Redpaper™ publication provides key information about continuous delivery in IBM Db2® 12 for z/OS®. It discusses how continuous delivery works and the changes that have been made in Db2 12 to support continuous delivery, such as adding a new catalog table and changing existing catalog tables. Also the paper covers the effects on applications and how to take advantage of new function ...

Exploring IBM Db2 for z/OS Continuous Delivery

DB2® buffer pools are a key resource for ensuring good performance. This is becoming 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. A 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.
The purpose of this Redpaper is to:
- Describe the 

DB2® buffer pools are a key resource for ensuring good performance. This is becoming 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. A 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. ...

DB2 9 for z/OS: Buffer Pool Monitoring and Tuning

Maintaining high availability in a Parallel Sysplex®  requires planning and effort on the part of many individuals in multiple disciplines. DB2®  is just one component of a highly available environment. This Redpaper provides additional information to the Parallel Sysplex Availability Checklist, SG24-6061  IBM Redbooks publication. It focuses on configuring DB2 to take advantage of Parallel Sysplex and to maintain high availability. We also inclu

Maintaining high availability in a Parallel Sysplex®  requires planning and effort on the part of many individuals in multiple disciplines. DB2®  is just one component of a highly available environment. This Redpaper provides additional information to the Parallel Sysplex Availability Checklist, SG24-6061  IBM Redbooks publication. It focuses on configuring DB2 to take advantage of Parallel ...

Achieving the Highest Levels of Parallel Sysplex Availability in a DB2 Environment

Today’s business environment has increased in the complexity and rate of change that a database administrator must control. The ability to respond quickly to a changing environment is constantly challenged by the explosion of data growth combined with a decline in an experienced work staff. 

The IBM® DB2® Administration Tool for z/OS® Version 10 helps you become productive from Day 1 with DB2 10 for z/OS by using performance savings right away

Today’s business environment has increased in the complexity and rate of change that a database administrator must control. The ability to respond quickly to a changing environment is constantly challenged by the explosion of data growth combined with a decline in an experienced work staff.   The IBM® DB2® Administration Tool for z/OS® Version 10 helps you become productive from Day 1 with DB2 ...

Managing IBM DB2 10 for z/OS Using the IBM DB2 Administration Tool for z/OS Version 10

IBM® Db2® 13 for z/OS® delivers a host of major new advancements for using, maintaining, and administering this enterprise-critical database platform. In parallel with the development of the IBM z16 hardware and the z/OS 2.5 operating system, Db2 13 leverages the latest transformative innovations on the IBM Z® platform to improve database performance, availability, scalability, reliability, and security. The integration of database artificial int

IBM® Db2® 13 for z/OS® delivers a host of major new advancements for using, maintaining, and administering this enterprise-critical database platform. In parallel with the development of the IBM z16 hardware and the z/OS 2.5 operating system, Db2 13 leverages the latest transformative innovations on the IBM Z® platform to improve database performance, availability, scalability, reliability, and ...

IBM Db2 13 for z/OS and More

As organizations strive to do more with less, IBM® DB2® for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by using enterprise system resources with broad support for clustering software, such as IBM PowerHA® SystemMirror®, IBM Tivoli® System Automation for Multiplatforms (Tivoli SA MP), and Microsoft Windows Cluster Server. 

This IBM Redbooks® publication describ

As organizations strive to do more with less, IBM® DB2® for Linux, UNIX, and Windows provides various built-in high availability features. DB2 further provides high availability solutions by using enterprise system resources with broad support for clustering software, such as IBM PowerHA® SystemMirror®, IBM Tivoli® System Automation for Multiplatforms (Tivoli SA MP), and Microsoft Windows Cluster ...

High Availability and Disaster Recovery Options for DB2 for Linux, UNIX, and Windows

This IBM Redbooks publication will help you install and customize Siebel 2000 V6.1 applications for OS/390 V2.8 using DB2 V6.1. It is based on the installation experiences gained while installing Siebel 2000 at the IBM-ITSO in Poughkeepsie, New York.
The book contains an overview of Siebel Systems and their two- and three-tier architectures in the OS/390 environment. It describes the connections to the Siebel-DB2 database server on S/390, the cu

This IBM Redbooks publication will help you install and customize Siebel 2000 V6.1 applications for OS/390 V2.8 using DB2 V6.1. It is based on the installation experiences gained while installing Siebel 2000 at the IBM-ITSO in Poughkeepsie, New York. The book contains an overview of Siebel Systems and their two- and three-tier architectures in the OS/390 environment. It describes the connections ...

Siebel 2000 Database  Implementation on OS/390 Using NT Siebel Servers

IBM and SAP share a vision for responding to customers' specific requirements for tighter integration, platform flexibility, lower total cost of ownership, and improved performance. DB2 UDB V8.2.2 is an SAP-optimized version that uses autonomic computing technologies specifically tuned to help SAP users streamline installation, improve performance, and increase availability.

This IBM Redbooks publication provides information for SAP consultant

IBM and SAP share a vision for responding to customers' specific requirements for tighter integration, platform flexibility, lower total cost of ownership, and improved performance. DB2 UDB V8.2.2 is an SAP-optimized version that uses autonomic computing technologies specifically tuned to help SAP users streamline installation, improve performance, and increase availability.  This IBM Redbooks ...

SAP Solutions on IBM DB2 UDB V8.2.2 Handbook

This IBM® Redpaper™ publication highlights the findings of a study about the factors that affect the performance of IBM CICS® transactions that access IBM DB2® resources through the CICS DB2 attachment facility. Most of the study used the following hardware and software:
[<ul>]
[<li>]A 2097-E64 logical partition (LPAR) with three dedicated central processors 
[<li>]IBM z/OS® 1.11
[<li>]IBM CICS Transaction Server V4.1
[<li>]IBM DB2 V9
[</ul

This IBM® Redpaper™ publication highlights the findings of a study about the factors that affect the performance of IBM CICS® transactions that access IBM DB2® resources through the CICS DB2 attachment facility. Most of the study used the following hardware and software:      A 2097-E64 logical partition (LPAR) with three dedicated central processors    IBM z/OS® 1.11   IBM CICS Transaction ...

IBM CICS Performance Series: CICS, DB2, and Thread Safety

This IBM Redbooks publication deals with tuning a DB2 UDB / WebSphere Application Server environment, and is aimed at a target audience of DB2 UDB application developers and database administrators (DBAs).

We provide an overview of WebSphere Application Server architecture and its main components, and introduce some of its key application tuning and system tuning parameters. Then we continue with an overview of DB2 UDB architecture and compone

This IBM Redbooks publication deals with tuning a DB2 UDB / WebSphere Application Server environment, and is aimed at a target audience of DB2 UDB application developers and database administrators (DBAs).  We provide an overview of WebSphere Application Server architecture and its main components, and introduce some of its key application tuning and system tuning parameters. Then we continue ...

DB2 UDB/WebSphere Performance Tuning Guide

This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs).

We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance perspective, and describe key performance drivers in OLTP, 

This IBM Redbooks publication provides detailed information on implementing high performance OLTP and BI applications in DB2 UDB ESE V8 environments involving AIX and Windows 2000 platforms. It is aimed at a target audience of DB2 application developers and database administrators (DBAs).  We provide an overview of the architecture of a DB2 UDB V8 non-DPF environment from a performance ...

DB2 UDB ESE V8 non-DPF Performance Guide for High Performance OLTP and BI

IBM DB2 Universal Database Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This IBM Redbooks publication is an update of DB2 UDB Exploitation of the Windows Environment (SG24-6893), with a focus on DB2 UDB Version 8.2 functions and features.

We illustrate, step-by-step, the installation and migration processes. The 

IBM DB2 Universal Database Version 8.2 is another significant jump in DBRM technology. It delivers new features to address the ever-increasing demands and requirements of information management customers. This IBM Redbooks publication is an update of DB2 UDB Exploitation of the Windows Environment (SG24-6893), with a focus on DB2 UDB Version 8.2 functions and features.  We illustrate, ...

DB2 UDB V8.2 on the Windows Environment

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:
 
[<ul>]
[<li>]Cost savings and compliance through optimized innovations 
	[<ul>]
	[<li>]DB2 10 delivers value in this area by achieving up to 10% CPU savings for traditiona

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 ...

DB2 10 for z/OS Technical Overview

The MIDAW facility was introduced in the IBM z9 processor to improve FICON performance, especially when accessing IBM DB2 databases. This facility is a new method of gathering data into and scattering data from discontinuous storage locations during an I/O operation. This IBM Redpaper is intended for industry professionals who are interested in understanding IBM z/Architecture, and for people who want to understand the types of workloads that wil

The MIDAW facility was introduced in the IBM z9 processor to improve FICON performance, especially when accessing IBM DB2 databases. This facility is a new method of gathering data into and scattering data from discontinuous storage locations during an I/O operation. This IBM Redpaper is intended for industry professionals who are interested in understanding IBM z/Architecture, and for people who ...

How does the MIDAW Facility Improve the Performance of FICON Channels Using DB2 and other workloads?

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 managem

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 ...

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

This IBM® Redbooks® publication discusses in detail the facilities of DB2® for z/OS®, which allow complete monitoring of a DB2 environment. It focuses on the use of the DB2 instrumentation facility component (IFC) to provide monitoring of DB2 data and events and includes suggestions for related tuning.

We discuss the collection of statistics for the verification of performance of the various components of the DB2 system and accounting for trac

This IBM® Redbooks® publication discusses in detail the facilities of DB2® for z/OS®, which allow complete monitoring of a DB2 environment. It focuses on the use of the DB2 instrumentation facility component (IFC) to provide monitoring of DB2 data and events and includes suggestions for related tuning.  We discuss the collection of statistics for the verification of performance of the various ...

Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS

The IBM® DB2® Analytics Accelerator for IBM z/OS® is a high-performance appliance that integrates the IBM zEnterprise® infrastructure with IBM PureData™ for Analytics, powered by IBM Netezza® technology. With this integration, you can accelerate data-intensive and complex queries in a DB2 for z/OS highly secure and available environment.

DB2 and the Analytics Accelerator appliance form a self-managing hybrid environment running online transact

The IBM® DB2® Analytics Accelerator for IBM z/OS® is a high-performance appliance that integrates the IBM zEnterprise® infrastructure with IBM PureData™ for Analytics, powered by IBM Netezza® technology. With this integration, you can accelerate data-intensive and complex queries in a DB2 for z/OS highly secure and available environment.  DB2 and the Analytics Accelerator appliance form a ...

Reliability and Performance with IBM DB2 Analytics Accelerator V4.1

IBM DATABASE 2 Universal Database Server for z/OS Version 8 is the twelfth and largest release of DB2 for MVS. It brings new synergy with the zSeries hardware and is the first major subsystem to exploit the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability

IBM DATABASE 2 Universal Database Server for z/OS Version 8 is the twelfth and largest release of DB2 for MVS. It brings new synergy with the zSeries hardware and is the first major subsystem to exploit the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional ...

DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know, ... and More

We are in a new phase of On Demand Business. Companies must respond to fluctuating market conditions and provide products and services on demand to customers. DB2 for z/OS and IBM eServer technology enable you to maintain your company’s core competencies. They help you to manage global market and competition changes with consistent availability, security, and privacy, everywhere, all the time.

DB2 continues to deliver rich functionality for sc

We are in a new phase of On Demand Business. Companies must respond to fluctuating market conditions and provide products and services on demand to customers. DB2 for z/OS and IBM eServer technology enable you to maintain your company’s core competencies. They help you to manage global market and competition changes with consistent availability, security, and privacy, everywhere, all the time.  ...

The Business Value of DB2 UDB for z/OS

IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creates and maintains additional recovery assets that you can use for intelligent analysis of both DB2 and DB2 Recovery Expert assets to find the most efficient recovery path. DB2 Recovery Expert facilitates the process of rebuilding your dat

IBM DB2 Recovery Expert for Multiplatforms provides an enhanced data recovery solution that enables more precise recovery operations while reducing disruption during the recovery process. DB2 Recovery Expert creates and maintains additional recovery assets that you can use for intelligent analysis of both DB2 and DB2 Recovery Expert assets to find the most efficient recovery path. DB2 Recovery ...

IBM DB2 Recovery Expert for Multiplatforms V2 Usage Guide

This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage.

This book is written for SAP and DB2 administrators. Knowledge of these products and of

This IBM Redbooks publication presents many of the new and improved features and functions of DB2 V9.1 for z/OS and DB2 Connect V9.1. It explains how they complement and benefit your SAP NetWeaver environment. This book also shares some of our experiences in migrating our DB2 V8 SAP data sharing environment to DB2 9 for z/OS with a minimal amount of outage.  This book is written for SAP and DB2 ...

Enhancing SAP by Using DB2 9 for z/OS

In this IBM Redbooks publication we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine Analytics and reporting. It extends the DB2 data war

In this IBM Redbooks publication we describe and discuss DB2 Data Warehouse Edition (DWE) Version 9.1, a comprehensive platform offering with functionality to build a business intelligence infrastructure for analytics and Web-based applications, and best practices for deployment. DB2 DWE integrates core components for data warehouse construction and administration, data mining, OLAP, and InLine ...

Leveraging DB2 Data Warehouse Edition for Business Intelligence

IBM® DB2® Analytics Accelerator V4.1 expands the value of high-performance analytics. DB2 Analytics Accelerator 4.1 opens to static SQL applications and rowset processing, minimizes data movement, reduces latency, and improves availability.

Reliability and Performance with IBM DB2 Analytics Accelerator Version 4.1

This Tip describes the no-charge feature that was initially made available for DB2 for z/OS V7after the publication of the related IBM Redbooks publication "DB2 for z/OS and OS/390: Ready for Java."

IBM z/OS Application Connectivity to DB2 for z/OS and OS/390

DB2® for i5/OS® on V5R4 provides features and tooling to define, test, and improve index strategies. With the addition of Maintained Temporary Index (MTI) detail, the user can better understand temporary indexes and their effect on system performance.

Written by Scott Forstie
SQL development leader 
IBM® DB2 UDB for i5/OS

DB2® for i5/OS® on V5R4 provides features and tooling to define, test, and improve index strategies. With the addition of Maintained Temporary Index (MTI) detail, the user can better understand temporary indexes and their effect on system performance.  Written by Scott Forstie SQL development leader  IBM® DB2 UDB for i5/OS

Index Advisor Surfaces Maintained Temporary Indexes Activity on DB2 for i5/OS

DB2 for z/OS is a high performance DBMS, with a very strong reputation in high volume transaction workloads based on relational technology. WebSphere Application Server is a transaction monitor based on object-oriented technology, very much in sync with the J2EE standard. Can we marry the object world and relational world to create a high-volume, high-performance end-to-end OLTP environment? The answers can be found in this IBM Redbooks publicati

DB2 for z/OS is a high performance DBMS, with a very strong reputation in high volume transaction workloads based on relational technology. WebSphere Application Server is a transaction monitor based on object-oriented technology, very much in sync with the J2EE standard. Can we marry the object world and relational world to create a high-volume, high-performance end-to-end OLTP environment? The ...

DB2 for z/OS and WebSphere: The Perfect Couple

Moving data across different databases and even different platforms has been a common task in IT shops for quite some time. Applications may have been developed independently and over time, using packages and different technology; and data might reside on different platforms exploiting the specific platform strong points. However, there still is a growing need for applications that need to access all of this data for overall processing. 

While

Moving data across different databases and even different platforms has been a common task in IT shops for quite some time. Applications may have been developed independently and over time, using packages and different technology; and data might reside on different platforms exploiting the specific platform strong points. However, there still is a growing need for applications that need to access ...

Moving Data Across the DB2 Family

IBM DATABASE 2 Universal Database Server for z/OS Version 8 (DB2 V8 throughout this IBM book) is the twelfth and largest release of DB2 for MVS. It brings synergy with the zSeries hardware and exploits the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional characteristics of availability, exceptional scalability,

IBM DATABASE 2 Universal Database Server for z/OS Version 8 (DB2 V8 throughout this IBM book) is the twelfth and largest release of DB2 for MVS. It brings synergy with the zSeries hardware and exploits the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support, application development, and query functionality enhancements for e-business, while building upon the traditional ...

DB2 UDB for z/OS Version 8 Technical Preview

The requirements for a database management system (DBMS) have included support for very large and complex data objects.
DB2  UDB for OS/390  Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. The introduction of these new data types has implied

The requirements for a database management system (DBMS) have included support for very large and complex data objects. DB2  UDB for OS/390  Version 6 introduced the support for large objects (LOBs): they can contain text documents, images, or movies, and can be stored directly in the DBMS with sizes up to 2 gigabytes per object and 65,536 TB for a single LOB column in a 4,096 partition table. ...

LOBs with DB2 for z/OS: Stronger and Faster

A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes. 

When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, function test, acceptance test, volume test, and producti

A database administrator (DBA) has a challenging job trying to maintain databases in today’s nonstop 24x7 environments. This challenge is compounded by the complexity of database structures and the time pressure of trying to be up again as soon as possible without making mistakes.   When business expands, several DB2 subsystems have to be maintained, such as multiple development systems, ...

DB2 for z/OS Administration Tools for Enhanced Change Management

Consist Advanced Development Solution (ConsistADS) is an end-to-end conversion solution that conversion and transparency methods for migrating to IBM® DB2® for z/OS® software. The solution includes DB2 for z/OS and several DB2 tools as part of the package.

This IBM Redpaper™ publication explains the Natural and Adabas conversion to DB2 for z/OS by using ConsistADS. It includes prerequisite technical assessment requirements and conversion chall

Consist Advanced Development Solution (ConsistADS) is an end-to-end conversion solution that conversion and transparency methods for migrating to IBM® DB2® for z/OS® software. The solution includes DB2 for z/OS and several DB2 tools as part of the package.  This IBM Redpaper™ publication explains the Natural and Adabas conversion to DB2 for z/OS by using ConsistADS. It includes prerequisite ...

Converting Adabas to IBM DB2 for z/OS with ConsistADS

BLU Acceleration is a new technology that has been developed by IBM® and integrated directly into the IBM DB2® engine. BLU Acceleration is a new storage engine along with integrated run time (directly into the core DB2 engine) to support the storage and analysis of column-organized tables. The BLU Acceleration processing is parallel to the regular, row-based table processing found in the DB2 engine. This is not a bolt-on technology nor is it a se

BLU Acceleration is a new technology that has been developed by IBM® and integrated directly into the IBM DB2® engine. BLU Acceleration is a new storage engine along with integrated run time (directly into the core DB2 engine) to support the storage and analysis of column-organized tables. The BLU Acceleration processing is parallel to the regular, row-based table processing found in the DB2 ...

Search results