Listing backups

This option lists all the backups that are involved when Optim™ High Performance Unload is executed against an incremental or delta backup. This option is useful when you do not know all the backups that are involved when unloading from an incremental or delta backup image.

When working with an incremental/delta backup, with an USING BACKUP clause pointing to such a backup, use this option when you do not know the exact backups it is based on. When the --list-backups option is specified, Optim High Performance Unload displays this backups list and the associated session numbers.

Example 1: Using the --list-backups option

In this example, the execution environment is described as follows:

3 machines with partitioned data: lat127 (database partition #0), lat128 (database partition #9) and lat129 (database partition #221).
Optim High Performance Unload will be executed on the lat127 machine.

The concerned backups have been taken as follows:

a FULL multi-sessions backup in the directories:
- "/db2home/i957pmbk/backups/full/volume1" and
- "/db2home/i957pmbk/backups/full/volume2"
an INCREMENTAL multi-sessions backup in the directories:
- "/db2home/i957pmbk/backups/incr/volume1" and
- "/db2home/i957pmbk/backups/incr/volume2"

The result of Optim High Performance Unload execution:

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

Example 2: Using the --list-backups option with backups residing in different storage environments (TSM and DISK)

In this example, the execution environment is described as follows:

The backups have been taken from the database SAMPLE
a full backup, taken at 20140530134246 with TSM
an incremental backup, taken at 20140530134338 in the directory “/home/i970” on disk
a delta backup, taken at 20140530134411 with TSM
another delta backup, taken at 20140530134440 in the directory “/home/i970” on disk.

[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

Each backup information (directory and session number) is specified in the INZU657I information message only if the backup has been taken on disk.