What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
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
Define db2.
How can the duplicate values be eliminated from db2 select?
What is db2 look?
How to execute stored procedure in db2 command editor?
What is the maximum length of sqlca?
What is the maximum number of columns in a db2 table?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is temporal table in db2?
What is reorg and runstats in db2?
Name the various locking levels available?
What is isolation level in db2?
What happens in bind step in a db2 program?
What is plan in cobol db2?
What is dbrm? What it contains?
What is rct?