Name
nbdb2adutl — used to query or extract DB2 archive logs from the NetBackup catalog.
SYNOPSIS
nbdb2adutl query logs db database_name [inst instance_name] [between sn1 and sn2] [chain n | all] [partition n | all] [browse_client client_name]
nbdb2adutl extract logs db database_name [inst instance_name] [between sn1 and sn2] [chain n | all] [partition n | all] [browse_client client_name]
On UNIX systems, the directory path to this command is /usr/openv/netbackup/bin/
On Windows systems, the directory path to this command is install_path\NetBackup\bin\
DESCRIPTION
Use the nbdb2adutl command to interact with the DB2 archive logs found in the NetBackup catalog.
When you use the query option, the command queries the NetBackup catalog for DB2 archive log backups. The inst option is only required when the instance name (DB2INSTANCE) is not found in the environment.
When you use the extract option, the command restores DB2 archive logs from NetBackup to the user's current working directory. Existing log files are not overwritten. For this reason, be careful when you use all with either partition or chain. The inst option is only required when the instance name (DB2INSTANCE) is not found in the environment.
By default, the original user who backed up the archive logs or any user from the same group has access to the archive log backups. Permissions are set at backup time using the BKUP_IMAGE_PERM option. See the NetBackup for DB2 Administrator's Guide for more information.
OPTIONS
- between sn1 and sn2
Identifies the range of archive log sequence numbers. The specified sequence numbers are inclusive in the range. If the option is omitted, all sequence numbers that meet the specified criteria are returned.
- browse_client client_name
Identifies the name of the client where the backups were performed. Used for alternate client restores. Master server must be configured for alternate client restore. i.e altnames, etc. If not specified, the browse client is determined from the
bp.conf.- chain n | all
Identifies the archive log chain number. Use all to indicate that you want all chain numbers included. The default value is 0.
- db database_name
Name of the database.
- extract
Identifies that a restore operation is to be performed.
- inst instance_name
Name of the instance. The option is required if the name of the instance cannot be obtained from the DB2INSTANCE environment value.
- logs
Identifies that the DB2 archive logs are the object.
- partition n | all
Identifies the DB2 database partition. Use all to specify all partition numbers. The default is 0.
- query
Used to search the NetBackup catalog for DB2 archive log backups.
EXAMPLES
Example 1: Query all the logs for a database named sample where the instance is prod, the partition is 0, and the chain is 0.
nbdb2adutl query logs db sample inst prod
Example 2: Query log sequence numbers 5 to 10 for the sample database, where the instance is prod, the partition is 0 and the chain is 0. Instance prod is found in the environment.
nbdb2adutl query logs db sample between 5 and 10
Example 3: Restore log sequence numbers 5 to 10 for the sample database, where the instance is prod, the partition is 0, and the chain is 0.
nbdb2adutl extract logs db sample inst prod between 5 and 10
Example 4: Alternate client restore log sequence number 5 to 10 for the sample database from the production server prodbox.sample.com, where instance is prod, the partition is 0, and chain is 0.
nbdb2adutl extract logs db sample inst prod between 5 and 10 browse_client prodbox.sample.com
SEE ALSO
See bplist.