Job Management Partner 1/Performance Management User's Guide

8.2 Overview of partial backups

With Store 2.0, you can partially back up performance data. Partial backup is available only while the Agent Store or Remote Monitor Store service is running. Partial backups allow you to accumulate differential data by specifying a past backup directory as the backup destination.

Organization of this section

(1) Data subject to back up

(2) Effectively using partial backups

(3) Example of performing a partial backup

(1) Data subject to back up

When backing up data, you need to specify the beginning and end of the backup period based on Greenwich Mean Time as a number of days relative to the execution date of the backup command. For example, if you want to perform a partial backup of the performance data from three days prior to the execution date (the backup date) up to the day before the execution date, specify 3 as the start of the backup period and 1 as the end. In this case, the backup operation applies to the data from three days to one day prior to execution of the backup command. When the backup command is executed, the data from the specified backup period is backed up to the backup directory.

Because the PD and PL databases and the per-minute and hourly records in the PI database are stored in multiple files that each contains the performance data for a particular day, the unit databases for the specified dates are backed up. The daily, weekly, monthly, and yearly records in the PI database are included in the backup data even when they contain data from outside the period defined by the specified start and end dates.

(2) Effectively using partial backups

(a) Minimizing duplicate backup data as much as possible

The Store 2.0 database is composed of multiple unit databases each covering a specific time period. Only the most recent unit database is updated. For example, when using unit databases that each contains the performance data for a specific day, the Agent sequentially writes data to the unit database for that day. However, the unit database from the previous day remains unchanged from its status at 23:59 GMT until its retention period expires and the file is deleted. Accordingly, by performing a partial backup of the data from the date when the previous backup was made to the day before the current backup date, you can back up data without acquiring the same day's unit database more than once.

Example: When the previous backup was acquired n days ago

jpctool db backup -id DS1inst1[host1] -d d:\backup01^# -partial (n+1),1

# D:\backup01 indicates the backup directory.

(b) Backing up the most recent data possible

To back up the latest database, use the following command:

Example: Backing up the latest version of the database

jpctool db backup -id DS1inst1[host1] -d d:\backup01^# -partial 0,0

# D:\backup01 indicates the backup directory.

(3) Example of performing a partial backup

The following is an example of performing a partial backup in the JST (Japan Standard Time, GMT + 9:00) time zone.

At 3 AM each day, an overnight batch job is executed that executes the following backup command targeting the instance inst1 of the multi-instance Agent Store and Remote Monitor Store services with the product ID Z.
 
jpctool db backup -id DSinst1[host1] -partial 1,1
 
In this case, the unit database that covers the time that is the same as the backup command execution time on the date in the specified range is backed up. Now, suppose that the backup command is executed at 03:00 on October 15, in a week that begins on October 12.

The command is executed at 03:00 (JST) on October 15.

Taking into account the 9-hour difference, 03:00 JST on October 15 is 18:00 GMT on October 14.

Because the command specifies -partial 1,1 (one day ago), the partial backup applies to the data between 00:00 AM and 23:59 PM (GMT) on October 13.

Again, taking into account the 9-hour difference, the backup range from 00:00 GMT to 23:59 GMT on October 13 is from 09:00 JST on October 13 to 09:00 JST on October 14.

Therefore, in the case of per-minute records, the data from 09:00 on October 13 until 09:00 on October 14 JST is backed up. If the backup command is executed again at the same time on the following day, you can start backing up from where you stopped on the previous day. The following figure shows the backup range for per-minute records.

Figure 8-1 Backup range for per-minute records

In the case of weekly records, because the unit database that covers the specified period is backed up, this results in the data from 09:00 on October 12 to 03:00 on October 15, including the latest data, being backed up. If the backup command is executed again at the same time on the following day, all of the data from the beginning of the week (October 12) onward is backed up again. The following figure shows the backup range for weekly records.

Figure 8-2 Backup range for weekly records

[Contents][Back][Next]

[Trademarks]