LOADMODE

La opción LOADMODE especifica la modalidad para el mandato Db2® Load que se genera durante la migración de datos.

Sintaxis: LOADMODE load_mode; LOADMODE (load_mode[ WITH dpf_load_mode ]); Utilice la opción LOADMODE para aplicar una modalidad específica al mandato Load de Db2 generado. Todas las opciones corresponden a las modalidades disponibles para el mandato Db2 Load. Consulte la documentación de Db2 para ver las descripciones de la modalidad de mandato de carga de Db2 .
Variable: Ninguna.
Valor predeterminado: INSERT

load_mode

Sintaxis: INSERT | REPLACE [KEEPDICTIONARY | RESETDICTIONARY] | RESTART | TERMINATE
Variable: Ninguna.
Valor predeterminado: INSERT

modo_carga_dpf

Sintaxis: LOAD_ONLY | LOAD_ONLY_VERIFY_PART | PARTITION_ONLY | PARTITION_AND_LOAD; Utilice la cláusula dpf_load_mode para la opción LOADMODE para aplicar una modalidad específica al mandato Load de Db2 generado en entornos DPF. Todas las opciones corresponden a las modalidades disponibles para el mandato Db2 Load. Consulte la documentación de Db2 para ver las descripciones de la modalidad de mandato de carga de Db2 .
Variable: Ninguna.
Valor predeterminado: INSERT

Ejemplo: Generar un mandato Load con la modalidad Load establecida en RESTART

Para especificar una modalidad Load RESTART, utilice el ejemplo de archivo de control siguiente:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM I951.EMPLOYEE;
OUTFILE("outfile")
LOADFILE(“loadfile”)
LOADMODE RESTART
FORMAT DEL;

La ejecución de Optim™ High Performance Unload con el fichero de control genera el siguiente informe:

INZM031I Optim High Performance Unload for Db2 06.01.00.001(100702) 
         64 bits 07/02/10 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM I951.EMPLOYEE;
000004 OUTFILE("outfile")
000005 LOADFILE("loadfile")
000006 LOADMODE RESTART
000007 FORMAT DEL;

INZU462I HPU control step start: 14:09:35.930.
INZU463I HPU control step end  : 14:09:36.464.
INZU464I HPU run step start    : 14:09:36.496.
INZU410I HPU utility has unloaded 42 rows on lat194 host for I951.EMPLOYEE in outfile.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 14:09:38.553.
INZI441I HPU successfully ended: Real time -> 0m2.622832s
User time -> 0m0.085986s : Father -> 0m0.080987s, Children -> 0m0.004999s
Syst time -> 0m0.015997s : Father -> 0m0.011998s, Children -> 0m0.003999s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
RESTART INTO "I951"."EMPLOYEE"("EMPNO","FIRSTNME","MIDINIT",
"LASTNAME","WORKDEPT","PHONENO","HIREDATE","JOB","EDLEVEL",
"SEX","BIRTHDATE","SALARY","BONUS","COMM");

Ejemplo: Generar un mandato table con la modalidad Load establecida en REPLACE

Para especificar la modalidad Load REPLACE durante la migración automática, utilice el ejemplo de archivo de control siguiente:

GLOBAL CONNECT TO SAMPLE;
MIGRATE TABLESPACE
SELECT * FROM I951.EMPLOYEE;
TARGET ENVIRONMENT (INSTANCE "i951")
TARGET KEYS (CURRENT)
LOADMODE REPLACE
FORMAT DEL INTO I951.EMPLOYEE_IMP;

Ejecutar Optim High Performance Unload con el archivo de control genera el siguiente informe:

INZM031I Optim High Performance Unload for Db2 06.01.00.001(100702) 
         64 bits 07/02/10 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 MIGRATE TABLESPACE
000003 SELECT * FROM I951.EMPLOYEE;
000004 TARGET ENVIRONMENT (INSTANCE "i951")
000005 TARGET KEYS (CURRENT)
000006 LOADMODE REPLACE
000007 FORMAT DEL INTO I951.EMPLOYEE_IMP;

INZU462I HPU control step start: 14:00:29.229.
INZU463I HPU control step end  : 14:00:29.727.
INZU464I HPU run step start    : 14:00:29.757.
INZU543I HPU utility will perform load operations on lat194 host.
INZU539I [lat194] HPU utility has performed load (REPLACE mode) 
         into I951.EMPLOYEE_IMP on database SAMPLE for instance i951 : 
         Report in /home/i951/labo/hm320_mnt/I951.EMPLOYEE_IMP.msg 
         (Read 42, Skipped 0, Loaded 42, Rejected 0, Deleted 0, Commited 42)
INZU465I HPU run step end      : 14:00:36.923.
INZI441I HPU successfully ended: Real time -> 0m7.693607s
User time -> 0m0.093984s : Father -> 0m0.092985s, Children -> 0m0.000999s
Syst time -> 0m0.020996s : Father -> 0m0.015997s, Children -> 0m0.004999s

Importante: el mensaje INZU539I del informe resume la generación del mandato Load.

Ejemplo: Volver a efectuar la partición con LOAD_ONLY

