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 value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
EXPLAIN has output with MATCHCOLS = 0. What does it mean?
What is lock escalation in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is PRIME TABLE and what are the uses of it
Is it possible using max on a char column?
what is cursor stability?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is a db2 package?
What is a cursor in programming?
What are the various locking levels available?
select distinct(empid),distinct(dept),name from EMP will the above query work?