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 |
Could anyone clearly explain the diference between sub query and correlated sub query?
What is a lock?
What is PRIME TABLE and what are the uses of it
what is plan? is plan executable or package?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Normalization in DB2 – first normal form, second normal form
What are the two types of logging in the db2 database? Explain them.
What is DCLGEN ?
What is usage pointer in cobol?
What is sqlca?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
How to see the structure of db2 table??