백업 나열

이 옵션은 증분 백업 또는 델타 백업이 실행될 때 관련된 모든 백업을 나열합니다 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 에서 실행됩니다.

관련 백업이 다음과 같이 작성되었습니다.

디렉토리의 FULL 다중 세션 백업:
- "/db2home/i957pmbk/backups/full/volume1" and
- "/db2home/i957pmbk/backups/full/volume2"
디렉토리의 INCREMENTAL 다중 세션 백업:
- "/db2home/i957pmbk/backups/incr/volume1" and
- "/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에서 작성됨
TSM에서 20140530134246에 작성한 전체 백업
디스크의 “/home/i970” 디렉토리에서 20140530134338에 작성한 증분 백업
TSM에서 20140530134411에 작성한 델타 백업
디스크의 “/home/i970” 디렉토리에서 20140530134440에 작성한 다른 델타 백업

[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 정보 메시지에서 지정됩니다.