装入方式

LOADMODE 选项指定数据迁移期间生成的 Db2® Load 命令的方式。

语法: LOADMODE load_mode; LOADMODE (load_mode[ WITH dpf_load_mode ]); 使用 LOADMODE 选项将特定方式应用于生成的 Db2 Load 命令。所有选项都对应于可用于 Db2 Load 命令的方式。请参阅 Db2 文档以获取 Db2 Load 命令方式描述。
变量: 无。
缺省值: 插入

加载模式

语法: INSERT | REPLACE [KEEPDICTIONARY | RESETDICTIONARY] | RESTART | TERMINATE
变量: 无。
缺省值: 插入

DPF加载模式

语法: LOAD_ONLY | LOAD_ONLY_VERIFY_PART | PARTITION_ONLY | PARTITION_AND_LOAD; 使用 LOADMODE 选项的 dpf_load_mode 子句将特定方式应用于 DPF 环境中生成的 Db2 Load 命令。所有选项都对应于可用于 Db2 Load 命令的方式。请参阅 Db2 文档以获取 Db2 Load 命令方式描述。
变量: 无。
缺省值: 插入

示例: 在 Load 方式设置为 RESTART 的情况下生成 Load 命令

要指定 RESTART 装入方式，请使用以下控制文件示例:

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

运行 Optim™ High Performance Unload 会生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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");

示例: 在装入方式设置为 REPLACE 的情况下迁移表

要在自动迁移期间指定 REPLACE Load 方式，请使用以下控制文件示例:

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;

运行 Optim High Performance Unload 控制文件生成以下报告：

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

要点: 报告中的 INZU539I 消息概述了 Load 命令生成。

示例: 使用 LOAD_ONLY 重新分区

要在卸载到分区环境期间指定 LOAD_ONLY 方式，请使用以下控制文件示例:

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;

运行 Optim High Performance Unload 控制文件生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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 ".";

示例: 使用 LOAD_ONLY 卸载到多个输出文件

要指定 LOAD_ONLY 方式并卸载到与源数据库分区一样多的输出文件，请使用以下控制文件示例:

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;

在这种情况下，将使用内部的数据库分区映射来生成输出文件。运行 Optim High Performance Unload 控制文件生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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 ".";

示例: 使用 LOAD_ONLY_VERIFY_PART 卸载

要指定 LOAD_ONLY_VERIFY_PART 方式并卸载到与源数据库分区一样多的输出文件，请使用以下控制文件示例:

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;

在这种情况下，将使用内部的数据库分区映射来生成输出文件。运行 Optim High Performance Unload 控制文件生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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 ".";

示例: 使用 PARTITION_ONLY 卸载

要指定 PARTITION_ONLY 方式并将其卸载到唯一输出文件，请使用以下控制文件示例:

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

在这种情况下，将使用内部的数据库分区映射来生成输出文件。运行 Optim High Performance Unload 控制文件生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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 ".";

示例: 使用 PARTITION_AND_LOAD 卸载

要指定 PARTITION_AND_LOAD 方式并将其卸载到唯一输出文件，请使用以下控制文件示例:

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

在这种情况下，将使用内部的数据库分区映射来生成输出文件。运行 Optim High Performance Unload 控制文件生成以下报告：

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

生成的 Db2 Load 命令文件将具有以下语法:

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 ".";