Affichage de la liste des sauvegardes

Cette option liste toutes les sauvegardes impliquées lorsque l'option Optim™ High Performance Unload est exécuté contre une sauvegarde incrémentale ou delta. Cette option est utile lorsque vous ne connaissez pas toutes les sauvegardes impliquées lors du déchargement à partir d'une image de sauvegarde incrémentielle ou différentielle.

Lors de l'utilisation d'une sauvegarde incrémentielle/différentielle, avec une clause USING BACKUP pointant vers cette sauvegarde, utilisez cette option lorsque vous ne savez sur quoi se basent exactement les sauvegardes. Lorsque l'option « --list-backups » est spécifiée, Optim High Performance Unload affiche cette liste de sauvegardes et les numéros de session associés.

Exemple 1 : Utilisation de l'option --list-backups

Dans cet exemple, l'environnement d'exécution est décrit comme suit :

3 ordinateurs avec des données partitionnées : lat127 (partition de base de données #0), lat128 (partition de base de données #9) et lat129 (partition de base de données #221).
Optim High Performance Unload sera exécuté sur la machine d' lat127.

Les sauvegardes concernées ont été utilisées comme suit :

une sauvegarde multi-sessions INTEGRALE dans les répertoires :
- "/db2home/i957pmbk/backups/full/volume1" et
- "/db2home/i957pmbk/backups/full/volume2"
une sauvegarde multi-sessions INCREMENTIELLE dans les répertoires :
- "/db2home/i957pmbk/backups/incr/volume1" et
- "/db2home/i957pmbk/backups/incr/volume2"

Le résultat de l' Optim High Performance Unload exécution :

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

Exemple 2 : Utilisation de l'option --list-backups avec des sauvegardes qui se trouvent dans d'autres environnements de stockage (TSM et DISK)

Dans cet exemple, l'environnement d'exécution est décrit comme suit :

Les sauvegardes proviennent de la base de données SAMPLE
une sauvegarde intégrale, obtenue le 20140530134246 avec TSM
une sauvegarde incrémentielle, obtenue le 20140530134338 dans le répertoire "/home/i970" sur le disque
une sauvegarde différentielle, obtenue le 20140530134411 avec TSM
une autre sauvegarde différentielle, obtenue le 20140530134440 dans le répertoire "/home/i970" sur le disque.

[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

Chaque information de sauvegarde (répertoire et numéro de session) est spécifiée dans le message d'information INZU657I uniquement si la sauvegarde provient du disque.