Where besides the DB2 catalog is database object
information stored by DB2?
Answer / s
Datbase object information is stored in a internal format
in DBD, Database Descriptors.
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you need to do before you do EXPLAIN ?
what is datacom db?
Which component is responsible for processing sql statements and selecting access paths?
What is the use of commit in db2?
Suppose if I need to update a column, how you do that using cursor?
When will you chose to run RUNSTATS?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is the difference between drop table and delete table?
What is DCLGEN ?
On which levels locks can be applied?
What do you mean by rollback?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures