|
Hi Eric,
Thanks for volunteering to document the online backup feature. You are right, Server Admin Guide and Reference Guide has to be updated with the above information. In addition to what you already mentioned, I think following information also should be added: Server Guide : 1) in Section : Using the backup procedure to perform an online backup (SYSCS_UTIL.SYSCS_BACKUP_DATABASE ..topic) SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedures will throw error, if there are any unlogged operations already executed in the same transaction as backup procedure. If there are any unlogged operations in progress in other transactions in the system when backup starts, this procedures will block until those transactions are completed before performing the backup. Derby automatically converts unlogged operations to logged mode if they are started when the backup is in progress except operations that are used to maintain application jar files in the database. Procedures to install, replace, and remove jar files in a database are blocked when the backup is in progress. If you don't want backup to block for unlogged operation in other transactions to complete, use SYSCS_UTIL.SYSCS_BACKUP_DATABASE_NOWAIT procedure. This procedure will return error immediately if there are any transactions in progress with unlogged operations at the start of the backup instead of waiting for those transactions to complete. 2) Same information as above should be added to Rollforward Recovery Section also. (SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE topic). Info is same as above(1) , except procedure names will be SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE and SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT 3) Any mention of update operations not possible should be removed except when it is mentioned in the context of using SYSCS_UTIL.SYSCS_FREEZE_DATABASE procedure. 4) In the freeze procedure section following sentence should be changed. Current sentence: "For example, because the UNIX tar command uses operating system file-copying routines, and Derby uses the IBM Application Developer Kit file-copying routines, the tar command might provide faster backups than the SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure. " replace it with something like: "For example, because the UNIX tar command uses operating system file-copying routines, and SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure uses java I/O calls with additional internal synchronization to allow updates during the backup, the tar command might provide faster backups than the SYSCS_UTIL.SYSCS_BACKUP_DATABASE procedure. " Reference Guide: 1) Following two new procedures needs to be added to the Reference Guide: --SYSC_UTIL.SYSCS_ONLINE_BACKUP_DATABASE_NOWAIT and --SYSC_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT 2) While scanning throws the docs, I also noticed Following two procedures are missing in 10.0 and 10.1 docs in the reference manual , I think they need to be added too. SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE (IN BACKUPDIR VARCHAR(32672), IN SMALLINT DELETE_ARCHIVED_LOG_FILES) SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE(IN SMALLINT DELETE_ARCHIVED_LOG_FILES) Thanks -suresht This patch addresses the changes to online backups. It adds the following four new topics to the Reference Guide:
SYSCS_UTIL.SYSCS_ONLINE_BACKUP_DATABASE_NOWAIT SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT SYSCS_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE And affects five files in the Server and Admin Guide. The HTML files are included for review. Can somebody take a look at the doc patch for this issue?
Thanks very much for documenting online backup. changes looks good except for one minor error in
SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE doc. rrefdiableprog.html: small correction needed SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE: 1) procedure description is not clear: current decription : The SYSCS_UTIL.SYSCS_DISABLE_LOG_ARCHIVE_MODE system procedure disables log archive mode for the database. should be changed to: " This system procedure disables the log archive mode and deletes any existing online archived log files if the input parameter DELETE_ARCHIVED_LOG_FILES is non-zero. " 2) DELETE_ARCHIVED_LOG_FILES argument explanation is incorrect: Current description: If the input parameter value for the DELETE_ARCHIVED_LOG_FILES parameter is a non-zero value, online archived log files that were created before this backup will be deleted. The log files are deleted only after a successful backup. The correct one should be : " If the input parameter value for the DELETE_ARCHIVED_LOG_FILES parameter is a non-zero value then all existing online archived log files are deleted. If the value is zero then exiting online archived log files files are not deleted. ' Thanks -suresh I went ahead and made these final minor changes to the patch because it was so close to commit. The derby916-2.diff is the new patch file, and contains the latest comments from Suresh. The derby916-2html.zip file contains new html ouput files for review. Thanks!
Thanks for making the changes Jeff. It looks good.
+1 -suresht Can a committer please commit this? It looks like there are no objections to the latest patch. Thanks Suresh!
Hi Jeff, committed this yesterday, forgot to mark resolved. Committed, revision 384085.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
 |
|
Sub-task
Closed
Major
Reference Guide:
Add the following two new stored procedures:
--SYSC_UTIL.SYSCS_ONLINE_BACKUP_DATABASE_NOWAIT and
--SYSC_UTIL.SYSCS_BACKUP_DATABASE_AND_ENABLE_LOG_ARCHIVE_MODE_NOWAIT
Also, it doesn't look like there are any changes to the SYSCS_UTIL.SYSCS_BACKUP_DATABASE topic. Is that correct?
Server and Admin Guide:
--Remove references to update operations not being possible during a backup (there are a lot of these)
--Add topic about performing an online backup in which unlogged operations immediately return an error.
Anything else?