What is a DB2 catalog?
- 2 Answers
- 6393 Views
- I also Faced
- E-Mail Answers
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 coalesce in db2?
What is the logical entity between plan and Package?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
What is the physical storage length of timestamp data type?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
what are stage one indexable predicates?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What are union and union all?
What is meant by isolation level?
How to find primary key of a table in db2?
What is performance tuning db2?
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
COBOL 
