svn commit: r709166 - in /db/derby/docs/trunk/src/tuning: ctunproper22250.dita rtunproperrowlocking.dita tuningderby.ditamap

[ch...@apache.org]

Author: chaase3
Date: Thu Oct 30 07:17:26 2008
New Revision: 709166

URL: http://svn.apache.org/viewvc?rev=709166&view=rev
Log:
DERBY-1412: Possible values for derby.storage.rowLocking Derby engine is not currently documented eventhough the property is

Added topic for property to tuning guide, modified map file and property list to point to it.

Patch: DERBY-1412.diff

Added:
    db/derby/docs/trunk/src/tuning/rtunproperrowlocking.dita   (with props)
Modified:
    db/derby/docs/trunk/src/tuning/ctunproper22250.dita
    db/derby/docs/trunk/src/tuning/tuningderby.ditamap

Modified: db/derby/docs/trunk/src/tuning/ctunproper22250.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ctunproper22250.dita?rev=709166&r1=709165&r2=709166&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/ctunproper22250.dita (original)
+++ db/derby/docs/trunk/src/tuning/ctunproper22250.dita Thu Oct 30 07:17:26 2008
@@ -240,6 +240,11 @@
 <entry colname="3">X</entry>
 </row>
 <row>
+<entry colname="1"><i><xref href="rtunproperrowlocking.dita#rtunproperrowlocking">derby.storage.rowLocking</xref></i></entry>
+<entry colname="2">S, D</entry>
+<entry colname="3">&nbsp;</entry>
+</row>
+<row>
 <entry colname="1"><i><xref href="rtunproper34037.dita#rtunproper34037">derby.storage.tempDirectory</xref></i></entry>
 <entry colname="2">S, D</entry>
 <entry colname="3">X</entry>

Added: db/derby/docs/trunk/src/tuning/rtunproperrowlocking.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproperrowlocking.dita?rev=709166&view=auto
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproperrowlocking.dita (added)
+++ db/derby/docs/trunk/src/tuning/rtunproperrowlocking.dita Thu Oct 30 07:17:26 2008
@@ -0,0 +1,60 @@
+<?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="rtunproperrowlocking">
+<title>derby.storage.rowLocking</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.rowLocking</indexterm>
+<indexterm>databases<indexterm>configuring row-level locking</indexterm></indexterm>
+<indexterm>databases<indexterm>configuring table-level locking</indexterm></indexterm>
+<indexterm>lock granularity<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog>
+<refbody>
+<section><title>Function</title>
+<p>If set to true, enables row-level locking. When you disable row-level
+locking, you use table-level locking.</p>
+<p>Row-level locking uses more system resources but allows greater concurrency,
+which works better in multi-user systems. Table-level locking works best with
+single-user applications or read-only applications.</p>
+<p>If you use row-level locking (the default), the system decides whether to
+use table-level locking or row-level locking for each table in each DML
+statement. In certain situations, the system might choose to escalate the
+locking scheme from row-level locking to table-level locking to improve
+performance.</p>
+<p>For more information about locking, see
+<xref href="ctunoptimz27975.dita#ctunoptimz27975"/> in this manual, and
+"Locking, concurrency, and isolation" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph>.</p>
+</section>
+<section><title>Default</title>
+<p>True.</p></section>
+<refsyn><title>Example</title>
+<codeblock><b><ph>-- system-wide property</ph>
+derby.storage.rowLocking=false</b></codeblock>
+<codeblock><b><ph>-- database-level property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+    'derby.storage.rowLocking', 'false')</b></codeblock>
+</refsyn>
+<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/tuning/rtunproperrowlocking.dita
------------------------------------------------------------------------------
    svn:eol-style = native

Modified: db/derby/docs/trunk/src/tuning/tuningderby.ditamap
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/tuningderby.ditamap?rev=709166&r1=709165&r2=709166&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tuning/tuningderby.ditamap (original)
+++ db/derby/docs/trunk/src/tuning/tuningderby.ditamap Thu Oct 30 07:17:26 2008
@@ -301,6 +301,7 @@
 <topicref href="rtunproper28026.dita" navtitle="derby.storage.pageReservedSpace">
 </topicref>
 <topicref href="rtunproper40688.dita" navtitle="derby.storage.pageSize"></topicref>
+<topicref href="rtunproperrowlocking.dita" navtitle="derby.storage.rowLocking"></topicref>
 <topicref href="rtunproper34037.dita" navtitle="derby.storage.tempDirectory">
 </topicref>
 <topicref href="rtunproper33027.dita" navtitle="derby.stream.error.field">