How To Backup Db2 Database In Windows
You lot can utilise the List UTILITIES command to monitor backup, restore, and rollforward operations on a database. Result the List UTILITIES command and specify the Evidence Particular pick.
db2 list utilities show detail ID = 6 Type = Fill-in Database Name = ITSITI Partition Number = 0 Description = online db Outset Time = 15/04/2011 xi:fifteen:22.756644 Land = Executing Invocation Type = User Throttling: Priority = Unthrottled Progress Monitoring: Estimated Percentage Consummate = 15 Total Piece of work = 65465345 bytes Completed Work = 46546546 bytes Start Time = 15/04/2011 11:00:00.756644
Backup Functioning
Initial estimate of the number of bytes to be processed volition be specified. As the fill-in functioning progresses the number of bytes to be processed will be updated. The bytes shown does non correspond to the size of the image and should not exist used as an gauge for backup image size. The actual paradigm might be much smaller depending on whether it is an incremental or compressed fill-in.
Restore performance
No initial estimate will exist given. Instead UNKNOWN will be specified. As each buffer is read from the image, the actual amount of bytes read volition be updated. For automatic incremental restore operations where multiple images might be restored, the progress will exist tracked using phases. Each phase represents an image to exist restored from the incremental chain. Initially, only i phase will be indicated. Afterward the first epitome is restored, the total number of phases will be indicated. Every bit each image is restored the number of phases completed will exist updated, as will the number of bytes processed.
Crash Recovery & Rollforward Recovery
There will be ii phases of progress monitoring: FORWARD and BACKWARD. During the Forwards phase, log files are read and the log records are applied to the database. For crash recovery, the total amount of work is estimated using the starting log sequence number upwards to the terminate of the last log file. For rollforward recovery, when this phase begins UNKNOWN will be specified for the total work estimate. The amount of work processed in bytes will be updated equally the process continues.During the BACKWARD phase, whatsoever uncommitted changes applied during the FORWARD phase are rolled back. An estimate for the amount of log data to be processed in bytes will be provided. The corporeality of work processed in bytes volition be updated as the procedure continues.
Source: https://itsiti.com/db2-backup-restore-recovery-operations-monitoring/
Posted by: ottopairofterl.blogspot.com
0 Response to "How To Backup Db2 Database In Windows"
Post a Comment