database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

---

What is the advantage in De-normalizing tables in DB2?

0 Answers  

---

What os does db2 run on?

0 Answers  

---

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

---

How to retrieve rows from a db2 table in embedded sql?

0 Answers  

---

i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,

---

List out the three types of page locks that can be held.

0 Answers  

---

What is RUNSTATS?

3 Answers  

---

What are the contents of a DCLGEN?

4 Answers   MetLife,

---

What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?

4 Answers  

---

What is difference between rollback and commit?

0 Answers  

---