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 if we fail to give values in columns declared as NOT NULL ?
How to define the a field which accepts value till 99999.99 in db2
What is dbrm library?
Explain about open switch business continuity software?
What is db2? Explain.
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
what is + sign and -ve sign for sql code ?
What is iseries database?
how to fetch multiple records without using cursor
where can we use index and subscript ? with example ?
Mention and explain the contention situations caused by locks?
Which component is used to execute the sql statements?