com.ibm.db.models.db2.luw
Interface LUWTableSpace

All Superinterfaces:
commonj.sdo.DataObject, org.eclipse.emf.ecore.sdo.EDataObject, org.eclipse.emf.ecore.EModelElement, org.eclipse.emf.ecore.ENamedElement, org.eclipse.emf.ecore.EObject, org.eclipse.emf.common.notify.Notifier, java.io.Serializable, org.eclipse.wst.rdb.internal.models.sql.schema.SQLObject
All Known Implementing Classes:
LUWTableSpaceImpl

public interface LUWTableSpace
extends org.eclipse.wst.rdb.internal.models.sql.schema.SQLObject

A representation of the model object 'Table Space'. DB2 Universal Database SQL Reference Version 8.1 (Vol.1 and 2) http://www7b.software.ibm.com/dmdd/library/techarticle/0206sqlref/0206sqlref.html Table space design A table space is a storage structure containing tables, indexes, large objects, and long data. Table spaces reside in database partition groups. They allow you to assign the location of database and table data directly onto containers. (A container can be a directory name, a device name, or a file name.) This can provide improved performance and more flexible configuration. Since table spaces reside in database partition groups, the table space selected to hold a table defines how the data for that table is distributed across the database partitions in a database partition group. A single table space can span several containers. It is possible for multiple containers (from one or more table spaces) to be created on the same physical disk (or drive). For improved performance, each container should use a different disk. Figure 14 illustrates the relationship between tables and table spaces within a database, and the containers associated with that database. Creating table spaces in database partition groups By placing a table space in a multiple-partition database partition group, all of the tables within the table space are divided or partitioned across each partition in the database partition group. The table space is created into a database partition group. Once in a database partition group, the table space must remain there; it cannot be changed to another database partition group. The CREATE TABLESPACE statement is used to associate a table space with a database partition group. IBMR DB2 Universal Database - SQL Reference Volume 1 - Version 8 Table spaces and other storage structures Storage structures contain database objects. The basic storage structure is the table space; it contains tables, indexes, large objects, and data defined with a LONG data type. There are two types of table spaces: - Database managed space (DMS): a table space that is managed by the database manager. - System managed space (SMS): a table space that is managed by the operating system. All table spaces consist of containers. A container describes where objects are stored. A subdirectory in a file system is an example of a container. When data is read from table space containers, it is placed in an area of memory called a buffer pool. A buffer pool is associated with a specific table space, thereby allowing control over which data will share the same memory areas for data buffering. Creation: EXTENTSIZE number-of-pages Specifies the number of PAGESIZE pages that will be written to a container before skipping to the next container. The extent size value can also be specified as an integer value followed by K (for kilobytes), M (for megabytes), or G (for gigabytes). If specified in this way, the floor of the number of bytes divided by the pagesize is used to determine the number of pages value for extent size. The database manager cycles repeatedly through the containers as data is stored. The default value is provided by the DFT_EXTENT_SZ configuration parameter. PREFETCHSIZE number-of-pages Specifies the number of PAGESIZE pages that will be read from the tablespace when data prefetching is being performed. The prefetch size value can also be specified as an integer value followed by K (for kilobytes), M (for megabytes), or G (for gigabytes). If specified in this way, the floor of the number of bytes divided by the pagesize is used to determine the number of pages value for prefetch size. Prefetching reads in data needed by a query prior to it being referenced by the query, so that the query need not wait for I/O to be performed. The default value is provided by the DFT_PREFETCH_SZ configuration parameter. BUFFERPOOL bufferpool-name The name of the buffer pool used for tables in this tablespace. The buffer pool must exist (SQLSTATE 42704). If not specified, the default buffer pool (IBMDEFAULTBP) is used. The page size of the bufferpool must match the page size specified (or defaulted) for the tablespace (SQLSTATE 428CB). The database partition group of the tablespace must be defined for the bufferpool (SQLSTATE 42735). OVERHEAD number-of-milliseconds Any numeric literal (integer, decimal, or floating point) that specifies the I/O controller overhead and disk seek and latency time, in milliseconds. The number should be an average for all containers that belong to the tablespace, if not the same for all containers. This value is used to determine the cost of I/O during query optimization. TRANSFERRATE number-of-milliseconds Any numeric literal (integer, decimal, or floating point) that specifies the time to read one page into memory, in milliseconds. The number should be an average for all containers that belong to the tablespace, if not the same for all containers. This value is used to determine the cost of I/O during query optimization. DROPPED TABLE RECOVERY Dropped tables in the specified tablespace may be recovered using the RECOVER TABLE ON option of the ROLLFORWARD command. This clause can only be specified for a REGULAR tablespace (SQLSTATE 42613).

