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 are stage one indexable predicates?
What are PACKAGES ?
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
What is auditing?
What is the difference between dbm cfg and db cfg file in db2 ?
Define predicate?
What is the difference between spufi and qmf?
Plan is an executable form of sql statements,But what exactly resides inside a Plan. what are the details inside Plan.
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
How to create db2 table in mainframe?
cursor with hold explain ?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?