Describe what a storage group (STOGROUP) is?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

Describe what a storage group (STOGROUP) is?

A STOGROUP is a named collection of DASD volumnes to be used by table spaces and index spaces of databases. The volumns of STOGROUP must be of the same device type.

(Continued on next question...)

Other Interview Questions

• What is the SQL Communicaions Area and what are some of its key fields?
• What keyword does an SQL SELECT statement use for a string search?
• How could one combine a set of incremental image copies into a single copy?
• What is a DB2 access path?
• Can we declare DB2 HOST variable in COBOL COPY book ?
• What is tablespace ?
• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What does it mean if the null indicator has -1, 0, -2??
• If I have a view which is a join of two or more tables, can this view be updatable?
• What is the meaning of -805 SQL return code ?
• More...