Public Methods

MethodDescription
BoundAttachmentsReturns the BoundAttachments collection of this Object.
DB2UDBContainersDMSIf the given Tablespace is database managed, this returns the DMS Containers.
DB2UDBContainersSMSIf the given Tablespace is system managed, this returns the SMS Containers.
UserCommentsReturns the user comment collection associated with this Object.

Public Properties

PropertyDescription
BufferPoolHolds the name of the BufferPool associated with the Tablespace. DATATYPE: String.
DescriptionDescription of the Tablespace. DATATYPE: String.
ExtentSizeRepresents the ExtentSize (the number of 4k pages written to a container before skipping to the next). DATATYPE: Integer.
GUIDGUID of the Tablespace. DATATYPE: String.
IDReturns the DB2 UDB BufferPool's ID. DATATYPE: Integer.
NameName of the DB2 UDB BufferPool. DATATYPE: String.
NodeGroupHolds the name of the NodeGroup associated with the Tablespace. DATATYPE: String.
OverheadRepresents the Overhead of the Tablespace in milliseconds (I/O Controller, disk seek, and latency time). DATATYPE: String.
PageSizeSpecifies the page size of the Tablespace in kilobytes. Sizes of 0 (default), 4, 8, 16, and 32 are valid. DATATYPE: Integer.
PrefetchSizeRepresents the PrefetchSize (the number of pages read for prefetching). DATATYPE: Integer.
RecoveryStatusSpecifies the recovery status of the Tablespace. An empty string, ON, and OFF are valid. DATATYPE: String.
SystemManagedTrue if the Tablespace is SystemManaged (SMS) or False if it is DatabaseManaged (DMS). DATATYPE: Boolean.
TransferRateRepresents the time (in milliseconds) required to read one 4K Page into memory. DATATYPE: String.
TypeRepresents the Tablespace Type (REGULAR, LONG, or TEMPORARY). DATATYPE: String.
  • No labels