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 image copy? Virtusa 1
What is lock contention?   1
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ? Wipro 2
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?   1
cobol-db2 runjcl please? DELL 2
suppose in my table 10 rows are there , i want to update odd rows salary as 90000 ? how u do it ? any one help me ? what do we use here cursor-fetch or normal sql ? IBM 4
What is a cursor and what is its function?   2
if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records UST 4
What is meant by index cardinality?   2
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq   2
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).   1
What is sqlcode -811? CTS 7
 
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