|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
public interface LUWTableSpace
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:
Tablespace Type
Management Type
Extent Size
Pre Fetch Size
Overhead
Transfer Rate
Recover Dropped Table On
Page Size
Size
Auto Resize
Group
Containers
Buffer Pool
Index Data Tables
LOB Data Tables
Regular Data Tables
Database
LOB Data Partition
Regular Data Partition
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 |
---|
TableSpaceType getTablespaceType()
TableSpaceType
.
If the meaning of the 'Tablespace Type' attribute isn't clear, there really should be more of a description here...
TableSpaceType
,
setTablespaceType(TableSpaceType)
,
LUWPackage.getLUWTableSpace_TablespaceType()
void setTablespaceType(TableSpaceType value)
Tablespace Type
' attribute.
value
- the new value of the 'Tablespace Type' attribute.TableSpaceType
,
getTablespaceType()
ManagementType getManagementType()
ManagementType
.
If the meaning of the 'Management Type' attribute isn't clear, there really should be more of a description here...
ManagementType
,
setManagementType(ManagementType)
,
LUWPackage.getLUWTableSpace_ManagementType()
void setManagementType(ManagementType value)
Management Type
' attribute.
value
- the new value of the 'Management Type' attribute.ManagementType
,
getManagementType()
int getExtentSize()
If the meaning of the 'Extent Size' attribute isn't clear, there really should be more of a description here...
setExtentSize(int)
,
LUWPackage.getLUWTableSpace_ExtentSize()
void setExtentSize(int value)
Extent Size
' attribute.
value
- the new value of the 'Extent Size' attribute.getExtentSize()
int getPreFetchSize()
If the meaning of the 'Pre Fetch Size' attribute isn't clear, there really should be more of a description here...
setPreFetchSize(int)
,
LUWPackage.getLUWTableSpace_PreFetchSize()
void setPreFetchSize(int value)
Pre Fetch Size
' attribute.
value
- the new value of the 'Pre Fetch Size' attribute.getPreFetchSize()
double getOverhead()
If the meaning of the 'Overhead' attribute isn't clear, there really should be more of a description here...
setOverhead(double)
,
LUWPackage.getLUWTableSpace_Overhead()
void setOverhead(double value)
Overhead
' attribute.
value
- the new value of the 'Overhead' attribute.getOverhead()
double getTransferRate()
If the meaning of the 'Transfer Rate' attribute isn't clear, there really should be more of a description here...
setTransferRate(double)
,
LUWPackage.getLUWTableSpace_TransferRate()
void setTransferRate(double value)
Transfer Rate
' attribute.
value
- the new value of the 'Transfer Rate' attribute.getTransferRate()
boolean isRecoverDroppedTableOn()
If the meaning of the 'Recover Dropped Table On' attribute isn't clear, there really should be more of a description here...
setRecoverDroppedTableOn(boolean)
,
LUWPackage.getLUWTableSpace_RecoverDroppedTableOn()
void setRecoverDroppedTableOn(boolean value)
Recover Dropped Table On
' attribute.
value
- the new value of the 'Recover Dropped Table On' attribute.isRecoverDroppedTableOn()
PageSizeType getPageSize()
"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...
PageSizeType
,
setPageSize(PageSizeType)
,
LUWPackage.getLUWTableSpace_PageSize()
void setPageSize(PageSizeType value)
Page Size
' attribute.
value
- the new value of the 'Page Size' attribute.PageSizeType
,
getPageSize()
long getSize()
If the meaning of the 'Size' attribute isn't clear, there really should be more of a description here...
setSize(long)
,
LUWPackage.getLUWTableSpace_Size()
void setSize(long value)
Size
' attribute.
value
- the new value of the 'Size' attribute.getSize()
boolean isAutoResize()
If the meaning of the 'Auto Resize' attribute isn't clear, there really should be more of a description here...
setAutoResize(boolean)
,
LUWPackage.getLUWTableSpace_AutoResize()
void setAutoResize(boolean value)
Auto Resize
' attribute.
value
- the new value of the 'Auto Resize' attribute.isAutoResize()
LUWPartitionGroup getGroup()
Table Spaces
'.
If the meaning of the 'Group' reference isn't clear, there really should be more of a description here...
setGroup(LUWPartitionGroup)
,
LUWPackage.getLUWTableSpace_Group()
,
LUWPartitionGroup.getTableSpaces()
void setGroup(LUWPartitionGroup value)
Group
' reference.
value
- the new value of the 'Group' reference.getGroup()
org.eclipse.emf.common.util.EList getContainers()
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...
LUWPackage.getLUWTableSpace_Containers()
,
LUWDatabaseContainer.getTableSpace()
LUWBufferPool getBufferPool()
Table Spaces
'.
If the meaning of the 'Buffer Pool' reference isn't clear, there really should be more of a description here...
setBufferPool(LUWBufferPool)
,
LUWPackage.getLUWTableSpace_BufferPool()
,
LUWBufferPool.getTableSpaces()
void setBufferPool(LUWBufferPool value)
Buffer Pool
' reference.
value
- the new value of the 'Buffer Pool' reference.getBufferPool()
org.eclipse.emf.common.util.EList getRegularDataTables()
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...
LUWPackage.getLUWTableSpace_RegularDataTables()
,
LUWStorageTable.getRegularDataTableSpace()
LUWDatabase getDatabase()
Tablespaces
'.
If the meaning of the 'Database' reference isn't clear, there really should be more of a description here...
setDatabase(LUWDatabase)
,
LUWPackage.getLUWTableSpace_Database()
,
LUWDatabase.getTablespaces()
void setDatabase(LUWDatabase value)
Database
' reference.
value
- the new value of the 'Database' reference.getDatabase()
org.eclipse.emf.common.util.EList getLOBDataPartition()
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...
LUWPackage.getLUWTableSpace_LOBDataPartition()
,
LUWDataPartition.getLOBDataTableSpace()
org.eclipse.emf.common.util.EList getRegularDataPartition()
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...
LUWPackage.getLUWTableSpace_RegularDataPartition()
,
LUWDataPartition.getRegularDataTableSpace()
org.eclipse.emf.common.util.EList getIndexDataTables()
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...
LUWPackage.getLUWTableSpace_IndexDataTables()
,
LUWStorageTable.getIndexDataTableSpace()
org.eclipse.emf.common.util.EList getLOBDataTables()
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...
LUWPackage.getLUWTableSpace_LOBDataTables()
,
LUWStorageTable.getLOBDataTableSpace()
java.util.List getTables()
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |