What is a DB2 catalog ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is a DB2 catalog ?

The DB2 catalog is a set of tables that contain information about all of the DB2 objects ( tables, views, plans etc ).

(Continued on next question...)

Other Interview Questions

• What is the error code - 803 ?
• How does one remove entires from the SCT02 table?
• What is Declaration Generator ( DCLGEN )?
• I need to view the number of tables existing under one particular OWNER. ?
• What do the initials DDL and DML stand for and what is their meaning?
• What is SQLcode - 922?
• What is an alias and how does it differ from a synonym?
• What is the difference between primary key and unique index?
• What is CHECK PENDING ?
• What is cursor stability?
• More...