Command Reference

db2adutl - Work with TSM Archived Images

Allows users to query, extract, verify, and delete backups, logs, and load copy images saved using Tivoli Storage Manager (formerly ADSM).

On UNIX based systems, this utility is located in the INSTHOME/sqllib/misc directory and on OS/2 and Windows operating systems it is located in the \sqllib\misc directory.

For more information about this command, see the Administration Guide.

Authorization

None

Required Connection

None

Command Syntax

>>-db2adutl----------------------------------------------------->
 
>-----+-QUERY--+-------------------------------------+-----------------------------+>
      |        +-+------------+---+---------------+--+                             |
      |        | +-TABLESPACE-+   '-SHOW INACTIVE-'  |                             |
      |        | +-FULL-------+                      |                             |
      |        | '-LOADCOPY---'                      |                             |
      |        '-LOGS--+---------------------+-------'                             |
      |                '-BETWEEN sn1 AND sn2-'                                     |
      +-EXTRACT--+--------------------------------------------------------------+--+
      |          +-+------------+--+---------------+----+---------------------+-+  |
      |          | +-TABLESPACE-+  '-SHOW INACTIVE-'    '-TAKEN AT-timestamp--' |  |
      |          | +-FULL-------+                                               |  |
      |          | '-LOADCOPY---'                                               |  |
      |          '-LOGS--+----------------------+-------------------------------'  |
      |                  '-BETWEEN sn1 AND sn2--'                                  |
      +-DELETE--+-------------------------------------------------------+----------+
      |         +-+------------+---+----------------------------------+-+          |
      |         | +-TABLESPACE-+   +-KEEP--n--------------------------+ |          |
      |         | +-FULL-------+   +-OLDER--+-------+---+-timestamp-+-+ |          |
      |         | '-LOADCOPY---'   |        '-THAN--'   '-n--days---' | |          |
      |         |                  '-TAKEN AT--timestamp--------------' |          |
      |         '-LOGS--+-------------------------+---------------------'          |
      |                 '-BETWEEN--sn1--AND--sn2--'                                |
      '-VERIFY--+----------------------------------------------------------------+-'
                +-+------------+---+----------------+---+----------------------+-+
                | +-TABLESPACE-+   '-SHOW INACTIVE--'   '-TAKEN AT--timestamp--' |
                | '-FULL-------'                                                 |
                '-LOGS--+----------------------+---------------------------------'
                        '-BETWEEN sn1 AND sn2--'
 
>-----+--------------------------------+------------------------>
      '--+-DATABASE-+--database_name---'
         '-DB-------'
 
>-----+--------------------+---+---------------------+---------->
      '-NODE--node_number--'   '-PASSWORD--password--'
 
>-----+----------------------+---+--------------------+--------->
      '-NODENAME--node_name--'   '-WITHOUT PROMPTING--'
 
>-----+---------------+----------------------------------------><
      '-OWNER--owner--'

Command Parameters

QUERY

Queries the TSM server for DB2 objects.

EXTRACT

Copies DB2 objects from the TSM server to the current directory on the local machine.

DELETE

Either deactivates backup objects or deletes log archives on the TSM server.

VERIFY

Performs consistency checking on the backup copy that is on the server.

Note:

This parameter causes the entire backup image to be transferred over the network.

TABLESPACE

Includes only table space backup images.

FULL

Includes only full database backup images.

LOADCOPY

Includes only load copy images.

LOGS

Includes only log archive images

BETWEEN sn1 AND sn2

Specifies that the logs between log sequence number 1 and log sequence number 2 are to be used.

SHOW INACTIVE

Includes backup objects that have been deactivated.

TAKEN AT timestamp

Specifies a backup image by its time stamp.

KEEP n

Deactivates all objects of the specified type except for the most recent n by time stamp.

OLDER THAN timestamp or n days

Specifies that objects with a time stamp earlier than timestamp or n days will be deactivated.

DATABASE database_name

Considers only those objects associated with the specified database name.

NODE node_number

Considers only those objects created by the specified node number.

PASSWORD password

Specifies the TSM client password for this node, if required. If a database is specified and the password is not provided, the value specified for the tsm_password database configuration parameter is passed to TSM; otherwise, no password is used.

NODENAME node_name

Considers only those images associated with a specific TSM node name.

WITHOUT PROMPTING

The user is not prompted for verification before objects are deleted.

OWNER owner

Considers only those objects created by the specified owner.

Examples

The following is sample output from:db2 backup database rawsampl use tsm

  Backup successful. The timestamp for this backup is : 19970929130942
  
  db2adutl query
 
  Query for database RAWSAMPL
 
  Retrieving full database backup information.
     full database backup image: 1, Time: 19970929130942, 
                                    Oldest log: S0000053.LOG, Sessions used: 1
     full database backup image: 2, Time: 19970929142241, 
                                    Oldest log: S0000054.LOG, Sessions used: 1
 
  Retrieving table space backup information.
     table space backup image: 1, Time: 19970929094003, 
                                  Oldest log: S0000051.LOG, Sessions used: 1
     table space backup image: 2, Time: 19970929093043, 
                                  Oldest log: S0000050.LOG, Sessions used: 1
     table space backup image: 3, Time: 19970929105905, 
                                  Oldest log: S0000052.LOG, Sessions used: 1
 
  Retrieving log archive information.
     Log file: S0000050.LOG
     Log file: S0000051.LOG
     Log file: S0000052.LOG
     Log file: S0000053.LOG
     Log file: S0000054.LOG
     Log file: S0000055.LOG

The following is sample output from:db2adutl delete full taken at 19950929130942 db rawsampl

  Query for database RAWSAMPL
 
  Retrieving full database backup information.  Please wait.
 
    full database backup image: RAWSAMPL.0.db26000.0.19970929130942.001
 
    Do you want to deactivate this backup image (Y/N)? y
 
      Are you sure (Y/N)? y
 
  db2adutl query
 
  Query for database RAWSAMPL
 
  Retrieving full database backup information.
     full database backup image: 2, Time: 19950929142241, 
                              Oldest log: S0000054.LOG, Sessions used: 1
 
  Retrieving table space backup information.
     table space backup image: 1, Time: 19950929094003, 
                            Oldest log: S0000051.LOG, Sessions used: 1
     table space backup image: 2, Time: 19950929093043, 
                            Oldest log: S0000050.LOG, Sessions used: 1
     table space backup image: 3, Time: 19950929105905, 
                            Oldest log: S0000052.LOG, Sessions used: 1
 
  Retrieving log archive information.
     Log file: S0000050.LOG
     Log file: S0000051.LOG
     Log file: S0000052.LOG
     Log file: S0000053.LOG
     Log file: S0000054.LOG
     Log file: S0000055.LOG

[ Top of Page | Previous Page | Next Page ]