<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <!--NewPage--> <HTML> <HEAD> <!-- Generated by javadoc (build 1.6.0_18) on Sat Dec 04 05:26:46 UTC 2010 --> <TITLE> TableSpace </TITLE> <META NAME="date" CONTENT="2010-12-04"> <LINK REL ="stylesheet" TYPE="text/css" HREF="../../../../../../stylesheet.css" TITLE="Style"> <SCRIPT type="text/javascript"> function windowTitle() { if (location.href.indexOf('is-external=true') == -1) { parent.document.title="TableSpace"; } } </SCRIPT> <NOSCRIPT> </NOSCRIPT> </HEAD> <BODY BGCOLOR="white" onload="windowTitle();"> <HR> <!-- ========= START OF TOP NAVBAR ======= --> <A NAME="navbar_top"><!-- --></A> <A HREF="#skip-navbar_top" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_top_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR> </TABLE> </TD> <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> </EM> </TD> </TR> <TR> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2"><B>PREV CLASS</B></A> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2"><B>NEXT CLASS</B></A></FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../../index.html?org/apache/ws/jaxme/sqls/db2/TableSpace.html" target="_top"><B>FRAMES</B></A> <A HREF="TableSpace.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_top"></A> <!-- ========= END OF TOP NAVBAR ========= --> <HR> <!-- ======== START OF CLASS DATA ======== --> <H2> <FONT SIZE="-1"> org.apache.ws.jaxme.sqls.db2</FONT> <BR> Interface TableSpace</H2> <DL> <DT><B>All Known Implementing Classes:</B> <DD><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/DB2SQLFactoryImpl.PredefinedTableSpace.html" title="class in org.apache.ws.jaxme.sqls.db2">DB2SQLFactoryImpl.PredefinedTableSpace</A>, <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpaceImpl.html" title="class in org.apache.ws.jaxme.sqls.db2">TableSpaceImpl</A></DD> </DL> <HR> <DL> <DT><PRE>public interface <B>TableSpace</B></DL> </PRE> <P> <p>Interface of a DB2 TableSpace. An object of this kind is used to create a <code>CREATE TABLESPACE ...</code> statement.</p> <p>A TableSpace can be associated to a <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A>. If it is, it inherits certain settings from the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A>, in particular the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A>.</p> <p>A tablespace needs to know where data is stored physically. DB2 distinguishes between two possible data locations: System managed (Files handled by the operating system) and Database managed (Files handled by the database or Devices). In the latter case the database will preallocate space for the files or devices, giving a slightly faster operation. On the other hand, database managed files cannot grow automatically.</p> <p>A tablespaces data location is called container. Any tablespace must have at least one container. Note, that one tablespace cannot have both system managed containers and database managed containers. If the first container is system managed, then all containers are, and vice versa.</p> <P> <P> <DL> <DT><B>Author:</B></DT> <DD><a href="mailto:joe@ispsoft.de">Jochen Wiedmann</a></DD> </DL> <HR> <P> <!-- ======== NESTED CLASS SUMMARY ======== --> <A NAME="nested_class_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Nested Class Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static interface</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A></B></CODE> <BR> Interface of a TableSpace Container.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static interface</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.DatabaseManagedContainer.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.DatabaseManagedContainer</A></B></CODE> <BR> Interface of a database managed container.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static interface</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Name.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Name</A></B></CODE> <BR> </TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static interface</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.SystemManagedContainer.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.SystemManagedContainer</A></B></CODE> <BR> Interface of a system managed container, aka operating system file.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE>static class</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Type.html" title="class in org.apache.ws.jaxme.sqls.db2">TableSpace.Type</A></B></CODE> <BR> A DB2 TableSpace type.</TD> </TR> </TABLE> <!-- ========== METHOD SUMMARY =========== --> <A NAME="method_summary"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="2"><FONT SIZE="+2"> <B>Method Summary</B></FONT></TH> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2">BufferPool</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getBufferPool()">getBufferPool</A></B>()</CODE> <BR> Returns the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A> used by this <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>TableSpace</CODE></A>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.util.Iterator</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getContainers()">getContainers</A></B>()</CODE> <BR> Returns an <CODE>Iterator</CODE> to the table spaces containers.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.Long</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getExtentSize()">getExtentSize</A></B>()</CODE> <BR> Returns the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be written to a container before skipping to the next container.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Name.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Name</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getName()">getName</A></B>()</CODE> <BR> Returns the tablespace name.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.Number</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getOverhead()">getOverhead</A></B>()</CODE> <BR> Returns the I/O controller overhead and disk seek and latency time, in milliseconds.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2">PageSize</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()">getPageSize</A></B>()</CODE> <BR> Returns the tablespaces page size.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.Long</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPrefetchSize()">getPrefetchSize</A></B>()</CODE> <BR> Returns the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be read from the tablespace when data prefetching is being performed.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/DB2SQLFactory.html" title="interface in org.apache.ws.jaxme.sqls.db2">DB2SQLFactory</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getSQLFactory()">getSQLFactory</A></B>()</CODE> <BR> Returns the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html" title="interface in org.apache.ws.jaxme.sqls"><CODE>SQLFactory</CODE></A> that created this <code>TableSpace</code> object.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.Number</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getTransferRate()">getTransferRate</A></B>()</CODE> <BR> Returns the transfer rate, which is defined as the time to read one page into memory, in milliseconds.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Type.html" title="class in org.apache.ws.jaxme.sqls.db2">TableSpace.Type</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getType()">getType</A></B>()</CODE> <BR> Returns the tablespace type.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> java.lang.Boolean</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#hasDroppedTableRecovery()">hasDroppedTableRecovery</A></B>()</CODE> <BR> Returns whether dropped tables in the specified tablespace may be recovered using the <code>RECOVER TABLE ON</code> option of the <code>ROLLFORWARD</code> command.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> boolean</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#isPredefined()">isPredefined</A></B>()</CODE> <BR> Returns whether this TableSpace is predefined by the system.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newDatabaseManagedContainerInDevice(java.lang.String, long)">newDatabaseManagedContainerInDevice</A></B>(java.lang.String pDevice, long pNumPages)</CODE> <BR> Creates a new database managed container with the given raw operating system device and the given number of pages.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newDatabaseManagedContainerInFile(java.lang.String, long)">newDatabaseManagedContainerInFile</A></B>(java.lang.String pFile, long pNumPages)</CODE> <BR> Creates a new database managed container with the given file or device and the given number of pages.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A></CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newSystemManagedContainer(java.lang.String)">newSystemManagedContainer</A></B>(java.lang.String pFile)</CODE> <BR> Creates a new system managed container with the given file.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setBufferPool(org.apache.ws.jaxme.sqls.db2.BufferPool)">setBufferPool</A></B>(<A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2">BufferPool</A> pBufferPool)</CODE> <BR> Sets the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A> used by this <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>TableSpace</CODE></A>.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setDroppedTableRecovery(java.lang.Boolean)">setDroppedTableRecovery</A></B>(java.lang.Boolean pRecoverable)</CODE> <BR> Sets whether dropped tables in the specified tablespace may be recovered using the <code>RECOVER TABLE ON</code> option of the <code>ROLLFORWARD</code> command.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setExtentSize(java.lang.Long)">setExtentSize</A></B>(java.lang.Long pSize)</CODE> <BR> Sets the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be written to a container before skipping to the next container.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setOverhead(java.lang.Number)">setOverhead</A></B>(java.lang.Number pOverhead)</CODE> <BR> Sets the I/O controller overhead and disk seek and latency time, in milliseconds.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setPageSize(org.apache.ws.jaxme.sqls.db2.PageSize)">setPageSize</A></B>(<A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2">PageSize</A> pSize)</CODE> <BR> Sets the tablespaces page size.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setPrefetchSize(java.lang.Long)">setPrefetchSize</A></B>(java.lang.Long pSize)</CODE> <BR> Sets the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be read from the tablespace when data prefetching is being performed.</TD> </TR> <TR BGCOLOR="white" CLASS="TableRowColor"> <TD ALIGN="right" VALIGN="top" WIDTH="1%"><FONT SIZE="-1"> <CODE> void</CODE></FONT></TD> <TD><CODE><B><A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setTransferRate(java.lang.Number)">setTransferRate</A></B>(java.lang.Number pNumber)</CODE> <BR> Sets the transfer rate, which is defined as the time to read one page into memory, in milliseconds.</TD> </TR> </TABLE> <P> <!-- ============ METHOD DETAIL ========== --> <A NAME="method_detail"><!-- --></A> <TABLE BORDER="1" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" SUMMARY=""> <TR BGCOLOR="#CCCCFF" CLASS="TableHeadingColor"> <TH ALIGN="left" COLSPAN="1"><FONT SIZE="+2"> <B>Method Detail</B></FONT></TH> </TR> </TABLE> <A NAME="getSQLFactory()"><!-- --></A><H3> getSQLFactory</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/DB2SQLFactory.html" title="interface in org.apache.ws.jaxme.sqls.db2">DB2SQLFactory</A> <B>getSQLFactory</B>()</PRE> <DL> <DD><p>Returns the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/SQLFactory.html" title="interface in org.apache.ws.jaxme.sqls"><CODE>SQLFactory</CODE></A> that created this <code>TableSpace</code> object.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getName()"><!-- --></A><H3> getName</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Name.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Name</A> <B>getName</B>()</PRE> <DL> <DD><p>Returns the tablespace name. Tablespace names must be unique in the database.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getType()"><!-- --></A><H3> getType</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Type.html" title="class in org.apache.ws.jaxme.sqls.db2">TableSpace.Type</A> <B>getType</B>()</PRE> <DL> <DD><p>Returns the tablespace type.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getPageSize()"><!-- --></A><H3> getPageSize</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2">PageSize</A> <B>getPageSize</B>()</PRE> <DL> <DD><p>Returns the tablespaces page size. If the <code>TableSpace</code> has an associated <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A>, returns the BufferPool's page size. Otherwise returns the page size configured via <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#setPageSize(org.apache.ws.jaxme.sqls.db2.PageSize)"><CODE>setPageSize(PageSize)</CODE></A>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setPageSize(org.apache.ws.jaxme.sqls.db2.PageSize)"><!-- --></A><H3> setPageSize</H3> <PRE> void <B>setPageSize</B>(<A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2">PageSize</A> pSize)</PRE> <DL> <DD><p>Sets the tablespaces page size. This value will be ignored, if the <code>TableSpace</code> has an associated <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getExtentSize()"><!-- --></A><H3> getExtentSize</H3> <PRE> java.lang.Long <B>getExtentSize</B>()</PRE> <DL> <DD><p>Returns the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be written to a container before skipping to the next container. The database manager cycles repeatedly through the containers as data is stored. Defaults to null, in which case the DB2 configuration parameter DFT_EXTENT_SZ applies.</p> </p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setExtentSize(java.lang.Long)"><!-- --></A><H3> setExtentSize</H3> <PRE> void <B>setExtentSize</B>(java.lang.Long pSize)</PRE> <DL> <DD><p>Sets the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be written to a container before skipping to the next container. The database manager cycles repeatedly through the containers as data is stored. Defaults to null, in which case the DB2 configuration parameter DFT_EXTENT_SZ applies.</p> </p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getPrefetchSize()"><!-- --></A><H3> getPrefetchSize</H3> <PRE> java.lang.Long <B>getPrefetchSize</B>()</PRE> <DL> <DD><p>Returns the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be read from the tablespace when data prefetching is being performed. 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. Defaults to null, in which case the DB2 configuration parameter DFT_PREFETCH_SZ applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setPrefetchSize(java.lang.Long)"><!-- --></A><H3> setPrefetchSize</H3> <PRE> void <B>setPrefetchSize</B>(java.lang.Long pSize)</PRE> <DL> <DD><p>Sets the number of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#getPageSize()"><CODE>pageSize</CODE></A> pages that will be read from the tablespace when data prefetching is being performed. 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. Defaults to null, in which case the DB2 configuration parameter DFT_PREFETCH_SZ applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getOverhead()"><!-- --></A><H3> getOverhead</H3> <PRE> java.lang.Number <B>getOverhead</B>()</PRE> <DL> <DD><p>Returns 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. Defaults to null, in which case the DB2 default (24.1) applies.</p> </p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setOverhead(java.lang.Number)"><!-- --></A><H3> setOverhead</H3> <PRE> void <B>setOverhead</B>(java.lang.Number pOverhead)</PRE> <DL> <DD><p>Sets 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. Defaults to null, in which case the DB2 default (24.1) applies.</p> </p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getTransferRate()"><!-- --></A><H3> getTransferRate</H3> <PRE> java.lang.Number <B>getTransferRate</B>()</PRE> <DL> <DD><p>Returns the transfer rate, which is defined as the time to read one page into memory, in milliseconds. The number shouldbe 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. Defaults to null, in which case the DB2 default (0.9) applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setTransferRate(java.lang.Number)"><!-- --></A><H3> setTransferRate</H3> <PRE> void <B>setTransferRate</B>(java.lang.Number pNumber)</PRE> <DL> <DD><p>Sets the transfer rate, which is defined as the time to read one page into memory, in milliseconds. The number shouldbe 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. Defaults to null, in which case the DB2 default (0.9) applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="hasDroppedTableRecovery()"><!-- --></A><H3> hasDroppedTableRecovery</H3> <PRE> java.lang.Boolean <B>hasDroppedTableRecovery</B>()</PRE> <DL> <DD><p>Returns whether dropped tables in the specified tablespace may be recovered using the <code>RECOVER TABLE ON</code> option of the <code>ROLLFORWARD</code> command. This clause can only be specified for a <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Type.html#REGULAR"><CODE>TableSpace.Type.REGULAR</CODE></A> tablespace (SQLSTATE 42613). For more information on recovering dropped tables, refer to the Administration Guide. Defaults to null, in which case the DB2 default applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setDroppedTableRecovery(java.lang.Boolean)"><!-- --></A><H3> setDroppedTableRecovery</H3> <PRE> void <B>setDroppedTableRecovery</B>(java.lang.Boolean pRecoverable)</PRE> <DL> <DD><p>Sets whether dropped tables in the specified tablespace may be recovered using the <code>RECOVER TABLE ON</code> option of the <code>ROLLFORWARD</code> command. This clause can only be specified for a <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Type.html#REGULAR"><CODE>TableSpace.Type.REGULAR</CODE></A> tablespace (SQLSTATE 42613). For more information on recovering dropped tables, refer to the Administration Guide. Defaults to null, in which case the DB2 default applies.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newSystemManagedContainer(java.lang.String)"><!-- --></A><H3> newSystemManagedContainer</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A> <B>newSystemManagedContainer</B>(java.lang.String pFile)</PRE> <DL> <DD><p>Creates a new system managed container with the given file.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newDatabaseManagedContainerInFile(java.lang.String, long)"><!-- --></A><H3> newDatabaseManagedContainerInFile</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A> <B>newDatabaseManagedContainerInFile</B>(java.lang.String pFile, long pNumPages)</PRE> <DL> <DD><p>Creates a new database managed container with the given file or device and the given number of pages.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="newDatabaseManagedContainerInDevice(java.lang.String, long)"><!-- --></A><H3> newDatabaseManagedContainerInDevice</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2">TableSpace.Container</A> <B>newDatabaseManagedContainerInDevice</B>(java.lang.String pDevice, long pNumPages)</PRE> <DL> <DD><p>Creates a new database managed container with the given raw operating system device and the given number of pages.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getContainers()"><!-- --></A><H3> getContainers</H3> <PRE> java.util.Iterator <B>getContainers</B>()</PRE> <DL> <DD><p>Returns an <CODE>Iterator</CODE> to the table spaces containers. Any element in the <CODE>Iterator</CODE> is an instance of <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>TableSpace.Container</CODE></A>, which was created using <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newSystemManagedContainer(java.lang.String)"><CODE>newSystemManagedContainer(String)</CODE></A>, <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newDatabaseManagedContainerInFile(java.lang.String, long)"><CODE>newDatabaseManagedContainerInFile(String, long)</CODE></A>, or <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html#newDatabaseManagedContainerInDevice(java.lang.String, long)"><CODE>newDatabaseManagedContainerInDevice(String, long)</CODE></A>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="setBufferPool(org.apache.ws.jaxme.sqls.db2.BufferPool)"><!-- --></A><H3> setBufferPool</H3> <PRE> void <B>setBufferPool</B>(<A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2">BufferPool</A> pBufferPool)</PRE> <DL> <DD><p>Sets the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A> used by this <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>TableSpace</CODE></A>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="getBufferPool()"><!-- --></A><H3> getBufferPool</H3> <PRE> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2">BufferPool</A> <B>getBufferPool</B>()</PRE> <DL> <DD><p>Returns the <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/BufferPool.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>BufferPool</CODE></A> used by this <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.html" title="interface in org.apache.ws.jaxme.sqls.db2"><CODE>TableSpace</CODE></A>.</p> <P> <DD><DL> </DL> </DD> </DL> <HR> <A NAME="isPredefined()"><!-- --></A><H3> isPredefined</H3> <PRE> boolean <B>isPredefined</B>()</PRE> <DL> <DD><p>Returns whether this TableSpace is predefined by the system.</p> <P> <DD><DL> </DL> </DD> </DL> <!-- ========= END OF CLASS DATA ========= --> <HR> <!-- ======= START OF BOTTOM NAVBAR ====== --> <A NAME="navbar_bottom"><!-- --></A> <A HREF="#skip-navbar_bottom" title="Skip navigation links"></A> <TABLE BORDER="0" WIDTH="100%" CELLPADDING="1" CELLSPACING="0" SUMMARY=""> <TR> <TD COLSPAN=2 BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A NAME="navbar_bottom_firstrow"><!-- --></A> <TABLE BORDER="0" CELLPADDING="0" CELLSPACING="3" SUMMARY=""> <TR ALIGN="center" VALIGN="top"> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../overview-summary.html"><FONT CLASS="NavBarFont1"><B>Overview</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-summary.html"><FONT CLASS="NavBarFont1"><B>Package</B></FONT></A> </TD> <TD BGCOLOR="#FFFFFF" CLASS="NavBarCell1Rev"> <FONT CLASS="NavBarFont1Rev"><B>Class</B></FONT> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="package-tree.html"><FONT CLASS="NavBarFont1"><B>Tree</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../deprecated-list.html"><FONT CLASS="NavBarFont1"><B>Deprecated</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../index-all.html"><FONT CLASS="NavBarFont1"><B>Index</B></FONT></A> </TD> <TD BGCOLOR="#EEEEFF" CLASS="NavBarCell1"> <A HREF="../../../../../../help-doc.html"><FONT CLASS="NavBarFont1"><B>Help</B></FONT></A> </TD> </TR> </TABLE> </TD> <TD ALIGN="right" VALIGN="top" ROWSPAN=3><EM> </EM> </TD> </TR> <TR> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/PageSize.html" title="class in org.apache.ws.jaxme.sqls.db2"><B>PREV CLASS</B></A> <A HREF="../../../../../../org/apache/ws/jaxme/sqls/db2/TableSpace.Container.html" title="interface in org.apache.ws.jaxme.sqls.db2"><B>NEXT CLASS</B></A></FONT></TD> <TD BGCOLOR="white" CLASS="NavBarCell2"><FONT SIZE="-2"> <A HREF="../../../../../../index.html?org/apache/ws/jaxme/sqls/db2/TableSpace.html" target="_top"><B>FRAMES</B></A> <A HREF="TableSpace.html" target="_top"><B>NO FRAMES</B></A> <SCRIPT type="text/javascript"> <!-- if(window==top) { document.writeln('<A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A>'); } //--> </SCRIPT> <NOSCRIPT> <A HREF="../../../../../../allclasses-noframe.html"><B>All Classes</B></A> </NOSCRIPT> </FONT></TD> </TR> <TR> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> SUMMARY: <A HREF="#nested_class_summary">NESTED</A> | FIELD | CONSTR | <A HREF="#method_summary">METHOD</A></FONT></TD> <TD VALIGN="top" CLASS="NavBarCell3"><FONT SIZE="-2"> DETAIL: FIELD | CONSTR | <A HREF="#method_detail">METHOD</A></FONT></TD> </TR> </TABLE> <A NAME="skip-navbar_bottom"></A> <!-- ======== END OF BOTTOM NAVBAR ======= --> <HR> </BODY> </HTML>