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.

in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?

1 Answers   IBM,

---

What is a base table?

2 Answers  

---

Give a brief description of db2 isolation levels?

0 Answers  

---

what is load and unload in db2

1 Answers   IBM,

---

What are the disadvantages of using VARCHAR?

3 Answers  

---

---

Define check constraint.

0 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

What is a recovery log?

1 Answers  

---

Outputs of explain are with matchcols = 0. What does this signify?

0 Answers  

---

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

---

What is db2?

0 Answers  

---

is it compulsory commitment control in journal?

0 Answers   TCS,

---