Archives

Anything you can do I can do better, said the Package to the Plan. IDUG is 20 years old and packages are sweet 16, yet many shops still don’t take proper advantage of packages.Come away with an in-depth understanding of packages and what you need to do to exploit the many benefits of package based SQL over plan based SQL. SQLJ is underutilized in the industry, understand what SQLJ is and how easy it is to implement and use. Get valuable tips on implementing SQLJ and find out what to avoid.

EXP. LEVEL: Beginner

OBJECTIVES:

What is a package and why should your plans not have SQL bound to them? Detailed review of the many benefits to package based SQL. Understand the generation process [compile, precompile, bind, link].

Take a deep dive with package execution flow and bind parameters you need to understand. We will break down the internals and make it easy to understand EDM pool, thread storage in DBM1. Tips to tied package bind options to make your life easier.

Recommendations for implementing and maintaining packages. How many collections do you need? Should you bind a package into multiple collections? What you need to understand about package security, 2nd auth ID’s and bindagent.

Fun package topics! How can you safely deprecate obsolete programs? Learn why reoptimization favors packages. What is all this noise about free package fall back, and how can you use this to mitigate rebind performance degradation?

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!