Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

DB2


1. 

IBM DB2 11 for z/OS Performance Topics

IBM DB2 11 for z/OS Performance Topics

By: Paolo Bruni; Brian Baggett; Jeffrey Berger; Neena Cherian; Nguyen Dao; David Dossantos; Akiko Hoshikawa; Maggie Jin; Gopal Krishnan; Ping Liang; Cristian Molaro; Todd Munk; Mai Nguyen; Tomokazu Ohtsu; Bharat Verma; Lingyun Wang; Dan Weis; Chung Wu; David Zhang

Publisher: IBM Redbooks

Publication Date: 25-JUL-2014

Insert Date: 27-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

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 applications, while some enhancements require user actions such as Data Definition Language (DDL) updates. DB2 11 CPU reduction can potentially...

2. 

Architecting and Deploying IBM DB2 with BLU Acceleration in Your Analytical Environment

Architecting and Deploying IBM DB2 with BLU Acceleration in Your Analytical Environment

By: Whei-Jen Chen; Brigitte Blaser; Aidan Craddock; Polly Lau; Cong Lin; Kushal Munir; Martin Schlegel; Alexander Zietlow

Publisher: IBM Redbooks

Publication Date: 19-JUN-2014

Insert Date: 09-JUL-2014

Slots: 1.0

Table of Contents • Start Reading

IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, UNIX, and Windows Release 10.5. BLU Acceleration delivers breakthrough performance improvements for analytic queries by using dynamic in-memory columnar technologies. Different from other vendor solutions, BLU Acceleration allows the unified computing of online transaction processing (OLTP) and analytics data inside a single database, therefore, removing barriers and accelerating results for users. With observed hundredfold improvement in query response time, BLU Acceleration provides a simple,...

3. 

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

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

By: Paolo Bruni; Felipe Bortoletto; Adrian Burke; Cathy Drummond; Yasuhiro Ohmori

Publisher: IBM Redbooks

Publication Date: 28-FEB-2014

Insert Date: 30-MAR-2014

Slots: 1.0

Table of Contents • Start Reading

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 tracking the behavior of the applications. We have intentionally omitted considerations for query optimization; they are worth a separate...

4. 

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

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

By: Paolo Bruni; Tom Crocker; Elaine Morelli; Richard Schaufuss

Publisher: IBM Redbooks

Publication Date: 27-AUG-2013

Insert Date: 30-MAR-2014

Slots: 1.0

Table of Contents • Start Reading

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

5. 

DB2 11 for z/OS Technical Overview

DB2 11 for z/OS Technical Overview

By: Paolo Bruni; Felipe Bortoletto; Ravikumar Kalyanasundaram; Sabine Kaschta; Glenn McGeoch; Cristian Molaro

Publisher: IBM Redbooks

Publication Date: 31-DEC-2013

Insert Date: 21-JAN-2014

Slots: 1.0

Table of Contents • Start Reading

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 - Simplified management, improved autonomics, and reduced planned outages DB2 11 can save money and save time - Aggressive CPU reduction goals - Additional...

6. 

Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1

Hybrid Analytics Solution using IBM DB2 Analytics Accelerator for z/OS V3.1

By: Paolo Bruni; Willie Favero; James Guo; Ravikumar Kalyanasundaram; Ruiping Li; Cristian Molaro; Andy Perkins; Theresa Tai; Dino Tonelli

Publisher: IBM Redbooks

Publication Date: 27-SEP-2013

Insert Date: 19-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

The IBM® DB2® Analytics Accelerator Version 3.1 for IBM z/OS® (simply called Accelerator in this book) is a union of the IBM System z® quality of service and IBM 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 analysis. In this IBM Redbooks® publication, we provide technical decision-makers with a broad understanding of the benefits of Version 3.1 of the Accelerator's major new functions. We describe their installation...

7. 

Oracle to DB2 Conversion Guide: Compatibility Made Easy

Oracle to DB2 Conversion Guide: Compatibility Made Easy

