DB2Ar 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 IBMAr RedbooksAr 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 DRDAAr 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.If you use the DB2 coprocessor, you process SQL statements as you compile your program. ... DB2 coprocessor conversion considerations in Enterprise COBOL for z/OS Compiler and Runtime Migration Guide Version 4 Release 1, anbsp;...
|Title||:||DB2 9 for z/OS: Packages Revisited|
|Author||:||Paolo Bruni, Sean A. Dunn, Howard Hirsch, Norihiko Nakajima, Suresh Sane, IBM Redbooks|
|Publisher||:||IBM Redbooks - 2012-08-03|