You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by jt...@apache.org on 2005/03/31 02:27:30 UTC
svn commit: r159548 [15/17] - in incubator/derby/docs/trunk/src: adminguide/
devguide/ getstart/ tuning/
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita Wed Mar 30 16:26:36 2005
@@ -1,55 +1,55 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper40688">
-<title>derby.storage.pageSize</title>
-<prolog><metadata>
-<keywords><indexterm>derby.storage.pageSize</indexterm><indexterm>Page size<indexterm>configuring</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>Defines the page size, in bytes, for on-disk database pages for tables
-or indexes used during table or index creation. Page size can only be one
-the following values: 4096, 8192, 16384, or 32768. Set this property prior
-to issuing the CREATE TABLE or CREATE INDEX statement. This value will be
-used for the lifetime of the newly created conglomerates.</p>
-</section>
-<section><title>Valid conglomerates</title>
-<p>Tables and indexes, including the indexes created to enforce constraints.</p>
-</section>
-<section><title>Default</title>
-<p id="rtunproper21619">4096 bytes.</p>
-</section>
-<section><title>Valid values</title>
-<p>Page size can only be one the following values: 4096, 8192, 16384, or 32768.
-If you specify an invalid value, <ph conref="tunconrefs.dita#prod/productshortname"></ph> uses the default value 4096.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b><ph>-- changing the default for the system</ph>
-derby.storage.pageSize=8192
-<ph>-- changing the default for the database</ph>
-CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.storage.pageSize',
- '8192')
-</b></codeblock>
-</example>
-<section><title>Dynamic or static</title>
-<p>This property is dynamic; if you change it while <ph conref="tunconrefs.dita#prod/productshortname"></ph> is running,
-the change takes effect immediately. For information about dynamic changes
-to properties, see <xref href="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper40688">
+<title>derby.storage.pageSize</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.pageSize</indexterm><indexterm>Page size<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Defines the page size, in bytes, for on-disk database pages for tables
+or indexes used during table or index creation. Page size can only be one
+the following values: 4096, 8192, 16384, or 32768. Set this property prior
+to issuing the CREATE TABLE or CREATE INDEX statement. This value will be
+used for the lifetime of the newly created conglomerates.</p>
+</section>
+<section><title>Valid conglomerates</title>
+<p>Tables and indexes, including the indexes created to enforce constraints.</p>
+</section>
+<section><title>Default</title>
+<p id="rtunproper21619">4096 bytes.</p>
+</section>
+<section><title>Valid values</title>
+<p>Page size can only be one the following values: 4096, 8192, 16384, or 32768.
+If you specify an invalid value, <ph conref="tunconrefs.dita#prod/productshortname"></ph> uses the default value 4096.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- changing the default for the system</ph>
+derby.storage.pageSize=8192
+<ph>-- changing the default for the database</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.storage.pageSize',
+ '8192')
+</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is dynamic; if you change it while <ph conref="tunconrefs.dita#prod/productshortname"></ph> is running,
+the change takes effect immediately. For information about dynamic changes
+to properties, see <xref href="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper40688.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita Wed Mar 30 16:26:36 2005
@@ -1,39 +1,39 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper43414">
-<title>derby.language.logQueryPlan</title>
-<prolog><metadata>
-<keywords><indexterm>derby.language.logQueryPlan</indexterm><indexterm>Statement execution<indexterm>debugging</indexterm></indexterm><indexterm>Statements<indexterm>debugging</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>When this property is set to true, <ph conref="tunconrefs.dita#prod/productshortname"></ph> writes the query plan information
-into the derby.log file for all executed queries.</p>
-<p>This property is useful for debugging to know what query plan was chosen
-by the optimizer.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>derby.language.logQueryPlan=true</b></codeblock>
-</example>
-<section><title>Default</title>
-<p>False.</p>
-</section>
-<section><title>Dynamic or static</title>
-<p>static</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper43414">
+<title>derby.language.logQueryPlan</title>
+<prolog><metadata>
+<keywords><indexterm>derby.language.logQueryPlan</indexterm><indexterm>Statement execution<indexterm>debugging</indexterm></indexterm><indexterm>Statements<indexterm>debugging</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>When this property is set to true, <ph conref="tunconrefs.dita#prod/productshortname"></ph> writes the query plan information
+into the derby.log file for all executed queries.</p>
+<p>This property is useful for debugging to know what query plan was chosen
+by the optimizer.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.language.logQueryPlan=true</b></codeblock>
+</example>
+<section><title>Default</title>
+<p>False.</p>
+</section>
+<section><title>Dynamic or static</title>
+<p>static</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper43414.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita Wed Mar 30 16:26:36 2005
@@ -1,43 +1,43 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper43517">
-<title>derby.language.logStatementText</title>
-<prolog><metadata>
-<keywords><indexterm>derby.language.logStatementText</indexterm><indexterm>Statement execution<indexterm>debugging</indexterm></indexterm><indexterm>Statements<indexterm>debugging</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>When this property is set to true, <ph conref="tunconrefs.dita#prod/productshortname"></ph> writes the text and parameter
-values of all executed statements to the information log at the beginning
-of execution. It also writes information about commits and rollbacks. Information
-includes the time and thread number.</p>
-<p>This property is useful for debugging.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>derby.language.logStatementText=true
-<ph>-- database-wide property</ph>
-CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.language.logStatementText', 'true')</b></codeblock>
-</example>
-<section><title>Default</title>
-<p>False.</p>
-</section>
-<section><title>Dynamic or static</title>
-<p>static</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper43517">
+<title>derby.language.logStatementText</title>
+<prolog><metadata>
+<keywords><indexterm>derby.language.logStatementText</indexterm><indexterm>Statement execution<indexterm>debugging</indexterm></indexterm><indexterm>Statements<indexterm>debugging</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>When this property is set to true, <ph conref="tunconrefs.dita#prod/productshortname"></ph> writes the text and parameter
+values of all executed statements to the information log at the beginning
+of execution. It also writes information about commits and rollbacks. Information
+includes the time and thread number.</p>
+<p>This property is useful for debugging.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.language.logStatementText=true
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.language.logStatementText', 'true')</b></codeblock>
+</example>
+<section><title>Default</title>
+<p>False.</p>
+</section>
+<section><title>Dynamic or static</title>
+<p>static</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper43517.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita Wed Mar 30 16:26:36 2005
@@ -1,48 +1,48 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper46141">
-<title>derby.locks.waitTimeout</title>
-<prolog><metadata>
-<keywords><indexterm>derby.locks.waitTimeout</indexterm><indexterm>Deadlocks<indexterm>wait timeout property</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>Specifies the number of seconds after which <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts a transaction
-when it is waiting for a lock. When <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts (and rolls back) the
-transaction, the transaction receives an <i>SQLException</i> of <i>SQLState</i> 40XL1.</p>
-<p>The time specified by this property is approximate.</p>
-<p>A zero value for this property means that <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts a transaction
-any time it cannot immediately obtain a lock that it requests.</p>
-<p>A negative value for this property is equivalent to an infinite wait time;
-the transaction waits forever to obtain the lock.</p>
-<p>If this property is set to a value greater than or equal to zero but less
-than the value of <i><xref href="rtunproper10607.dita#rtunproper10607"/>,</i> then <ph conref="tunconrefs.dita#prod/productshortname"></ph> never performs any deadlock checking. </p>
-</section>
-<section><title>Default</title>
-<p>60 seconds.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.locks.waitTimeout', '15')
-derby.locks.waitTimeout=60</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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper46141">
+<title>derby.locks.waitTimeout</title>
+<prolog><metadata>
+<keywords><indexterm>derby.locks.waitTimeout</indexterm><indexterm>Deadlocks<indexterm>wait timeout property</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies the number of seconds after which <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts a transaction
+when it is waiting for a lock. When <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts (and rolls back) the
+transaction, the transaction receives an <i>SQLException</i> of <i>SQLState</i> 40XL1.</p>
+<p>The time specified by this property is approximate.</p>
+<p>A zero value for this property means that <ph conref="tunconrefs.dita#prod/productshortname"></ph> aborts a transaction
+any time it cannot immediately obtain a lock that it requests.</p>
+<p>A negative value for this property is equivalent to an infinite wait time;
+the transaction waits forever to obtain the lock.</p>
+<p>If this property is set to a value greater than or equal to zero but less
+than the value of <i><xref href="rtunproper10607.dita#rtunproper10607"/>,</i> then <ph conref="tunconrefs.dita#prod/productshortname"></ph> never performs any deadlock checking. </p>
+</section>
+<section><title>Default</title>
+<p>60 seconds.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.locks.waitTimeout', '15')
+derby.locks.waitTimeout=60</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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper46141.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita Wed Mar 30 16:26:36 2005
@@ -1,55 +1,55 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper81359">
-<title>derby.storage.pageCacheSize</title>
-<prolog><metadata>
-<keywords><indexterm>derby.storage.pageCacheSize</indexterm><indexterm>Page cache size<indexterm>configuring</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>Defines the size, in number of pages, of the database's data page cache
-(data pages kept in memory).</p>
-<p>The actual amount of memory the page cache will use depends on the following:
-
-<ul>
-<li>the size of the cache (configured with this property, <i><xref href="#rtunproper81359"/></i>)</li>
-<li>the size of the pages (configured with the <i><xref href="rtunproper40688.dita#rtunproper40688"/></i> property)</li>
-<li>overhead (varies with JVMs)</li>
-</ul></p>
-<p>When increasing the size of the page cache, you typically have to allow
-more memory for the Java heap when starting the embedding application (taking
-into consideration, of course, the memory needs of the embedding application
-as well). For example, using the default page size of 4K, a page cache size
-of 2000 pages will require at least 8 MB of memory (and probably more, given
-the overhead).</p>
-<p>For a simple application (no GUI), using the Sun 1.1.7 JVM on Windows NT
-and using the -mx96m option (which allows 96 MB for the Java heap), it is
-possible to have a page cache size of 10,000 pages (approximately 40 MB).</p>
-<p>The minimum value is 40 pages. If you specify a lower value, <ph conref="tunconrefs.dita#prod/productshortname"></ph> uses
-the default value.</p>
-</section>
-<section><title>Default</title>
-<p>1000 pages.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>derby.storage.pageCacheSize=160</b></codeblock>
-</example>
-<section><title>Dynamic or static</title>
-<p>Static. You must reboot the system for the change to take effect.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper81359">
+<title>derby.storage.pageCacheSize</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.pageCacheSize</indexterm><indexterm>Page cache size<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Defines the size, in number of pages, of the database's data page cache
+(data pages kept in memory).</p>
+<p>The actual amount of memory the page cache will use depends on the following:
+
+<ul>
+<li>the size of the cache (configured with this property, <i><xref href="#rtunproper81359"/></i>)</li>
+<li>the size of the pages (configured with the <i><xref href="rtunproper40688.dita#rtunproper40688"/></i> property)</li>
+<li>overhead (varies with JVMs)</li>
+</ul></p>
+<p>When increasing the size of the page cache, you typically have to allow
+more memory for the Java heap when starting the embedding application (taking
+into consideration, of course, the memory needs of the embedding application
+as well). For example, using the default page size of 4K, a page cache size
+of 2000 pages will require at least 8 MB of memory (and probably more, given
+the overhead).</p>
+<p>For a simple application (no GUI), using the Sun 1.1.7 JVM on Windows NT
+and using the -mx96m option (which allows 96 MB for the Java heap), it is
+possible to have a page cache size of 10,000 pages (approximately 40 MB).</p>
+<p>The minimum value is 40 pages. If you specify a lower value, <ph conref="tunconrefs.dita#prod/productshortname"></ph> uses
+the default value.</p>
+</section>
+<section><title>Default</title>
+<p>1000 pages.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.storage.pageCacheSize=160</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Static. You must reboot the system for the change to take effect.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper81359.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita Wed Mar 30 16:26:36 2005
@@ -1,55 +1,55 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper81405">
-<title>derby.database.forceDatabaseLock</title>
-<prolog><metadata>
-<keywords><indexterm>derby.database.forceDatabaseLock</indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>On some platforms, if set to true, prevents <ph conref="tunconrefs.dita#prod/productshortname"></ph> from booting a
-database if a <i>db.lck</i> file is present in the database
-directory.</p>
-<p><ph conref="tunconrefs.dita#prod/productshortname"></ph> attempts to prevent two JVMs from accessing a database at one
-time (and potentially corrupting it) with the use of a file called <i>db.lck</i> in the database directory. On some operating systems, the use
-of a lock file does not guarantee single access, and so <ph conref="tunconrefs.dita#prod/productshortname"></ph> only issues
-a warning and might allow multiple JVM access even when the file is present.
-(For more information, see "Double-Booting System Behavior" in Chapter
-1 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph></cite>.)</p>
-<p><ph conref="tunconrefs.dita#prod/productshortname"></ph> provides the property <i>derby.database.forceDatabaseLock</i> for use on platforms that do not provide the ability for <ph conref="tunconrefs.dita#prod/productshortname"></ph> to
-guarantee single JVM access. By default, this property is set to false. When
-this property is set to true, if <ph conref="tunconrefs.dita#prod/productshortname"></ph> finds the <i>db.lck</i> file when it attempts to boot the database, it throws an exception
-and does not boot the database.
-<note>This situation can occur
-even when no other JVMs are accessing the database; in that case, remove the <i>db.lck</i> file by hand in order to boot the database. If
-the <i>db.lck</i> file is removed by hand while a JVM is
-still accessing a <ph conref="tunconrefs.dita#prod/productshortname"></ph> database, there is no way for <ph conref="tunconrefs.dita#prod/productshortname"></ph> to
-prevent a second VM from starting up and possibly corrupting the database.
-In this situation no warning message is logged to the error log. </note></p>
-</section>
-<section><title>Default</title>
-<p>false</p>
-</section>
-<example><title>Example</title>
-<codeblock><b>derby.database.forceDatabaseLock=true</b></codeblock>
-</example>
-<section><title>Dynamic or static</title>
-<p>This property is static; if you change it while <ph conref="tunconrefs.dita#prod/productshortname"></ph> is running,
-the change does not take effect until you reboot.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper81405">
+<title>derby.database.forceDatabaseLock</title>
+<prolog><metadata>
+<keywords><indexterm>derby.database.forceDatabaseLock</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>On some platforms, if set to true, prevents <ph conref="tunconrefs.dita#prod/productshortname"></ph> from booting a
+database if a <i>db.lck</i> file is present in the database
+directory.</p>
+<p><ph conref="tunconrefs.dita#prod/productshortname"></ph> attempts to prevent two JVMs from accessing a database at one
+time (and potentially corrupting it) with the use of a file called <i>db.lck</i> in the database directory. On some operating systems, the use
+of a lock file does not guarantee single access, and so <ph conref="tunconrefs.dita#prod/productshortname"></ph> only issues
+a warning and might allow multiple JVM access even when the file is present.
+(For more information, see "Double-Booting System Behavior" in Chapter
+1 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph></cite>.)</p>
+<p><ph conref="tunconrefs.dita#prod/productshortname"></ph> provides the property <i>derby.database.forceDatabaseLock</i> for use on platforms that do not provide the ability for <ph conref="tunconrefs.dita#prod/productshortname"></ph> to
+guarantee single JVM access. By default, this property is set to false. When
+this property is set to true, if <ph conref="tunconrefs.dita#prod/productshortname"></ph> finds the <i>db.lck</i> file when it attempts to boot the database, it throws an exception
+and does not boot the database.
+<note>This situation can occur
+even when no other JVMs are accessing the database; in that case, remove the <i>db.lck</i> file by hand in order to boot the database. If
+the <i>db.lck</i> file is removed by hand while a JVM is
+still accessing a <ph conref="tunconrefs.dita#prod/productshortname"></ph> database, there is no way for <ph conref="tunconrefs.dita#prod/productshortname"></ph> to
+prevent a second VM from starting up and possibly corrupting the database.
+In this situation no warning message is logged to the error log. </note></p>
+</section>
+<section><title>Default</title>
+<p>false</p>
+</section>
+<example><title>Example</title>
+<codeblock><b>derby.database.forceDatabaseLock=true</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>This property is static; if you change it while <ph conref="tunconrefs.dita#prod/productshortname"></ph> is running,
+the change does not take effect until you reboot.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper81405.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita Wed Mar 30 16:26:36 2005
@@ -1,43 +1,43 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunproper98166">
-<title>derby.locks.monitor</title>
-<prolog><metadata>
-<keywords><indexterm>derby.locks.monitor</indexterm><indexterm>Locks<indexterm>monitoring</indexterm></indexterm><indexterm>Deadlocks<indexterm>monitoring</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section><title>Function</title>
-<p>Specifies that all deadlock errors are logged to the error log. If <i><xref href="rtunproper26985.dita#rtunproper26985"/></i> is set to ignore
-deadlock errors, <i>derby.locks.monitor</i> overrides
-it.</p>
-</section>
-<section><title>Default</title>
-<p>False.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b><ph>-- system property</ph>
-derby.locks.monitor=true
-
-CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.locks.monitor', 'true')</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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunproper98166">
+<title>derby.locks.monitor</title>
+<prolog><metadata>
+<keywords><indexterm>derby.locks.monitor</indexterm><indexterm>Locks<indexterm>monitoring</indexterm></indexterm><indexterm>Deadlocks<indexterm>monitoring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section><title>Function</title>
+<p>Specifies that all deadlock errors are logged to the error log. If <i><xref href="rtunproper26985.dita#rtunproper26985"/></i> is set to ignore
+deadlock errors, <i>derby.locks.monitor</i> overrides
+it.</p>
+</section>
+<section><title>Default</title>
+<p>False.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- system property</ph>
+derby.locks.monitor=true
+
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.locks.monitor', 'true')</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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunproper98166.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita Wed Mar 30 16:26:36 2005
@@ -1,28 +1,28 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunpropercachedn">
-<title>Caching user DNs</title>
-<prolog>
-</prolog>
-<refbody>
-<section><p>This property caches user DNs (distinguished names) locally when <i><xref href="rtunproper13766.dita#rtunproper13766"/></i> is set to <i>LDAP</i> and <i><xref href="rtunproper37341.dita#rtunproper37341"/></i> is
-set to <i>derby.user.</i> When you provide a user DN with
-this property, <ph conref="tunconrefs.dita#prod/productshortname"></ph> is able to avoid an LDAP search for that user's
-DN before authenticating. For those users without DNs defined with this property, <ph conref="tunconrefs.dita#prod/productshortname"></ph> performs
-a search using the default value of <i><xref href="rtunproper37341.dita#rtunproper37341"/>.</i></p></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunpropercachedn">
+<title>Caching user DNs</title>
+<prolog>
+</prolog>
+<refbody>
+<section><p>This property caches user DNs (distinguished names) locally when <i><xref href="rtunproper13766.dita#rtunproper13766"/></i> is set to <i>LDAP</i> and <i><xref href="rtunproper37341.dita#rtunproper37341"/></i> is
+set to <i>derby.user.</i> When you provide a user DN with
+this property, <ph conref="tunconrefs.dita#prod/productshortname"></ph> is able to avoid an LDAP search for that user's
+DN before authenticating. For those users without DNs defined with this property, <ph conref="tunconrefs.dita#prod/productshortname"></ph> performs
+a search using the default value of <i><xref href="rtunproper37341.dita#rtunproper37341"/>.</i></p></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunpropercachedn.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita Wed Mar 30 16:26:36 2005
@@ -1,53 +1,53 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunsearchauthdn">
-<title>derby.authentication.ldap.searchAuthDN</title>
-<prolog><metadata>
-<keywords><indexterm>derby.authentication.ldap.searchAuthDN</indexterm><indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section>Along with <i><xref href="rtunsearchauthpw.dita#rtunsearchauthpw"/>,</i> this property indicates how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the LDAP directory
-server to do searches for user DN (distinguished name). This property specifies
-the DN; <i><xref href="rtunsearchauthpw.dita#rtunsearchauthpw"/></i> specifies
-the password to use for the search.
-<p>If these two properties are not specified,
-an anonymous search is performed if it is supported.</p>
-<p>For more information
-about LDAP user authentication, see "LDAP Directory Service" in Chapter
-7 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph>.</cite></p></section>
-<refsyn><title>Syntax</title>
-<codeblock><b>derby.authentication.ldap.searchAuthDn=<b><i>DN</i></b></b></codeblock>
-</refsyn>
-<section><title>Default</title>
-<p>If not specified, an anonymous search is performed if it is supported.</p>
-</section>
-<example><title>Example</title>
-<codeblock><b><ph>-- system-wide property</ph>
-derby.authentication.ldap.searchAuthDn=
- cn=guest,o=JBMSTours.com
-<ph>-- database-wide property</ph>
-CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.authentication.ldap.searchAuthDn',
- 'cn=guest,o=JBMSTours.com')</b></codeblock>
-</example>
-<section><title>Dynamic or static</title>
-<p>Static. For system-wide properties, you must reboot <ph conref="tunconrefs.dita#prod/productshortname"></ph> for the
-change to take effect. For database-wide properties, you must reboot the database
-for the change to take effect.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunsearchauthdn">
+<title>derby.authentication.ldap.searchAuthDN</title>
+<prolog><metadata>
+<keywords><indexterm>derby.authentication.ldap.searchAuthDN</indexterm><indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>Along with <i><xref href="rtunsearchauthpw.dita#rtunsearchauthpw"/>,</i> this property indicates how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the LDAP directory
+server to do searches for user DN (distinguished name). This property specifies
+the DN; <i><xref href="rtunsearchauthpw.dita#rtunsearchauthpw"/></i> specifies
+the password to use for the search.
+<p>If these two properties are not specified,
+an anonymous search is performed if it is supported.</p>
+<p>For more information
+about LDAP user authentication, see "LDAP Directory Service" in Chapter
+7 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph>.</cite></p></section>
+<refsyn><title>Syntax</title>
+<codeblock><b>derby.authentication.ldap.searchAuthDn=<b><i>DN</i></b></b></codeblock>
+</refsyn>
+<section><title>Default</title>
+<p>If not specified, an anonymous search is performed if it is supported.</p>
+</section>
+<example><title>Example</title>
+<codeblock><b><ph>-- system-wide property</ph>
+derby.authentication.ldap.searchAuthDn=
+ cn=guest,o=JBMSTours.com
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.authentication.ldap.searchAuthDn',
+ 'cn=guest,o=JBMSTours.com')</b></codeblock>
+</example>
+<section><title>Dynamic or static</title>
+<p>Static. For system-wide properties, you must reboot <ph conref="tunconrefs.dita#prod/productshortname"></ph> for the
+change to take effect. For database-wide properties, you must reboot the database
+for the change to take effect.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita Wed Mar 30 16:26:36 2005
@@ -1,46 +1,46 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN"
- "../dtd/reference.dtd">
-<reference id="rtunsearchauthpw" xml:lang="en-us"><?Pub Caret?>
-<title>derby.authentication.ldap.searchAuthPW</title>
-<prolog><metadata>
-<keywords><indexterm>derby.authentication.ldap.searchAuthPW</indexterm><indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
-</keywords>
-</metadata></prolog>
-<refbody>
-<section>Along with <i><xref href="rtunsearchauthdn.dita#rtunsearchauthdn"></xref>,</i> indicates
-how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the directory server to do searches in order to
-retrieve a fully qualified user DN. This property specifies the password; <i><xref
-href="rtunsearchauthdn.dita#rtunsearchauthdn"></xref></i> specifies the DN to use
-for the search. <p>For more information about LDAP user authentication,
-see "LDAP Directory Service" in Chapter 7 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph>.</cite></p></section>
-<section><title>Default</title> <p>If not specified, an anonymous search is
-performed if it is supported.</p> </section>
-<example><title>Example</title> <codeblock><b><ph>-- system-wide property</ph>
-derby.authentication.ldap.searchAuthPW=guestPassword
-<ph>-- database-wide property</ph>
-CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
- 'derby.authentication.ldap.searchAuthPW',
- 'guestPassword')</b></codeblock> </example>
-<section><title>Dynamic or static</title> <p>Static. For system-wide properties,
-you must reboot <ph conref="tunconrefs.dita#prod/productshortname"></ph> for the change to take effect. For database-wide properties,
-you must reboot the database for the change to take effect.</p> </section>
-</refbody>
-</reference>
-<?Pub *0000001687?>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN"
+ "../dtd/reference.dtd">
+<reference id="rtunsearchauthpw" xml:lang="en-us"><?Pub Caret?>
+<title>derby.authentication.ldap.searchAuthPW</title>
+<prolog><metadata>
+<keywords><indexterm>derby.authentication.ldap.searchAuthPW</indexterm><indexterm>LDAP<indexterm>configuring</indexterm></indexterm>
+</keywords>
+</metadata></prolog>
+<refbody>
+<section>Along with <i><xref href="rtunsearchauthdn.dita#rtunsearchauthdn"></xref>,</i> indicates
+how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the directory server to do searches in order to
+retrieve a fully qualified user DN. This property specifies the password; <i><xref
+href="rtunsearchauthdn.dita#rtunsearchauthdn"></xref></i> specifies the DN to use
+for the search. <p>For more information about LDAP user authentication,
+see "LDAP Directory Service" in Chapter 7 of the <cite><ph conref="tunconrefs.dita#pub/citdevelop"></ph>.</cite></p></section>
+<section><title>Default</title> <p>If not specified, an anonymous search is
+performed if it is supported.</p> </section>
+<example><title>Example</title> <codeblock><b><ph>-- system-wide property</ph>
+derby.authentication.ldap.searchAuthPW=guestPassword
+<ph>-- database-wide property</ph>
+CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
+ 'derby.authentication.ldap.searchAuthPW',
+ 'guestPassword')</b></codeblock> </example>
+<section><title>Dynamic or static</title> <p>Static. For system-wide properties,
+you must reboot <ph conref="tunconrefs.dita#prod/productshortname"></ph> for the change to take effect. For database-wide properties,
+you must reboot the database for the change to take effect.</p> </section>
+</refbody>
+</reference>
+<?Pub *0000001687?>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita Wed Mar 30 16:26:36 2005
@@ -1,63 +1,63 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtunstorminrecsize">
-<title>derby.storage.minimumRecordSize</title>
-<prolog><metadata>
-<keywords><indexterm>derby.storage.minimumRecordSize</indexterm>
-</keywords>
-</metadata>
-</prolog><refbody>
-<section>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>See also <i><xref href="rtunproper28026.dita#rtunproper28026"/>.</i></p></section>
-<section><title>Valid conglomerates</title>
-<p>Tables only.</p>
-</section>
-<section><title>Default</title>
-<p id="rtunproper30157">12 bytes.</p>
-</section>
-<section><title>Minimum value</title>
-<p>12 bytes.</p>
-</section>
-<section><title>Maximum value</title>
-<p><i><xref href="rtunproper40688.dita#rtunproper40688"/></i> * (1
-- <i><xref href="rtunproper28026.dita#rtunproper28026"/></i>/100) "
-100.</p>
-<p>If you set this property to a value outside the legal range, <ph conref="tunconrefs.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="tunconrefs.dita#prod/productshortname"></ph> is running,
-the change takes effect immediately. For information about dynamic changes
-to properties, see <xref href="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
-</section></refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtunstorminrecsize">
+<title>derby.storage.minimumRecordSize</title>
+<prolog><metadata>
+<keywords><indexterm>derby.storage.minimumRecordSize</indexterm>
+</keywords>
+</metadata>
+</prolog><refbody>
+<section>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>See also <i><xref href="rtunproper28026.dita#rtunproper28026"/>.</i></p></section>
+<section><title>Valid conglomerates</title>
+<p>Tables only.</p>
+</section>
+<section><title>Default</title>
+<p id="rtunproper30157">12 bytes.</p>
+</section>
+<section><title>Minimum value</title>
+<p>12 bytes.</p>
+</section>
+<section><title>Maximum value</title>
+<p><i><xref href="rtunproper40688.dita#rtunproper40688"/></i> * (1
+- <i><xref href="rtunproper28026.dita#rtunproper28026"/></i>/100) "
+100.</p>
+<p>If you set this property to a value outside the legal range, <ph conref="tunconrefs.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="tunconrefs.dita#prod/productshortname"></ph> is running,
+the change takes effect immediately. For information about dynamic changes
+to properties, see <xref href="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
+</section></refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita Wed Mar 30 16:26:36 2005
@@ -1,54 +1,54 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 topic PUBLIC "-//IBM//DTD DITA Topic//EN"
- "../dtd/topic.dtd">
-<topic id="rtuntrademderby" xml:lang="en-us"><?Pub Caret?>
-<title>Trademarks</title>
-<body>
-<p>The following terms are trademarks of International Business Machines Corporation
-in the United States, other countries, or both, and have been used in at least
-one of the documents in the DB2 UDB documentation library.</p>
-<table colsep="0" expanse="column" frame="none">
-<tgroup cols="2">
-<tbody>
-<row>
-<entry><lines>Cloudscape
-DB2
-DB2 Universal Database
-</lines></entry>
-<entry> <lines>DRDA
-IBM
-WebSphere</lines></entry>
-</row>
-</tbody>
-</tgroup>
-</table>
-<p>The following terms are trademarks or registered trademarks of other companies
-and have been used in at least one of the documents in the <ph conref="tunconrefs.dita#prod/productlongname"></ph> documentation
-library:</p>
-<p>Microsoft, Windows, Windows NT, and the Windows logo are trademarks of
-Microsoft Corporation in the United States, other countries, or both. </p>
-<p>Java and all Java-based trademarks are trademarks of Sun Microsystems,
-Inc. in the United States, other countries, or both.</p>
-<p>UNIX is a registered trademark of The Open Group in the United States and
-other countries.</p>
-<p>Other company, product, or service names may be trademarks or service marks
-of others.</p>
-</body>
-</topic>
-<?Pub *0000001441?>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 topic PUBLIC "-//IBM//DTD DITA Topic//EN"
+ "../dtd/topic.dtd">
+<topic id="rtuntrademderby" xml:lang="en-us"><?Pub Caret?>
+<title>Trademarks</title>
+<body>
+<p>The following terms are trademarks of International Business Machines Corporation
+in the United States, other countries, or both, and have been used in at least
+one of the documents in the DB2 UDB documentation library.</p>
+<table colsep="0" expanse="column" frame="none">
+<tgroup cols="2">
+<tbody>
+<row>
+<entry><lines>Cloudscape
+DB2
+DB2 Universal Database
+</lines></entry>
+<entry> <lines>DRDA
+IBM
+WebSphere</lines></entry>
+</row>
+</tbody>
+</tgroup>
+</table>
+<p>The following terms are trademarks or registered trademarks of other companies
+and have been used in at least one of the documents in the <ph conref="tunconrefs.dita#prod/productlongname"></ph> documentation
+library:</p>
+<p>Microsoft, Windows, Windows NT, and the Windows logo are trademarks of
+Microsoft Corporation in the United States, other countries, or both. </p>
+<p>Java and all Java-based trademarks are trademarks of Sun Microsystems,
+Inc. in the United States, other countries, or both.</p>
+<p>UNIX is a registered trademark of The Open Group in the United States and
+other countries.</p>
+<p>Other company, product, or service names may be trademarks or service marks
+of others.</p>
+</body>
+</topic>
+<?Pub *0000001441?>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntrademderby.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita Wed Mar 30 16:26:36 2005
@@ -1,34 +1,34 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtuntransform139">
-<title>BETWEEN transformations</title>
-<prolog><metadata>
-<keywords>
-<indexterm>BETWEEN transformations</indexterm>
-<indexterm>Internal transformation of statements<indexterm>BETWEEN predicates</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog>
-<refbody>
-<section><p>A BETWEEN predicate is transformed into equivalent predicates that use
-the >= and <= operators, which are optimizable. For example:
-<codeblock><b>flight_date BETWEEN DATE('2004-04-01') and DATE('2004-04-10')</b></codeblock></p></section>
-<section><p>is transformed into
-<codeblock><b>flight_date >= DATE('2004-04-01')
-AND flight_date >= '2004-04-10'</b></codeblock></p></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtuntransform139">
+<title>BETWEEN transformations</title>
+<prolog><metadata>
+<keywords>
+<indexterm>BETWEEN transformations</indexterm>
+<indexterm>Internal transformation of statements<indexterm>BETWEEN predicates</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog>
+<refbody>
+<section><p>A BETWEEN predicate is transformed into equivalent predicates that use
+the >= and <= operators, which are optimizable. For example:
+<codeblock><b>flight_date BETWEEN DATE('2004-04-01') and DATE('2004-04-10')</b></codeblock></p></section>
+<section><p>is transformed into
+<codeblock><b>flight_date >= DATE('2004-04-01')
+AND flight_date >= '2004-04-10'</b></codeblock></p></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntransform139.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita Wed Mar 30 16:26:36 2005
@@ -1,33 +1,33 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtuntransform208">
-<title>LIKE transformations</title>
-<prolog><metadata>
-<keywords>
-<indexterm>LIKE transformations</indexterm>
-<indexterm>Internal transformation of statements<indexterm>LIKE predicates</indexterm></indexterm>
-</keywords>
-</metadata>
-</prolog>
-<refbody><section>
-<ul>
-<li><xref href="rtuntransform345.dita#rtuntransform345"/></li>
-<li><xref href="rtuntransform443.dita#rtuntransform443"/></li>
-<li><xref href="rtuntransform472.dita#rtuntransform472"/></li>
-</ul></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtuntransform208">
+<title>LIKE transformations</title>
+<prolog><metadata>
+<keywords>
+<indexterm>LIKE transformations</indexterm>
+<indexterm>Internal transformation of statements<indexterm>LIKE predicates</indexterm></indexterm>
+</keywords>
+</metadata>
+</prolog>
+<refbody><section>
+<ul>
+<li><xref href="rtuntransform345.dita#rtuntransform345"/></li>
+<li><xref href="rtuntransform443.dita#rtuntransform443"/></li>
+<li><xref href="rtuntransform472.dita#rtuntransform472"/></li>
+</ul></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntransform208.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita Wed Mar 30 16:26:36 2005
@@ -1,41 +1,41 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtuntransform345">
-<title>Character string beginning with constant</title>
-<prolog>
-</prolog>
-<refbody>
-<section><p>A LIKE predicate in which a column is compared to a character string that <i>begins</i> with a character constant (not a wildcard) is transformed
-into three predicates: one predicate that uses the LIKE operator, one that
-uses the >= operator, and one that uses the < operator. For example:
-
-<codeblock><b>country LIKE 'Ch%i%'</b></codeblock></p></section>
-<section><p>becomes
-<codeblock><b>country LIKE 'Ch%i%'
-AND country >= 'Ch'
-AND country < 'Ci'</b></codeblock></p></section>
-<section><p>The first (LIKE) predicate is not optimizable, but the new predicates added
-by the transformation are.</p></section>
-<section><p>When the character string begins with one more character constants and
-ends with a single "%", the first LIKE clause is eliminated. For example:
-
-<codeblock><b>country LIKE 'Ch%'</b></codeblock></p></section>
-<section><p>becomes
-<codeblock><b>country >= 'Ch'
-AND country < 'Ci'</b></codeblock></p></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtuntransform345">
+<title>Character string beginning with constant</title>
+<prolog>
+</prolog>
+<refbody>
+<section><p>A LIKE predicate in which a column is compared to a character string that <i>begins</i> with a character constant (not a wildcard) is transformed
+into three predicates: one predicate that uses the LIKE operator, one that
+uses the >= operator, and one that uses the < operator. For example:
+
+<codeblock><b>country LIKE 'Ch%i%'</b></codeblock></p></section>
+<section><p>becomes
+<codeblock><b>country LIKE 'Ch%i%'
+AND country >= 'Ch'
+AND country < 'Ci'</b></codeblock></p></section>
+<section><p>The first (LIKE) predicate is not optimizable, but the new predicates added
+by the transformation are.</p></section>
+<section><p>When the character string begins with one more character constants and
+ends with a single "%", the first LIKE clause is eliminated. For example:
+
+<codeblock><b>country LIKE 'Ch%'</b></codeblock></p></section>
+<section><p>becomes
+<codeblock><b>country >= 'Ch'
+AND country < 'Ci'</b></codeblock></p></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntransform345.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita Wed Mar 30 16:26:36 2005
@@ -1,34 +1,34 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtuntransform443">
-<title>Character string without wildcards</title>
-<prolog>
-</prolog>
-<refbody>
-<section><p>A LIKE predicate is transformed into a predicate that uses the = operator
-(and a NOT LIKE predicate is transformed into one that uses <>) when
-the character string does not contain any wildcards. For example:
-<codeblock><b>country LIKE 'Chile'</b></codeblock></p></section>
-<section><p>becomes
-<codeblock><b>country = 'Chile'</b></codeblock></p></section>
-<section><p>and
-<codeblock><b>country NOT LIKE 'Chile'</b></codeblock></p></section>
-<section><p>becomes
-<codeblock><b>country <> 'Chile'</b></codeblock></p></section>
-<section><p>Predicates that use the = operator are <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform19435">optimizable</xref>. Predicates that use the <> operator are <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform26698">sargable</xref>.</p></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtuntransform443">
+<title>Character string without wildcards</title>
+<prolog>
+</prolog>
+<refbody>
+<section><p>A LIKE predicate is transformed into a predicate that uses the = operator
+(and a NOT LIKE predicate is transformed into one that uses <>) when
+the character string does not contain any wildcards. For example:
+<codeblock><b>country LIKE 'Chile'</b></codeblock></p></section>
+<section><p>becomes
+<codeblock><b>country = 'Chile'</b></codeblock></p></section>
+<section><p>and
+<codeblock><b>country NOT LIKE 'Chile'</b></codeblock></p></section>
+<section><p>becomes
+<codeblock><b>country <> 'Chile'</b></codeblock></p></section>
+<section><p>Predicates that use the = operator are <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform19435">optimizable</xref>. Predicates that use the <> operator are <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform26698">sargable</xref>.</p></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntransform443.dita
------------------------------------------------------------------------------
svn:eol-style = native
Modified: incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita
URL: http://svn.apache.org/viewcvs/incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita?view=diff&r1=159547&r2=159548
==============================================================================
--- incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita (original)
+++ incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita Wed Mar 30 16:26:36 2005
@@ -1,41 +1,41 @@
-<?xml version="1.0" encoding="utf-8"?>
-<!--
-Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
-
-Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
-<reference xml:lang="en-us" id="rtuntransform472">
-<title>Unknown parameter</title>
-<prolog>
-</prolog>
-<refbody>
-<section><p>'The situation is similar to those described above when a column is compared
-using the LIKE operator to a parameter whose value is unknown in advance (dynamic
-parameter, join column, etc.).</p></section>
-<section><p>In this situation, the LIKE predicate is likewise transformed into three
-predicates: one LIKE predicate, one predicate using the >= operator, and
-one predicate using the < operator. For example:
-<codeblock><b>country LIKE ?</b></codeblock></p></section>
-<section><p>is transformed into
-<codeblock><b>country LIKE ?
-AND country >= <b><i>InternallyGeneratedParameter</i></b>
-AND country < <b><i>InternallyGeneratedParameter</i></b></b></codeblock></p></section>
-<section><p>where the <i>InternallyGeneratedParameters</i> are calculated
-at the beginning of execution based on the value of the parameter.
-<note>This transformation can lead to a bad plan if the user passes in
-a string that begins with a wildcard or a nonselective string as the parameter.
-Users can work around this possibility by writing the query like this (which
-is not optimizable):
-<codeblock><b>(country || '') LIKE ?</b></codeblock></note></p></section>
-</refbody></reference>
+<?xml version="1.0" encoding="utf-8"?>
+<!--
+Copyright 1997, 2004 The Apache Software Foundation or its licensors, as applicable.
+
+Licensed 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 "-//IBM//DTD DITA Reference//EN" "../dtd/reference.dtd">
+<reference xml:lang="en-us" id="rtuntransform472">
+<title>Unknown parameter</title>
+<prolog>
+</prolog>
+<refbody>
+<section><p>'The situation is similar to those described above when a column is compared
+using the LIKE operator to a parameter whose value is unknown in advance (dynamic
+parameter, join column, etc.).</p></section>
+<section><p>In this situation, the LIKE predicate is likewise transformed into three
+predicates: one LIKE predicate, one predicate using the >= operator, and
+one predicate using the < operator. For example:
+<codeblock><b>country LIKE ?</b></codeblock></p></section>
+<section><p>is transformed into
+<codeblock><b>country LIKE ?
+AND country >= <b><i>InternallyGeneratedParameter</i></b>
+AND country < <b><i>InternallyGeneratedParameter</i></b></b></codeblock></p></section>
+<section><p>where the <i>InternallyGeneratedParameters</i> are calculated
+at the beginning of execution based on the value of the parameter.
+<note>This transformation can lead to a bad plan if the user passes in
+a string that begins with a wildcard or a nonselective string as the parameter.
+Users can work around this possibility by writing the query like this (which
+is not optimizable):
+<codeblock><b>(country || '') LIKE ?</b></codeblock></note></p></section>
+</refbody></reference>
Propchange: incubator/derby/docs/trunk/src/tuning/rtuntransform472.dita
------------------------------------------------------------------------------
svn:eol-style = native