Tivoli Storage Manager (以前の ADSM) を使用して保管した、 バックアップ、ログ、およびロード・コピー・イメージの、 照会、抽出、検査、および削除をユーザーに許可します。
UNIX ベースのシステムでは、このユーティリティーは INSTHOME/sqllib/misc ディレクトリーにあり、 OS/2 および Windows オペレーティング・システムでは \sqllib\misc ディレクトリーにあります。
このコマンドの詳細については、管理の手引き を参照してください。
許可
なし
必須接続
なし
コマンド構文
>>-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--'
コマンド・パラメーター
注: | このパラメーターを指定すると、 バックアップ・イメージ全体がネットワークを介して転送されます。 |
例
以下に示すのは、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
以下に示すのは、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