|
|
|
The dump dxgrid-db command takes a consistent snapshot copy of the datastore of a running DSA (an online dump). The file that is written represents the contents of the datastore when the dump started. Updates may proceed while the dump is in progress but they will not appear in the dump file.
The datastore file is copied to a file with the extension .zdb.
Note: Each dump overwrites the previous backup file. Create a cron job on UNIX or a scheduled task on Windows to copy the backed up file to a safe location before the next dump.
The DXdumpdb tool can export data from a datastore created by the dump command.
The command has the following format:
dump dxgrid-db [period start period];
(Optional) Specifies that the online dump is performed at regular intervals.
Defines the number of seconds from Sunday 00:00:00 a.m. GMT.
Note: The start time is defined using GMT and not your local time.
Defines the number of seconds between online dumps.
Note: The start time is relative to the period and should be lower than it. If you specify a start time that is greater than the period, the actual start is start - period. For example, if the period is 3600 seconds (one hour) and start is 3610 seconds, the online dump starts 10 seconds from midnight GMT and continues every hour from then on.
Example: Perform an Online Dump Every Hour
The following command takes a snapshot copy of the datastore every hour:
dump dxgrid-db period 0 3600
Example: Perform an Online Dump Every Night
The following command takes a snapshot copy of the datastore every night at 3 a.m. in a GMT+10:00 time zone:
dump dxgrid-db period 61200 86400
In this example, the start time is the number of seconds from Sunday midnight GMT to the first 3 a.m. slot, corrected by the time zone value, as follows:
(3 am - 10 time zone + 24 hours) * 60 minutes * 60 seconds = 61,200
The 24 hour period is calculated as follows:
24 hours * 60 minutes * 60 seconds = 86,400
| Copyright © 2011 CA. All rights reserved. | Email CA Technologies about this topic |