Allows you to query, extract, verify, and delete backup images, logs, and load copy images that are saved using Tivoli® Storage Manager (TSM). You can also use db2adutl to upload backup images and archived log files currently stored on disk to TSM. As well, you can use db2adutl to grant and revoke access to objects on a TSM server.
On UNIX operating systems, this utility is located in the sqllib/adsm directory. On Windows operating systems, it is located in sqllib\bin.
None
None
>>-db2adutl--+-| db2-object-options |-----+-------------------->< '-| access-control-options |-' db2-object-options |--+-| QUERY-options |---+--------------------------------------> +-| EXTRACT-options |-+ +-| UPLOAD-options |--+ +-| DELETE-options |--+ '-| VERIFY-options |--' >--+---------------------------------+--------------------------> '-COMPRLIB--decompression-library-' >--+----------------------------------+--+---------+------------> '-COMPROPTS--decompression-options-' '-VERBOSE-' >--+-----------------------------+------------------------------> '-+-DATABASE-+--database_name-' '-DB-------' >--+-------------------------------------+----------------------> '-DBPARTITIONNUM--db-partition-number-' >--+----------------------+--+--------------------+-------------> '-OPTIONS--tsm_options-' '-PASSWORD--password-' >--+---------------------+--+-----------------------------+-----> '-NODENAME--node_name-' '-MGMTCLASS -management-class-' >--+--------------+--+-------------------+----------------------| '-OWNER--owner-' '-WITHOUT PROMPTING-' QUERY-options |--QUERY--------------------------------------------------------> >--+-----------------------------------------------------------+--| +-+-+------------+--+----------------+-+--+---------------+-+ | | +-TABLESPACE-+ +-NONINCREMENTAL-+ | '-SHOW INACTIVE-' | | | '-FULL-------' +-INCREMENTAL----+ | | | | '-DELTA----------' | | | '-LOADCOPY---------------------------' | '-LOGS--+----------------------------+--+----------+--------' '-+-BETWEEN--sn1--AND--sn2-+-' '-CHAIN--n-' +-SINCE--sn1-------------+ '-OLDER THAN--sn1--------' EXTRACT-options |--EXTRACT------------------------------------------------------> >--+------------------------------------------------------------------------------------------------+--| +-+-+------------+--+----------------+-+--+---------------+--+--------+--+---------------------+-+ | | +-TABLESPACE-+ +-NONINCREMENTAL-+ | '-SHOW INACTIVE-' '-SUBSET-' '-TAKEN AT--timestamp-' | | | '-FULL-------' +-INCREMENTAL----+ | | | | '-DELTA----------' | | | '-LOADCOPY---------------------------' | '-LOGS--+----------------------------+--+----------+---------------------------------------------' '-+-BETWEEN--sn1--AND--sn2-+-' '-CHAIN--n-' '-SINCE--sn1-------------' UPLOAD-options |--UPLOAD--+------------+---------------------------------------> '-AND REMOVE-' >--+-------------------------------------+----------------------> '-IMAGES--+-------------------------+-' +-+-TAKEN AT--timestamp-+-+ | '-WITH LOGS-----------' | '-filename----------------' >--+----------------------------------------------------------------------------+--> '-LOGS--+------------------------+--+----------+--+------------------------+-' +-BETWEEN--sn1--AND--sn2-+ '-CHAIN--n-' | .-LOGARCHMETH1-. | '-OLDER THAN--sn1--------' '-FROM--+-LOGARCHMETH2-+-' >--+----------------------+--+-----------------------+----------> '-MGMTCLASS--mgmtclass-' '-DB2USER--db2_username-' >--+---------------------------+--------------------------------| '-DB2PASSWORD--db2_password-' DELETE-options |--DELETE-------------------------------------------------------> >--+----------------------------------------------------------------------------+--| +-+-+------------+--+----------------+-+--+--------------------------------+-+ | | +-TABLESPACE-+ +-NONINCREMENTAL-+ | +-KEEP--n------------------------+ | | | '-FULL-------' +-INCREMENTAL----+ | +-OLDER--+------+--+-timestamp-+-+ | | | '-DELTA----------' | | '-THAN-' '-n--days---' | | | '-LOADCOPY---------------------------' '-TAKEN AT--timestamp------------' | '-LOGS--+----------------------------+--+----------+-------------------------' '-+-BETWEEN--sn1--AND--sn2-+-' '-CHAIN--n-' '-OLDER THAN--sn1--------' VERIFY-options |--VERIFY-------------------------------------------------------> >--+--------------------------------------------------------------------------------------------------------+--| '-| verify-options |--+-+------------+--+----------------+-+--+---------------+--+---------------------+-' | +-TABLESPACE-+ +-NONINCREMENTAL-+ | '-SHOW INACTIVE-' '-TAKEN AT--timestamp-' | '-FULL-------' +-INCREMENTAL----+ | | '-DELTA----------' | '-LOADCOPY---------------------------' verify-options |--+-ALL-------------+------------------------------------------| +-CHECK-----------+ +-DMS-------------+ +-HEADER----------+ +-LFH-------------+ +-TABLESPACES-----+ +-SGF-------------+ +-HEADERONLY------+ +-TABLESPACESONLY-+ +-SGFONLY---------+ +-OBJECT----------+ '-PAGECOUNT-------' access-control-options |--+------------------------------------------------------------------------------------------------+--> +-GRANT--+-ALL-------------+--ON--+-ALL-----------------+--FOR--+-DATABASE-+--database_name------+ | '-USER--user_name-' '-NODENAME--node_name-' '-DB-------' | +-REVOKE--+-ALL-------------+--ON--+-ALL-----------------+--FOR--+-ALL-------------------------+-+ | '-USER--user_name-' '-NODENAME--node_name-' '-+-DATABASE-+--database_name-' | | '-DB-------' | '-QUERYACCESS--FOR--+-ALL-------------------------+----------------------------------------------' '-+-DATABASE-+--database_name-' '-DB-------' >--+--------------------+---------------------------------------| '-PASSWORD--password-'
S <tbspID> <objID> <objType> <startPage> <numPages>
D <tbspID> <objType> <startPage> <numPages>
L <log num> <startPos> <numPages>
For other data (for example, initial data): O <objType> <startPos> <numBytes>
The default output file is extractPage.out. You can override the default output file name by setting the DB2EXTRACTFILE environment variable to a full path.
Backup successful. The timestamp for this backup is : 20031209184503
The
following is sample output from the command db2adutl query
issued following the backup operation: Query for database RAWSAMPL
Retrieving FULL DATABASE BACKUP information.
1 Time: 20031209184403, Oldest log: S0000050.LOG, Sessions: 1
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for RAWSAMPL
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for RAWSAMPL
Retrieving TABLESPACE BACKUP information.
No TABLESPACE BACKUP images found for RAWSAMPL
Retrieving INCREMENTAL TABLESPACE BACKUP information.
No INCREMENTAL TABLESPACE BACKUP images found for RAWSAMPL
Retrieving DELTA TABLESPACE BACKUP information.
No DELTA TABLESPACE BACKUP images found for RAWSAMPL
Retrieving LOCAL COPY information.
No LOCAL COPY images found for RAWSAMPL
Retrieving log archive information.
Log file: S0000050.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.46.13
Log file: S0000051.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.46.43
Log file: S0000052.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.47.12
Log file: S0000053.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.50.14
Log file: S0000054.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.50.56
Log file: S0000055.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.52.39
Query for database RAWSAMPL
Retrieving FULL DATABASE BACKUP information.
Taken at: 20031209184503 DB Partition Number: 0 Sessions: 1
Do you want to delete this file (Y/N)? y
Are you sure (Y/N)? y
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for RAWSAMPL
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for RAWSAMPL
The
following is sample output from the command db2adutl query
issued following the operation that deleted the full backup image.
Note the timestamp for the backup image.
Query for database RAWSAMPL
Retrieving FULL DATABASE BACKUP information.
1 Time: 20031209184403, Oldest log: S0000050.LOG, Sessions: 1
Retrieving INCREMENTAL DATABASE BACKUP information.
No INCREMENTAL DATABASE BACKUP images found for RAWSAMPL
Retrieving DELTA DATABASE BACKUP information.
No DELTA DATABASE BACKUP images found for RAWSAMPL
Retrieving TABLESPACE BACKUP information.
No TABLESPACE BACKUP images found for RAWSAMPL
Retrieving INCREMENTAL TABLESPACE BACKUP information.
No INCREMENTAL TABLESPACE BACKUP images found for RAWSAMPL
Retrieving DELTA TABLESPACE BACKUP information.
No DELTA TABLESPACE BACKUP images found for RAWSAMPL
Retrieving LOCAL COPY information.
No LOCAL COPY images found for RAWSAMPL
Retrieving log archive information.
Log file: S0000050.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.46.13
Log file: S0000051.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.46.43
Log file: S0000052.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.47.12
Log file: S0000053.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.50.14
Log file: S0000054.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.50.56
Log file: S0000055.LOG, Chain Num: 0, DB Partition Number: 0,
Taken at 2003-12-09-18.52.39
Node User Database Name type
-------------------------------------------------------------------
bar2 jchisan sample B
<all> <all> test B
-------------------------------------------------------------------
Access Types: B - Backup images L - Logs A - both
One parameter from each group below can be used to restrict what backup images types are included in the operation:
When using proxy nodes in TSM environments, in order to see the backup images or the log archives taken when the proxy node was used, you must specify the OPTIONS parameter with the shared TSM proxy node value using the asnodename option (for example OPTIONS "-asnodename=cluster1" ). The OPTIONS parameter is available starting in Version 9.7 Fix Pack 2 and later fix packs.
TSM grants delete access to the owner of the object or to the root user. It might restrict delete access to other users.
S0******.LOG
The
log files on the TSM server are written to the ./NODE0***/TESTLOG/C0******/ directory.If the db2adutl utility encounters errors with TSM the actual TSM return code is displayed and the TSM documentation should be referred for troubleshooting steps.