Monday, February 2, 2009

Redbook DB2 9 for z/OS: Packages Revisited

Hi DB2 User,

IBM just published a draft version of a new Redbook, "DB2 9 for z/OS: Packages Revisited, SG24-7688-00" :

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 may not be optimal today. In this book, we take a fresh look to bringing packages into the 21st century.

We begin with an overview of packages and explain the advantages of using packages. Since 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 set up 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 appendix part includes useful queries and mentions tools for managing packages effectively.

Table of Contents
Part 1. What are packages?
Chapter 1. Packages overview - ready for review
Chapter 2. BIND options
Chapter 3. Packages execution flow
Chapter 4. Conversion to packages
Part 2. Using packages
Chapter 5. Developing applications
Chapter 6. Developing distributed applications
Chapter 7. Common problems and resolutions
Part 3. Managing packages
Chapter 8. Packages administration
Chapter 9. Security considerations
Chapter 10. Access path management
Chapter 11. Performance considerations
Appendix A. Catalog tables and EXPLAIN tables
Appendix B. Useful queries
Appendix C. DSNZPARMs, trigger packages, and tools
Appendix D. Sample database environment