バックアップのリスト

このオプションは、増分バックアップまたはデルタ・バックアップに対して Optim™ High Performance Unload がインクリメンタルバックアップまたはデルタバックアップに対して実行されたときに関係するすべてのバックアップを一覧表示します。このオプションは、増分バックアップ・イメージまたは差分バックアップ・イメージからのアンロード時に組み込まれるバックアップをすべて把握していない場合に役立ちます。

増分/差分バックアップを指す USING BACKUP 節を使用してこのようなバックアップを処理する際に、ベースとなる完全バックアップが分からない場合は、このオプションを使用します。 --list-backups オプションが指定された場合、 Optim High Performance Unload このバックアップリストと関連するセッション番号を表示します。

例 1: --list-backups オプションの使用

この例では、以下のような実行環境を使用します。

データがパーティション化された 3 台のマシン: lat127 (データベース・パーティション #0)、lat128 (データベース・パーティション #9)、lat129 (データベース・パーティション #221)
Optim High Performance Unloadlat127 マシン上で実行されます。

当該バックアップは以下のように作成されています。

マルチセッションのフルバックアップは、以下のディレクトリーにあります。
- "/db2home/i957pmbk/backups/full/volume1"
- "/db2home/i957pmbk/backups/full/volume2"
マルチセッションの増分バックアップは、以下のディレクトリーにあります。
- "/db2home/i957pmbk/backups/incr/volume1"
- "/db2home/i957pmbk/backups/incr/volume2"

実行結果： Optim High Performance Unload 実行結果：

i957pmbk@lat127:~> /opt/ibm/HPU/V5.1/bin/db2hpu -f SYSIN -i i957pmbk --list-backups
INZM031I Optim High Performance Unload for Db2 06.01.00.001(131204)
         64 bits 12/04/2013 (Linux lat127 x86_64)
INZI473I Memory limitations: 4881Mb for virtual memory and 'unlimited' for data segment
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8
000002 USING BACKUP CATALOG BCK_DATA FROM "/backups/volume1",
000003                                    "/backups/volume2" TAKEN AT 20130405134729;
000004 ;
000005 UNLOAD TABLESPACE
000006 DB2 NO LOCK NO FLUSH BUFFERPOOLS NO
000007 USING BACKUP DATABASE BCK_DATA FROM "/backups/volume1",
000008                                     "/backups/volume2" ON SOURCE HOST TAKEN AT 20130405134729;
000009 SELECT * FROM TS_SMS_4K.TB_BCK_SAMPLE;
000010 FORMAT DEL;
000011 

INZU462I HPU control step start: 18:25:44.370.
INZU656I The list of backups determined by the USING BACKUP CATALOG clause for the partition 0:
INZU557I The partition 0 backup image taken at 20130405134435 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20130405134435 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I The partition 0 backup image taken at 20130405134435 (session #2) has been taken in the '/backups/volume2' directory.
INZU557I The partition 0 backup image taken at 20130405134729 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20130405134729 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I The partition 0 backup image taken at 20130405134729 (session #2) has been taken in the '/backups/volume2' directory.
INZU656I The list of backups determined by the USING BACKUP DATABASE clause for the partition 0:
INZU557I The partition 0 backup image taken at 20130405134435 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20130405134435 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I The partition 0 backup image taken at 20130405134435 (session #2) has been taken in the '/backups/volume2' directory.
INZU557I The partition 0 backup image taken at 20130405134729 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20130405134729 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I The partition 0 backup image taken at 20130405134729 (session #2) has been taken in the '/backups/volume2' directory.
INZU463I HPU control step end  : 18:25:44.410.
INZU464I HPU run step start    : 18:25:44.410.
INZU656I [lat128] The list of backups determined by the USING BACKUP DATABASE clause for the partition 9:
INZU557I [lat128] The partition 9 backup image taken at 20130405134435 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU657I [lat128] The partition 9 backup image taken at 20130405134435 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I [lat128] The partition 9 backup image taken at 20130405134435 (session #2) has been taken in the '/backups/volume2' directory.
INZU557I [lat128] The partition 9 backup image taken at 20130405134729 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I [lat128] The partition 9 backup image taken at 20130405134729 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I [lat128] The partition 9 backup image taken at 20130405134729 (session #2) has been taken in the '/backups/volume2' directory.
INZU656I [lat129] The list of backups determined by the USING BACKUP DATABASE clause for the partition 221:
INZU557I [lat129] The partition 221 backup image taken at 20130405134435 is involved in the unload (Type FULL OFFLINE DATABASE, Device DISK).
INZU657I [lat129] The partition 221 backup image taken at 20130405134435 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I [lat129] The partition 221 backup image taken at 20130405134435 (session #2) has been taken in the '/backups/volume2' directory.
INZU557I [lat129] The partition 221 backup image taken at 20130405134729 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I [lat129] The partition 221 backup image taken at 20130405134729 (session #1) has been taken in the '/backups/volume1' directory.
INZU657I [lat129] The partition 221 backup image taken at 20130405134729 (session #2) has been taken in the '/backups/volume2' directory.
INZU465I HPU run step end      : 18:25:44.753.
INZI441I HPU successfully ended: Real time -> 0m0.383105s
User time -> 0m0.071989s : Parent -> 0m0.071989s, Children -> 0m0.000000s
Syst time -> 0m0.028995s : Parent -> 0m0.028995s, Children -> 0m0.000000s

例 2: 異なるストレージ環境 (TSM および DISK) にあるバックアップでの --list-backups オプションの使用

この例では、以下のような実行環境を使用します。

バックアップは、データベース SAMPLE から作成されています。
フルバックアップは 20140530134246 に TSM を使用して作成されています。
増分バックアップは 20140530134338 に作成され、ディスク上のディレクトリー “ /home/i970 ” に格納されています。
差分バックアップは 20140530134411 に TSM を使用して作成されています。
別の差分バックアップは 20140530134440 に作成され、ディスク上のディレクトリー “ /home/i970” に格納されています。

[i970@lat202(el040701_dev:) ~]$ /opt/ibm/HPU/V5.1/bin/db2hpu -f SYSIN_HPU -i i970 -s /opt/ibm/db2/V9.7 --list-backups
INZM031I Optim High Performance Unload for Db2 06.01.00.001(140530) 
         64 bits 05/30/2014 (Linux lat202 x86_64)
INZI473I Memory limitations: 'unlimited' for virtual memory and 'unlimited' for data segment
       ----+----1----+----2----+----3----+----4----+----5----+----6----+----7----+----8----
000001 GLOBAL CONNECT TO SAMPLE
000002 USING BACKUP CATALOG SAMPLE FROM "/home/i970" TAKEN AT 20140530134440;
000003 ;
000004 
000005 UNLOAD TABLESPACE
000006 PART(0)
000007 DB2 NO LOCK NO FLUSH BUFFERPOOLS NO
000008 
000009 USING BACKUP DATABASE SAMPLE FROM "/home/i970" TAKEN AT 20140530134440;
000010 
000011 SELECT * FROM EMPLOYEE;
000012 OUTFILE("outfile")
000013 FORMAT DEL;
000014 

INZU462I HPU control step start: 16:19:42.663.
INZU656I The list of backups determined by the USING BACKUP CATALOG clause for the partition 0:
INZU557I The partition 0 backup image taken at 20140530134246 is involved in the unload (Type FULL OFFLINE DATABASE, Device TSM).
INZU557I The partition 0 backup image taken at 20140530134338 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20140530134338 (session #1) has been taken in the directory '/home/i970'.
INZU557I The partition 0 backup image taken at 20140530134411 is involved in the unload (Type DELTA OFFLINE DATABASE, Device TSM).
INZU557I The partition 0 backup image taken at 20140530134440 is involved in the unload (Type DELTA OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20140530134440 (session #1) has been taken in the directory '/home/i970'.
INZU656I The list of backups determined by the USING BACKUP DATABASE clause for the partition 0:
INZU557I The partition 0 backup image taken at 20140530134246 is involved in the unload (Type FULL OFFLINE DATABASE, Device TSM).
INZU557I The partition 0 backup image taken at 20140530134338 is involved in the unload (Type INCREMENTAL OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20140530134338 (session #1) has been taken in the directory '/home/i970'.
INZU557I The partition 0 backup image taken at 20140530134411 is involved in the unload (Type DELTA OFFLINE DATABASE, Device TSM).
INZU557I The partition 0 backup image taken at 20140530134440 is involved in the unload (Type DELTA OFFLINE DATABASE, Device DISK).
INZU657I The partition 0 backup image taken at 20140530134440 (session #1) has been taken in the directory '/home/i970'.
INZU463I HPU control step end  : 16:19:42.671.
INZI441I HPU successfully ended: Real time -> 0m0.008107s
User time -> 0m0.004000s : Parent -> 0m0.004000s, Children -> 0m0.000000s
Syst time -> 0m0.016000s : Parent -> 0m0.016000s, Children -> 0m0.000000s

各バックアップ情報 (ディレクトリーとセッション番号) が INZU657I 情報メッセージ内に指定されるのは、バックアップがディスク上に作成されている場合のみです。