Where besides the DB2 catalog is database object

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Where besides the DB2 catalog is database object information stored by DB2?

DB2 also stores information about DB2 objects as database descriptors (DBDs) in DBD Directory table.

(Continued on next question...)

Other Job Interview Questions

• What is the significance of DB2 free space and what parameters control it?
• What is dynamic SQL?
• What is a thread?
• In terms of DB2 indexing, what is the root page ?
• Is it mandatory to use DCLGEN? If not, why would you use it at all ?
• When one binds a PACKAGE of a plan what package information is stored and where it is stored?
• What is Declaration Generator ( DCLGEN )?
• What is lock escalation?
• What is SQLcode - 922?
• What is a DB2 catalog ?
• More...