Property | Description |
---|
BufferPool | Holds the name of the BufferPool associated with the Tablespace. DATATYPE: String. |
Description | Description of the Tablespace. DATATYPE: String. |
ExtentSize | Represents the ExtentSize (the number of 4k pages written to a container before skipping to the next). DATATYPE: Integer. |
GUID | GUID of the Tablespace. DATATYPE: String. |
ID | Returns the DB2 UDB BufferPool's ID. DATATYPE: Integer. |
Name | Name of the DB2 UDB BufferPool. DATATYPE: String. |
NodeGroup | Holds the name of the NodeGroup associated with the Tablespace. DATATYPE: String. |
Overhead | Represents the Overhead of the Tablespace in milliseconds (I/O Controller, disk seek, and latency time). DATATYPE: String. |
PageSize | Specifies the page size of the Tablespace in kilobytes. Sizes of 0 (default), 4, 8, 16, and 32 are valid. DATATYPE: Integer. |
PrefetchSize | Represents the PrefetchSize (the number of pages read for prefetching). DATATYPE: Integer. |
RecoveryStatus | Specifies the recovery status of the Tablespace. An empty string, ON, and OFF are valid. DATATYPE: String. |
SystemManaged | True if the Tablespace is SystemManaged (SMS) or False if it is DatabaseManaged (DMS). DATATYPE: Boolean. |
TransferRate | Represents the time (in milliseconds) required to read one 4K Page into memory. DATATYPE: String. |
Type | Represents the Tablespace Type (REGULAR, LONG, or TEMPORARY). DATATYPE: String. |