Interested to Buy Any Domain ? << Click Here >> for more details...
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
- 4 Answers
- 20409 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / guest
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 ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
What is db2 stogroup?
How does db2 sample database connect?
What is the use of db2?
Explain in brief how does db2 determine what lock-size to use?
Define predicate?
Define buffer pool.
What is null in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How is the value function used?
What is difference between alias and synonym in db2?
What is the purpose of rollback and commit?
What is dclgen in db2?
Explain dclgen.
How do you find the maximum value in a column in db2?