Para especificar la modalidad LOAD_ONLY durante la descarga a un entorno particionado, utilice el ejemplo de archivo de control siguiente:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM EMPLOYEE;
OUTFILE("outfile")
TARGET KEYS ((EMPNO) PARTS(0,1,2,3))
LOADFILE("loadfile")
LOADMODE (REPLACE WITH LOAD_ONLY)
FORMAT DEL INTO EMP_TARGET;

Ejecutar Optim High Performance Unload con el archivo de control genera el siguiente informe:

INZM031I Optim High Performance Unload for Db2 06.01.00.001(110725) 
         64 bits 07/28/2011 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile")
000005 TARGET KEYS ((EMPNO) PARTS(0,1,2,3))
000006 LOADFILE("loadfile")
000007 LOADMODE (REPLACE WITH LOAD_ONLY)
000008 FORMAT DEL INTO EMP_TARGET;

INZU462I HPU control step start: 17:20:32.808.
INZU463I HPU control step end  : 17:20:33.179.
INZU464I HPU run step start    : 17:20:33.197.
INZU410I HPU utility has unloaded 7 rows on lat194 host for I951.EMPLOYEE in outfile.000.
INZU410I HPU utility has unloaded 13 rows on lat194 host for I951.EMPLOYEE in outfile.001.
INZU410I HPU utility has unloaded 10 rows on lat194 host for I951.EMPLOYEE in outfile.002.
INZU410I HPU utility has unloaded 12 rows on lat194 host for I951.EMPLOYEE in outfile.003.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 17:20:33.213.
INZI441I HPU successfully ended: Real time -> 0m0.404497s
User time -> 0m0.096985s : Father -> 0m0.096985s, Children -> 0m0.000000s
Syst time -> 0m0.014997s : Father -> 0m0.014997s, Children -> 0m0.000000s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
REPLACE INTO "EMP_TARGET" ("EMPNO","FIRSTNME","MIDINIT","LASTNAME",
"WORKDEPT","PHONENO","HIREDATE","JOB","EDLEVEL","SEX","BIRTHDATE",
"SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE LOAD_ONLY PART_FILE_LOCATION ".";

Ejemplo: Descarga con LOAD_ONLY en varios archivos de salida

Para especificar una modalidad LOAD_ONLY y para descargar a tantos archivos de salida como particiones de bases de datos de origen haya, utilice el siguiente ejemplo de archivo de control:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM EMPLOYEE;
OUTFILE("outfile.%{source_node}")
LOADFILE("loadfile")
LOADMODE (REPLACE WITH LOAD_ONLY)
FORMAT DEL INTO EMP_TARGET;

En este caso, los archivos de salida se generan con una correlación de partición de base de datos en el interior. Ejecutar Optim High Performance Unload con el archivo de control genera el siguiente informe:

INZM031I Optim High Performance Unload for Db2 06.01.00.001(110725) 
         64 bits 07/28/2011 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile.%{source_node}")
000005 LOADFILE("loadfile")
000006 LOADMODE (REPLACE WITH LOAD_ONLY)
000007 FORMAT DEL INTO EMP_TARGET;

INZU462I HPU control step start: 17:24:43.718.
INZU463I HPU control step end  : 17:24:44.088.
INZU464I HPU run step start    : 17:24:44.106.
INZU410I HPU utility has unloaded 15 rows on lat194 host for I951.EMPLOYEE in outfile.000.
INZU410I HPU utility has unloaded 14 rows on lat194 host for I951.EMPLOYEE in outfile.002.
INZU410I HPU utility has unloaded 13 rows on lat194 host for I951.EMPLOYEE in outfile.001.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 17:24:45.501.
INZI441I HPU successfully ended: Real time -> 0m1.783879s
User time -> 0m0.106983s : Father -> 0m0.106983s, Children -> 0m0.000000s
Syst time -> 0m0.015997s : Father -> 0m0.015997s, Children -> 0m0.000000s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
REPLACE INTO "EMP_TARGET" ("EMPNO","FIRSTNME","MIDINIT",
"LASTNAME","WORKDEPT","PHONENO","HIREDATE","JOB","EDLEVEL",
"SEX","BIRTHDATE","SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE LOAD_ONLY PART_FILE_LOCATION ".";

Ejemplo: Descarga con LOAD_ONLY_VERIFY_PART

Para especificar una modalidad LOAD_ONLY_VERIFY_PART y para descargar en tantos archivos de salida como particiones de bases de datos de origen haya, utilice el siguiente ejemplo de archivo de control:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM EMPLOYEE;
OUTFILE("outfile.%{source_node}")
LOADFILE("loadfile")
LOADMODE (REPLACE WITH LOAD_ONLY_VERIFY_PART)
FORMAT DEL INTO EMP_TARGET;

INZM031I Optim High Performance Unload for Db2 06.01.00.001(110725) 
         64 bits 07/28/2011 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile.%{source_node}")
000005 LOADFILE("loadfile")
000006 LOADMODE (REPLACE WITH LOAD_ONLY_VERIFY_PART)
000007 FORMAT DEL INTO EMP_TARGET;

INZU462I HPU control step start: 17:30:07.808.
INZU463I HPU control step end  : 17:30:08.180.
INZU464I HPU run step start    : 17:30:08.202.
INZU410I HPU utility has unloaded 15 rows on lat194 host for I951.EMPLOYEE in outfile.000.
INZU410I HPU utility has unloaded 13 rows on lat194 host for I951.EMPLOYEE in outfile.001.
INZU410I HPU utility has unloaded 14 rows on lat194 host for I951.EMPLOYEE in outfile.002.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 17:30:08.213.
INZI441I HPU successfully ended: Real time -> 0m0.404232s
User time -> 0m0.098984s : Father -> 0m0.098984s, Children -> 0m0.000000s
Syst time -> 0m0.009998s : Father -> 0m0.009998s, Children -> 0m0.000000s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
REPLACE INTO "EMP_TARGET" ("EMPNO","FIRSTNME","MIDINIT",
"LASTNAME","WORKDEPT","PHONENO","HIREDATE","JOB","EDLEVEL",
"SEX","BIRTHDATE","SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE LOAD_ONLY_VERIFY_PART 
PART_FILE_LOCATION ".";

Ejemplo: Descarga con PARTITION_ONLY

Para especificar la modalidad PARTITION_ONLY y descargar a un único archivo de salida, utilice el ejemplo de archivo de control siguiente:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM EMPLOYEE;
OUTFILE("outfile")
LOADFILE("loadfile")
LOADMODE (REPLACE WITH PARTITION_ONLY)
FORMAT DEL INTO EMP_TARGET;

INZM031I Optim High Performance Unload for Db2 06.01.00.001(110725) 
         64 bits 07/28/2011 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile")
000005 LOADFILE("loadfile")
000006 LOADMODE (REPLACE WITH PARTITION_ONLY)
000007 FORMAT DEL INTO EMP_TARGET;

INZU462I HPU control step start: 17:34:09.231.
INZU463I HPU control step end  : 17:34:09.596.
INZU464I HPU run step start    : 17:34:09.612.
INZU410I HPU utility has unloaded 42 rows on lat194 host for I951.EMPLOYEE in outfile.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 17:34:09.621.
INZI441I HPU successfully ended: Real time -> 0m0.389682s
User time -> 0m0.096985s : Father -> 0m0.096985s, Children -> 0m0.000000s
Syst time -> 0m0.014997s : Father -> 0m0.014997s, Children -> 0m0.000000s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
REPLACE INTO "EMP_TARGET" ("EMPNO","FIRSTNME",
"MIDINIT","LASTNAME","WORKDEPT","PHONENO","HIREDATE",
"JOB","EDLEVEL","SEX","BIRTHDATE","SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE PARTITION_ONLY 
PART_FILE_LOCATION ".";

Ejemplo: Descarga con PARTITION_AND_LOAD

Para especificar la modalidad PARTITION_AND_LOAD y descargar a un único archivo de salida, utilice el ejemplo de archivo de control siguiente:

GLOBAL CONNECT TO SAMPLE;
UNLOAD TABLESPACE
SELECT * FROM EMPLOYEE;
OUTFILE("outfile")
LOADFILE("loadfile")
LOADMODE (REPLACE WITH PARTITION_AND_LOAD)
FORMAT DEL INTO EMP_TARGET;

INZM031I Optim High Performance Unload for Db2 06.01.00.001(110725) 
         64 bits 07/28/2011 (Linux lat194 x86_64)
000001 GLOBAL CONNECT TO SAMPLE;
000002 UNLOAD TABLESPACE
000003 SELECT * FROM EMPLOYEE;
000004 OUTFILE("outfile")
000005 LOADFILE("loadfile")
000006 LOADMODE (REPLACE WITH PARTITION_AND_LOAD)
000007 FORMAT DEL INTO EMP_TARGET;

INZU462I HPU control step start: 17:34:09.231.
INZU463I HPU control step end  : 17:34:09.596.
INZU464I HPU run step start    : 17:34:09.612.
INZU410I HPU utility has unloaded 42 rows on lat194 host for I951.EMPLOYEE in outfile.
INZU442I HPU utility has generated the LOAD file loadfile (LRECL=0).
INZU465I HPU run step end      : 17:34:09.621.
INZI441I HPU successfully ended: Real time -> 0m0.389682s
User time -> 0m0.096985s : Father -> 0m0.096985s, Children -> 0m0.000000s
Syst time -> 0m0.014997s : Father -> 0m0.014997s, Children -> 0m0.000000s

El archivo de mandatos de carga de Db2 generado tendrá la sintaxis siguiente:

LOAD FROM "outfile" OF DEL
MODIFIED BY CODEPAGE=1208
REPLACE INTO "EMP_TARGET" ("EMPNO","FIRSTNME","MIDINIT",
"LASTNAME","WORKDEPT","PHONENO","HIREDATE","JOB","EDLEVEL",
"SEX","BIRTHDATE","SALARY","BONUS","COMM")
PARTITIONED DB CONFIG MODE PARTITION_AND_LOAD 
PART_FILE_LOCATION ".";