db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r713746 [3/3] - /db/derby/docs/trunk/src/ref/
Date Thu, 13 Nov 2008 16:09:46 GMT
Added: db/derby/docs/trunk/src/ref/rrefproperstormin.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperstormin.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproperstormin.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproperstormin.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,66 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproperstormin">
+<title>derby.storage.minimumRecordSize</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.minimumRecordSize</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Indicates the minimum user row size in bytes for on-disk database pages for
+tables when you are creating a table. This property ensures that there is enough
+room for a row to grow on a page when updated without having to overflow. This
+is generally most useful for VARCHAR and VARCHAR FOR BIT DATA data types and for
+tables that are updated a lot, in which the rows start small and grow due to
+updates. Reserving the space at the time of insertion minimizes row overflow
+due to updates, but it can result in wasted space. Set the property prior to
+issuing the CREATE TABLE statement.</p>
+<p>See also <i><xref href="rrefproper28026.dita#rrefproper28026"/>.</i></p>
+</section>
+<section><title>Valid conglomerates</title>
+<p>Tables only.</p>
+</section>
+<section><title>Default</title>
+<p>12 bytes.</p>
+</section>
+<section><title>Minimum value</title>
+<p>12 bytes.</p>
+</section>
+<section><title>Maximum value</title>
+<p><i><xref href="rrefproper40688.dita#rrefproper40688">derby.storage.pageSize</xref></i>
* (1
+- <i><xref href="rrefproper28026.dita#rrefproper28026">derby.storage.pageReservedSpace</xref></i>/100)
"
+100.</p>
+<p>If you set this property to a value outside the legal range, <ph conref="../conrefs.dita#prod/productshortname"></ph>
uses
+the default value.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- changing the default for the system</ph>
+derby.storage.minimumRecordSize=128
+<ph>-- changing the default for the database</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY( 
+    'derby.storage.minimumRecordSize',
+    '128')
+</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is dynamic; if you change it while <ph conref="../conrefs.dita#prod/productshortname"></ph>
is running,
+the change takes effect immediately. For information about dynamic changes
+to properties, see <xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproperstormin.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproperverbose.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperverbose.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproperverbose.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproperverbose.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,44 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproperverbose">
+<title>derby.replication.verbose</title>
+<prolog><metadata>
+<keywords><indexterm>derby.replication.verbose</indexterm>
+<indexterm>replication<indexterm>specifying message logging</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies whether replication messages are written to the 
+<ph conref="../conrefs.dita#prod/productshortname"></ph> log.</p>
+</section>
+<section><title>Default</title>
+<p>True.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.replication.verbose=false</b></codeblock>
+</example>
+<section><title>Scope</title>
+<p><xref href="crefproper51399.dita#crefproper51399/rrefproper41229">system-wide</xref></p>
+</section>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while
+<ph conref="../conrefs.dita#prod/productshortname"></ph> is running, the change
+does not take effect until you reboot.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproperverbose.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Added: db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita?rev=713746&view=auto
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita (added)
+++ db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita Thu Nov 13 08:09:44 2008
@@ -0,0 +1,50 @@
+<?xml version="1.0" encoding="utf-8"?>
+<!-- 
+Licensed to the Apache Software Foundation (ASF) under one or more
+contributor license agreements.  See the NOTICE file distributed with
+this work for additional information regarding copyright ownership.
+The ASF licenses this file to You under the Apache License, Version 2.0
+(the "License"); you may not use this file except in compliance with
+the License.  You may obtain a copy of the License at      
+
+http://www.apache.org/licenses/LICENSE-2.0  
+
+Unless required by applicable law or agreed to in writing, software  
+distributed under the License is distributed on an "AS IS" BASIS,  
+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  
+See the License for the specific language governing permissions and  
+limitations under the License.
+-->
+<!DOCTYPE reference PUBLIC "-//OASIS//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rrefproperxatrantimeout">
+<title>derby.jdbc.xaTransactionTimeout</title>
+<prolog><metadata>
+<keywords><indexterm>derby.jdbc.xaTransactionTimeout</indexterm>
+<indexterm>XA Transactions<indexterm>transaction timeout property</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies the default value of the XA transaction timeout that is used when
+a user either does not specify the XA transaction timeout or requests to use the
+default value. It is possible to use the
+<codeph>XAResource.setTransactionTimeout</codeph> method to specify the XA
+transaction timeout value for the global transaction.</p>
+<p>A zero or negative value for this property means that the transaction timeout
+is not used.</p>
+</section>
+<section><title>Default</title>
+<p>The transaction timeout is not used.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>-- system-wide property
+derby.jdbc.xaTransactionTimeout=120</b></codeblock>
+<codeblock><b>-- database-wide property
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.jdbc.xaTransactionTimeout', '120')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Dynamic; the change takes effect immediately. For information about dynamic
+changes to properties, see
+<xref href="crefproperdynstat.dita#crefproperdynstat"/>.</p>
+</section></refbody></reference>

