Answer Posted / 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.

How do you eliminate duplicate values in db2?

1190

---

What is cursor stability in db2?

1356

---

Where do you specify them?

1279

---

Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

1065

---

How do I connect my db2 database to ibm?

1050

---

What is the use of value function?

1149

---

What is explain in db2?

1020

---

What parameters are used to control the free space in DB2?

1056

---

How can deadlocks be resolved?

935

---

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

2365

---

What is dclgen (declaration generator)?

1059

---

What are the uses of db2 optimizer?

1295

---

Can one database have multiple instances?

1054

---

What is db2 catalog database?

1041

---

How can you do the explain of a dynamic sql statement?

1069

---