Which component is responsible for processing sql statements and selecting access paths?
No Answer is Posted For this Question
Be the First to Post Answer
What is a view? Why use it?
how to check the table is empty or not?
what is the input to PLAN? what is the input to DBRM?
What if we fail to give values in columns declared as NOT NULL ?
What is the result of open cursor statement?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How do u achieve record level locking in DB2 versions when record level locking is not allowed?
db2 restart logic ?
Which catalog table stores referential constraints?
What is dbrm library?
how to resolve -805 . how to see dbrm and package not found