Storage group properties

A storage group is a set of storage objects on which DB2® data can be stored. You can use storage groups to allocate storage for table spaces and indexes.
General page
Property Description
Name Specifies a name for the storage group.
Default Specifies that the storage group should be used as the default storage group. You can specify only one default storage group. If you specify that a new storage group is the default storage group, the storage group that you previously specified as default is no longer used as the default storage group.
Storage Paths Specifies a drive or file path for the storage group. The maximum length for the storage path is 175 characters.
Performance page
Property Description
Overhead Specifies the I/O controller overhead and disk seek and latency time. This value is used to determine the cost of I/O during query optimization. The value that you specify is a number-of-milliseconds value, and can be any numeric literal (integer, decimal, or floating point).
Device Read Rate Specifies the time to read one page into memory. This value is used to determine the cost of I/O during query optimization. The value of number-of-milliseconds can be any numeric literal (integer, decimal, or floating point).
Data Tag Specifies how often data is accessed (a data "temperature" value between “hot" or “cold"). You can specify a number from 1 to 9, where 1 is "hot" (accessed most often), and 9 is "cold" (should be accessed least often). The number that you specify should match the number that you specified in the InfoSphere® Optim™ Configuration Manager product when you specified the data tag.
Documentation page
Specifies user-supplied information about the object.

Feedback