DB2 9 for z/OS: Packages Revisited DB2 9 for z/OS: Packages Revisited

DB2 9 for z/OS: Packages Revisited

Publisher Description

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, Java™ 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.

GENRE
Computers & Internet
RELEASED
2009
March 2
LANGUAGE
EN
English
LENGTH
346
Pages
PUBLISHER
IBM Redbooks
SELLER
International Business Machines Corp
SIZE
2.4
MB

More Books Like This

Oracle to DB2 Conversion Guide: Compatibility Made Easy Oracle to DB2 Conversion Guide: Compatibility Made Easy
2014
DB2 11 for z/OS Technical Overview DB2 11 for z/OS Technical Overview
2016
IBM DB2 12 for z/OS Technical Overview IBM DB2 12 for z/OS Technical Overview
2019
DB2 10 for z/OS Technical Overview DB2 10 for z/OS Technical Overview
2014
Streamline Business with Consolidation and Conversion to DB2 for z/OS Streamline Business with Consolidation and Conversion to DB2 for z/OS
2014
Who Knew You Could Do That with RPG IV? Modern RPG for the Modern Programmer Who Knew You Could Do That with RPG IV? Modern RPG for the Modern Programmer
2018

More Books by IBM Redbooks

TCP/IP Tutorial and Technical Overview TCP/IP Tutorial and Technical Overview
2006
Advanced Networking Concepts Applied Using Linux on IBM System z Advanced Networking Concepts Applied Using Linux on IBM System z
2012
IPv6 Introduction and Configuration IPv6 Introduction and Configuration
2012
IT Security Compliance Management Design Guide with IBM Tivoli Security Information and Event Manager IT Security Compliance Management Design Guide with IBM Tivoli Security Information and Event Manager
2010
IBM/Cisco Multiprotocol Routing: An Introduction and Implementation IBM/Cisco Multiprotocol Routing: An Introduction and Implementation
2009
Big Data Networked Storage Solution for Hadoop Big Data Networked Storage Solution for Hadoop
2013