Propchange: db/derby/docs/trunk/src/ref/rrefproperxatrantimeout.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetdbpropproc.dita Thu Nov 13 08:09:44 2008
@@ -23,14 +23,16 @@
 <refbody>
 <section><p>Use the <codeph>SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY</codeph>
system
 procedure to set or delete the value of a property of the database on the
-current connection.</p></section>
+current connection. For information about properties, see
+<xref href="rrefproper32213.dita#rrefproper32213"></xref>.</p></section>
 <section><p>If  "VALUE" is not null, then the property with key value "KEY"
 is set to "VALUE".  If "VALUE" is null, then the property with key value "KEY"
 is deleted from the database property set.</p></section>
 <section><title>Syntax</title> <codeblock>SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN
KEY VARCHAR(128),
 IN VALUE VARCHAR(32672))</codeblock> <p>This procedure does not return any
 results.</p></section>
-<section><title>JDBC example</title> <p>Set the <codeph>derby.locks.deadlockTimeout</codeph>
property
+<section><title>JDBC example</title> <p>Set the
+<codeph><xref href="rrefproper10607.dita#rrefproper10607">derby.locks.deadlockTimeout</xref></codeph>
property
 to a value of 10:</p> <codeblock>CallableStatement cs = conn.prepareCall
 ("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)");
 cs.setString(1, "derby.locks.deadlockTimeout");

Modified: db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsetuseraccess.dita Thu Nov 13 08:09:44 2008
@@ -33,11 +33,13 @@
 <dd> Valid values for CONNECTION_PERMISSION are:<dl><dlentry>
 <dt>fullAccess</dt>
 <dd>Adds the user to the list of users with full access to the database. The
-value for the database property is <varname>derby.database.fullAccessUsers</varname>.</dd>
+value for the database property is
+<codeph><xref href="rrefproper25025.dita#rrefproper25025">derby.database.fullAccessUsers</xref></codeph>.</dd>
 </dlentry><dlentry>
 <dt>readOnlyAccess</dt>
 <dd>Adds the user to the list of users with read-only access to the database.
-The value for the database property is <varname>derby.database.readOnlyAccessUsers</varname>.
</dd>
+The value for the database property is
+<codeph><xref href="rrefproper39325.dita#rrefproper39325">derby.database.readOnlyAccessUsers</xref></codeph>.</dd>
 </dlentry><dlentry>
 <dt>null</dt>
 <dd>Removes the user from the list of permissions, reverting the user to the

Modified: db/derby/docs/trunk/src/ref/rrefsqlj31580.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqlj31580.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqlj31580.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqlj31580.dita Thu Nov 13 08:09:44 2008
@@ -35,7 +35,7 @@
 schema name cannot exceed 128 characters. Schema names must be unique within
 the database.</p> 
 <p>The CREATE SCHEMA statement is subject to access control when the 
-<codeph>derby.database.sqlAuthorization</codeph> property is set to 
+<codeph><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></codeph>
property is set to 
 <codeph>true</codeph> for the database or system. Only the database owner can
create a schema with a name 
 different from the current user name, and only the the database owner can 
 specify 

Modified: db/derby/docs/trunk/src/ref/rrefsqljgrant.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljgrant.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljgrant.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljgrant.dita Thu Nov 13 08:09:44 2008
@@ -38,7 +38,8 @@
 <li>Create a trigger on a table.</li>
 <li>Update data in a table or in a subset of columns in a table.</li>
 <li>Run a specified function or procedure.</li>
