Interested to Buy Any Domain ? << Click Here >> for more details...
What does this mean ?
GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
- 4 Answers
- 20562 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
How can record locking be achieved in those DB2 versions which do not support it?
What is difference between rollback and commit?
What is the role of the data page in the db2 database?
What db2 400?
What is collection in db2 bind?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
Can we update view in db2?
What is a page in db2?
What is the difference between cursor stability and repeatable read isolation levels?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are the contents of a dclmgen?
What is bind plan?
What is role in db2?
Which isolation level provides maximum concurrency?
