ALLInterview.com :: Home Page            
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
Google
   
 
Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
 
 


 

 
 COBOL interview questions  COBOL Interview Questions (851)
 JCL interview questions  JCL Interview Questions (700)
 CICS interview questions  CICS Interview Questions (448)
 DB2 interview questions  DB2 Interview Questions (668)
 IMS interview questions  IMS Interview Questions (80)
 IDMS interview questions  IDMS Interview Questions (6)
 Natural interview questions  Natural Interview Questions (41)
 ADABAS interview questions  ADABAS Interview Questions (8)
 REXX interview questions  REXX Interview Questions (21)
 Assembler interview questions  Assembler Interview Questions (29)
 CLIST interview questions  CLIST Interview Questions (1)
 QMF interview questions  QMF Interview Questions (4)
 MVS interview questions  MVS Interview Questions (11)
 OS390 interview questions  OS390 Interview Questions (9)
 OS 2 interview questions  OS 2 Interview Questions (0)
 VSAM interview questions  VSAM Interview Questions (177)
 QSAM interview questions  QSAM Interview Questions (3)
 Sysplex interview questions  Sysplex Interview Questions (5)
 IBM MainFrame AllOther interview questions  IBM MainFrame AllOther Interview Questions (128)
Question
What is a DB2 plan?
 Question Submitted By :: DB2
I also faced this Question!!     Answer Posted By  
 
Answer
# 1
A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRMs and packages. Before a DB2 for z/OS
program (with static SQL) can be run, it must have a plan
associated with it.

Plans are created by the BIND command. The plan is stored in
the DB2 directory and accessed when its program is run.
Information about the plan is stored in the DB2 catalog.
 
Is This Answer Correct ?    83 Yes 5 No
Jessica
 
Answer
# 2
An application plan or package is generated by the bind to
define an access path
 
Is This Answer Correct ?    63 Yes 14 No
Sadiq Afroze
 
 
 
Answer
# 3
It establish relation between application program and DB2
tables.
 
Is This Answer Correct ?    52 Yes 10 No
Guest
 
Answer
# 4
Only PLANS are executable and not PACKAGES. You have bind
your package to a PLAN while executing.
 
Is This Answer Correct ?    32 Yes 10 No
Shankar
 
Answer
# 5
a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.
 
Is This Answer Correct ?    12 Yes 2 No
Vira Raguram.i
 
Answer
# 6
A plan provides the channel between the aplication program
and the system which can be called up on call statements to
cobol for the sql code from db2 catalog when bind process
has done..
 
Is This Answer Correct ?    10 Yes 0 No
Anil
 
Answer
# 7
BIND CAN HAPPEN TWO PROCESS...ONE IS PACKAGE...ANOTHER ONE IS PLAN....PLAN IS EXCUTABLE....WE BIND DBRM TO PACKAGE AND THEN INTO THE PLAN....WE BIND DIRECTLY DBRM TO PLAN...ONE DBRM IS CREATED FOR ONE PROGRAM....IN 10 DBRMS WE BIND INTO THE PLAN...IN 10 TIMES WE BIND INTO THE PLAN...IN CASE OF PACKAGE 10 DBRMS ARE BIND INTO THE PACKAGE AND THEN INTO THE PLAN ITS NO NEED TO BIND 10 TIMES..10 PACKAGES ARE INCLUDED IN ONE PACKAGE LIST..WE BIND ONE PACKAGE INTO THE PLAN AUTOMATICALLY 9 PACKAGES ARE BIND...PLAN IS EXCUTABLE...MEANS IT IS EXCUTABLE WITH LOAD MODULE...PLAN TIME STAMP TOKEN AND LOAD MODULE TIME STAMP TOKEN IF IT MATCH..THE PROGRAM IS EXCUTED... 
Is This Answer Correct ?    5 Yes 0 No
Siri
 
Answer
# 8
A db2 plan contains collections which in turn contains
packages.
A package contains the exectauble format of the sql
statements placed in the DBRM which was created during the
pre-comlie step.
 
Is This Answer Correct ?    9 Yes 7 No
Ganesh
 

 
 
 
Other DB2 Interview Questions
 
  Question Asked @ Answers
 
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2   3
What is an intent lock?   3
What do you do to keep the cursor from closing after a commit?   1
How many clustering indexes can be defined for a table?   2
What is the function of the Data Manager?   2
wht r the requirements for writing a cobol-db2 pgm ? IBM 4
Suppose I have a program which uses a dynamic SQL and it has been performing well till now. Off late, I find that the performance has deteriorated. What happened?   1
What information can you find in SYSIBM.SYSLINKS table? TCS 1
Which catalog table stores referential constraints?   1
What is EXPLAIN?   1
what's the error code for Unique Index Violation?   2
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?   1
 
For more DB2 Interview Questions Click Here 
 
 
 
 
 


   
Copyright Policy  |  Terms of Service  |  Articles  |  Site Map  |  RSS Site Map  |  Contact Us
   
Copyright 2013  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  KalAajKal.com