The following features are supported:

See Also:
LUWPackage.getLUWTableSpace()

Method Summary
 LUWBufferPool getBufferPool()
          Returns the value of the 'Buffer Pool' reference.
 org.eclipse.emf.common.util.EList getContainers()
          Returns the value of the 'Containers' containment reference list.
 LUWDatabase getDatabase()
          Returns the value of the 'Database' reference.
 int getExtentSize()
          Returns the value of the 'Extent Size' attribute.
 LUWPartitionGroup getGroup()
          Returns the value of the 'Group' reference.
 org.eclipse.emf.common.util.EList getIndexDataTables()
          Returns the value of the 'Index Data Tables' reference list.
 org.eclipse.emf.common.util.EList getLOBDataPartition()
          Returns the value of the 'LOB Data Partition' reference list.
 org.eclipse.emf.common.util.EList getLOBDataTables()
          Returns the value of the 'LOB Data Tables' reference list.
 ManagementType getManagementType()
          Returns the value of the 'Management Type' attribute.
 double getOverhead()
          Returns the value of the 'Overhead' attribute.
 PageSizeType getPageSize()
          Returns the value of the 'Page Size' attribute.
 int getPreFetchSize()
          Returns the value of the 'Pre Fetch Size' attribute.
 org.eclipse.emf.common.util.EList getRegularDataPartition()
          Returns the value of the 'Regular Data Partition' reference list.
 org.eclipse.emf.common.util.EList getRegularDataTables()
          Returns the value of the 'Regular Data Tables' reference list.
 long getSize()
          Returns the value of the 'Size' attribute.
 java.util.List getTables()
           
 TableSpaceType getTablespaceType()
          Returns the value of the 'Tablespace Type' attribute.
 double getTransferRate()
          Returns the value of the 'Transfer Rate' attribute.
 boolean isAutoResize()
          Returns the value of the 'Auto Resize' attribute.
 boolean isRecoverDroppedTableOn()
          Returns the value of the 'Recover Dropped Table On' attribute.
 void setAutoResize(boolean value)
          Sets the value of the 'Auto Resize' attribute.
 void setBufferPool(LUWBufferPool value)
          Sets the value of the 'Buffer Pool' reference.
 void setDatabase(LUWDatabase value)
          Sets the value of the 'Database' reference.
 void setExtentSize(int value)
          Sets the value of the 'Extent Size' attribute.
 void setGroup(LUWPartitionGroup value)
          Sets the value of the 'Group' reference.
 void setManagementType(ManagementType value)
          Sets the value of the 'Management Type' attribute.
 void setOverhead(double value)
          Sets the value of the 'Overhead' attribute.
 void setPageSize(PageSizeType value)
          Sets the value of the 'Page Size' attribute.
 void setPreFetchSize(int value)
          Sets the value of the 'Pre Fetch Size' attribute.
 void setRecoverDroppedTableOn(boolean value)
          Sets the value of the 'Recover Dropped Table On' attribute.
 void setSize(long value)
          Sets the value of the 'Size' attribute.
 void setTablespaceType(TableSpaceType value)
          Sets the value of the 'Tablespace Type' attribute.
 void setTransferRate(double value)
          Sets the value of the 'Transfer Rate' attribute.
 
