What is a DB2 catalog?

Answers were Sorted based on User's Feedback



What is a DB2 catalog?..

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

What is a DB2 catalog?..

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

Post New Answer

More DB2 Interview Questions

what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........

1 Answers  


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers   TATA,


How many sub queries can you combine together ?

4 Answers   IBM,


what is + sign and -ve sign for sql code ?

1 Answers   TCS,


What is index in db2?

1 Answers  






DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,


What is the difference between IN subselects and EXISTS subselect?

1 Answers   HCL, PreVator, TCS,


How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,


How do I copy a table in db2?

0 Answers  


cobol-db2 runjcl please?

2 Answers   DELL,


what is SMP/E? and what are the major steps of it? thanks...

1 Answers   IBM,


What is DB2 (IBM Database 2)?

3 Answers  


Categories