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 |
Explain the function of data manager.
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
Mention some fields that are a part of sqlca.
Why do we need reorg in db2?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is the difference between oracle and db2?
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
What is db2 instance?
How do you select a row using indexes in db2?
What is lock contention?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is query for your birthday date should be in hours,minute and seconds format?