Methods inherited from interface org.eclipse.wst.rdb.internal.models.sql.schema.SQLObject
addEAnnotation, addEAnnotationDetail, getComments, getDependencies, getDescription, getEAnnotation, getEAnnotationDetail, getLabel, getPrivileges, removeEAnnotationDetail, setAnnotationDetail, setDescription, setLabel
 
Methods inherited from interface org.eclipse.emf.ecore.sdo.EDataObject
getInstanceProperties
 
Methods inherited from interface commonj.sdo.DataObject
createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, createDataObject, delete, get, get, get, getBigDecimal, getBigDecimal, getBigDecimal, getBigInteger, getBigInteger, getBigInteger, getBoolean, getBoolean, getBoolean, getByte, getByte, getByte, getBytes, getBytes, getBytes, getChar, getChar, getChar, getContainer, getContainmentProperty, getDataGraph, getDataObject, getDataObject, getDataObject, getDate, getDate, getDate, getDouble, getDouble, getDouble, getFloat, getFloat, getFloat, getInt, getInt, getInt, getList, getList, getList, getLong, getLong, getLong, getSequence, getSequence, getSequence, getShort, getShort, getShort, getString, getString, getString, getType, isSet, isSet, isSet, set, set, set, setBigDecimal, setBigDecimal, setBigDecimal, setBigInteger, setBigInteger, setBigInteger, setBoolean, setBoolean, setBoolean, setByte, setByte, setByte, setBytes, setBytes, setBytes, setChar, setChar, setChar, setDataObject, setDataObject, setDataObject, setDate, setDate, setDate, setDouble, setDouble, setDouble, setFloat, setFloat, setFloat, setInt, setInt, setInt, setList, setList, setList, setLong, setLong, setLong, setShort, setShort, setShort, setString, setString, setString, unset, unset, unset
 
Methods inherited from interface org.eclipse.emf.ecore.ENamedElement
getName, setName
 
Methods inherited from interface org.eclipse.emf.ecore.EModelElement
getEAnnotations
 

Method Detail

getTablespaceType

TableSpaceType getTablespaceType()
Returns the value of the 'Tablespace Type' attribute. The literals are from the enumeration TableSpaceType.

If the meaning of the 'Tablespace Type' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Tablespace Type' attribute.
See Also:
TableSpaceType, setTablespaceType(TableSpaceType), LUWPackage.getLUWTableSpace_TablespaceType()

setTablespaceType

void setTablespaceType(TableSpaceType value)
Sets the value of the 'Tablespace Type' attribute.

Parameters:
value - the new value of the 'Tablespace Type' attribute.
See Also:
TableSpaceType, getTablespaceType()

getManagementType

ManagementType getManagementType()
Returns the value of the 'Management Type' attribute. The literals are from the enumeration ManagementType.

If the meaning of the 'Management Type' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Management Type' attribute.
See Also:
ManagementType, setManagementType(ManagementType), LUWPackage.getLUWTableSpace_ManagementType()

setManagementType

void setManagementType(ManagementType value)
Sets the value of the 'Management Type' attribute.

Parameters:
value - the new value of the 'Management Type' attribute.
See Also:
ManagementType, getManagementType()

getExtentSize

int getExtentSize()
Returns the value of the 'Extent Size' attribute.

If the meaning of the 'Extent Size' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Extent Size' attribute.
See Also:
setExtentSize(int), LUWPackage.getLUWTableSpace_ExtentSize()

setExtentSize

void setExtentSize(int value)
Sets the value of the 'Extent Size' attribute.

Parameters:
value - the new value of the 'Extent Size' attribute.
See Also:
getExtentSize()

getPreFetchSize

int getPreFetchSize()
Returns the value of the 'Pre Fetch Size' attribute.

If the meaning of the 'Pre Fetch Size' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Pre Fetch Size' attribute.
See Also:
setPreFetchSize(int), LUWPackage.getLUWTableSpace_PreFetchSize()

setPreFetchSize

void setPreFetchSize(int value)
Sets the value of the 'Pre Fetch Size' attribute.

