Answer / s

Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.

Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.

Partitioned tablespace, only one table can be defined and
rows are spread across partitions.

Explain the contention situations caused by locks?

0 Answers  

---

What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,

---

What is runstats utility in db2?

0 Answers  

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What does the RUNSTATS Utility do?

4 Answers  

---

how can you access index

4 Answers   IBM, Tech Mahindra,

---

What language is db2 written in?

0 Answers  

---

If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI

4 Answers   ADP,

---

What is dbrm? What it contains? When it will be created?

0 Answers  

---

how to resolve -805. give clear explination for that

2 Answers   IBM,

---

What is Declaration Generator(DCLGEN)?

1 Answers  

---

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers   Accenture,

---