<!--$Id: txn_stat.html,v 1.1.1.1 2003/02/15 04:55:55 zarzycki Exp $--> <!--Copyright 1997-2002 by Sleepycat Software, Inc.--> <!--All rights reserved.--> <!--See the file LICENSE for redistribution information.--> <html> <head> <title>Berkeley DB: DbEnv.txn_stat</title> <meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> <meta name="keywords" content="embedded,database,programmatic,toolkit,b+tree,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,java,C,C++"> </head> <body bgcolor=white> <a name="2"><!--meow--></a> <table width="100%"><tr valign=top> <td> <h1>DbEnv.txn_stat</h1> </td> <td align=right> <a href="../api_java/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <hr size=1 noshade> <tt> <h3><pre> import com.sleepycat.db.*; <p> public DbTxnStat txn_stat(int flags) throws DbException; </pre></h3> <h1>Description</h1> <p>The DbEnv.txn_stat method returns the transaction subsystem statistics. <p>The <b>flags</b> value must be set to 0 or the following value: <p><dl compact> <p><dt><a name="Db.DB_STAT_CLEAR">Db.DB_STAT_CLEAR</a><dd>Reset statistics after returning their values. </dl> <p>The DbEnv.txn_stat method creates a DbTxnStat object encapsulating the transaction region statistics. The following data fields are available from the DbTxnStat object: <p><dl compact> <dt>public <a href="../api_java/lsn_class.html">DbLsn</a> st_last_ckp;<dd>The LSN of the last checkpoint. <dt>public long st_time_ckp;<dd>The time the last completed checkpoint finished (as the number of seconds since the Epoch, returned by the IEEE/ANSI Std 1003.1 (POSIX) <b>time</b> interface). <dt>public int st_last_txnid;<dd>The last transaction ID allocated. <dt>public int st_maxtxns;<dd>The maximum number of active transactions possible. <dt>public int st_nactive;<dd>The number of transactions that are currently active. <dt>public int st_maxnactive;<dd>The maximum number of active transactions at any one time. <dt>public int st_nbegins;<dd>The number of transactions that have begun. <dt>public int st_naborts;<dd>The number of transactions that have aborted. <dt>public int st_ncommits;<dd>The number of transactions that have committed. <dt>public int st_nrestores;<dd>The number of transactions that have been restored. <dt>public int st_regsize;<dd>The size of the region. <dt>public int st_region_wait;<dd>The number of times that a thread of control was forced to wait before obtaining the region lock. <dt>public int st_region_nowait;<dd>The number of times that a thread of control was able to obtain the region lock without waiting. <dt>public Active st_txnarray[];<dd>The array of active transactions. Each element of the array is an object of type DbTxnStat.Active, a top level inner class, that has the following fields: <p><dl compact> <p><dt>public int txnid;<dd>The transaction ID of the transaction. <dt>public int parentid;<dd>The transaction ID of the parent transaction (or 0, if no parent). <dt>public <a href="../api_java/lsn_class.html">DbLsn</a> lsn;<dd>The current log sequence number when the transaction was begun. </dl> </dl> <p>The DbEnv.txn_stat method throws an exception that encapsulates a non-zero error value on failure. <h1>Errors</h1> <p>The DbEnv.txn_stat method may fail and throw an exception for errors specified for other Berkeley DB and C library or system methods. If a catastrophic error has occurred, the DbEnv.txn_stat method may fail and throw a <a href="../api_java/runrec_class.html">DbRunRecoveryException</a>, in which case all subsequent Berkeley DB calls will fail in the same way. <h1>Class</h1> <a href="../api_java/env_class.html">DbEnv</a>, <a href="../api_java/txn_class.html">DbTxn</a> <h1>See Also</h1> <a href="../api_java/txn_list.html">Transaction Subsystem and Related Methods</a> </tt> <table width="100%"><tr><td><br></td><td align=right> <a href="../api_java/c_index.html"><img src="../images/api.gif" alt="API"></a><a href="../reftoc.html"><img src="../images/ref.gif" alt="Ref"></a> </td></tr></table> <p><font size=1><a href="http://www.sleepycat.com">Copyright Sleepycat Software</a></font> </body> </html>