db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bpendle...@apache.org
Subject svn commit: r882655 - /db/derby/docs/trunk/src/devguide/cdevconcepts50894.dita
Date Fri, 20 Nov 2009 17:56:30 GMT
Author: bpendleton
Date: Fri Nov 20 17:56:29 2009
New Revision: 882655

URL: http://svn.apache.org/viewvc?rev=882655&view=rev
DERBY-2845: Improve devguide tips on debugging deadlocks

This change adds some additional content to the Development Guide page on
debugging deadlocks. The additional content provides more information
about how to use the SYSCS_DIAG.LOCK_TABLE diagnostic table, and also
points to detailed information available in the Derby wiki.


Modified: db/derby/docs/trunk/src/devguide/cdevconcepts50894.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/devguide/cdevconcepts50894.dita?rev=882655&r1=882654&r2=882655&view=diff
--- db/derby/docs/trunk/src/devguide/cdevconcepts50894.dita (original)
+++ db/derby/docs/trunk/src/devguide/cdevconcepts50894.dita Fri Nov 20 17:56:29 2009
@@ -25,9 +25,37 @@
 <p><ph conref="../conrefs.dita#prod/productshortname"></ph> provides a
-to help you in this situation, <i>org.apache.derby.diag.LockTable</i>. You
+    to help you in this situation, <i>org.apache.derby.diag.LockTable</i>.
+    Access to the <i>LockTable</i> information is provided via the
+    SYSCS_DIAG.LOCK_TABLE diagnostic table.</p>
+diagnostic table shows all of the locks that are currently held in the <ph
+    conref="../conrefs.dita#prod/productshortname"></ph> database. 
+You can reference the SYSCS_DIAG.LOCK_TABLE diagnostic table directly
+in a statement.</p>
+    example:<codeblock>SELECT * FROM SYSCS_DIAG.LOCK_TABLE</codeblock></p>
+the SYSCS_DIAG.LOCK_TABLE diagnostic table is referenced in a statement, a
+snapshot of the lock table is taken.
+    For more information about how to use this table:
+    <ul>
+        <li>See "SYSCS_DIAG diagnostic tables and functions" in the
+            <cite><ph conref="../conrefs.dita#pub/citref"></ph></cite>.</li>
+        <li>See the <xref format="html"
+            href="http://db.apache.org/derby/javadoc/engine/org/apache/derby/diag/LockTable.html"
scope="external">LockTable API documentation</xref>.
+        </li>
+    </ul>
+    You
 can also set the property <i>derby.locks.deadlockTrace</i> to dump additional
 information to the derby.log file about any deadlocks that occur on your system. 
 See the Tuning Guide for more information on this property. For information, see the <cite><ph
+<p>Additional general information about diagnosing locking problems can be
+    found in the <ph conref="../conrefs.dita#prod/productshortname"></ph>
+    Wiki at <xref format="html"
+        href="http://wiki.apache.org/db-derby/LockDebugging" scope="external">
+        http://wiki.apache.org/db-derby/LockDebugging</xref>.

View raw message