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
- 5896 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 |
What is the purpose of rollback and commit?
Mention the various locks that are available in db2.
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is index cardinality?
What is meant by AUTO COMMIT?
What is the logical entity between plan and Package?
What's The Error Code For Unique Index Voilation?
What are PACKAGES ?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
what is a plan and how do you refer the plan in the program?
What are the 2 sqlcodes that are returned?
COBOL 