By: Yvonne Chan; Nick Ivanov; Olaf Mueller

Publisher: IBM Redbooks

Publication Date: 13-SEP-2013

Insert Date: 13-DEC-2013

Slots: 1.0

Table of Contents • Start Reading

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

8. 

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

By: Raul F. Chong; Clara Liu

Publisher: IBM Press

Publication Date: 30-OCT-2013

Insert Date: 29-OCT-2013

Slots: 1.0

Table of Contents • Start Reading

The Easy, Visual Introduction to IBM DB2 Version 10.5 for Linux, UNIX, and Windows Foreword by Judy Huber, Vice President, Distributed Data Servers and Data Warehousing; Director, IBM Canada Laboratory This book covers everything you need to get productive with the latest version of IBM DB2 and apply it to today’s business challenges. It discusses key features introduced in DB2 Versions 10.5, 10.1, and 9.7, including improvements in manageability, integration, security, Big Data support, BLU Acceleration, and cloud computing. DB2 Essentials illuminates key concepts with...

9. 

Data Integrity with DB2 for z/OS

Data Integrity with DB2 for z/OS

By: Paolo Bruni; John Iczkovits; Rama Naidoo; Fabricio Pimentel; Suresh Sane

Publisher: IBM Redbooks

Publication Date: 10-JUL-2006

Insert Date: 27-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

DB2 provides functions to guarantee integrity at the system level and at the application level. From the system point of view, DB2's integration with zSeries and disk storage architecture is the cornerstone for data integrity. Logging functionality and COPY and RECOVER utilities are the building blocks for bringing the table space back to a current or consistent status in case of hardware or software failures or when application events need to be rerun. From the application point of view, DB2 supports locking and commit at the transaction level, and general data integrity (at entity and...

10. 

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

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

By: Viviane Anavi-Chaput

Publisher: IBM Redbooks

Publication Date: 27-NOV-2001

Insert Date: 27-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

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, and introduces the migration methodology needed to move the Siebel database from a DB2/Oracle for NT platform to a DB2 for OS/390 platform. It...

11. 

DB2 for z/OS Application Programming Topics

DB2 for z/OS Application Programming Topics

By: Bart Steegmans; Rafael Garcia; Luis Garmendia; Anne Lesell

Publisher: IBM Redbooks

Publication Date: 31-OCT-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

This IBM Redbooks publication describes the major enhancements that affect application programming when accessing DB2 data on a S/390 or zSeries platform, including the object-oriented extensions such as triggers, user-defined function and user-defined distinct types, the usage of temporary tables, savepoints and the numerous extensions to the SQL language, to help you build powerful, reliable and scalable applications, whether it be in a traditional environment or on an e-business platform. IBM DATABASE 2 Universal Database Server for z/OS and OS/390 Version 7 is currently at its...

12. 

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

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

By: Viviane Anavi-Chaput

Publisher: IBM Redbooks

Publication Date: 15-NOV-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

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 customers, as well as the most efficient scenarios we would like to recommend to DB2 database administrators. The scenarios described in this...

13. 

Mining Your Own Business in Health Care Using DB2 Intelligent Miner for Data

Mining Your Own Business in Health Care Using DB2 Intelligent Miner for Data

By: Corinne Baragoin

Publisher: IBM Redbooks

Publication Date: 12-SEP-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in health care by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical health care issues are addressed in this book, such as: How to calculate weight for diagnoses related groups? Are there characteristic groups of patients in my population? Can we optimize medical tests for a...

14. 

Mining Your Own Business in Telecoms Using DB2 Intelligent Miner for Data

Mining Your Own Business in Telecoms Using DB2 Intelligent Miner for Data

By: Corinne Baragoin

Publisher: IBM Redbooks

Publication Date: 06-SEP-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in telecommunications by real usage experience and to position the value of DB2 Intelligent Miner for Data in a Business Intelligence architecture as an integrated solution. Typical telecoms issues are addressed in this book, such as: What are the characteristics of your customers? Can you predict the customers who are likely to leave? How do you discover the true value of your...