Parameters:
value - the new value of the 'Pre Fetch Size' attribute.
See Also:
getPreFetchSize()

getOverhead

double getOverhead()
Returns the value of the 'Overhead' attribute.

If the meaning of the 'Overhead' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Overhead' attribute.
See Also:
setOverhead(double), LUWPackage.getLUWTableSpace_Overhead()

setOverhead

void setOverhead(double value)
Sets the value of the 'Overhead' attribute.

Parameters:
value - the new value of the 'Overhead' attribute.
See Also:
getOverhead()

getTransferRate

double getTransferRate()
Returns the value of the 'Transfer Rate' attribute.

If the meaning of the 'Transfer Rate' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Transfer Rate' attribute.
See Also:
setTransferRate(double), LUWPackage.getLUWTableSpace_TransferRate()

setTransferRate

void setTransferRate(double value)
Sets the value of the 'Transfer Rate' attribute.

Parameters:
value - the new value of the 'Transfer Rate' attribute.
See Also:
getTransferRate()

isRecoverDroppedTableOn

boolean isRecoverDroppedTableOn()
Returns the value of the 'Recover Dropped Table On' attribute.

If the meaning of the 'Recover Dropped Table On' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Recover Dropped Table On' attribute.
See Also:
setRecoverDroppedTableOn(boolean), LUWPackage.getLUWTableSpace_RecoverDroppedTableOn()

setRecoverDroppedTableOn

void setRecoverDroppedTableOn(boolean value)
Sets the value of the 'Recover Dropped Table On' attribute.

Parameters:
value - the new value of the 'Recover Dropped Table On' attribute.
See Also:
isRecoverDroppedTableOn()

getPageSize

PageSizeType getPageSize()
Returns the value of the 'Page Size' attribute. The default value is "FOUR_K". The literals are from the enumeration PageSizeType.

If the meaning of the 'Page Size' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Page Size' attribute.
See Also:
PageSizeType, setPageSize(PageSizeType), LUWPackage.getLUWTableSpace_PageSize()

setPageSize

void setPageSize(PageSizeType value)
Sets the value of the 'Page Size' attribute.

Parameters:
value - the new value of the 'Page Size' attribute.
See Also:
PageSizeType, getPageSize()

getSize

long getSize()
Returns the value of the 'Size' attribute.

If the meaning of the 'Size' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Size' attribute.
See Also:
setSize(long), LUWPackage.getLUWTableSpace_Size()

setSize

void setSize(long value)
Sets the value of the 'Size' attribute.

Parameters:
value - the new value of the 'Size' attribute.
See Also:
getSize()

isAutoResize

boolean isAutoResize()
Returns the value of the 'Auto Resize' attribute.

If the meaning of the 'Auto Resize' attribute isn't clear, there really should be more of a description here...

Returns:
the value of the 'Auto Resize' attribute.
See Also:
setAutoResize(boolean), LUWPackage.getLUWTableSpace_AutoResize()

setAutoResize

void setAutoResize(boolean value)
Sets the value of the 'Auto Resize' attribute.

Parameters:
value - the new value of the 'Auto Resize' attribute.
See Also:
isAutoResize()

getGroup

LUWPartitionGroup getGroup()
Returns the value of the 'Group' reference. It is bidirectional and its opposite is 'Table Spaces'.

If the meaning of the 'Group' reference isn't clear, there really should be more of a description here...

Returns:
the value of the 'Group' reference.
See Also:
setGroup(LUWPartitionGroup), LUWPackage.getLUWTableSpace_Group(), LUWPartitionGroup.getTableSpaces()

setGroup

void setGroup(LUWPartitionGroup value)
Sets the value of the 'Group' reference.

Parameters:
value - the new value of the 'Group' reference.
See Also:
getGroup()

getContainers

org.eclipse.emf.common.util.EList getContainers()
Returns the value of the 'Containers' containment reference list. The list contents are of type LUWDatabaseContainer. It is bidirectional and its opposite is 'Table Space'.

