DB2 9 for z/OS: Packages Revisited

DB2 9 for z/OS: Packages Revisited
Author :
Publisher : IBM Redbooks
Total Pages : 350
Release :
ISBN-10 : 9780738432366
ISBN-13 : 0738432369
Rating : 4/5 (369 Downloads)

Book Synopsis DB2 9 for z/OS: Packages Revisited by : Paolo Bruni

Download or read book DB2 9 for z/OS: Packages Revisited written by Paolo Bruni and published by IBM Redbooks. This book was released on 2012-08-03 with total page 350 pages. Available in PDF, EPUB and Kindle. Book excerpt: DB2® packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of distributed computing, JavaTM language, new tools, and upgrades in the platform software and hardware. The best practices back then just might not be optimal today. In this IBM® Redbooks® publication, we take a fresh look at bringing packages into the 21st century. We begin with an overview of packages and explain the advantages of using packages. Because database request module (DBRM) based plans have been deprecated in DB2 9, you need to convert to packages if you did not use packages already. We provide guidance on using a DB2 provided function to convert from DBRM-based plans to packages. We re-examine the application development frameworks for packages: program preparation, package setup, and execution. For distributed applications, we include a discussion of a utility to identify and remove deprecated private protocol and converting to DRDA® as well as an introduction to the new pureQuery function of Data Studio. We also discuss common problems and their resolutions. We then explore administration and operational activities dealing with packages, including security, access path management (where we discuss the newly introduced package stability feature to allow for a seamless fallback), and management and performance aspects. The appendixes include useful queries and mention tools for managing packages effectively.


DB2 9 for z/OS: Packages Revisited Related Books

DB2 9 for z/OS: Packages Revisited
Language: en
Pages: 350
Authors: Paolo Bruni
Categories: Computers
Type: BOOK - Published: 2012-08-03 - Publisher: IBM Redbooks

GET EBOOK

DB2® packages were introduced with DB2 V2.3 in 1993. During the 15 years that have elapsed, a lot has changed. In particular, there is a more widespread use of
DB2 9 for z/OS Performance Topics
Language: en
Pages: 424
Authors: Paolo Bruni
Categories: Computers
Type: BOOK - Published: 2012-09-28 - Publisher: IBM Redbooks

GET EBOOK

DB2 9 for z/OS is an exciting new version, with many improvements in performance and little regression. DB2 V9 improves availability and security, as well as ad
DB2 10 for z/OS Technical Overview
Language: en
Pages: 724
Authors: Paolo Bruni
Categories: Computers
Type: BOOK - Published: 2014-07-16 - Publisher: IBM Redbooks

GET EBOOK

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 MVSTM. It brings improved perform
Improving z/OS Application Availability by Managing Planned Outages
Language: en
Pages: 328
Authors: Frank Kyne
Categories: Computers
Type: BOOK - Published: 2014-12-22 - Publisher: IBM Redbooks

GET EBOOK

This IBM® Redbooks® publication is intended to make System Programmers, Operators, and Availability Managers aware of the enhancements to recent releases of I
Subsystem and Transaction Monitoring and Tuning with DB2 11 for z/OS
Language: en
Pages: 356
Authors: Paolo Bruni
Categories: Computers
Type: BOOK - Published: 2022-08-31 - Publisher: IBM Redbooks

GET EBOOK

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 th