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 (849)
 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 (79)
 IDMS interview questions  IDMS Interview Questions (6)
 Natural interview questions  Natural Interview Questions (39)
 ADABAS interview questions  ADABAS Interview Questions (7)
 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 ?    82 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 9 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 ?    31 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
 
What is the syntax of SELECT statement when embedded in a COBOL program?   2
What is DB2 (IBM Database 2)?   3
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time. Syntel 2
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?   4
What is sqlcode -811? CTS 7
select 100 records from million records ? Verizon 2
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.   1
if i made sme changes in sub pgm wht r the things to be done for this ? TCS 1
What is a subselect? Is it different from a nested select?   1
What is a clustering index ?   3
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?   2
What is auditing?   2
 
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