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.

How to resolve -504 sql code in DB2?

2 Answers   Cap Gemini,

---

What is db2 stogroup?

0 Answers  

---

What is db2? Explain.

0 Answers  

---

how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures

2 Answers   Accenture,

---

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

---

What DB2 Catalog column tell you when an index needs table reorganized ?

1 Answers  

---

wht are the restrictions for union ?

2 Answers   CTS,

---

How many databases can be created inside an instance in db2 ?

0 Answers   MCN Solutions,

---

cobol-db2 runjcl please?

2 Answers   DELL,

---

On the create tablespace, what does the CLOSE parameter do?

1 Answers  

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What are some SQL aggregates and other built-in functions?

2 Answers  

---