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.

What does db2 mean?

0 Answers  

---

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

0 Answers  

---

What will the DB2 optimizer do?

2 Answers  

---

What is a Resource Control Table(RCT)? Describe its characteristics.

3 Answers  

---

How can you display the current date & current time ?

7 Answers   Cap Gemini,

---

Is there any advantage to denormalizing DB2 tables?

1 Answers  

---

What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.

1 Answers   Cap Gemini,

---

List down the types of triggers in the db2 database?

0 Answers  

---

What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,

---

what is dynamic cursor?gives syntax for this?

1 Answers   TCS,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

Mention the length of physical storage of the given data types of db2 – date, timestamp, time

0 Answers  

---