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.