When is the authorization check on DB2 objects done - at
BIND time or run time?
Answer / shyam
In the Plans or packages which has the Static SQL's,
Authorization check is done based on the VALIDATE parameter
in BIND control card ..If VALIDATE(BIND), Authorization
check is done during the BIND time. If VALIDATE(RUN),
Authorization check is done during the run time.
For the plans or packages having Dynamic SQL's ,
Authorization check is done during the run time.
Shyam
Is This Answer Correct ? | 16 Yes | 1 No |
What is db2 optimizer?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is a page?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
How can you display the current date & current time ?
What is a NULL value? What are the pros and cons of using NULLS?
Define data page.
What is a buffer in memory?
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
What information can you find in SYSIBM.SYSLINKS table?
db2 restart logic ?
What is host variable?