Answer / Gopal Swaroop

A Storage Group (STOGROUP) in DB2 is a logical container that holds one or more database objects, such as tablespaces, indexes, and synonyms. The purpose of a storage group is to logically organize these objects for ease of administration and management. A storage group can be thought of as a collection of storage resources that are used by the database.

Is db2 a mainframe?

1 Answers  

---

Give some example of statistics collected during RUNSTATS?

1 Answers  

---

Explain the use of the WHERE clause?

1 Answers  

---

What are foreign keys?

1 Answers  

---

How to find schema of a table in db2?

1 Answers  

---

Where can you declare a cursor in a cobol-db2 program?

1 Answers  

---

How do I change the column size in db2?

1 Answers  

---

How many sub queries can you combine together ?

4 Answers   IBM,

---

Mention the downsides of page level lock.

1 Answers  

---

can we update the table by using cursors can anyone post the query?

5 Answers   DELL, HCL,

---

What is index cardinality?

3 Answers  

---

What is dpf in db2?

1 Answers  

---