What is a DB2 catalog?
Answers were Sorted based on User's Feedback
Answer / nahid gorji
DB2 catalogs store MetaData , which means Data about Data.
Such as information about the DB2 objects created/Altered
by users or output of RUNSTATS utility which are utilized
when running SQL statement or selecting access path.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / s
DB2 stores information about all the ojects in the db2
subsystem in the catalog tables.
Is This Answer Correct ? | 3 Yes | 0 No |
What is the difference between Primary key and unique index?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
What is the purpose of the WHENEVER statement?
What is DB2 (IBM Database 2)?
what is copy pending and check pending ?
how to resolve -818 error. how to see timestamp token in load module and plan
What technique is used to retrieve data from more than one table in a single SQL statement?
Differentiate between cs and rr isolation levels? Where do you specify them?
When is the access path determined for dynamic SQL?
What is buffer pool?
What is a collection?
What is the picture clause of null indicator variable?