15. 

Mining Your Own Business in Banking Using DB2 Intelligent Miner for Data

Mining Your Own Business in Banking Using DB2 Intelligent Miner for Data

By: Corinne Baragoin

Publisher: IBM Redbooks

Publication Date: 30-AUG-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in banking by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture as an integrated solution. Typical banking issues are addressed in this book, such as: How can you discover the characteristics of your customers? Which products can you sell to which customers and how? This book also describes a data mining...

16. 

Mining Your Own Business in Retail Using DB2 Intelligent Miner for Data

Mining Your Own Business in Retail Using DB2 Intelligent Miner for Data

By: Corinne Baragoin

Publisher: IBM Redbooks

Publication Date: 22-AUG-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

The new challenge of integrated solutions is to get more knowledge from data in order to build the most valuable solutions. This IBM Redbooks publication is a solution guide to address the business issues in retail by real usage experience and to position the value of DB2 Intelligent Miner For Data in a Business Intelligence architecture. Typical retail issues are addressed in this book, such as: How can I characterize my customers from the mix of products that they purchase? How can I decide which products to recommend to my customers? How can I categorize my customers and identify...

17. 

IBM ESS and IBM DB2 UDB Working Together

IBM ESS and IBM DB2 UDB Working Together

By: Barry Mellish; John Aschoff; Bryan Cox; Dawn Seymour

Publisher: IBM Redbooks

Publication Date: 01-NOV-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

This IBM Redbooks publication gives you information to use the IBM Enterprise Storage Subsystem with IBM DB2 Universal Database. Most of the information presented here applies to UNIX and Windows environments. Our examples are only for AIX. First, we supply an overview of the products that we use in our environment and introduce the terminology. Next, we discuss the configuration options available for these products and the methodology that we recommend for sizing an Enterprise Storage Subsystem for use with the DB2 Universal Database. We also discuss the challenges of mapping...

18. 

DB2 for OS/390 and z/OS Powering the World's e-business Solutions

DB2 for OS/390 and z/OS Powering the World's e-business Solutions

By: Paolo Bruni; Kosta Gerontzos; Gareth Jones; Kyung Soon Um

Publisher: IBM Redbooks

Publication Date: 18-JUN-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

This IBM Redbooks publication provides an understanding of the environment required to access DB2 for OS/390 and z/OS Version 7 for use with an Internet Web server. More and more customers worldwide are using DB2 technology on the S/390 platform to implement a wide variety of mission-critical business applications. The Web is used to enhance DB2's role as a true enterprise database server. This book provides a brief introduction and overview of Internet concepts and terminology to offer a perspective for DB2 users. A broad understanding of several application and middleware...

19. 

Advanced Functions and Administration on DB2 Universal Database for iSeries

Advanced Functions and Administration on DB2 Universal Database for iSeries

By: Hernando Bedoya; Daniel Lema; Vijay Marwaha; David F Squires; Mark Walas

Publisher: IBM Redbooks

Publication Date: 14-DEC-2001

Insert Date: 26-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Dive into the details of DB2 Universal Database for iSeries advanced functions and database administration. This IBM Redbooks publication aims to equip programmers, analysts, and database administrators with all the skills and tools necessary to take advantage of the powerful features of the DB2 Universal Database for iSeries relational database system. It provides suggestions, guidelines, and practical examples about when and how to effectively use DB2 Universal Database for iSeries. This book contains information that you may not find anywhere else, including programming...

20. 

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

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

By: Paolo Bruni; Zhen Hua Dong; Josef Klitsch; Maggie Lin; Rajesh Ramachandran; Bart Steegmans; Andreas Thiele

Publisher: IBM Redbooks

Publication Date: 07-AUG-2013

Insert Date: 15-AUG-2013

Slots: 1.0

Table of Contents • Start Reading

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