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 sc...@apache.org on 2007/03/30 17:14:53 UTC
svn commit: r524117 [3/3] - /db/derby/docs/trunk/src/tuning/
Modified: db/derby/docs/trunk/src/tuning/rtunproper34037.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper34037.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper34037.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper34037.dita Fri Mar 30 08:14:48 2007
@@ -24,7 +24,7 @@
</metadata>
</prolog><refbody>
<section><title>Function</title>
-<p>Defines the location on disk for temporary file space needed by <ph conref="tunconrefs.dita#prod/productshortname"></ph> for
+<p>Defines the location on disk for temporary file space needed by <ph conref="../conrefs.dita#prod/productshortname"></ph> for
performing large sorts and deferred deletes and updates. (Temporary files
are automatically deleted after use, and are removed when the database restarts
after a crash.) The temporary directory named by this property will be created
@@ -40,7 +40,7 @@
ERROR XJ001: Java exception:
'a:\databases\db\tmp\T887256591756.tmp: java.io.IOException'.</codeblock></p>
<p>This property moves the temporary directories for all databases being used
-by the <ph conref="tunconrefs.dita#prod/productshortname"></ph> system. <ph conref="tunconrefs.dita#prod/productshortname"></ph> makes temporary directories for each
+by the <ph conref="../conrefs.dita#prod/productshortname"></ph> system. <ph conref="../conrefs.dita#prod/productshortname"></ph> makes temporary directories for each
database under the directory referenced by this property. For example, if
the property is set as follows:
<codeblock><b>derby.storage.tempDirectory=C:/Temp/dbtemp</b></codeblock></p>
@@ -63,6 +63,6 @@
'c:/Temp/dbtemp')</b></codeblock>
</example>
<section><title>Dynamic or static</title>
-<p>This property is static; you must restart <ph conref="tunconrefs.dita#prod/productshortname"></ph> for a change to take
+<p>This property is static; you must restart <ph conref="../conrefs.dita#prod/productshortname"></ph> for a change to take
effect.</p>
</section></refbody></reference>
Modified: db/derby/docs/trunk/src/tuning/rtunproper35028.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper35028.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper35028.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper35028.dita Fri Mar 30 08:14:48 2007
@@ -25,14 +25,14 @@
</metadata></prolog>
<refbody>
<section><title>Function</title> <p>Specifies a static method that returns
-a stream to which the <ph conref="tunconrefs.dita#prod/productshortname"></ph> error
+a stream to which the <ph conref="../conrefs.dita#prod/productshortname"></ph> error
log is written.</p> <p>Specify the method using the fully qualified name of
the class, then a dot (.) and then the method name. The method must be public
and static. Its return type can be either <i>java.io.OutputStream </i>or <i>java.io.Writer</i>. <ph
-conref="tunconrefs.dita#prod/productshortname"></ph> will not call the <i>close()</i> method
+conref="../conrefs.dita#prod/productshortname"></ph> will not call the <i>close()</i> method
of the object returned by the method.</p> <p>The method is called once at <ph
-conref="tunconrefs.dita#prod/productshortname"></ph> boot time, and the return
-value is used for the lifetime of <ph conref="tunconrefs.dita#prod/productshortname"></ph>.
+conref="../conrefs.dita#prod/productshortname"></ph> boot time, and the return
+value is used for the lifetime of <ph conref="../conrefs.dita#prod/productshortname"></ph>.
If the method returns null, the error stream defaults to the system error
stream. If the method does not exist or is inaccessible, the error stream
defaults to the system error stream (<i>java.lang.System.err</i>).</p> <p>If
@@ -43,7 +43,7 @@
getLogStream</b></codeblock> </example>
<section><title>Scope</title> <p><xref href="ctunproper51399.dita#ctunproper51399/rtunproper41229">system-wide</xref></p> </section>
<section><title>Dynamic or static</title> <p>This property is static; if you
-change it while <ph conref="tunconrefs.dita#prod/productshortname"></ph> is
+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>
Modified: db/derby/docs/trunk/src/tuning/rtunproper37341.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper37341.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper37341.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper37341.dita Fri Mar 30 08:14:48 2007
@@ -25,13 +25,13 @@
</prolog><refbody>
<section><title>Function</title>
<p>Specifies the search filter to use to determine what constitutes a user
-(and other search predicate) for <ph conref="tunconrefs.dita#prod/productshortname"></ph> searches for a full DN during
+(and other search predicate) for <ph conref="../conrefs.dita#prod/productshortname"></ph> searches for a full DN during
user authentication.</p>
-<p>If you set this property to <i>derby.user</i>, <ph conref="tunconrefs.dita#prod/productshortname"></ph> looks
-for cached full DNs for users that you have defined with the <i><xref href="rtunproper27355.dita#rtunproper27355">derby.user.UserName</xref></i> property. For other users, <ph conref="tunconrefs.dita#prod/productshortname"></ph> performs
+<p>If you set this property to <i>derby.user</i>, <ph conref="../conrefs.dita#prod/productshortname"></ph> looks
+for cached full DNs for users that you have defined with the <i><xref href="rtunproper27355.dita#rtunproper27355">derby.user.UserName</xref></i> property. For other users, <ph conref="../conrefs.dita#prod/productshortname"></ph> performs
a search using the <i>default</i> search filter.</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>
+Service" in Chapter 7 of the <cite><ph conref="../conrefs.dita#pub/citdevelop"></ph>.</cite></p>
</section>
<refsyn><title>Syntax</title>
<codeblock><b>derby.authentication.ldap.searchFilter=
@@ -39,7 +39,7 @@
</refsyn>
<section><title>Default</title>
<codeblock><b>(&(objectClass=inetOrgPerson)(uid=<b><i>userName</i></b>))</b></codeblock>
-<note><ph conref="tunconrefs.dita#prod/productshortname"></ph> automatically uses the filter you specify with
+<note><ph conref="../conrefs.dita#prod/productshortname"></ph> automatically uses the filter you specify with
((uid=<i>userName</i>)) unless you include %USERNAME% in
the definition. You might want to use %USERNAME% if your user DNs map the
user name to something other than <i>uid </i>(for example, <i>user</i>).</note>
@@ -48,11 +48,11 @@
<codeblock><b><ph>-- system-wide properties</ph>
derby.authentication.ldap.searchFilter=objectClass=person
<ph>## people in the marketing department
-## <ph conref="tunconrefs.dita#prod/productshortname"></ph> automatically adds (uid=<userName>)</ph>
+## <ph conref="../conrefs.dita#prod/productshortname"></ph> automatically adds (uid=<userName>)</ph>
derby.authentication.ldap.searchFilter=(&(ou=Marketing)
(objectClass=person))
<ph>## all people but those in marketing
-## <ph conref="tunconrefs.dita#prod/productshortname"></ph> automatically adds (uid=<userName>)</ph>
+## <ph conref="../conrefs.dita#prod/productshortname"></ph> automatically adds (uid=<userName>)</ph>
derby.authentication.ldap.searchFilter=(&(!(ou=Marketing)
(objectClass=person))
<ph>## map %USERNAME% to user, not <i>uid</i></ph>
@@ -67,7 +67,7 @@
'objectClass=person')</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
+<p>Static. For system-wide properties, you must reboot <ph conref="../conrefs.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>
Modified: db/derby/docs/trunk/src/tuning/rtunproper40346.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper40346.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper40346.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper40346.dita Fri Mar 30 08:14:48 2007
@@ -24,7 +24,7 @@
</metadata>
</prolog><refbody>
<section><title>Function</title>
-<p>Used by the <ph conref="tunconrefs.dita#prod/productshortname"></ph> system at runtime in determining when to attempt
+<p>Used by the <ph conref="../conrefs.dita#prod/productshortname"></ph> system at runtime in determining when to attempt
to escalate locking for at least one of the tables involved in a transaction
from row-level locking to table-level locking.</p>
<p>A large number of row locks use a lot of resources. If nearly all the rows
Modified: db/derby/docs/trunk/src/tuning/rtunproper40688.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper40688.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper40688.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper40688.dita Fri Mar 30 08:14:48 2007
@@ -38,7 +38,7 @@
</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>
+If you specify an invalid value, <ph conref="../conrefs.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>
@@ -50,7 +50,7 @@
</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,
+<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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
</section></refbody></reference>
Modified: db/derby/docs/trunk/src/tuning/rtunproper43414.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper43414.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper43414.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper43414.dita Fri Mar 30 08:14:48 2007
@@ -24,7 +24,7 @@
</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
+<p>When this property is set to true, <ph conref="../conrefs.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>
Modified: db/derby/docs/trunk/src/tuning/rtunproper43517.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper43517.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper43517.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper43517.dita Fri Mar 30 08:14:48 2007
@@ -24,7 +24,7 @@
</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
+<p>When this property is set to true, <ph conref="../conrefs.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>
Modified: db/derby/docs/trunk/src/tuning/rtunproper46141.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper46141.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper46141.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper46141.dita Fri Mar 30 08:14:48 2007
@@ -24,16 +24,16 @@
</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
+<p>Specifies the number of seconds after which <ph conref="../conrefs.dita#prod/productshortname"></ph> aborts a transaction
+when it is waiting for a lock. When <ph conref="../conrefs.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
+<p>A zero value for this property means that <ph conref="../conrefs.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">derby.locks.deadlockTimeout</xref>,</i> then <ph conref="tunconrefs.dita#prod/productshortname"></ph> never performs any deadlock checking. </p>
+than the value of <i><xref href="rtunproper10607.dita#rtunproper10607">derby.locks.deadlockTimeout</xref>,</i> then <ph conref="../conrefs.dita#prod/productshortname"></ph> never performs any deadlock checking. </p>
</section>
<section><title>Default</title>
<p>60 seconds.</p>
Modified: db/derby/docs/trunk/src/tuning/rtunproper81359.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper81359.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper81359.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper81359.dita Fri Mar 30 08:14:48 2007
@@ -42,7 +42,7 @@
<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
+<p>The minimum value is 40 pages. If you specify a lower value, <ph conref="../conrefs.dita#prod/productshortname"></ph> uses
the default value.</p>
</section>
<section><title>Default</title>
Modified: db/derby/docs/trunk/src/tuning/rtunproper81405.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproper81405.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproper81405.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproper81405.dita Fri Mar 30 08:14:48 2007
@@ -24,23 +24,23 @@
</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
+<p>On some platforms, if set to true, prevents <ph conref="../conrefs.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
+<p><ph conref="../conrefs.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
+of a lock file does not guarantee single access, and so <ph conref="../conrefs.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
+1 of the <cite><ph conref="../conrefs.dita#pub/citdevelop"></ph></cite>.)</p>
+<p><ph conref="../conrefs.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="../conrefs.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
+this property is set to true, if <ph conref="../conrefs.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
+still accessing a <ph conref="../conrefs.dita#prod/productshortname"></ph> database, there is no way for <ph conref="../conrefs.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>
@@ -51,6 +51,6 @@
<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,
+<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>
Modified: db/derby/docs/trunk/src/tuning/rtunpropercachedn.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunpropercachedn.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunpropercachedn.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunpropercachedn.dita Fri Mar 30 08:14:48 2007
@@ -23,7 +23,7 @@
<refbody>
<section><p>This property caches user DNs (distinguished names) locally when <i><xref href="rtunproper13766.dita#rtunproper13766">derby.authentication.provider</xref></i> is set to <i>LDAP</i> and <i><xref href="rtunproper37341.dita#rtunproper37341">derby.authentication.ldap.searchFilter</xref></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
+this property, <ph conref="../conrefs.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="../conrefs.dita#prod/productshortname"></ph> performs
a search using the default value of <i><xref href="rtunproper37341.dita#rtunproper37341">derby.authentication.ldap.searchFilter</xref>.</i></p></section>
</refbody></reference>
Modified: db/derby/docs/trunk/src/tuning/rtunproperdurability.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunproperdurability.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunproperdurability.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunproperdurability.dita Fri Mar 30 08:14:48 2007
@@ -24,7 +24,7 @@
</metadata></prolog>
<refbody>
<section><title>Function</title>This property changes the default durability
-of <ph conref="tunconrefs.dita#prod/productshortname"></ph> to improve performance
+of <ph conref="../conrefs.dita#prod/productshortname"></ph> to improve performance
at the expense of consistency and durability of the database. The only valid
supported case insensitive value is <codeph>test</codeph>. If this property
is set to any value other than <codeph>test</codeph>, this property setting
@@ -53,10 +53,10 @@
<example><title>Example</title><codeblock><b>derby.system.durability=test</b></codeblock><p>Since
this is a system property, you can set it in the <codeph>derby.properties</codeph> file
or on the command line of the JVM when starting the application.</p><p>You
-might enable this property when using <ph conref="tunconrefs.dita#prod/productshortname"></ph> as
+might enable this property when using <ph conref="../conrefs.dita#prod/productshortname"></ph> as
a test database where consistency or recoverability is not an issue.</p></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
+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>
Modified: db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunpropersqlauth.dita Fri Mar 30 08:14:48 2007
@@ -36,10 +36,10 @@
</ul>The values are not case-sensitive.</p><note>If you set this property
as a system property before you create the databases, all new databases will
automatically have SQL authorization enabled. If the databases already exists,
-you can set this property only as a database property. </note><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> uses
+you can set this property only as a database property. </note><p><ph conref="../conrefs.dita#prod/productshortname"></ph> uses
the type of user authentication that is specified with the <codeph>derby.authentication.provider</codeph> property.</p><p>For
more information about user authorization, see "User authorizations" in the <cite><ph
-conref="tunconrefs.dita#pub/citdevelop"></ph></cite>.</p> </section>
+conref="../conrefs.dita#pub/citdevelop"></ph></cite>.</p> </section>
<example><title>Example</title><codeblock><b><ph>-- system-wide property</ph>
derby.database.sqlAuthorization=true</b></codeblock><codeblock><b><ph>-- database-level property</ph>
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(
Modified: db/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunsearchauthdn.dita Fri Mar 30 08:14:48 2007
@@ -23,7 +23,7 @@
</keywords>
</metadata>
</prolog><refbody>
-<section>Along with <i><xref href="rtunsearchauthpw.dita#rtunsearchauthdn">derby.authentication.ldap.searchAuthPW</xref>,</i> this property indicates how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the LDAP directory
+<section>Along with <i><xref href="rtunsearchauthpw.dita#rtunsearchauthdn">derby.authentication.ldap.searchAuthPW</xref>,</i> this property indicates how <ph conref="../conrefs.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#rtunsearchauthdn">derby.authentication.ldap.searchAuthPW</xref></i> specifies
the password to use for the search.
@@ -31,7 +31,7 @@
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>
+7 of the <cite><ph conref="../conrefs.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>
@@ -48,7 +48,7 @@
'cn=guest,o=ExampleSite.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
+<p>Static. For system-wide properties, you must reboot <ph conref="../conrefs.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>
Modified: db/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunsearchauthpw.dita Fri Mar 30 08:14:48 2007
@@ -26,11 +26,11 @@
</metadata></prolog>
<refbody>
<section>Along with <i><xref href="rtunsearchauthdn.dita#rtunsearchauthdn">derby.authentication.ldap.searchAuthDN</xref>,</i> indicates
-how <ph conref="tunconrefs.dita#prod/productshortname"></ph> should bind with the directory server to do searches in order to
+how <ph conref="../conrefs.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">derby.authentication.ldap.searchAuthDN</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>
+see "LDAP Directory Service" in Chapter 7 of the <cite><ph conref="../conrefs.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>
@@ -40,7 +40,7 @@
'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 <ph conref="../conrefs.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>
Modified: db/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtunstorminrecsize.dita Fri Mar 30 08:14:48 2007
@@ -45,7 +45,7 @@
<p><i><xref href="rtunproper40688.dita#rtunproper40688">derby.storage.pageSize</xref></i> * (1
- <i><xref href="rtunproper28026.dita#rtunproper28026">derby.storage.pageReservedSpace</xref></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
+<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>
@@ -58,7 +58,7 @@
</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,
+<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="ctunsetprop44147.dita#ctunsetprop44147"/>.</p>
</section></refbody></reference>
Modified: db/derby/docs/trunk/src/tuning/rtuntrademderby.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntrademderby.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntrademderby.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntrademderby.dita Fri Mar 30 08:14:48 2007
@@ -21,7 +21,7 @@
<title>Trademarks</title>
<body>
<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
+and have been used in at least one of the documents in the <ph conref="../conrefs.dita#prod/productlongname"></ph> documentation
library:</p>
<p>Cloudscape, DB2, DB2 Universal Database, DRDA, and IBM are trademarks of
International Business Machines Corporation in the United States, other countries,
Modified: db/derby/docs/trunk/src/tuning/rtuntransform582.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntransform582.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntransform582.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntransform582.dita Fri Mar 30 08:14:48 2007
@@ -27,7 +27,7 @@
</prolog>
<refbody>
<section><p>A static IN list predicate is one in which the IN list is composed entirely
-of constants. <ph conref="tunconrefs.dita#prod/productshortname"></ph> calculates the minimum and maximum values in the
+of constants. <ph conref="../conrefs.dita#prod/productshortname"></ph> calculates the minimum and maximum values in the
list and transforms the predicate into three new predicates: the original
IN predicate, one that uses the >= operator, and one that uses the <=
operator. The second and third are optimizable. For example:
Modified: db/derby/docs/trunk/src/tuning/rtuntransform590.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntransform590.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntransform590.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntransform590.dita Fri Mar 30 08:14:48 2007
@@ -29,11 +29,11 @@
<section><p>If all the OR predicates in a WHERE clause are of the form
<codeblock><b><b><i><xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref></i></b> = <b><i>Expression</i></b></b></codeblock></p></section>
<section><p>where the <b><i>columnReference</i></b> is the same for
-all predicates in the OR chain, <ph conref="tunconrefs.dita#prod/productshortname"></ph> transforms the OR chain into an
+all predicates in the OR chain, <ph conref="../conrefs.dita#prod/productshortname"></ph> transforms the OR chain into an
IN list of the following form:
<codeblock><b><b><i><xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref></i></b> IN (<b><i>Expression1</i></b>, <b><i>Expression2</i></b>, ..., <b><i>ExpressionN</i></b>)</b></codeblock></p></section>
<section><p>The new predicate might be optimizable.</p></section>
-<section><p>For example, <ph conref="tunconrefs.dita#prod/productshortname"></ph> can transform the following statement:
+<section><p>For example, <ph conref="../conrefs.dita#prod/productshortname"></ph> can transform the following statement:
<codeblock><b>SELECT * FROM Flights
WHERE flight_id = 'AA1111'
OR flight_id = 'US5555'
@@ -41,6 +41,6 @@
<section><p>into this one:
<codeblock><b>SELECT * FROM Flights
WHERE flight_id IN ('AA1111', 'US5555', ?)</b></codeblock></p></section>
-<section><p>If this transformed IN list is a static IN list, <ph conref="tunconrefs.dita#prod/productshortname"></ph> also performs
+<section><p>If this transformed IN list is a static IN list, <ph conref="../conrefs.dita#prod/productshortname"></ph> also performs
the static IN list transformation (see <xref href="rtuntransform582.dita#rtuntransform582"/>).</p></section>
</refbody></reference>
Modified: db/derby/docs/trunk/src/tuning/rtuntransform866547.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntransform866547.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntransform866547.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntransform866547.dita Fri Mar 30 08:14:48 2007
@@ -21,8 +21,8 @@
<prolog>
</prolog>
<refbody>
-<section><p>When a join statement selects from three or more tables, <ph conref="tunconrefs.dita#prod/productshortname"></ph> analyzes
-any <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s between <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref>s within each query block and adds additional <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s where possible if they do not currently exist. For example, <ph conref="tunconrefs.dita#prod/productshortname"></ph> transforms
+<section><p>When a join statement selects from three or more tables, <ph conref="../conrefs.dita#prod/productshortname"></ph> analyzes
+any <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s between <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref>s within each query block and adds additional <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s where possible if they do not currently exist. For example, <ph conref="../conrefs.dita#prod/productshortname"></ph> transforms
the following query:
<codeblock><b>SELECT * FROM samp.employee e, samp.emp_act a, samp.emp_resume r
WHERE e.empno = a.empno
Modified: db/derby/docs/trunk/src/tuning/rtuntransform866587.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntransform866587.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntransform866587.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntransform866587.dita Fri Mar 30 08:14:48 2007
@@ -21,16 +21,16 @@
<prolog>
</prolog>
<refbody>
-<section><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> applies transitive closure on search clauses after transitive
+<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> applies transitive closure on search clauses after transitive
closure on join clauses. For each <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform26698">sargable</xref> predicate
where a <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform13785">simple column reference</xref> is compared with a constant
-(or the IS NULL and IS NOT NULL operators), <ph conref="tunconrefs.dita#prod/productshortname"></ph> looks for an <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref> between the simple column reference
+(or the IS NULL and IS NOT NULL operators), <ph conref="../conrefs.dita#prod/productshortname"></ph> looks for an <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref> between the simple column reference
and a simple column reference from another table in the same query block.
-For each such <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>, <ph conref="tunconrefs.dita#prod/productshortname"></ph> then
+For each such <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>, <ph conref="../conrefs.dita#prod/productshortname"></ph> then
searches for a similar comparison (the same operator) between the column from
-the other table and the same constant. <ph conref="tunconrefs.dita#prod/productshortname"></ph> adds a new predicate if
+the other table and the same constant. <ph conref="../conrefs.dita#prod/productshortname"></ph> adds a new predicate if
no such predicate is found.</p></section>
-<section><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> performs all other possible transformations on the predicates
+<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> performs all other possible transformations on the predicates
(described in <xref href="ctuntransform35783.dita#ctuntransform35783"/>) before applying
transitive closure on search clauses.</p></section>
<section><p>For example, given the following statement:
@@ -39,13 +39,13 @@
AND Flights.flight_id between 'AA1100' and 'AA1250'
AND Flights.flight_id <> 'AA1219'
AND FlightAvailability.flight_id <> 'AA1271' </b></codeblock></p></section>
-<section><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> first performs any other transformations:
+<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> first performs any other transformations:
<ul>
<li>the BETWEEN transformation on the second predicate:
<codeblock><b>AND Flights.flight_id >= 'AA1100'
AND Flights.flight_id <= 'AA1250'</b></codeblock></li>
</ul></p></section>
-<section><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> then performs the transitive closure:
+<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> then performs the transitive closure:
<codeblock><b>SELECT * FROM Flights, FlightAvailability
WHERE Flights.flight_id = FlightAvailability.flight_id
AND Flights.flight_id >= 'AA1100'
@@ -56,7 +56,7 @@
AND FlightAvailability.flight_id <= 'AA1250'
AND FlightAvailability.flight_id <> 'AA1271'
AND FlightAvailability.flight_id <> 'AA1219'</b></codeblock></p></section>
-<section><p>When a sargable predicate uses the = operator, <ph conref="tunconrefs.dita#prod/productshortname"></ph> can remove all <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s comparing that column reference to
+<section><p>When a sargable predicate uses the = operator, <ph conref="../conrefs.dita#prod/productshortname"></ph> can remove all <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref>s comparing that column reference to
another simple column reference from the same query block as part of applying
transitive closure, because the <xref href="ctuntransform13966.dita#ctuntransform13966/rtuntransform36163">equijoin predicate</xref> is
now redundant, whether or not a new predicate was added. For example:
Modified: db/derby/docs/trunk/src/tuning/rtuntransform867602.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/rtuntransform867602.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/rtuntransform867602.dita (original)
+++ db/derby/docs/trunk/src/tuning/rtuntransform867602.dita Fri Mar 30 08:14:48 2007
@@ -25,7 +25,7 @@
</metadata>
</prolog>
<refbody>
-<section><p><ph conref="tunconrefs.dita#prod/productshortname"></ph> transforms COUNT(nonNullableColumn) into COUNT(*). This improves
+<section><p><ph conref="../conrefs.dita#prod/productshortname"></ph> transforms COUNT(nonNullableColumn) into COUNT(*). This improves
performance by potentially reducing the number of referenced columns in the
table (each referenced column needs to be read in for each row) and by giving
the optimizer more access path choices. For example, the cheapest access path
Modified: db/derby/docs/trunk/src/tuning/ttundepth33391.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ttundepth33391.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/ttundepth33391.dita (original)
+++ db/derby/docs/trunk/src/tuning/ttundepth33391.dita Fri Mar 30 08:14:48 2007
@@ -26,15 +26,15 @@
<indexterm>Checkpoint</indexterm></keywords>
</metadata></prolog>
<taskbody>
-<context> After you create indexes, make sure that <ph conref="tunconrefs.dita#prod/productshortname"></ph> is
+<context> After you create indexes, make sure that <ph conref="../conrefs.dita#prod/productshortname"></ph> is
using them. In addition, you might also want to find out the join order <ph
-conref="tunconrefs.dita#prod/productshortname"></ph> is choosing.<p>A general
+conref="../conrefs.dita#prod/productshortname"></ph> is choosing.<p>A general
plan of attack for analyzing your application's SQL statements:</p></context>
<steps>
<step><cmd>Collect your application's most frequently used SQL statements
and transactions into a single test.</cmd></step>
<step><cmd>Create a benchmark test suite against which to run the sample queries.
-The first thing the test suite should do is checkpoint data (force <ph conref="tunconrefs.dita#prod/productshortname"></ph> to
+The first thing the test suite should do is checkpoint data (force <ph conref="../conrefs.dita#prod/productshortname"></ph> to
flush data to disk). You can do that with the following JDBC code: </cmd>
<stepxmp><codeblock>CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_CHECKPOINT_DATABASE()");
@@ -43,13 +43,13 @@
<step><cmd>Use performance timings to identify poorly performing queries.
Try to distinguish between cached and uncached data. Focus on measuring operations
on uncached data (data not already in memory). For example, the first time
-you run a query, <ph conref="tunconrefs.dita#prod/productshortname"></ph> returns
-uncached data. If you run the same query immediately afterward, <ph conref="tunconrefs.dita#prod/productshortname"></ph> is
+you run a query, <ph conref="../conrefs.dita#prod/productshortname"></ph> returns
+uncached data. If you run the same query immediately afterward, <ph conref="../conrefs.dita#prod/productshortname"></ph> is
probably returning cached data. The performance of these two otherwise identical
statements varies significantly and skews results.</cmd></step>
<step><cmd>Use RunTimeStatistics to identify tables that are scanned excessively.
Check that the appropriate indexes are being used to satisfy the query and
-that <ph conref="tunconrefs.dita#prod/productshortname"></ph> is choosing
+that <ph conref="../conrefs.dita#prod/productshortname"></ph> is choosing
the best join order. You can also set derby.language.logQueryPlan to true
to check whether indexes are being used or not. This property will is print
query plans in the derby.log file. See <xref href="rtunproper43414.dita#rtunproper43414"></xref>,
Modified: db/derby/docs/trunk/src/tuning/ttundepth34375.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tuning/ttundepth34375.dita?view=diff&rev=524117&r1=524116&r2=524117
==============================================================================
--- db/derby/docs/trunk/src/tuning/ttundepth34375.dita (original)
+++ db/derby/docs/trunk/src/tuning/ttundepth34375.dita Fri Mar 30 08:14:48 2007
@@ -28,7 +28,7 @@
<steps-unordered>
<step><cmd>To use the RUNTIMESTATISTICS attribute in <codeph>ij</codeph>,
turn on and off RUNTIMESTATISTICS using the <codeph>SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS()</codeph> system
-procedure (see the <cite><ph conref="tunconrefs.dita#pub/citref"></ph></cite> for more information):</cmd>
+procedure (see the <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite> for more information):</cmd>
<stepxmp><codeblock>-- turn on RUNTIMESTATISTICS for connection:
<b>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);</b>
-- execute complex query here -- step through the result set
@@ -37,7 +37,7 @@
<b>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(0);</b></codeblock></stepxmp>
</step>
<step><cmd>Turn on statistics timing using the <codeph>SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING</codeph> system
-procedure (see the <cite><ph conref="tunconrefs.dita#pub/citref"></ph></cite> for more information).
+procedure (see the <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite> for more information).
If you do not turn on statistics timing, you will see the statement execution
plan only, and not the timing information.</cmd><stepxmp><codeblock>CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);</codeblock></stepxmp></step>