-</ul></p><p>Before you issue a GRANT statement, check that the <codeph>derby.database.sqlAuthorization</codeph>
property
+</ul></p><p>Before you issue a GRANT statement, check that the
+<codeph><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></codeph>
property
 is set to <codeph>true</codeph>. The <codeph>derby.database.sqlAuthorization</codeph>
property
 enables the SQL Authorization mode.</p><p>You can grant privileges to database
 objects that you are authorized to grant. See the CREATE statement for the

Modified: db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsqljrevoke.dita Thu Nov 13 08:09:44 2008
@@ -37,7 +37,8 @@
 <li>Create a trigger on a table.</li>
 <li>Update data in a table or in a subset of columns in a table.</li>
 <li>Run a specified routine (function or procedure).</li>
-</ul></p><p>Before you issue a REVOKE statement, check that the <codeph>derby.database.sqlAuthorization</codeph>
property
+</ul></p><p>Before you issue a REVOKE statement, check that the
+<codeph><xref href="rrefpropersqlauth.dita#rrefpropersqlauth">derby.database.sqlAuthorization</xref></codeph>
property
 is set to <codeph>true</codeph>. The <codeph>derby.database.sqlAuthorization</codeph>
property
 enables the SQL Authorization mode.</p><p>You can revoke privileges from an
 object if you are the owner of the object or the  <xref href="rrefattrib26867.dita#rrefattrib26867">database

Modified: db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita?rev=713746&r1=713745&r2=713746&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita Thu Nov 13 08:09:44 2008
@@ -112,9 +112,12 @@
 to a Java string.</p><p>For example:<codeblock>SELECT * 
     FROM TABLE (SYSCS_DIAG.ERROR_LOG_READER('myderbyerrors.log')) 
     AS T1</codeblock></p><p><note type="tip"> By default <ph conref="../conrefs.dita#prod/productshortname"></ph>
log
-files contain only boot, shutdown, and error messages. In the <cite><ph conref="../conrefs.dita#pub/cittuning"></ph>
guide</cite>,
-see the <parmname>derby.stream.error.logSeverityLevel</parmname> property
-and the <parmname>derby.language.logStatementText</parmname> property for
+files contain only boot, shutdown, and error messages.
+See the
+<codeph><xref href="rrefproper26985.dita#rrefproper26985">derby.stream.error.logSeverityLevel</xref></codeph>
+property and the
+<codeph><xref href="rrefproper43517.dita#rrefproper43517">derby.language.logStatementText</xref></codeph>
+property for
 instructions on how to print more information to <ph conref="../conrefs.dita#prod/productshortname"></ph>
log
 files. You can then query that information by using the SYSCS_DIAG.ERROR_LOG_READER
 diagnostic table function. </note></p></section>
@@ -177,9 +180,12 @@
 whose data type maps to a Java string.</p><p>For example:<codeblock>SELECT
* 
     FROM TABLE (SYSCS_DIAG.STATEMENT_DURATION('somederby.log')) 
     AS T1</codeblock></p><p><note type="tip"> By default <ph conref="../conrefs.dita#prod/productshortname"></ph>
log
-files contain only boot, shutdown, and error messages. In the <cite><ph conref="../conrefs.dita#pub/cittuning"></ph>
guide</cite>,
-see the <parmname>derby.stream.error.logSeverityLevel</parmname> property
-and the <parmname>derby.language.logStatementText</parmname> property for
+files contain only boot, shutdown, and error messages.
+See the
+<codeph><xref href="rrefproper26985.dita#rrefproper26985">derby.stream.error.logSeverityLevel</xref></codeph>
+property and the
+<codeph><xref href="rrefproper43517.dita#rrefproper43517">derby.language.logStatementText</xref></codeph>
+property for
 instructions on how to print more information to <ph conref="../conrefs.dita#prod/productshortname"></ph>
log
 files. You can then query that information by using the SYSCS_DIAG.STATEMENT_DURATION
 diagnostic table function. </note></p></section>



Mime
View raw message