ALLInterview.com :: Home Page KalAajKal.com
 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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  MainFrame  >>  IBM MainFrame  >>  DB2
 
 


 

 
 COBOL interview questions  COBOL Interview Questions
 JCL interview questions  JCL Interview Questions
 CICS interview questions  CICS Interview Questions
 DB2 interview questions  DB2 Interview Questions
 IMS interview questions  IMS Interview Questions
 IDMS interview questions  IDMS Interview Questions
 Natural interview questions  Natural Interview Questions
 ADABAS interview questions  ADABAS Interview Questions
 REXX interview questions  REXX Interview Questions
 Assembler interview questions  Assembler Interview Questions
 CLIST interview questions  CLIST Interview Questions
 QMF interview questions  QMF Interview Questions
 MVS interview questions  MVS Interview Questions
 OS390 interview questions  OS390 Interview Questions
 OS 2 interview questions  OS 2 Interview Questions
 VSAM interview questions  VSAM Interview Questions
 QSAM interview questions  QSAM Interview Questions
 Sysplex interview questions  Sysplex Interview Questions
 IBM MainFrame AllOther interview questions  IBM MainFrame AllOther Interview Questions
Question
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
 Question Submitted By :: S
I also faced this Question!!     Rank Answer Posted By  
 
  Re: What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Answer
# 1
Granting BIND gives BIND authority on the Plan MK2 to all 
users. 
BIND PLAN establishes the relationship between DB2 and all 
DBRMs or packages in that plan.

BIND(ADD) can be used for creating a new plan or package.
BIND(REPLACE) can be used when the program has been changed.

With this authority, any user is able to bind a DBRM or a 
package to the plan MK2. The users can rebind the Plan as 
well.

The Bind process performs the following :
1) Checks SQL syntax.
2) Checks security.
3) Compares column and table names against the DB2 Catalog.
4) Builds an access path strategy for each SQL statement.

Granting EXECUTE to PUBLIC gives all users, the authority 
to EXECUTE the plan MK2.

Regards,
Amit
 
Is This Answer Correct ?    1 Yes 0 No
Guest
 
  Re: What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Answer
# 2
this is data control language these work will done by data 
base administrator. if the dba gives the permission then 
only we can use tables and other components otherwise we 
can do any operation.
 
Is This Answer Correct ?    0 Yes 0 No
Shilpa
 
 
 
  Re: What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
Answer
# 3
This is basically -922 error, Authorization failure, so 
admin will grant permission to bind the plan or dbrm
 
Is This Answer Correct ?    0 Yes 0 No
Ravi
 

 
 
 
Other DB2 Interview Questions
 
  Question Asked @ Answers
 
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?  2
What do the initials DDL and DML stand for and what is their meaning?  1
What is the maximum number of tables that can be stored on a Partitioned Table Space ?  1
What techniques will be used to avoid deadlock??  1
What is meant by repeatable read?  1
How do you filter out the rows retrieved from a Db2 table ?  1
When do you specify the isolation level? How?  1
What is correlation names?  1
What is a DBRM, PLAN ?  1
what is the process of precompiler?  2
What is the significance of DB2 free space and what parameters control it?  1
When would you prefer to use VARCHAR?  2
What is lock escalation?  1
What are the advantages of using a PACKAGE?  2
What is pagespace?  1
How are write I/Os from the buffer pool executed?  1
What are the isolation levels possible ?  2
What is a clustered index?  1
What are the four lockable units for DB2?  1
What are the various locking levels available?  2
 
For more DB2 Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com