db2acsutil - Manage Db2 snapshot backup objects command
Lists, deletes, and monitors Db2 snapshot backup objects.
You can use db2acsutil to manage Db2 snapshot
backup objects in the following three ways:
- List the Db2 snapshot backups that you can use to restore your database
- Delete Db2 snapshot backups that were generated using the BACKUP command, the db2Backup API, or the ADMIN_CMD stored procedure with the BACKUP DATABASE parameter
- Monitor the status of Db2 snapshot backups
Note: db2acsutil is not supported on objects created in a higher Db2 Version
release.
Authorization
NoneRequired connection
NoneCommand syntax
Command parameters
- load libraryName
- The name of the shared library containing the vendor fast copying technology used in the Db2 snapshot backup. This parameter can contain the full path. If the full path is not given, the default path is the same library as with the BACKUP DATABASE and RESTORE DATABASE commands (in ~/sqllib/acs).
- script scriptName
- The fully qualified name of the script that created the snapshot objects.
- options "optionsString"
- Specifies options to be used for this utility. The string will be passed to the vendor support library exactly as it was entered, without the double quotation marks.
- query
- Queries the Db2 ACS
repository and returns a table of known objects.
- status
- Queries the Db2 ACS repository and returns a table of known objects with their current status.
- delete
- This deletes Db2 snapshot objects, and removes their record from the Db2 ACS repository after they have been deleted.
- snapshot
- Filters the records returned or operated on to only snapshot objects.
- taken at | older than | since
- These options filter the results of the utility to the specified
time ranges.
- timestamp
- A timestamp of the form
YYYYMMDDhhmmss
. - N days ago
- Number of days ago, where N is the number of days before the current date.
- [not] newest X
- Filter the utility results such that only the newest (by timestamp) X records are considered. If the NOT keyword is specified, then all records except the newest X are considered.
- database | db dbName
- Considers only those objects associated with the specified database name.
- instance instanceName
- The name of the database manager instance associated with the Db2 snapshot backup objects you are managing.
- dbpartitionnum db-partition-number
- Considers only those objects created by the specified database partition number.
- host hostname
- Considers only those objects created by the specified hostname. For example, this would typically be the TCP/IP hostname of the Db2 server.
- show details
- Displays detailed object information from the Db2 ACS repository. If this option is used, instead of a table with a single brief record per line, a detailed stanza will be produced for each Db2 ACS object.
- without prompting
- Specifies that the utility will run unattended, and that any actions which normally require user intervention will return an error message.
Examples
Sample output for a snapshot backup
with an active background copy.
db2acsutil query status db f01 instance db2inst1 dbpartitionnum 0
Instance Database Part Image Time Status
========== ========== ==== ============== =======================================
keon14 F01 0 20070719120848 Remotely mountable + Background_monitor
pending (16 / 1024 MB)
Sample output for a snapshot backup with a completed background
copy.
db2acsutil query status db f01 instance db2inst1 dbpartitionnum 0 show details
Instance : keon14
Database : F01
Partition : 0
Image timestamp : 20070719120848
Host : machine1
Owner :
Db2 Version : 9.5.0
Creation time : Thu Jul 19 12:08:50 2007
First active log (chain:file) : 0:0
Metadata bytes : 6196
Progress state : Successful
Usability state : Remotely mountable + Repetitively restorable + Swap restorable
+ Physical protection + Full copy
Bytes completed : 0
Bytes total : 0
Usage notes
Using db2acsutil is the only way to delete Db2 snapshot backups created using the BACKUP command, the db2Backup API, or the ADMIN_CMD stored procedure with the BACKUP DATABASE parameter. You cannot use automated recovery object deletion or the PRUNE HISTORY command with the AND DELETE parameter to delete Db2 snapshot backups. You also cannot delete backups manually though the filer/storage system.
The usability state of a Db2 snapshot
backup indicates what you can do with the Db2 snapshot.
Table 1 lists
and describes possible Db2 snapshot
backup usability states.
Note: If you query a snapshot backup taken with a
custom script, the usability state is always returned as Unknown
because the usability of the image is dependent on the quality of the script.
Usability state | Description |
---|---|
LOCALLY_MOUNTABLE | You can mount the backed up data from the local machine. |
REMOTELY_MOUNTABLE | You can mount the backed up data from a remote machine. |
REPETITIVELY_RESTORABLE | You can use the Db2 snapshot backup image multiple times to restore your backed up data. |
DESTRUCTIVELY_RESTORABLE | You can use the Db2 snapshot backup image to restore your backed up data once; after the backed up data is restored, this Db2 snapshot image, and potentially others, are destroyed. |
SWAP_RESTORABLE | You can access the volumes directly, but a RESTORE DB command cannot be executed and the backed up data cannot be copied back onto the source volumes. |
PHYSICAL_PROTECTION | The snapshot is protected against physical failures in the source volumes. |
FULL_COPY | A full copy of the data has been created. You can use the Db2 snapshot backup image to restore the backed up data. |
DELETED | Indicates that a backup has been marked for deletion. The snapshot storage associated with a DELETED backup will be withdrawn via a maintenance process running in the background. Once this has completed, the backup will be removed from the Db2 ACS repository. |
FORCED_MOUNT | Awaiting verification of filesystem consistency by mounting an AIX® JFS filesystem. |
BACKGROUND_MONITOR_PENDING | Status is being monitored by the Db2 ACS background progress monitor. |
TAPE_BACKUP_PENDING | Awaiting an offloaded tape backup. |
TAPE_BACKUP_IN_PROGRESS | An offloaded tape backup is currently in progress. |
TAPE_BACKUP_COMPLETE | Offloaded tape backup has completed. |