DB2 9 for z/OS: Packages Revisited

DB2 9 for z/OS: Packages Revisited

4.11 - 1251 ratings - Source

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.Paolo Bruni, Sean A. Dunn, Howard Hirsch, Norihiko Nakajima, Suresh Sane, IBM Redbooks. 8. If the last ... If the package is not found in SPT01, a -805 SQL code is returned to the program, indicating that the package has not been found. 18.

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

You must register with us as either a Registered User before you can Download this Book. You'll be greeted by a simple sign-up page.

Once you have finished the sign-up process, you will be redirected to your download Book page.

How it works:
  • 1. Register a free 1 month Trial Account.
  • 2. Download as many books as you like (Personal use)
  • 3. Cancel the membership at any time if not satisfied.

Click button below to register and download Ebook
Privacy Policy | Contact | DMCA