If the meaning of the 'Containers' containment reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'Containers' containment reference list.
See Also:
LUWPackage.getLUWTableSpace_Containers(), LUWDatabaseContainer.getTableSpace()

getBufferPool

LUWBufferPool getBufferPool()
Returns the value of the 'Buffer Pool' reference. It is bidirectional and its opposite is 'Table Spaces'.

If the meaning of the 'Buffer Pool' reference isn't clear, there really should be more of a description here...

Returns:
the value of the 'Buffer Pool' reference.
See Also:
setBufferPool(LUWBufferPool), LUWPackage.getLUWTableSpace_BufferPool(), LUWBufferPool.getTableSpaces()

setBufferPool

void setBufferPool(LUWBufferPool value)
Sets the value of the 'Buffer Pool' reference.

Parameters:
value - the new value of the 'Buffer Pool' reference.
See Also:
getBufferPool()

getRegularDataTables

org.eclipse.emf.common.util.EList getRegularDataTables()
Returns the value of the 'Regular Data Tables' reference list. The list contents are of type LUWStorageTable. It is bidirectional and its opposite is 'Regular Data Table Space'.

If the meaning of the 'Regular Data Tables' reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'Regular Data Tables' reference list.
See Also:
LUWPackage.getLUWTableSpace_RegularDataTables(), LUWStorageTable.getRegularDataTableSpace()

getDatabase

LUWDatabase getDatabase()
Returns the value of the 'Database' reference. It is bidirectional and its opposite is 'Tablespaces'.

If the meaning of the 'Database' reference isn't clear, there really should be more of a description here...

Returns:
the value of the 'Database' reference.
See Also:
setDatabase(LUWDatabase), LUWPackage.getLUWTableSpace_Database(), LUWDatabase.getTablespaces()

setDatabase

void setDatabase(LUWDatabase value)
Sets the value of the 'Database' reference.

Parameters:
value - the new value of the 'Database' reference.
See Also:
getDatabase()

getLOBDataPartition

org.eclipse.emf.common.util.EList getLOBDataPartition()
Returns the value of the 'LOB Data Partition' reference list. The list contents are of type LUWDataPartition. It is bidirectional and its opposite is 'LOB Data Table Space'.

If the meaning of the 'LOB Data Partition' reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'LOB Data Partition' reference list.
See Also:
LUWPackage.getLUWTableSpace_LOBDataPartition(), LUWDataPartition.getLOBDataTableSpace()

getRegularDataPartition

org.eclipse.emf.common.util.EList getRegularDataPartition()
Returns the value of the 'Regular Data Partition' reference list. The list contents are of type LUWDataPartition. It is bidirectional and its opposite is 'Regular Data Table Space'.

If the meaning of the 'Regular Data Partition' reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'Regular Data Partition' reference list.
See Also:
LUWPackage.getLUWTableSpace_RegularDataPartition(), LUWDataPartition.getRegularDataTableSpace()

getIndexDataTables

org.eclipse.emf.common.util.EList getIndexDataTables()
Returns the value of the 'Index Data Tables' reference list. The list contents are of type LUWStorageTable. It is bidirectional and its opposite is 'Index Data Table Space'.

If the meaning of the 'Index Data Tables' reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'Index Data Tables' reference list.
See Also:
LUWPackage.getLUWTableSpace_IndexDataTables(), LUWStorageTable.getIndexDataTableSpace()

getLOBDataTables

org.eclipse.emf.common.util.EList getLOBDataTables()
Returns the value of the 'LOB Data Tables' reference list. The list contents are of type LUWStorageTable. It is bidirectional and its opposite is 'LOB Data Table Space'.

If the meaning of the 'LOB Data Tables' reference list isn't clear, there really should be more of a description here...

Returns:
the value of the 'LOB Data Tables' reference list.
See Also:
LUWPackage.getLUWTableSpace_LOBDataTables(), LUWStorageTable.getLOBDataTableSpace()

getTables

java.util.List getTables()