database DSNDB01 means
a.db2 catalog
b.db2 directory
c.BSDS
d.active logs
answer with reason please
Answer / dogniuniu
B, DB2 directory. DSNDB01 is a DB2 system database that
contains DB2's directory. The directory contains table
spaces that hold DBDs(DBD01), Plans(SCT02), Packages
(SPT01), information about utilities(SYSUTILX) and system
log range records (SYSLGRNX). This data cannot be queried
through SQL, only through DB2 commands.
| Is This Answer Correct ? | 4 Yes | 0 No |
Q3. How will you fetch duplicate values from a DB2 table?
how to resolve -805. give clear explination for that
Which catalog table stores referential constraints?
what is difference between Plan and Package
how can u understand the end of the table ?
Which component is responsible for processing sql statements and selecting access paths?
What is rct?
What are the three lock types?
What is the default page size of buffer pools?
What is runstats db2?
Which catalog tables contain authorization information?
What's the maximum number of volumes that can be added to a STOGROUP?