diff options
author | Lorry Tar Creator <lorry-tar-importer@baserock.org> | 2015-02-17 17:25:57 +0000 |
---|---|---|
committer | <> | 2015-03-17 16:26:24 +0000 |
commit | 780b92ada9afcf1d58085a83a0b9e6bc982203d1 (patch) | |
tree | 598f8b9fa431b228d29897e798de4ac0c1d3d970 /docs/bdb-sql | |
parent | 7a2660ba9cc2dc03a69ddfcfd95369395cc87444 (diff) | |
download | berkeleydb-master.tar.gz |
Diffstat (limited to 'docs/bdb-sql')
34 files changed, 1004 insertions, 116 deletions
diff --git a/docs/bdb-sql/BDB-SQL-Guide.pdf b/docs/bdb-sql/BDB-SQL-Guide.pdf Binary files differindex dfcca036..4b69fee4 100644 --- a/docs/bdb-sql/BDB-SQL-Guide.pdf +++ b/docs/bdb-sql/BDB-SQL-Guide.pdf diff --git a/docs/bdb-sql/accessing_bdb_sql_databases.title.html b/docs/bdb-sql/accessing_bdb_sql_databases.title.html index 9e8d8ea5..dfd6675b 100644 --- a/docs/bdb-sql/accessing_bdb_sql_databases.title.html +++ b/docs/bdb-sql/accessing_bdb_sql_databases.title.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/addedpragmas.html b/docs/bdb-sql/addedpragmas.html index c9fabbeb..8f94b31f 100644 --- a/docs/bdb-sql/addedpragmas.html +++ b/docs/bdb-sql/addedpragmas.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -75,6 +75,11 @@ </dt> <dt> <span class="sect2"> + <a href="addedpragmas.html#large_record_opt">PRAGMA large_record_opt</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="addedpragmas.html#multiversion">PRAGMA multiversion</a> </span> </dt> @@ -293,6 +298,38 @@ <div class="titlepage"> <div> <div> + <h3 class="title"><a id="large_record_opt"></a>PRAGMA large_record_opt</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA large_record_opt [= number bytes]</pre> + <p> + Enables optimized storage of large records. Any record + larger than the given number of bytes will be stored in + a new format that improves read and write performance + for large records. + </p> + <p> + This pragma must be called before any data is added to + the database, otherwise it will be ignored. + </p> + <p> + This optimization is incompatible with encryption, and + <code class="literal">SQLITE_ReadUncommitted</code>. + </p> + <p> + This optimization stores large records in a folder + called <code class="literal">__db_bl</code> in the journal folder. + So if the database is manually moved to a new location, + the folder with the large records most also be moved. + The Online Backup Function will automatically backup up + these records with the rest of the database. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> <h3 class="title"><a id="multiversion"></a>PRAGMA multiversion</h3> </div> </div> @@ -350,12 +387,6 @@ information into the shared cache without waiting for a write operation to complete. </p> - <p> - Specifying this PRAGMA without a percentage value - causes the current trickle value to be displayed. - Specify <code class="literal">0</code> to turn the trickle - functionality off. - </p> </div> <div class="sect2" lang="en" xml:lang="en"> <div class="titlepage"> @@ -381,7 +412,7 @@ </div> </div> <p> - Seven PRAGMAs were added to control replication. + Fourteen PRAGMAs were added to manage and control replication. They are described in <a class="xref" href="sqlrep.html" title="Chapter 4. Using Replication with the SQL API">Using Replication with the SQL API</a>: </p> @@ -399,37 +430,72 @@ <ul type="disc"> <li> <p> - <span class="bold"><strong>PRAGMA replication</strong></span> + <a class="xref" href="reppragma.html#pragma_replication" title="PRAGMA replication">PRAGMA replication</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_ack_policy" title="PRAGMA replication_ack_policy">PRAGMA replication_ack_policy</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_ack_timeout" title="PRAGMA replication_ack_timeout">PRAGMA replication_ack_timeout</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_get_master" title="PRAGMA replication_get_master">PRAGMA replication_get_master</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_initial_master" title="PRAGMA replication_initial_master">PRAGMA replication_initial_master</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_local_site" title="PRAGMA replication_local_site">PRAGMA replication_local_site</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_num_sites" title="PRAGMA replication_num_sites">PRAGMA replication_num_sites</a> + </p> + </li> + <li> + <p> + <a class="xref" href="reppragma.html#pragma_replication_perm_failed" title="PRAGMA replication_perm_failed">PRAGMA replication_perm_failed</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_initial_master</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_priority" title="PRAGMA replication_priority">PRAGMA replication_priority</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_local_site</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_remote_site" title="PRAGMA replication_remote_site">PRAGMA replication_remote_site</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_remote_site</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_remove_site" title="PRAGMA replication_remove_site">PRAGMA replication_remove_site</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_remove_site</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_site_status" title="PRAGMA replication_site_status">PRAGMA replication_site_status</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_verbose_output</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_verbose_output" title="PRAGMA replication_verbose_output">PRAGMA replication_verbose_output</a> </p> </li> <li> <p> - <span class="bold"><strong>PRAGMA replication_verbose_file</strong></span> + <a class="xref" href="reppragma.html#pragma_replication_verbose_file" title="PRAGMA replication_verbose_file">PRAGMA replication_verbose_file</a> </p> </li> </ul> diff --git a/docs/bdb-sql/admin.html b/docs/bdb-sql/admin.html index e54174ed..bed12e8c 100644 --- a/docs/bdb-sql/admin.html +++ b/docs/bdb-sql/admin.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -50,7 +50,7 @@ <dl> <dt> <span class="sect2"> - <a href="admin.html#idp50743400">Backing Up Replicated Berkeley DB SQL Databases</a> + <a href="admin.html#idp51296616">Backing Up Replicated Berkeley DB SQL Databases</a> </span> </dt> </dl> @@ -93,6 +93,21 @@ </dt> </dl> </dd> + <dt> + <span class="sect1"> + <a href="recoverysql.html">Catastrophic Recovery</a> + </span> + </dt> + <dt> + <span class="sect1"> + <a href="statsql.html">Database Statistics</a> + </span> + </dt> + <dt> + <span class="sect1"> + <a href="verifysql.html">Verify Database Structure</a> + </span> + </dt> </dl> </div> <p> @@ -111,7 +126,7 @@ <dl> <dt> <span class="sect2"> - <a href="admin.html#idp50743400">Backing Up Replicated Berkeley DB SQL Databases</a> + <a href="admin.html#idp51296616">Backing Up Replicated Berkeley DB SQL Databases</a> </span> </dt> </dl> @@ -131,23 +146,21 @@ To learn how to use SQLite Online Backup API, see the official <a class="ulink" href="http://www.sqlite.org/backup.html" target="_top">SQLite Documentation Page.</a> </p> - <p> - If you are using replication, you will also need to copy the - file that contains the replication pragma information in order - to have a full backup. To do that copy the file named <code class="literal"> - pragma</code> from the database journal directory. - </p> <div class="sect2" lang="en" xml:lang="en"> <div class="titlepage"> <div> <div> - <h3 class="title"><a id="idp50743400"></a>Backing Up Replicated Berkeley DB SQL Databases</h3> + <h3 class="title"><a id="idp51296616"></a>Backing Up Replicated Berkeley DB SQL Databases</h3> </div> </div> </div> <p> - When BDB SQL interface databases are replicated the process for backing up - a regular database should be followed. The user must then copy + When BDB SQL interface databases are replicated .dump and the SQLite Online + Backup API are not sufficient to create a backup. In a separate + process you should use the <a href="../api_reference/C/db_hotbackup.html" class="olink">db_hotbackup</a> utility or other methods + described in the + <a href="../gsg_txn/C/backuprestore.html" class="olink">Oracle Berkeley DB Backup Procedures</a> + section. You must then copy some additional files for the backup to be complete. </p> <p> @@ -176,6 +189,9 @@ <li> <code class="literal">__db.rep.system</code> </li> + <li> + <code class="literal">pragma</code> + </li> </ul> </div> <p> diff --git a/docs/bdb-sql/bdb-concepts.html b/docs/bdb-sql/bdb-concepts.html index 61308339..ec7715d3 100644 --- a/docs/bdb-sql/bdb-concepts.html +++ b/docs/bdb-sql/bdb-concepts.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/bfile-c.html b/docs/bdb-sql/bfile-c.html index 49108de9..6c26dd84 100644 --- a/docs/bdb-sql/bfile-c.html +++ b/docs/bdb-sql/bfile-c.html @@ -13,7 +13,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/bfile-extension.html b/docs/bdb-sql/bfile-extension.html index 67f91c93..4e5210ad 100644 --- a/docs/bdb-sql/bfile-extension.html +++ b/docs/bdb-sql/bfile-extension.html @@ -8,20 +8,20 @@ <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> <link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> <link rel="up" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> - <link rel="prev" href="datamigration.html" title="Data Migration" /> + <link rel="prev" href="verifysql.html" title="Verify Database Structure" /> <link rel="next" href="bfile-sql.html" title="BFILE SQL Objects and Functions" /> </head> <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> <th colspan="3" align="center">Appendix A. Using the BFILE Extension</th> </tr> <tr> - <td width="20%" align="left"><a accesskey="p" href="datamigration.html">Prev</a> </td> + <td width="20%" align="left"><a accesskey="p" href="verifysql.html">Prev</a> </td> <th width="60%" align="center"> </th> <td width="20%" align="right"> <a accesskey="n" href="bfile-sql.html">Next</a></td> </tr> @@ -95,12 +95,12 @@ <hr /> <table width="100%" summary="Navigation footer"> <tr> - <td width="40%" align="left"><a accesskey="p" href="datamigration.html">Prev</a> </td> + <td width="40%" align="left"><a accesskey="p" href="verifysql.html">Prev</a> </td> <td width="20%" align="center"> </td> <td width="40%" align="right"> <a accesskey="n" href="bfile-sql.html">Next</a></td> </tr> <tr> - <td width="40%" align="left" valign="top">Data Migration </td> + <td width="40%" align="left" valign="top">Verify Database Structure </td> <td width="20%" align="center"> <a accesskey="h" href="index.html">Home</a> </td> diff --git a/docs/bdb-sql/bfile-sql.html b/docs/bdb-sql/bfile-sql.html index d4b6d20e..eb11bd37 100644 --- a/docs/bdb-sql/bfile-sql.html +++ b/docs/bdb-sql/bfile-sql.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/buildinstall.html b/docs/bdb-sql/buildinstall.html index b0256550..cc275452 100644 --- a/docs/bdb-sql/buildinstall.html +++ b/docs/bdb-sql/buildinstall.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -58,7 +58,7 @@ <p> The BDB SQL interface comes as a part of the Oracle Berkeley DB download. This can be downloaded from the - <a class="ulink" href="http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html" target="_top">Oracle Berkeley DB download page</a>. + <a class="ulink" href="http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/downloads/index.html" target="_top">Oracle Berkeley DB download page</a>. </p> <div class="sect2" lang="en" xml:lang="en"> <div class="titlepage"> @@ -89,7 +89,7 @@ </li> <li> <p> - <code class="literal">libdb_sql50.dll</code> + <code class="literal">libdb_sql60.dll</code> </p> <p> This is the library that provides the BDB SQL interface. @@ -99,6 +99,23 @@ </li> </ul> </div> + <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;"> + <h3 class="title">Note</h3> + <p> + If you are upgrading an existing BDB SQL + installation, and you are upgrading from release + 6.1.19 or lower, then see the SQL database upgrade + instructions + <span> + at + <a href="../installation/sqlite_ver61.html" class="olink"> + Updated SQLite Version + </a> + </span> + + in the Berkeley DB Installation and Build Guide. + </p> + </div> </div> <div class="sect2" lang="en" xml:lang="en"> <div class="titlepage"> @@ -181,7 +198,7 @@ </div> <p> Download the ADO.NET package from the - <a class="ulink" href="http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html" target="_top">Oracle Berkeley DB download page</a>. + <a class="ulink" href="http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/downloads/index.html" target="_top">Oracle Berkeley DB download page</a>. </p> <div class="sect3" lang="en" xml:lang="en"> <div class="titlepage"> diff --git a/docs/bdb-sql/changedpragmas.html b/docs/bdb-sql/changedpragmas.html index 32d8729a..ec8a1116 100644 --- a/docs/bdb-sql/changedpragmas.html +++ b/docs/bdb-sql/changedpragmas.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/datamigration.html b/docs/bdb-sql/datamigration.html index fe0951f1..24e0cc02 100644 --- a/docs/bdb-sql/datamigration.html +++ b/docs/bdb-sql/datamigration.html @@ -9,12 +9,12 @@ <link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> <link rel="up" href="admin.html" title="Chapter 5. Administrating Berkeley DB SQL Databases" /> <link rel="prev" href="sync.html" title="Syncing with Oracle Databases" /> - <link rel="next" href="bfile-extension.html" title="Appendix A. Using the BFILE Extension" /> + <link rel="next" href="recoverysql.html" title="Catastrophic Recovery" /> </head> <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -23,7 +23,7 @@ <tr> <td width="20%" align="left"><a accesskey="p" href="sync.html">Prev</a> </td> <th width="60%" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th> - <td width="20%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td> + <td width="20%" align="right"> <a accesskey="n" href="recoverysql.html">Next</a></td> </tr> </table> <hr /> @@ -130,14 +130,14 @@ <td width="20%" align="center"> <a accesskey="u" href="admin.html">Up</a> </td> - <td width="40%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td> + <td width="40%" align="right"> <a accesskey="n" href="recoverysql.html">Next</a></td> </tr> <tr> <td width="40%" align="left" valign="top">Syncing with Oracle Databases </td> <td width="20%" align="center"> <a accesskey="h" href="index.html">Home</a> </td> - <td width="40%" align="right" valign="top"> Appendix A. Using the BFILE Extension</td> + <td width="40%" align="right" valign="top"> Catastrophic Recovery</td> </tr> </table> </div> diff --git a/docs/bdb-sql/dbfeatures.html b/docs/bdb-sql/dbfeatures.html index d20be241..15f932fc 100644 --- a/docs/bdb-sql/dbfeatures.html +++ b/docs/bdb-sql/dbfeatures.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/dbsqlbasics.html b/docs/bdb-sql/dbsqlbasics.html index 2fb8f662..ce156803 100644 --- a/docs/bdb-sql/dbsqlbasics.html +++ b/docs/bdb-sql/dbsqlbasics.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -153,6 +153,11 @@ </dt> <dt> <span class="sect2"> + <a href="addedpragmas.html#large_record_opt">PRAGMA large_record_opt</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="addedpragmas.html#multiversion">PRAGMA multiversion</a> </span> </dt> @@ -193,6 +198,20 @@ <a href="sql_encryption.html">Encryption</a> </span> </dt> + <dd> + <dl> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_native_encrypt">Berkeley DB encryption</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_see">SQLite Encryption Extension</a> + </span> + </dt> + </dl> + </dd> <dt> <span class="sect1"> <a href="sequencesupport.html">Using Sequences</a> diff --git a/docs/bdb-sql/index.html b/docs/bdb-sql/index.html index 41981dc5..2122709b 100644 --- a/docs/bdb-sql/index.html +++ b/docs/bdb-sql/index.html @@ -12,7 +12,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -30,11 +30,11 @@ <div class="titlepage"> <div> <div> - <h1 class="title"><a id="idp44688"></a>Getting Started with the Oracle Berkeley DB SQL APIs</h1> + <h1 class="title"><a id="idp11320"></a>Getting Started with the Oracle Berkeley DB SQL APIs</h1> </div> <div> <div class="legalnotice"> - <a id="idp50456832"></a> + <a id="idp50968456"></a> <p class="legalnotice-title"> <b>Legal Notice</b> </p> @@ -64,7 +64,7 @@ <p> To obtain a copy of this document's original source code, please submit a request to the Oracle Technology Network forum at: - <a class="ulink" href="http://forums.oracle.com/forums/forum.jspa?forumID=271" target="_top">http://forums.oracle.com/forums/forum.jspa?forumID=271</a> + <a class="ulink" href="https://forums.oracle.com/forums/forum.jspa?forumID=271" target="_top">https://forums.oracle.com/forums/forum.jspa?forumID=271</a> </p> @@ -72,7 +72,7 @@ </div> </div> <div> - <p class="pubdate">5/11/2012</p> + <p class="pubdate">2/17/2015</p> </div> </div> <hr /> @@ -229,6 +229,11 @@ </dt> <dt> <span class="sect2"> + <a href="addedpragmas.html#large_record_opt">PRAGMA large_record_opt</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="addedpragmas.html#multiversion">PRAGMA multiversion</a> </span> </dt> @@ -269,6 +274,20 @@ <a href="sql_encryption.html">Encryption</a> </span> </dt> + <dd> + <dl> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_native_encrypt">Berkeley DB encryption</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_see">SQLite Encryption Extension</a> + </span> + </dt> + </dl> + </dd> <dt> <span class="sect1"> <a href="sequencesupport.html">Using Sequences</a> @@ -393,6 +412,11 @@ </dt> <dt> <span class="sect2"> + <a href="sqlrep.html#permmessage">Permanent Message Handling</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="sqlrep.html#twositerep">Two-Site Replication Groups</a> </span> </dt> @@ -412,6 +436,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_policy">PRAGMA replication_ack_policy</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_timeout">PRAGMA replication_ack_timeout</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_get_master">PRAGMA replication_get_master</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_initial_master">PRAGMA replication_initial_master</a> </span> </dt> @@ -422,6 +461,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_num_sites">PRAGMA replication_num_sites</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_perm_failed">PRAGMA replication_perm_failed</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_priority">PRAGMA replication_priority</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_remote_site">PRAGMA replication_remote_site</a> </span> </dt> @@ -432,6 +486,11 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_site_status">PRAGMA replication_site_status</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_verbose_output">PRAGMA replication_verbose_output</a> </span> </dt> @@ -484,7 +543,7 @@ <dl> <dt> <span class="sect2"> - <a href="admin.html#idp50743400">Backing Up Replicated Berkeley DB SQL Databases</a> + <a href="admin.html#idp51296616">Backing Up Replicated Berkeley DB SQL Databases</a> </span> </dt> </dl> @@ -527,6 +586,21 @@ </dt> </dl> </dd> + <dt> + <span class="sect1"> + <a href="recoverysql.html">Catastrophic Recovery</a> + </span> + </dt> + <dt> + <span class="sect1"> + <a href="statsql.html">Database Statistics</a> + </span> + </dt> + <dt> + <span class="sect1"> + <a href="verifysql.html">Verify Database Structure</a> + </span> + </dt> </dl> </dd> <dt> diff --git a/docs/bdb-sql/journaldirectory.html b/docs/bdb-sql/journaldirectory.html index 3a0e4cde..cd6d90f2 100644 --- a/docs/bdb-sql/journaldirectory.html +++ b/docs/bdb-sql/journaldirectory.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/lockhandling.html b/docs/bdb-sql/lockhandling.html index 8b3dd006..d548a7a9 100644 --- a/docs/bdb-sql/lockhandling.html +++ b/docs/bdb-sql/lockhandling.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/lockingnotes.html b/docs/bdb-sql/lockingnotes.html index c5da5a5b..3410d004 100644 --- a/docs/bdb-sql/lockingnotes.html +++ b/docs/bdb-sql/lockingnotes.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/miscdiff.html b/docs/bdb-sql/miscdiff.html index 491b9a48..dda2fb67 100644 --- a/docs/bdb-sql/miscdiff.html +++ b/docs/bdb-sql/miscdiff.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/moreinfo.html b/docs/bdb-sql/moreinfo.html index 04966f49..0f444bb8 100644 --- a/docs/bdb-sql/moreinfo.html +++ b/docs/bdb-sql/moreinfo.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -53,21 +53,21 @@ <ul type="disc"> <li> <p> - <a class="ulink" href="http://download.oracle.com/docs/cd/E17076_02/html/installation/index.html" target="_top"> + <a class="ulink" href="http://docs.oracle.com/cd/E17076_02/html/installation/index.html" target="_top"> Berkeley DB Installation and Build Guide </a> </p> </li> <li> <p> - <a class="ulink" href="http://download.oracle.com/docs/cd/E17076_02/html/programmer_reference/index.html" target="_top"> + <a class="ulink" href="http://docs.oracle.com/cd/E17076_02/html/programmer_reference/index.html" target="_top"> Berkeley DB Programmer's Reference Guide </a> </p> </li> <li> <p> - <a class="ulink" href="http://download.oracle.com/docs/cd/E17076_02/html/gsg_db_rep/C/index.html" target="_top"> + <a class="ulink" href="http://docs.oracle.com/cd/E17076_02/html/gsg_db_rep/C/index.html" target="_top"> Berkeley DB Getting Started with Replicated Applications </a> </p> @@ -89,7 +89,7 @@ downloads, visit - <a class="ulink" href="http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html" target="_top">http://www.oracle.com/technetwork/database/berkeleydb/downloads/index.html</a>. + <a class="ulink" href="http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/downloads/index.html" target="_top">http://www.oracle.com/technetwork/database/database-technologies/berkeleydb/downloads/index.html</a>. </p> </span> <div class="sect2" lang="en" xml:lang="en"> @@ -104,8 +104,8 @@ You can post your comments and questions at the Oracle Technology (OTN) forum for <span> - Oracle Berkeley DB at: <a class="ulink" href="http://forums.oracle.com/forums/forum.jspa?forumID=271" target="_top">http://forums.oracle.com/forums/forum.jspa?forumID=271</a>, - or for Oracle Berkeley DB High Availability at: <a class="ulink" href="http://forums.oracle.com/forums/forum.jspa?forumID=272" target="_top">http://forums.oracle.com/forums/forum.jspa?forumID=272</a>. + Oracle Berkeley DB at: <a class="ulink" href="https://forums.oracle.com/forums/forum.jspa?forumID=271" target="_top">https://forums.oracle.com/forums/forum.jspa?forumID=271</a>, + or for Oracle Berkeley DB High Availability at: <a class="ulink" href="https://forums.oracle.com/forums/forum.jspa?forumID=272" target="_top">https://forums.oracle.com/forums/forum.jspa?forumID=272</a>. </span> diff --git a/docs/bdb-sql/mvcc.html b/docs/bdb-sql/mvcc.html index 2cec5b0c..2b5e7e28 100644 --- a/docs/bdb-sql/mvcc.html +++ b/docs/bdb-sql/mvcc.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/normal-sql.html b/docs/bdb-sql/normal-sql.html index 403510b3..5d1ccfcd 100644 --- a/docs/bdb-sql/normal-sql.html +++ b/docs/bdb-sql/normal-sql.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -60,7 +60,9 @@ </p> <p> SQLite datatyping is described in detail on the - Datatypes in SQLite Version 3 page. + <a class="ulink" href="http://sqlite.org/datatype3.html" target="_top"> + Datatypes in SQLite Version 3 + </a> page. </p> </li> <li> @@ -74,9 +76,9 @@ <p> How NULLs are handled in SQLite may be different from what you are used to. See - + <a class="ulink" href="http://www.sqlite.org/nulls.html" target="_top"> NULL Handling in SQLite Versus Other Database Engines - + </a> for details. </p> </li> @@ -84,9 +86,9 @@ <p> There are some features of SQL that SQLite does not support. For more information, see - + <a class="ulink" href="http://www.sqlite.org/omitted.html" target="_top"> SQL Features That SQLite Does Not Implement. - + </a> </p> </li> </ul> diff --git a/docs/bdb-sql/preface.html b/docs/bdb-sql/preface.html index 3d3f8a49..78d7626c 100644 --- a/docs/bdb-sql/preface.html +++ b/docs/bdb-sql/preface.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -64,7 +64,7 @@ </div> <p> Welcome to the Berkeley DB SQL interface. This manual describes how to - configure and use the SQL interface to Berkeley DB 11<span class="emphasis"><em>g</em></span> Release 2. + configure and use the SQL interface to Berkeley DB 12<span class="emphasis"><em>c</em></span> Release 1. This manual also describes common administrative tasks, such as backup and restore, database dump and load, and data migration when using the BDB SQL interface. diff --git a/docs/bdb-sql/recoverysql.html b/docs/bdb-sql/recoverysql.html new file mode 100644 index 00000000..ed4d344f --- /dev/null +++ b/docs/bdb-sql/recoverysql.html @@ -0,0 +1,80 @@ +<?xml version="1.0" encoding="UTF-8" standalone="no"?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> + <head> + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> + <title>Catastrophic Recovery</title> + <link rel="stylesheet" href="gettingStarted.css" type="text/css" /> + <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> + <link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> + <link rel="up" href="admin.html" title="Chapter 5. Administrating Berkeley DB SQL Databases" /> + <link rel="prev" href="datamigration.html" title="Data Migration" /> + <link rel="next" href="statsql.html" title="Database Statistics" /> + </head> + <body> + <div xmlns="" class="navheader"> + <div class="libver"> + <p>Library Version 12.1.6.1</p> + </div> + <table width="100%" summary="Navigation header"> + <tr> + <th colspan="3" align="center">Catastrophic Recovery</th> + </tr> + <tr> + <td width="20%" align="left"><a accesskey="p" href="datamigration.html">Prev</a> </td> + <th width="60%" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th> + <td width="20%" align="right"> <a accesskey="n" href="statsql.html">Next</a></td> + </tr> + </table> + <hr /> + </div> + <div class="sect1" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h2 class="title" style="clear: both"><a id="recoverysql"></a>Catastrophic Recovery</h2> + </div> + </div> + </div> + <p> + Catastrophic recovery is used when normal recovery is + unable to repair a corrupted database. + A detailed description of the recovery utility is described at + <a href="../api_reference/C/db_recover.html" class="olink">db_recover</a> + . This + section describes how to use the utility with a SQL database. + </p> + <p> + The first step in running recovery is to add a <a href="../programmer_reference/env_db_config.html#env_db_config.DB_CONFIG" class="olink">DB_CONFIG</a> + file + to the journal directory. In the file, add the following line: + </p> + <code class="code"> + add_data_dir .. + </code> + <p> + Then execute the following command in the journal directory + <span class="command"><strong>db_recover -c</strong></span>. + </p> + </div> + <div class="navfooter"> + <hr /> + <table width="100%" summary="Navigation footer"> + <tr> + <td width="40%" align="left"><a accesskey="p" href="datamigration.html">Prev</a> </td> + <td width="20%" align="center"> + <a accesskey="u" href="admin.html">Up</a> + </td> + <td width="40%" align="right"> <a accesskey="n" href="statsql.html">Next</a></td> + </tr> + <tr> + <td width="40%" align="left" valign="top">Data Migration </td> + <td width="20%" align="center"> + <a accesskey="h" href="index.html">Home</a> + </td> + <td width="40%" align="right" valign="top"> Database Statistics</td> + </tr> + </table> + </div> + </body> +</html> diff --git a/docs/bdb-sql/rep_usageexamples.html b/docs/bdb-sql/rep_usageexamples.html index 1894ef10..8aa95053 100644 --- a/docs/bdb-sql/rep_usageexamples.html +++ b/docs/bdb-sql/rep_usageexamples.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -113,7 +113,7 @@ dbsql univ.db <p> Site 2: </p> - <pre class="programlisting"> # Perform some reads on first replica. + <pre class="programlisting"> # Perform some reads on first replica. select * from university where region = "Europe"; select count(*) from country where top_100 > 0; diff --git a/docs/bdb-sql/reppragma.html b/docs/bdb-sql/reppragma.html index dac81daf..051a9a41 100644 --- a/docs/bdb-sql/reppragma.html +++ b/docs/bdb-sql/reppragma.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -45,6 +45,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_policy">PRAGMA replication_ack_policy</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_timeout">PRAGMA replication_ack_timeout</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_get_master">PRAGMA replication_get_master</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_initial_master">PRAGMA replication_initial_master</a> </span> </dt> @@ -55,6 +70,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_num_sites">PRAGMA replication_num_sites</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_perm_failed">PRAGMA replication_perm_failed</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_priority">PRAGMA replication_priority</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_remote_site">PRAGMA replication_remote_site</a> </span> </dt> @@ -65,6 +95,11 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_site_status">PRAGMA replication_site_status</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_verbose_output">PRAGMA replication_verbose_output</a> </span> </dt> @@ -92,7 +127,9 @@ <pre class="programlisting">PRAGMA replication=ON|OFF </pre> <p> Enables the local environment to participate in - replication. + replication. You only need to specify this PRAGMA + once to turn on replication; all future uses of the + database will automatically enable replication. </p> <p> Before invoking this PRAGMA for a brand new @@ -131,6 +168,166 @@ <div class="titlepage"> <div> <div> + <h3 class="title"><a id="pragma_replication_ack_policy"></a>PRAGMA replication_ack_policy</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_ack_policy=all|all_available|none|one|quorum </pre> + <p> + Sets the replication group's acknowledgement policy. If + no policy is specified, then this PRAGMA returns the + current acknowledgement policy. This PRAGMA may be + called at any time during the life of the application. + </p> + <p> + Acknowledgement policies are used to describe how + permanent messages will be handled. A message is + considered to be permanent if the master site has + received enough responses (acknowledgements) from its + replicas. Once the master is satisfied that a message is + permanent, it considers the transaction that generated + the message to be complete. Therefore, the + acknowledgement policy you set affects your + application's write throughput, as well as the + durability strength of your transactions. + </p> + <p> + Message acknowledgements must be returned within a set + timeout period. See + <a class="xref" href="reppragma.html#pragma_replication_ack_timeout" title="PRAGMA replication_ack_timeout">PRAGMA replication_ack_timeout</a> + for information on how to manage this timeout. + Also, + <a class="xref" href="reppragma.html#pragma_replication_perm_failed" title="PRAGMA replication_perm_failed">PRAGMA replication_perm_failed</a> + provides useful diagnostic information that you can use + to fine-tune your acknowledgement policy. + </p> + <p> + See + <a class="xref" href="sqlrep.html#permmessage" title="Permanent Message Handling">Permanent Message Handling</a> + for more information on message acknowledgements. + </p> + <p> + Possible permanent acknowledgement policies are: + </p> + <div class="itemizedlist"> + <ul type="disc"> + <li> + <p> + <code class="literal">all</code> + </p> + <p> + All sites belonging to the replication group must + acknowledge the message before the generating + transaction is considered to be complete. This + provides the strongest possible durability + guarantee, but also the slowest possible write + throughput. + </p> + <p> + Note that if any site is shutdown or otherwise + cannot be reached due to networking errors, + this acknowledgement policy will prevent your + application from considering any transactions + durable. + </p> + </li> + <li> + <p> + <code class="literal">all_available</code> + </p> + <p> + All currently connected sites must acknowledge the message. + </p> + </li> + <li> + <p> + <code class="literal">none</code> + </p> + <p> + The master will not wait for any message + acknowledgements before completing the + transaction. This results in the fastest + possible write throughput, but also the weakest + durability guarantee. + </p> + </li> + <li> + <p> + <code class="literal">one</code> + </p> + <p> + At least one site must acknowledge the message + before the transaction is considered to be + complete. + </p> + </li> + <li> + <p> + <code class="literal">quorum</code> + </p> + <p> + The master waits until it has received + acknowledgements from the minimum number of + electable sites sufficient to ensure the record + change is durable in the event of an election. + This is the default acknowledgement policy. + </p> + </li> + </ul> + </div> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="pragma_replication_ack_timeout"></a>PRAGMA replication_ack_timeout</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_ack_timeout=<timeout in microseconds> </pre> + <p> + Sets the replication site's acknowledgement timeout + value. If the acknowledgement policy cannot be met + within this timeout period, then the encompassing + transaction is not considered to be complete. This + PRAGMA may be called at any time during the life of the + application. The default is 1 second (1000000). + </p> + <p> + If no timeout is provided, then this PRAGMA returns + the replication site's current message acknowledgement + timeout value. + </p> + <p> + For information on specifying acknowledgement policies, + see + <a class="xref" href="reppragma.html#pragma_replication_ack_policy" title="PRAGMA replication_ack_policy">PRAGMA replication_ack_policy</a>. + Also, + <a class="xref" href="reppragma.html#pragma_replication_perm_failed" title="PRAGMA replication_perm_failed">PRAGMA replication_perm_failed</a> + provides useful diagnostic information that you can use + to fine-tune your acknowledgement timeouts. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="pragma_replication_get_master"></a>PRAGMA replication_get_master</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_get_master </pre> + <p> + Returns a host/port pair representing the current + master. If replication has not yet started, or if the + master is currently not known (such as during an + election), <code class="literal">NULL</code> is returned. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> <h3 class="title"><a id="pragma_replication_initial_master"></a>PRAGMA replication_initial_master</h3> </div> </div> @@ -185,6 +382,84 @@ <div class="titlepage"> <div> <div> + <h3 class="title"><a id="pragma_replication_num_sites"></a>PRAGMA replication_num_sites</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_num_sites</pre> + <p> + Returns the number of sites in the replication group, + or <code class="literal">0</code> if replication has not yet + started. Any input provided to this PRAGMA is ignored. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="pragma_replication_perm_failed"></a>PRAGMA replication_perm_failed</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_perm_failed </pre> + <p> + Returns the number of times that a permanent message + has failed the replication group's acknowledgement + policy since the last time this PRAGMA was called. Zero + is returned if replication has not yet started. + </p> + <p> + Every time a permanent message has failed + acknowledgement, a transaction was not considered + durable and the master waited the full acknowldgement + timeout period before returning from its commit. If + you are seeing a high number of permanent message + acknowledgement failures, then that might represent a + significant reduction in your application's + write-throughput. + </p> + <p> + To fix the problem, begin by examining your replicas to + make sure they are operating correctly, as well as your + network to make sure its performance is what you expect. + If all looks well, then you should either reduce your + acknowledgement policy (and accept a lessened + durability guarantee) or increase your acknowledgement + timeout period (which might reduce your write-throughput). + </p> + <p> + To manage your acknowledgement policies, see + <a class="xref" href="reppragma.html#pragma_replication_ack_policy" title="PRAGMA replication_ack_policy">PRAGMA replication_ack_policy</a>. + To manage your acknowledgement timeout policy, see + <a class="xref" href="reppragma.html#pragma_replication_ack_timeout" title="PRAGMA replication_ack_timeout">PRAGMA replication_ack_timeout</a>. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="pragma_replication_priority"></a>PRAGMA replication_priority</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_priority=<non-0 positive integer> </pre> + <p> + Sets the site's election priority. When holding + elections, if more than one site has the most + up-to-date copy of the data then the site with the + highest priority will become master. This PRAGMA may + be called at any time during the life of the + application. The default is 100. + </p> + <p> + If no priority is provided, then this PRAGMA returns + the site's current priority. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> <h3 class="title"><a id="pragma_replication_remote_site"></a>PRAGMA replication_remote_site</h3> </div> </div> @@ -241,6 +516,26 @@ <div class="titlepage"> <div> <div> + <h3 class="title"><a id="pragma_replication_site_status"></a>PRAGMA replication_site_status</h3> + </div> + </div> + </div> + <pre class="programlisting">PRAGMA replication_site_status </pre> + <p> + Returns whether the local site is the + <code class="literal">MASTER</code>, <code class="literal">CLIENT</code>, + or <code class="literal">UNKNOWN</code>. + </p> + <p> + <code class="literal">UNKNOWN</code> is returned if replication + has not yet started. CLIENT is another term for + replica. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> <h3 class="title"><a id="pragma_replication_verbose_output"></a>PRAGMA replication_verbose_output</h3> </div> </div> diff --git a/docs/bdb-sql/repstatistics.html b/docs/bdb-sql/repstatistics.html index a94c5d5c..66204c43 100644 --- a/docs/bdb-sql/repstatistics.html +++ b/docs/bdb-sql/repstatistics.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/selectpage_size.html b/docs/bdb-sql/selectpage_size.html index 24534435..ad79fde3 100644 --- a/docs/bdb-sql/selectpage_size.html +++ b/docs/bdb-sql/selectpage_size.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/sequencesupport.html b/docs/bdb-sql/sequencesupport.html index 71c251bd..80a27026 100644 --- a/docs/bdb-sql/sequencesupport.html +++ b/docs/bdb-sql/sequencesupport.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -130,7 +130,12 @@ </p> <p> The starting value for the sequence. If this - parameter is not provided then + parameter is not provided it is set to + <code class="literal">minvalue</code> if + an incrementing sequence is used, and + <code class="literal">maxvalue</code> if a decrementing + sequence is used. If neither + of those parameters are set then <code class="literal">0</code> is used. </p> </li> diff --git a/docs/bdb-sql/sql_encryption.html b/docs/bdb-sql/sql_encryption.html index c575776a..4f301967 100644 --- a/docs/bdb-sql/sql_encryption.html +++ b/docs/bdb-sql/sql_encryption.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -36,25 +36,74 @@ </div> </div> </div> - <p> - The Berkeley DB SQL interface supports the SQLite Encryption Extension (SEE) to ensure security of - your data. The supported encryption algorithm is AES-128 in CBC mode. - For more information on the concepts relating to BDB encryption, see the - <span> - <a href="../programmer_reference/env_encrypt.html" class="olink">Berkeley DB Programmer's Reference Guide.</a> + <div class="toc"> + <dl> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_native_encrypt">Berkeley DB encryption</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="sql_encryption.html#sql_see">SQLite Encryption Extension</a> </span> - - </p> + </dt> + </dl> + </div> <p> - To learn how to use the SQLite Encryption Extension (SEE), see the - official <a class="ulink" href="http://www.hwaci.com/sw/sqlite/see.html" target="_top">SQLite - Documentation Page.</a> - </p> - <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;"> - <h3 class="title">Note</h3> - <p> - The Berkeley DB SQL interface does not support the sqlite3_rekey method. + When encryption is enabled, the Berkeley DB SQL API uses + native Berkeley DB encryption to assure the security of + your data. As usual, the Berkeley DB SQL API is almost + identical to the SQLite API, so you can use the syntax of + the SQLite Encryption Extension to interact with your + encrypted data. </p> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="sql_native_encrypt"></a>Berkeley DB encryption</h3> + </div> + </div> + </div> + <p> + Berkeley DB supports encryption using the Rijndael/AES + algorithm. It is configured to use a 128-bit key. Berkeley + DB uses a 16-byte initialization vector generated using the + Mersenne Twister. All encrypted information is additionally + checksummed using the SHA1 Secure Hash Algorithm, using a + 160-bit message digest. For more information on BDB + encryption, see the + <span> + <a href="../programmer_reference/env_encrypt.html" class="olink"> + Berkeley DB Programmer's Reference Guide. + </a> + </span> + + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h3 class="title"><a id="sql_see"></a>SQLite Encryption Extension</h3> + </div> + </div> + </div> + <p> + To learn how to use the SQLite Encryption Extension (SEE), + see the official + <a class="ulink" href="http://www.hwaci.com/sw/sqlite/see.html" target="_top"> + SQLite Documentation Page. + </a> + </p> + <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;"> + <h3 class="title">Note</h3> + <p> + The Berkeley DB SQL interface does not support the + sqlite3_rekey method. + </p> + </div> </div> </div> <div class="navfooter"> diff --git a/docs/bdb-sql/sqlrep.html b/docs/bdb-sql/sqlrep.html index 56822bdb..cbbad427 100644 --- a/docs/bdb-sql/sqlrep.html +++ b/docs/bdb-sql/sqlrep.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -65,6 +65,11 @@ </dt> <dt> <span class="sect2"> + <a href="sqlrep.html#permmessage">Permanent Message Handling</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="sqlrep.html#twositerep">Two-Site Replication Groups</a> </span> </dt> @@ -84,6 +89,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_policy">PRAGMA replication_ack_policy</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_ack_timeout">PRAGMA replication_ack_timeout</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_get_master">PRAGMA replication_get_master</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_initial_master">PRAGMA replication_initial_master</a> </span> </dt> @@ -94,6 +114,21 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_num_sites">PRAGMA replication_num_sites</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_perm_failed">PRAGMA replication_perm_failed</a> + </span> + </dt> + <dt> + <span class="sect2"> + <a href="reppragma.html#pragma_replication_priority">PRAGMA replication_priority</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_remote_site">PRAGMA replication_remote_site</a> </span> </dt> @@ -104,6 +139,11 @@ </dt> <dt> <span class="sect2"> + <a href="reppragma.html#pragma_replication_site_status">PRAGMA replication_site_status</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="reppragma.html#pragma_replication_verbose_output">PRAGMA replication_verbose_output</a> </span> </dt> @@ -168,13 +208,6 @@ </li> </ul> </div> - <div class="note" style="margin-left: 0.5in; margin-right: 0.5in;"> - <h3 class="title">Note</h3> - <p> - You cannot access a BDB SQL database using multiple - processes if you enable replication for that database. - </p> - </div> <div class="sect1" lang="en" xml:lang="en"> <div class="titlepage"> <div> @@ -202,6 +235,11 @@ </dt> <dt> <span class="sect2"> + <a href="sqlrep.html#permmessage">Permanent Message Handling</a> + </span> + </dt> + <dt> + <span class="sect2"> <a href="sqlrep.html#twositerep">Two-Site Replication Groups</a> </span> </dt> @@ -335,7 +373,7 @@ </p> <p> For replicated BDB SQL applications, the durability - guarantee is extended because data modifications are + guarantee is enhanced because data modifications are also replicated to those environments that are participating in the replication group. This ensures higher data durability than non-replicated applications @@ -347,6 +385,71 @@ <div class="titlepage"> <div> <div> + <h3 class="title"><a id="permmessage"></a>Permanent Message Handling</h3> + </div> + </div> + </div> + <p> + Permanent messages are created by replication masters + as a part of a transactional commit operation. When a + replica receives a message that is marked as permanent, + it knows that the message affects transactional + integrity. Receipt of a permanent message means that + the replica must send a message acknowledgment back to + the master server because the master + <span class="emphasis"><em>might be</em></span> waiting for the + acknowledgment before it considers the transaction + commit to be complete. + </p> + <p> + Whether the master is actually waiting for message + acknowledgement depends on the acknowledgement policy + in effect for the replication group. Policies can range + from <code class="literal">NONE</code> (the master will not wait + for any acknowledgements before completing the + transaction) to <code class="literal">ALL</code> (the master will + wait for acknowledgements from all replicas before + completing the transaction). + </p> + <p> + Acknowledgements are only sent back to the master once + the replica has completed applying the message to its + local environment. Therefore, the stronger your + acknowledgement policy, the stronger you durability + guarantee. On the other hand, the stronger your + acknowledgement policy, the slower your application's + write throughput will be. + </p> + <p> + In addition to setting an acknowledgement policy, you + can also set an acknowledgment timeout. This time limit + is set in microseconds and it represents the length of + time the master will wait to satisfy its + acknowledgement policy for each transaction commit. If + this timeout value is not met, the transaction is still + committed locally to the master, but is not yet + considered durable across the replication group. Your + code should take whatever actions are appropriate for + that transaction. If enough other sites are available + to meet the acknowledgement policy, the transaction + will become durable after more time has passed. + </p> + <p> + You set acknowledgement policies and acknowledgement timeouts + using PRAGMAs. See + <a class="xref" href="reppragma.html#pragma_replication_ack_policy" title="PRAGMA replication_ack_policy">PRAGMA replication_ack_policy</a> + and + <a class="xref" href="reppragma.html#pragma_replication_ack_timeout" title="PRAGMA replication_ack_timeout">PRAGMA replication_ack_timeout</a>. + In addition, you can examine how frequently your + transactions do not achieve durability within the + acknowledgement timeout by using + <a class="xref" href="reppragma.html#pragma_replication_perm_failed" title="PRAGMA replication_perm_failed">PRAGMA replication_perm_failed</a>. + </p> + </div> + <div class="sect2" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> <h3 class="title"><a id="twositerep"></a>Two-Site Replication Groups</h3> </div> </div> diff --git a/docs/bdb-sql/statsql.html b/docs/bdb-sql/statsql.html new file mode 100644 index 00000000..b92a2a32 --- /dev/null +++ b/docs/bdb-sql/statsql.html @@ -0,0 +1,80 @@ +<?xml version="1.0" encoding="UTF-8" standalone="no"?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> + <head> + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> + <title>Database Statistics</title> + <link rel="stylesheet" href="gettingStarted.css" type="text/css" /> + <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> + <link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> + <link rel="up" href="admin.html" title="Chapter 5. Administrating Berkeley DB SQL Databases" /> + <link rel="prev" href="recoverysql.html" title="Catastrophic Recovery" /> + <link rel="next" href="verifysql.html" title="Verify Database Structure" /> + </head> + <body> + <div xmlns="" class="navheader"> + <div class="libver"> + <p>Library Version 12.1.6.1</p> + </div> + <table width="100%" summary="Navigation header"> + <tr> + <th colspan="3" align="center">Database Statistics</th> + </tr> + <tr> + <td width="20%" align="left"><a accesskey="p" href="recoverysql.html">Prev</a> </td> + <th width="60%" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th> + <td width="20%" align="right"> <a accesskey="n" href="verifysql.html">Next</a></td> + </tr> + </table> + <hr /> + </div> + <div class="sect1" lang="en" xml:lang="en"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a id="statsql"></a>Database Statistics</h2></div></div></div><p> + The statistics utility can be used to print out information on + tables in a database. A detailed description of the statistics + utility is described at <a href="../api_reference/C/db_stat.html" class="olink">db_stat</a> + . This + section describes how to use the utility with a SQL database. + </p><p> + The first step in getting statistics on a table is to find the + internal name for the table. The internal table name is + <code class="literal">table#####</code>, where the number is the rootpage + number, which can be retrieved using the following SQL statement: + </p><code class="code"> + SELECT rootpage FROM sqlite_master WHERE name='[table name]'; + </code> + For example, if the root page is 10, the internal table name + will be <code class="literal">table00010</code>. + <p> + In order to run the <span class="command"><strong>db_stat</strong></span> utility, + first add a <a href="../programmer_reference/env_db_config.html#env_db_config.DB_CONFIG" class="olink">DB_CONFIG</a> + file to the journal directory. + In the file, add the following line: + </p><code class="code"> + add_data_dir .. + </code><p> + Then execute the following command in the directory + with the database: + <span class="command"><strong>db_stat -d [file name] -h [journal directory] -s [internal table name]</strong></span>. + That command will print out information on the table. + </p></div> + <div class="navfooter"> + <hr /> + <table width="100%" summary="Navigation footer"> + <tr> + <td width="40%" align="left"><a accesskey="p" href="recoverysql.html">Prev</a> </td> + <td width="20%" align="center"> + <a accesskey="u" href="admin.html">Up</a> + </td> + <td width="40%" align="right"> <a accesskey="n" href="verifysql.html">Next</a></td> + </tr> + <tr> + <td width="40%" align="left" valign="top">Catastrophic Recovery </td> + <td width="20%" align="center"> + <a accesskey="h" href="index.html">Home</a> + </td> + <td width="40%" align="right" valign="top"> Verify Database Structure</td> + </tr> + </table> + </div> + </body> +</html> diff --git a/docs/bdb-sql/sync.html b/docs/bdb-sql/sync.html index 7bbd4d85..48e59648 100644 --- a/docs/bdb-sql/sync.html +++ b/docs/bdb-sql/sync.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> @@ -104,8 +104,8 @@ system, you can use the Oracle SQLite Mobile Client in exactly the same way as you would if you were using standard SQLite libraries and databases with it. See the - <a class="ulink" href="http://download.oracle.com/docs/cd/E12095_01/nav/portal_booklist.htm" target="_top"> - Oracle Database Lite + <a class="ulink" href="http://docs.oracle.com/cd/E35865_01/index.htm" target="_top"> + Oracle Database Mobile Server documentation. </a> documentation for information on using SQLite Mobile Client. </p> @@ -147,8 +147,8 @@ you can use the Oracle SQLite Mobile Client in exactly the same way as you would if you were using standard SQLite libraries and databases with it. See the - <a class="ulink" href="http://download.oracle.com/docs/cd/E12095_01/nav/portal_booklist.htm" target="_top"> - Oracle Database Lite </a> documentation for + <a class="ulink" href="http://docs.oracle.com/cd/E35865_01/index.htm" target="_top"> + Oracle Database Mobile Server </a> documentation for information on using SQLite Mobile Client. </p> </div> @@ -180,8 +180,8 @@ you can use the Oracle SQLite Mobile Client in exactly the same way as you would if you were using standard SQLite libraries and databases with it. See the - <a class="ulink" href="http://download.oracle.com/docs/cd/E12095_01/nav/portal_booklist.htm" target="_top"> - Oracle Database Lite </a> documentation for + <a class="ulink" href="http://docs.oracle.com/cd/E35865_01/index.htm" target="_top"> + Oracle Database Mobile Server </a> documentation for information on using SQLite Mobile Client. </p> </div> diff --git a/docs/bdb-sql/unsupportedpragmas.html b/docs/bdb-sql/unsupportedpragmas.html index afb2c513..b892fc60 100644 --- a/docs/bdb-sql/unsupportedpragmas.html +++ b/docs/bdb-sql/unsupportedpragmas.html @@ -14,7 +14,7 @@ <body> <div xmlns="" class="navheader"> <div class="libver"> - <p>Library Version 11.2.5.3</p> + <p>Library Version 12.1.6.1</p> </div> <table width="100%" summary="Navigation header"> <tr> diff --git a/docs/bdb-sql/verifysql.html b/docs/bdb-sql/verifysql.html new file mode 100644 index 00000000..3daf91b4 --- /dev/null +++ b/docs/bdb-sql/verifysql.html @@ -0,0 +1,82 @@ +<?xml version="1.0" encoding="UTF-8" standalone="no"?> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> + <head> + <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> + <title>Verify Database Structure</title> + <link rel="stylesheet" href="gettingStarted.css" type="text/css" /> + <meta name="generator" content="DocBook XSL Stylesheets V1.73.2" /> + <link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" /> + <link rel="up" href="admin.html" title="Chapter 5. Administrating Berkeley DB SQL Databases" /> + <link rel="prev" href="statsql.html" title="Database Statistics" /> + <link rel="next" href="bfile-extension.html" title="Appendix A. Using the BFILE Extension" /> + </head> + <body> + <div xmlns="" class="navheader"> + <div class="libver"> + <p>Library Version 12.1.6.1</p> + </div> + <table width="100%" summary="Navigation header"> + <tr> + <th colspan="3" align="center">Verify Database Structure</th> + </tr> + <tr> + <td width="20%" align="left"><a accesskey="p" href="statsql.html">Prev</a> </td> + <th width="60%" align="center">Chapter 5. Administrating Berkeley DB SQL Databases</th> + <td width="20%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td> + </tr> + </table> + <hr /> + </div> + <div class="sect1" lang="en" xml:lang="en"> + <div class="titlepage"> + <div> + <div> + <h2 class="title" style="clear: both"><a id="verifysql"></a>Verify Database Structure</h2> + </div> + </div> + </div> + <p> + Verification is used to confirm that a database structure is + correct, and has not been corrupted by a crash or other failure. + A detailed description of the verify utility is described at + <a href="../api_reference/C/db_verify.html" class="olink">db_verify</a> + . This + section describes how to use the utility with a SQL database. + </p> + <p> + The first step in running verify is to add a <a href="../programmer_reference/env_db_config.html#env_db_config.DB_CONFIG" class="olink">DB_CONFIG</a> + file + to the journal directory. In the file, add the following line: + </p> + <code class="code"> + add_data_dir .. + </code> + <p> + Then execute the following command in the database directory + <span class="command"><strong>db_verify -h [journal directory] [database file]</strong></span>. + The command will either print out a message reporting success, + or will list any error found in the database. + </p> + </div> + <div class="navfooter"> + <hr /> + <table width="100%" summary="Navigation footer"> + <tr> + <td width="40%" align="left"><a accesskey="p" href="statsql.html">Prev</a> </td> + <td width="20%" align="center"> + <a accesskey="u" href="admin.html">Up</a> + </td> + <td width="40%" align="right"> <a accesskey="n" href="bfile-extension.html">Next</a></td> + </tr> + <tr> + <td width="40%" align="left" valign="top">Database Statistics </td> + <td width="20%" align="center"> + <a accesskey="h" href="index.html">Home</a> + </td> + <td width="40%" align="right" valign="top"> Appendix A. Using the BFILE Extension</td> + </tr> + </table> + </div> + </body> +</html> |