Return-Path:
Delivered-To: apmail-db-derby-commits-archive@www.apache.org
Received: (qmail 97877 invoked from network); 11 Feb 2008 12:41:19 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
by minotaur.apache.org with SMTP; 11 Feb 2008 12:41:19 -0000
Received: (qmail 9264 invoked by uid 500); 11 Feb 2008 12:41:12 -0000
Delivered-To: apmail-db-derby-commits-archive@db.apache.org
Received: (qmail 9238 invoked by uid 500); 11 Feb 2008 12:41:12 -0000
Mailing-List: contact derby-commits-help@db.apache.org; run by ezmlm
Precedence: bulk
list-help:
list-unsubscribe:
List-Post:
Reply-To: "Derby Development"
List-Id:
Delivered-To: mailing list derby-commits@db.apache.org
Received: (qmail 9217 invoked by uid 99); 11 Feb 2008 12:41:12 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Feb 2008 04:41:12 -0800
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.3] (HELO eris.apache.org) (140.211.11.3)
by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Feb 2008 12:40:50 +0000
Received: by eris.apache.org (Postfix, from userid 65534)
id B5B6F1A9832; Mon, 11 Feb 2008 04:40:57 -0800 (PST)
Content-Type: text/plain; charset="utf-8"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Subject: svn commit: r620473 - in /db/derby/docs/trunk/src/adminguide:
cadminhubbkup01.dita cadminhubbkup63476.dita
Date: Mon, 11 Feb 2008 12:40:57 -0000
To: derby-commits@db.apache.org
From: dyre@apache.org
X-Mailer: svnmailer-1.0.8
Message-Id: <20080211124057.B5B6F1A9832@eris.apache.org>
X-Virus-Checked: Checked by ClamAV on apache.org
Author: dyre
Date: Mon Feb 11 04:40:54 2008
New Revision: 620473
URL: http://svn.apache.org/viewvc?rev=620473&view=rev
Log:
DERBY-2969: Admin Guide: Document that online backup is non-blocking
Patch contributed by Kim Haase
Patch file: DERBY-2969-2.diff
Modified:
db/derby/docs/trunk/src/adminguide/cadminhubbkup01.dita
db/derby/docs/trunk/src/adminguide/cadminhubbkup63476.dita
Modified: db/derby/docs/trunk/src/adminguide/cadminhubbkup01.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminhubbkup01.dita?rev=620473&r1=620472&r2=620473&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminhubbkup01.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminhubbkup01.dita Mon Feb 11 04:40:54 2008
@@ -35,11 +35,14 @@
a database that is currently open, use the following statement (forward slashes
are used as path separators in SQL commands):
CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE('c:/mybackups/2005-06-01')
-The SYSCS_UTIL.SYSCS_BACKUP_DATABASE() procedure puts the database
-into a state in which it can be safely copied, then copies the entire original
-database directory (including data files, online transaction log files, and
-jar files) to the specified backup directory. Files that are not within the
-original database directory (for example, derby.properties) are not copied.
+The SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure puts the database
+into a state in which it can be safely copied. The procedure then copies the
+entire original database directory (including data files, online transaction log
+files, and jar files) to the specified backup directory. Files that are not
+within the original database directory (for example, derby.properties)
+are not copied. With the exception of a few cases mentioned in
+,
+the procedure does not block concurrent transactions at any time.
The following example shows how to back up a database to a directory with
a name that reflects the current date:
public static void backUpDatabase(Connection conn)throws SQLException
@@ -47,7 +50,7 @@
// Get today's date as a string:
java.text.SimpleDateFormat todaysDate =
new java.text.SimpleDateFormat("yyyy-MM-dd");
-String backupdirectory = "c:/mybacksup/" +
+String backupdirectory = "c:/mybackups/" +
todaysDate.format((java.util.Calendar.getInstance()).getTime());
CallableStatement cs = conn.prepareCall("CALL SYSCS_UTIL.SYSCS_BACKUP_DATABASE(?)");
@@ -62,7 +65,7 @@
Do not back up different databases with the same name to the same backup
directory. If a database of the same name already exists in the backup directory,
it is assumed to be an older version and is overwritten.
-Unlogged Operations
+Unlogged Operations
For some operations, Derby does not log because it can keep the database
consistent without logging the data.
Modified: db/derby/docs/trunk/src/adminguide/cadminhubbkup63476.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/adminguide/cadminhubbkup63476.dita?rev=620473&r1=620472&r2=620473&view=diff
==============================================================================
--- db/derby/docs/trunk/src/adminguide/cadminhubbkup63476.dita (original)
+++ db/derby/docs/trunk/src/adminguide/cadminhubbkup63476.dita Mon Feb 11 04:40:54 2008
@@ -22,7 +22,8 @@
Online backups
-Use online backups to back up a database while it is running.
+Use online backups to back up a database while it is running, without
+blocking transactions.
You can perform online backups by using several types of backup procedures
or by using operating systems commands with the freeze and unfreeze system
procedures.