예 5: 전체 테이블스페이스 또는 데이터베이스 언로드

전체 데이터베이스 언로드 또는 전체 테이블스페이스 중 하나인 전역 언로드의 경우, 세 개의 키워드 %{tablespace_name}, %{table_schema} 및 %{table_name}은 아직 해당 절에 사용되지 않은 경우 자동으로 OUTFILE, LOADFILE 및 DDLFILE 절 스펙에 적용됩니다. 이는 고려한 각 테이블에 대해 생성된 파일을 구별하기 위해 수행됩니다.

다음은 특정 템플릿 키워드가 없는 Optim™ High Performance Unload 보고서의 발췌본입니다. OUTFILE 및 LOADFILE 절에 특정 템플릿 키워드가 없는 UNLOAD에 대한 보고서입니다:

INZM031I Optim High Performance Unload for Db2 06.01.00.001(120813)
         64 bits 08/13/2012 (Linux lat186 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 UNLOAD TABLESPACE USERSPACE1
000003 DB2 NO
000004 OUTFILE("outfile")
000005 LOADFILE("loadfile")
000006 FORMAT DEL;
000007

INZU462I HPU control step start: 15:34:29.221.
INZU463I HPU control step end  : 15:34:29.800.
INZU464I HPU run step start    : 15:34:29.908.                                 
INZU410I HPU utility has unloaded 5 rows on lat186 host for I975.CL_SCHED in outfile_USERSPACE1_I975_CL_SCHED.
INZU442I HPU utility has generated the LOAD file loadfile_USERSPACE1_I975_CL_SCHED (LRECL=0).
...
INZU410I HPU utility has unloaded 35 rows on lat186 host for I975.STAFFG in outfile_USERSPACE1_I975_STAFFG.
INZU442I HPU utility has generated the LOAD file loadfile_USERSPACE1_I975_STAFFG (LRECL=0).
INZU465I HPU run step end      : 15:34:29.936.
INZI441I HPU successfully ended: Real time -> 0m0.715058s
User time -> 0m0.035994s : Parent -> 0m0.035994s, Children -> 0m0.000000s
Syst time -> 0m0.034994s : Parent -> 0m0.034994s, Children -> 0m0.000000s

이 예에서 OUTFILE("outfile") 스펙은 자동으로 대체되었습니다.

OUTFILE(“outfile_%{tablespace_name}_%{table_schema}_%{table_name}”)

OUTFILE 및 LOADFILE 절의 템플리트 키워드 스펙으로 다른 패턴을 정의할 수 있습니다.

참고: 아래의 예에 표시된 것처럼, 모든 절에 이 세 키워드를 모두 명시적으로 지정하지 않아도 됩니다.

INZM031I Optim High Performance Unload for Db2 06.01.00.001(120813) 
         64 bits 08/13/2012 (Linux lat186 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 UNLOAD TABLESPACE USERSPACE1
000003 DB2 NO
000004 OUTFILE("%{tablespace_name}.%{table_schema}.%{table_name}.outfile")
000005 LOADFILE(“%{tablespace_name}.%{table_schema}.%{table_name}.loadfile")
000006 FORMAT DEL;
000007

INZU462I HPU control step start: 15:34:29.221.
INZU463I HPU control step end  : 15:34:29.800.
INZU464I HPU run step start    : 15:34:29.908.                                 
INZU410I HPU utility has unloaded 5 rows on lat186 host for I975.CL_SCHED in USERSPACE1.I975.CL_SCHED.outfile.
INZU442I HPU utility has generated the LOAD file USERSPACE1.I975.CL_SCHED.loadfile (LRECL=0).
...
INZU410I HPU utility has unloaded 35 rows on lat186 host for I975.STAFFG in USERSPACE1.I975.STAFFG.outfile.
INZU442I HPU utility has generated the LOAD file USERSPACE1.I975.STAFFG.loadfile (LRECL=0).
INZU465I HPU run step end      : 15:34:29.936.
INZI441I HPU successfully ended: Real time -> 0m0.715058s
User time -> 0m0.035994s : Parent -> 0m0.035994s, Children -> 0m0.000000s
Syst time -> 0m0.034994s : Parent -> 0m0.034994s, Children -> 0m0.000000s