Tech Library

    IDUG is proud to offer the latest in DB2 information straight from those who know it best: database administrators (DBAs), database managers, application programmers and developers, vendors and other IT professionals who use DB2 daily.

    I love Packages-N-Collections; Put Another Dime in the Jukebox Baby! (F05)

    Topic: 2008 NA

    Subtopic: DB2 for z/OS

    DATE: 2008-05-20 (09:15 AM - 10:15 AM)
    SPEAKERS: Rob Crane II (FedEx Freight System)

    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


    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?

    Java loves packages too, understand why SQLJ rocks! SQLJ is great; learn the flow, terminology and deployment suggestions for implementing SQLJ in your shop. SQLJ Translator, ser files, db2sqljcustomize, long-name package support and gotcha’s.

    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!

    Download File
    Click to Download

    NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.

    Copyright © 2015 IDUG. All Rights Reserved

    All material, files, logos and trademarks within this site are properties of their respective organizations.

    Terms of Service - Privacy Policy - Contact