Plan Package Concept in DB2

This document will guide you how to create a PLAN , PACKAGE and how to use the same during the run time. This Document will give you a clear picture on how a PLAN and PACKAGE association exists in DB2 system.

CREATE PLAN:

CREATE PACKAGE:

1) Points Points based based on the the below below JCLSJCLS--> -> a) Bind the program with the PACKAGE (SAMP01). This package was used during the PLAN Creation(PKLIST).  b) Member name will be the program thats needs to compiled and executed.

RUN DB2:

This is a simple RUN Jcls that will execute the program DB2SAMP . 1) Points based on the below JCLS--> a) We are using the PLAN name and not the PACKAGE name, becoz Plan is executable but PACKAGE is not executable.

With the above Jcls representation , you will be able to understand the system(PLAN/PACKAGE) system(PLAN/PACKA GE) clearly (practically) and , you will also be able to answer the question asked in interview on PACKAGE and PLAN confidently.

Below mentioned are few of my other documents : UNDERSTANDING SDF II TOOL LEARN VISUALLY WITH EXAMPLES http://www.scribd.com/doc/24006897/SDF-II-TOOL-2 UNDERSTANDING SCROLL CURSORS LEARN VISUALLY WITH EXAMPLES http://www.scribd.com/doc/24006883/Scroll-Cursors-2 HOW TO CREATE DATABASE IN ADABAS http://www.scribd.com/doc/39059895/Adabas-Database HOW TO CREATE DDM IN NATURAL-ADABAS http://www.scribd.com/doc/39059971/DDM HOW TO USE MULTI-ROW FETCH IN DB2 (BASIC EXAMPLE) http://www.scribd.com/doc/52329531/Multi-Row-Fetch-Example

JAVEED AHMED