Allows users to query, extract, verify, and delete backup images, logs, and load copy images that are saved using Tivoli® Storage Manager (TSM). Also allows users 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-+ '-LOGSTREAM--log-stream-number--------' >--+----------------------+--+--------------------+-------------> '-OPTIONS--tsm_options-' '-PASSWORD--password-' >--+---------------------+--+--------------+--------------------> '-NODENAME--node_name-' '-OWNER--owner-' >--+-------------------+----------------------------------------| '-WITHOUT PROMPTING-' QUERY-options |--QUERY--------------------------------------------------------> >--+-----------------------------------------------------------+--| +-+-+------------+--+----------------+-+--+---------------+-+ | | +-TABLESPACE-+ +-NONINCREMENTAL-+ | '-SHOW INACTIVE-' | | | '-FULL-------' +-INCREMENTAL----+ | | | | '-DELTA----------' | | | '-LOADCOPY---------------------------' | '-LOGS--+------------------------+--+----------+------------' '-BETWEEN--sn1--AND--sn2-' '-CHAIN--n-' EXTRACT-options |--EXTRACT------------------------------------------------------> >--+------------------------------------------------------------------------------------------------+--| +-+-+------------+--+----------------+-+--+---------------+--+--------+--+---------------------+-+ | | +-TABLESPACE-+ +-NONINCREMENTAL-+ | '-SHOW INACTIVE-' '-SUBSET-' '-TAKEN AT--timestamp-' | | | '-FULL-------' +-INCREMENTAL----+ | | | | '-DELTA----------' | | | '-LOADCOPY---------------------------' | '-LOGS--+------------------------+--+----------+-------------------------------------------------' '-BETWEEN--sn1--AND--sn2-' '-CHAIN--n-' 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-----------+ +-CHECKDMS--------+ +-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 example 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, Log stream: 0,
Taken at 2003-12-09-18.46.13
Log file: S0000051.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.46.43
Log file: S0000052.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.47.12
Log file: S0000053.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.50.14
Log file: S0000054.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.50.56
Log file: S0000055.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.52.39
Query for database RAWSAMPL
Retrieving FULL DATABASE BACKUP information.
Taken at: 20031209184503 Log stream: 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 example 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, Log stream: 0,
Taken at 2003-12-09-18.46.13
Log file: S0000051.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.46.43
Log file: S0000052.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.47.12
Log file: S0000053.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.50.14
Log file: S0000054.LOG, Chain Num: 0, Log stream: 0,
Taken at 2003-12-09-18.50.56
Log file: S0000055.LOG, Chain Num: 0, Log stream: 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
BufAddr MemberNum PoolID Token Type Offset FileSize ObjectSize OrigSize Object Name
-------- --------- ------ ----- ---- ------ -------- ---------- -------- -----------
00000000: 0 0 0 19 0 268 268 0 "BACKUP.START.RECORD.MARKER"
numTbspsInDB : 3
numTbspsInImg : 3
Total members : 3
Member numbers: 0,1,2
One parameter from each of the following groups 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.8 Fix Pack 3 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
Before
Version 9.8 Fix Pack 3, the log files on the TSM server were written
to the ./NODE0***/TESTLOG/C0******/ directory. In
Version 9.8 Fix Pack 3 and later fix packs, the log files on the TSM
server are written to the ./NODE****/LOGSTREAM****/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.