Interested to Buy Any Domain ? << Click Here >> for more details...
database DSNDB01 means
a.db2 catalog
b.db2 directory
c.BSDS
d.active logs
answer with reason please
- 1 Answers
- 5989 Views
- I also Faced
- E-Mail Answers
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 |
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
Name the various locking levels available?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Mention the downsides of page level lock.
What is a clustered index?
Can you tell me how can you find out the # of rows updated after an update statement?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is a cursor and what is its function?
What is node in db2?
how to fetch first 100 rows in db2
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
COBOL 
