DB2 10.5 for Linux, UNIX, and Windows
DB2 10.5 for Linux, UNIX, and Windows
Each row represents a storage group object.
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| SGNAME | VARCHAR (128) | Name of the storage group. | |
| SGID | INTEGER | Identifier for the storage group. | |
| OWNER | VARCHAR (128) | Authorization ID of the owner of the storage group. | |
| CREATE_TIME | TIMESTAMP | Time at which the storage group was created. | |
| DEFAULTSG | CHAR (1) | Indicates whether the storage group is the default storage
group.
|
|
| OVERHEAD | DOUBLE | Controller overhead and disk seek and latency time, in milliseconds (average for the storage paths in this storage group); 0 indicates value is not defined (assigned only by upgrade processing). | |
| DEVICEREADRATE | DOUBLE | Read transfer rate of the device, in megabytes per second (average for the storage paths in this storage group); 0 indicates value is not defined (assigned only by upgrade processing). | |
| WRITEOVERHEAD | DOUBLE | Y | Reserved for future use. |
| DEVICEWRITERATE | DOUBLE | Y | Reserved for future use. |
| DATATAG | SMALLINT | Tag to identify data stored in this storage group. Valid user-specified range is 1 through 9; 0 indicates no data tag is specified. | |
| CACHINGTIER | SMALLINT | Reserved for future use. | |
| REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |