¾È³çÇϼ¼¿ä. DB2 ¹× XpertMon »ç¿ëÀÚ ¿©·¯ºÐ!
¢ß ¾ÆÀÌƼ¿¢½ºÆÛÆ®±×·ì DB »ç¾÷ºÎÀÔ´Ï´Ù.
À̹ø¿¡´Â ORACLE°ú DB2 UDBÀÇ µ¥ÀÌÅÍ À̵¿ÀÇ µÎ¹ø° ½Ã°£À¸·Î DB2 UDBÀÇ µ¥ÀÌÅÍ À̵¿
¹æ¹ýÀÔ´Ï´Ù. Áï IMPORT, LOAD¿¡ ´ëÇØ »ìÆ캸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
DB2 - import
DB2¿¡¼µµ OracleÀÇ imp¿Í À¯»çÇÑ IMPORT À¯Æ¿¸®Æ¼¸¦ Á¦°øÇÕ´Ï´Ù.
import¿Í export ¸¦ Áö¿øÇÏ´Â ÆÄÀÏ Çü½ÄÀº 4°¡Áö ÀÔ´Ï´Ù. ÆÄÀÏÀÇ Çü½ÄÀº ÆÄÀÏÀ» ¸¸µé°Å³ª,
ÆÄÀÏÀ» »ç¿ëÇÏ´Â Åø¿¡ ÀÇÇØ ¼±Åõ˴ϴÙ. ÀϹÝÀûÀ¸·Î È®ÀåÀÚ´Â ÆÄÀÏ Çü½ÄÀ» ¾Ë ¼ö ÀÖµµ·Ï
.ixf³ª .del, .asc ·Î »ç¿ëÇÕ´Ï´Ù. ¿¹¸¦ µé¸é, employee.ixf ´Â ¼öÁ¤ ºÒ°¡´ÉÇÑ
DB2 interchange Çü½ÄÀ» ´ã°í ÀÖ½À´Ï´Ù.
Áö¿øµÇ´Â 4°¡Áö ÆÄÀÏ Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
- Delimited ASCII files : DEL
ÀÌ Çü½Ä¿¡¼ ±¸ºÐÀÚ´Â ¹®ÀÚ ±¸ºÐÀÚ, Ä®·³ ±¸ºÐÀÚ, Çà ±¸ºÐÀÚÁß Çϳª°¡ µÉ ¼ö ÀÖ½À´Ï´Ù.
¹®ÀÚ ±¸ºÐÀÚÀÇ ±âº»Àº ½Öµû¿ÈÇ¥("), Ä®·³ ±¸ºÐÀÚÀÇ ±âº»Àº ÄÞ¸¶(,) ÀÔ´Ï´Ù.
±âº» ±¸ºÐÀÚ´Â º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.
Çà ±¸ºÐÀÚ´Â UNIX¿¡¼ hex code·Î X'0A'À̸ç, WINDOWS ¿¡¼´Â X'0D0A'ÀÔ´Ï´Ù.
-
Non-delimited ASCII file : ASC
Non-Delimited ASCII file Àº °íÁ¤±æÀÌ Çʵ带 °¡Áø °ÍµéÀÔ´Ï´Ù.
·¹ÄÚµåÀÇ ¼øÂ÷ row´Â ÇàÀ¸·Î ±¸ºÐµË´Ï´Ù. ÀϹÝÀûÀ¸·Î ÀÌ Çü½ÄÀº ÇÑ ÁÙ·Î Á¤·ÄµÈ Ä®·³À»
»ç¿ëÇÏ´Â ¿ÜºÎ application °úÀÇ µ¥ÀÌÅÍ ±³È¯¿¡ »ç¿ëµË´Ï´Ù.
- Integrated Exchange Format file : IXF
DB2 µ¥ÀÌÅͺ£À̽º°£¿¡ µ¥ÀÌÅ͸¦ ±³È¯ÇÒ ¶§ ÁÖ·Î »ç¿ëµË´Ï´Ù. IXF ÆÄÀÏÀº µ¥ÀÌÅͺ£À̽º
Å×ÀÌºí ¹× À妽ºÀÇ ±¸Á¶Á¤º¸¸¦ Æ÷ÇÔÇÏ°í ÀÖ½À´Ï´Ù. ÀÌ Çü½ÄÀÇ ÆÄÀÏÀº ÆíÁý±â¸¦ ÅëÇØ
ÆíÁý ÇÒ ¼ö ¾ø½À´Ï´Ù.
- Worksheet Format file : WSF
ÀÌ Çü½ÄÀº ÀϹÝÀûÀ¸·Î Lotus 1-2-3 ¹× Symphony Á¦Ç°°£¿¡ µ¥ÀÌÅÍ ±³È¯¿¡ »ç¿ëµË´Ï´Ù.
DB2ÀÇ import ¸¦ ¼öÇàÇϱâ À§Çؼ´Â ÀûÀýÇÑ ±ÇÇÑÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. import¸¦ ¼öÇàÇϱâ
À§Çؼ´Â SYSADM ±ÇÇÑ ¶Ç´Â DBA ±ÇÇÑÀ» °®°í Àְųª, ¿É¼Ç¿¡ µû¶ó CREATETAB, CONTROL,
SELECT, INSERT µîÀÇ ±ÇÇÑÀÌ ÇÊ¿äÇÕ´Ï´Ù.
DB2 UDBÀÇ import ¹®¹ýÀº Á÷¼±Àû(straightforward)ÀÔ´Ï´Ù. ¿Â¶óÀÎ »ó¿¡¼ ¹®¹ýÁ¤º¸¸¦
¾Ë°í ½ÍÀ¸¸é, ¸í·Éâ¿¡¼ db2 "? Import" ¸í·ÉÀ» ¼öÇàÇϽʽÿÀ.
IMPORT FROM filename OF {IXF | ASC | DEL | WSF}
[LOBS FROM lob-path [ {,lob-path} ... ] ] [MODIFIED BY filetype-mod ...]
[METHOD {L ( col-start col-end [ {,col-start col-end} ... ] )
[NULL INDICATORS (col-position [ {,col-position} ... ] )] |
N ( col-name [ {,col-name} ... ] ) |
P ( col-position [ {,col-position} ... ] )}]
[ALLOW {NO | WRITE} ACCESS]
[COMMITCOUNT {n | AUTOMATIC}] [{RESTARTCOUNT | SKIPCOUNT} n]
[ROWCOUNT n] [WARNINGCOUNT n] [NOTIMEOUT] [MESSAGES message-file]
{{INSERT | INSERT_UPDATE | REPLACE | REPLACE_CREATE}
INTO {table-name [( insert-column , ... )] | hierarchy-description}
| CREATE INTO {table-name [( insert-column , ... )] |
hierarchy-description {AS ROOT TABLE | UNDER sub-table-name}
[IN tablespace-name [INDEX IN tablespace-name] [LONG IN tablespace-name]]}
[datalink-specification]
filetype-mod:
COMPOUND=x, INDEXSCHEMA=schema, FORCEIN, INDEXIXF, IMPLIEDDECIMAL,
NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR, RECLEN=x, STRIPTBLANKS,
STRIPTNULLS, NO_TYPE_ID, NODOUBLEDEL, LOBSINFILE, USEDEFAULTS,
CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO,
DELPRIORITYCHAR, IDENTITYMISSING, IDENTITYIGNORE,
GENERATEDMISSING, GENERATEDIGNORE, DATEFORMAT=x, TIMEFORMAT=x,
TIMESTAMPFORMAT=x, KEEPBLANKS, CODEPAGE=x, NOROWWARNINGS,
NOCHARDEL, USEGRAPHICCODEPAGE
hierarchy-description:
{ALL TABLES | (sub-table-name [(insert-column, ...)], ...)} [IN]
HIERARCHY {STARTING sub-table-name | (sub-table-name, ...)}
datalink-specification:
([DL_LINKTYPE URL][{DL_URL_REPLACE_PREFIX prefix |
DL_URL_DEFAULT_PREFIX prefix}] [DL_URL_SUFFIX suffix], ...)
|
DB2 ¿¡¼ import ¸¦ ¼öÇàÇÏ´Â ¹æ¹ýÀº 3°¡Áö°¡ ÀÖ½À´Ï´Ù.
- Á¦¾î¼¾ÅÍ : GUI¸¦ ÅëÇÑ ¹æ¹ý
Á¦¾î¼¾ÅÍ´Â ´ëȽÄÀÌ°í, ¸¶¹ý»ç°¡ °¢ ´Ü°è¸¦ ¾È³»ÇØÁֹǷΠ»ç¿ëÇϱâ Æí¸®ÇÕ´Ï´Ù.
SAMPLE µ¥ÀÌÅͺ£À̽º¿¡ Á¦¾î¼¾Å͸¦ ÀÌ¿ëÇÏ¿© import ¸¦ ¼öÇàÇÏ´Â ¿¹Á¦¸¦ º¸°Ú½À´Ï´Ù.
Example 1. Importing a comma delimited files, employee.del into the existing employee table
"000010","CHRISTINE","I","HAAS","A00","3978",19650101,"PRES ",18,"F",19330824, ...
"000020","MICHAEL","L","THOMPSON","B01","3476",19731010,"MANAGER ",18,"M",19480202, ...
"000030","SALLY","A","KWAN","C01","4738",19750405,"MANAGER ",20,"F",19410511, ...
"000050","JOHN","B","GEYER","E01","6789",19490817,"MANAGER ",16,"M",19250915, ...
"000060","IRVING","F","STERN","D11","6423",19730914,"MANAGER ",16,"M",19450707, ...
|
Á¦¾î¼¾Å͸¦ ¼öÇàÇϱâ À§Çؼ´Â "½ÃÀÛ" --> "ÇÁ·Î±×·¥" --> "IBM DB2" -->
"ÀÏ¹Ý °ü¸® µµ±¸" --> "Á¦¾î ¼¾ÅÍ" ·Î À̵¿ÇÕ´Ï´Ù. SAMPLE µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇÑ µÚ
"Tables" ¸¦ Ŭ¸¯ÇÕ´Ï´Ù. È¸é ¿ìÃø¿¡ ³ªÅ¸³ª´Â Å×ÀÌºí ¸ñ·Ï¿¡¼ employee Å×À̺íÀ»
¿À¸¥ÂÊ Å¬¸¯ÇÏ¸é ³ªÅ¸³ª´Â ¸Þ´º¿¡¼ import ¸¦ ¼±ÅÃÇÕ´Ï´Ù.
Import ¿¡ »ç¿ëÇÒ ÆÄÀÏÀÌ del Çü½ÄÀ̱⠶§¹®¿¡, ¿©·¯ ¿É¼ÇÀ» ÅëÇØ ¼¼¹ÐÇÑ import Á¶ÀÛÀ» °¡
´ÉÇÏ°Ô ÇÕ´Ï´Ù. ¿©±â¼´Â µ¥ÀÌÅÍÆÄÀÏ·Î employee.del ÆÄÀÏÀ» »ç¿ëÇÏ°í, ·Î±× ÆÄÀϸ¸
ÁöÁ¤Çϵµ·Ï ÇÏ°Ú½À´Ï´Ù. Import ¸ðµå·Î´Â INSERT , INSERT_REPLACE , REPLACE ¸ðµå°¡
ÀÖ½À´Ï´Ù. INSERT¸¦ ¼±ÅÃÇÏ¸é ±âÁ¸ÀÇ µ¥ÀÌÅÍ¿¡ »õ·Î¿î µ¥ÀÌÅ͸¦ Ãß°¡ÇÏ°Ô µË´Ï´Ù.
INSERT_UPDATE¸¦ »ç¿ëÇÏ·Á¸é ±âº»ÀûÀ¸·Î ÃÖ¼ÒÇÑ ÇϳªÀÇ ±âº» Å°°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
»õ·Î¿î µ¥ÀÌÅÍ´Â Ãß°¡µÇ°í, ±âÁ¸¿¡ ÀÖ´ø µ¥ÀÌÅÍ´Â °»½ÅµË´Ï´Ù. REPLACE ¸ðµå¸¦
¼±ÅÃÇϸé, ±âÁ¸ÀÇ µ¥ÀÌÅÍ´Â ¸ðµÎ »èÁ¦µÇ°í »õ·Î¿î ³»¿ëÀÌ insert µË´Ï´Ù.
±×¸². 8 Import - the file tab
Example. 2. À̹ø ¿¹¿¡¼´Â ¸¶Áö¸· 2 Ä®·³ÀÌ ºüÁø del ÆÄÀÏÀ» »ç¿ëÇÏ°Ú½À´Ï´Ù.
INSERT_UPDATE ¿É¼ÇÀ» »ç¿ëÇÏ¿© import ÀÛ¾÷À» ¼öÇàÇÏ°Ú½À´Ï´Ù.
µ¥ÀÌÅÍ ÆÄÀÏÀº '*'°¡ ±¸ºÐÀÚÀÎ ÆÄÀÏÀÔ´Ï´Ù.
"000010"*"CHRISTINE"*"I"*"HAAS"*"A00"*"3978"*19650101*"PRES "*18*"F"*19330824* ...
"000020"*"MICHAEL"*"L"*"THOMPSON"*"B01"*"3476"*19731010*"MANAGER "*18*"M"*19480202* ...
"000030"*"SALLY"*"A"*"KWAN"*"C01"*"4738"*19750405*"MANAGER "*20*"F"*19410511* ...
"000050"*"JOHN"*"B"*"GEYER"*"E01"*"6789"*19490817*"MANAGER "*16*"M"*19250915* ...
"000060"*"IRVING"*"F"*"STERN"*"D11"*"6423"*19730914*"MANAGER "*16*"M"*19450707* ...
|
±âº»ÀûÀÎ °úÁ¤Àº Example 1. °ú °°Áö¸¸, À̹ø¿¡´Â DEL ¿É¼Ç ¹öÆ°À» »ç¿ëÇؼ ±¸ºÐÀÚ¸¦
ÁöÁ¤ÇØ ÁÖ¾î¾ß ÇÕ´Ï´Ù. COLDEL À» ¼±ÅÃÇÏ°í, '*'¸¦ ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 9 ±¸ºÐÀÚ ¼±ÅÃ
±¸ºÐÀÚ¸¦ ¼±ÅÃÇÑ µÚ Ä®·³ ÅÇÀ¸·Î À̵¿ÇÏ¿© ¡®Ä®·³¡¯ ¹öÆ°À» ´©¸¨´Ï´Ù.
¿©±â¼´Â import ÇÒ Ä®·³À» ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 10 Ä®·³ ¼±Åà 1
BONUS, SALARY¸¦ Á¦¿ÜÇÑ ³ª¸ÓÁö Ä®·³À» ¸ðµÎ ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 11 Ä®·³ ¼±Åà 2
INSERT_UPDATE¸¦ ¼±ÅÃÇÒ °æ¿ì ÁÖÀÇÇÒ Á¡Àº, ±âº» Å°°¡ ÀÖ¾î¾ß ÇÑ´Ù´Â Á¡ÀÔ´Ï´Ù.
±âº»Å°°¡ ¾ø´Ù¸é ¸ÕÀú SQL¹®À¸·Î ±âº»Å°¸¦ ÁöÁ¤ÇØ ÁÖ¾î¾ß ÇÕ´Ï´Ù.
alter table employee add constraint empno primary key (empno)
- ¸í·ÉÇà 󸮱â(CLP) : ¸í·É¾î¸¦ ÅëÇÑ ¹æ¹ý
Example 1. ±âÁ¸¿¡ »ý¼ºµÈ employee Å×ÀÌºí¿¡ ','¸¦ ±¸ºÐÀÚ·Î »ç¿ëÇÏ´Â
µ¥ÀÌÅÍÆÄÀÏÀÎ employee.delÀ» »ç¿ëÇÏ°Ú½À´Ï´Ù.
¸í·Éâ¿¡¼ ´ÙÀ½ÀÇ ¸í·ÉÀ» ¼öÇàÇϽʽÿÀ.
CONNECT TO SAMPLE;
IMPORT FROM "E: mp1employee.del" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14) MESSAGES "E: mp1employee.log"
INSERT INTO ADMINISTRATOR.EMPLOYEE
(EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY, BONUS, COMM);
CONNECT RESET;
|
Example 2. ¸¸¾à ±¸ºÐÀÚ°¡ '*'ÀÌ°í, ¸¶Áö¸· µÎ Ä®·³À» Á¦¿ÜÇÑ ³ª¸ÓÁö Ä®·³À»
import ÇÒ °æ¿ì´Â ¸í·Éâ¿¡¼ ´ÙÀ½ÀÇ ¸í·ÉÀ» ¼öÇàÇϽʽÿÀ.
CONNECT TO SAMPLE;
IMPORT FROM "E: mp1employee.del" OF DEL MODIFIED BY COLDEL*
METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
MESSAGES "E: mp1employee.log"
INSERT_UPDATE INTO ADMINISTRATOR.EMPLOYEE
(EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY);
CONNECT RESET;
|
DB2 - LOAD
Import ¿Ü¿¡µµ DB2¿¡¼´Â ´ë·®ÀÇ µ¥ÀÌÅ͸¦ DB2 UDB µ¥ÀÌÅͺ£À̽º·Î ÈξÀ »¡¸® ÀûÀçÇÏ´Â
LOAD ¶ó´Â À¯Æ¿¸®Æ¼¸¦ Á¦°øÇÕ´Ï´Ù. Import °¡ insert SQL ¹®À» »ç¿ëÇÏ´Â °Í°ú ´Þ¸®
LOAD´Â µ¥ÀÌÅͺ£À̽º ÆÄÀÏ¿¡ Á÷Á¢ ±â·ÏÇÏ´Â ¹æ½ÄÀ» »ç¿ëÇÕ´Ï´Ù. Import¿Í LOAD ¸ðµÎ
»ç¿ëÀÚ Á¤ÀÇ Å×À̺í(UDT)¿Í LOBÀ» Áö¿øÇÏÁö¸¸, LOAD´Â ÆÄƼ¼ÇµÈ Å×ÀÌºí¿¡µµ µ¥ÀÌÅ͸¦
ÀûÀçÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ µÎ °¡Áö ÅøÀÇ ÁÖ¿ä Â÷ÀÌÁ¡°ú »ç¿ë¿¡ ´ëÇÑ ¼±ÅÃÀº ¼º´É¿¡ ÀÖ½À´Ï´Ù.
LOAD°¡ import º¸´Ù ÈξÀ ºü¸¨´Ï´Ù.
LOAD´Â °¢°¢ÀÇ ·¹Äڵ忡 ´ëÇØ ·Î±×¸¦ ³²±âÁö ¾Ê½À´Ï´Ù. ÇÏÁö¸¸ µ¥ÀÌÅÍÀÇ Àç ÀûÀç´Â
°¡´ÉÇÕ´Ï´Ù. load Áß¿¡ LIST UTILITIES ¶ó´Â DB2 ¸í·É¾î¸¦ »ç¿ëÇϸé load °úÁ¤À»
»ìÆ캼 ¼ö ÀÖ½À´Ï´Ù. LOAD´Â Å×ÀÌºí ·¹º§ÀÇ Àá±ÝÀ» »ç¿ëÇϹǷΠload ÁßÀÎ Å×ÀÌºí¿¡
´Ù¸¥ »ç¿ëÀÚ°¡ Á¢±ÙÇÒ ¼ö ¾ø½À´Ï´Ù.
LOAD ¸¦ »ç¿ëÇÏ·Á¸é, SYSADM, DBADM ¶Ç´Â SYSMAINT ±ÇÇÑÀ» °¡Áö°í Àְųª,
load ±ÇÇÑ°ú ÇÔ²² load ¿É¼Ç¿¡ µû¶ó INSERT³ª DELETE ±ÇÇÑÀ» °¡Áö°í ÀÖ¾î¾ß ÇÕ´Ï´Ù.
LOAD ¸í·É¿¡ ´ëÇÑ ¹®¹ýÀº ´ÙÀ½°ú °°À¸¸ç, ¾Æ·¡ ³»¿ëÀº db2 "? Load" ¸í·ÉÀ¸·Î
È®ÀÎ ÇÒ ¼ö ÀÖ½À´Ï´Ù.
LOAD QUERY TABLE table-name [TO local-message-file]
[NOSUMMARY | SUMMARYONLY] [SHOWDELTA]
LOAD [CLIENT] FROM file/pipe/dev/cursor_name [ {,file/pipe/dev} ... ]
OF {ASC | DEL | IXF | CURSOR}
[LOBS FROM lob-path [ {,lob-path} ... ] ]
[MODIFIED BY filetype-mod [ {filetype-mod} ... ] ]]
[METHOD {L ( col-start col-end [ {,col-start col-end} ... ] )
[NULL INDICATORS (col-position [ {,col-position} ... ] )]
| N ( col-name [ {,col-name} ... ] )
| P ( col-position [ {,col-position} ... ] )}]
[SAVECOUNT n]
[ROWCOUNT n] [WARNINGCOUNT n] [MESSAGES msg-file]
[TEMPFILES PATH pathname]
{INSERT | REPLACE | RESTART | TERMINATE}
INTO table-name [( insert-column [ {,insert-column} ... ] )]
[datalink-specification] [FOR EXCEPTION table-name]
[STATISTICS {NO | USE PROFILE}]
[{COPY {NO | YES { USE TSM [OPEN num-sess SESSIONS]
| TO dir/dev [ {,dir/dev} ... ]
| LOAD lib-name [OPEN num-sess SESSIONS]}}
| NONRECOVERABLE} ]
[HOLD QUIESCE] [WITHOUT PROMPTING] [DATA BUFFER buffer-size]
[SORT BUFFER buffer-size] [CPU_PARALLELISM n] [DISK_PARALLELISM n]
[INDEXING MODE {AUTOSELECT | REBUILD | INCREMENTAL | DEFERRED}]
[CHECK PENDING CASCADE {DEFERRED | IMMEDIATE}]
[ALLOW NO ACCESS | ALLOW READ ACCESS [USE tblspace-name]] [LOCK WITH FORCE]
[[PARTITIONED DB CONFIG] partitioned-db-option [{partitioned-db-option}...]]
filetype-mod:
NOROWWARNINGS, ANYORDER, BINARYNUMERICS, CODEPAGE=x,
DUMPFILE=x, FASTPARSE, NOHEADER, TOTALFREESPACE=x,
INDEXFREESPACE=x, PAGEFREESPACE=x, FORCEIN, IMPLIEDDECIMAL,
PACKEDDECIMAL, NOCHECKLENGTHS, NOEOFCHAR, NULLINDCHAR=x,
RECLEN=x, STRIPTBLANKS, STRIPTNULLS, NODOUBLEDEL, LOBSINFILE,
CHARDELx, COLDELx, DLDELx, DECPLUSBLANK, DECPTx, DATESISO,
DELPRIORITYCHAR, USEDEFAULTS, DATEFORMAT=x, TIMEFORMAT=x,
TIMESTAMPFORMAT=x, ZONEDDECIMAL, KEEPBLANKS, IDENTITYMISSING,
IDENTITYIGNORE, IDENTITYOVERRIDE, GENERATEDMISSING,
GENERATEDIGNORE, GENERATEDOVERRIDE, USEGRAPHICCODEPAGE
partitioned-db-option:
HOSTNAME x, FILE_TRANSFER_CMD x, PART_FILE_LOCATION x, OUTPUT_DBPARTNUMS x,
PARTITIONING_DBPARTNUMS x, MODE x, MAX_NUM_PART_AGENTS x, OMIT_HEADER,
ISOLATE_PART_ERRS x, STATUS_INTERVAL x, PORT_RANGE x, CHECK_TRUNCATION,
MAP_FILE_INPUT x, MAP_FILE_OUTPUT x, TRACE x, NEWLINE, DISTFILE x
datalink-specification:
([DL_LINKTYPE URL][{DL_URL_REPLACE_PREFIX prefix |
DL_URL_DEFAULT_PREFIX prefix}] [DL_URL_SUFFIX suffix], ...)
|
LOAD ÀÛ¾÷Àº 4´Ü°è·Î ±¸ºÐÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ 4´Ü°è´Â ¼øÂ÷ÀûÀ¸·Î ¼öÇàµË´Ï´Ù.
- ·Îµå ´Ü°è (load phase) : ÀÌ ´Ü°è¿¡¼, ¿ÜºÎ ÆÄÀÏÀÇ ³»¿ëÀÌ Å×ÀÌºí¿¡ ÀûÀçµÇ°í,
À妽ºµµ ¼öÁý ¹× Á¤·ÄµË´Ï´Ù. ÀÌ ´Ü°è¿¡¼ Áß¿äÇÑ ³»¿ëÀº LOAD ÀÛ¾÷¿¡ ÀÖ¾î¼
savepoint¸¦ È®ÀÎÇÏ´Â °ÍÀÔ´Ï´Ù. savepoint´Â LOAD°¡ ½ÇÆÐÇßÀ» °æ¿ì,
Àç ÀûÀç(reload) ÀÛ¾÷À» ¼öÇàÇÒ ¶§ ÇÊ¿äÇÕ´Ï´Ù. ÀûÀýÇÏÁö ¾ÊÀº ·¹ÄÚµå´Â
¸Þ½ÃÁöÆÄÀÏ¿¡ ±â·ÏµË´Ï´Ù.
- ºôµå ´Ü°è (build phase) : ÀÌ ´Ü°è¿¡¼´Â À妽º°¡ ºôµåµË´Ï´Ù.
ÀÌ ´Ü°è¿¡¼ failure°¡ ¹ß»ýÇßÀ» °æ¿ì, LOAD ÀÛ¾÷À» ´Ù½Ã ¼öÇàÇϸé
ºôµå ´Ü°èºÎÅÍ ½ÃÀÛµÇ°Ô µË´Ï´Ù.
- »èÁ¦ ´Ü°è (delete phase) : ÀÌ ´Ü°è¿¡¼´Â °íÀ¯ Å°³ª ±âº» Å°ÀÇ
Á¦¾à»çÇ׿¡ ¾î±ß³ª´Â °ÍµéÀ» ó¸®ÇÕ´Ï´Ù. À§¹Ý ÇàµéÀº exception table¿¡
¾²¿©Áý´Ï´Ù. ÀÌ ´Ü°è¿¡¼ failure°¡ ¹ß»ýÇϸé LOAD ÀÛ¾÷ Àç¼öÇà½Ã »èÁ¦ ´Ü°èºÎÅÍ
½ÃÀÛµÇ°Ô µË´Ï´Ù. ¸Þ½ÃÁöµµ ÀÌ ´Ü°è¿¡¼ »ý¼ºµË´Ï´Ù.
- À妽º º¹Á¦ ´Ü°è (index copy phase) : ÀÌ ´Ü°è¿¡¼ À妽º°¡ ½Ã½ºÅÛ ÀÓ½Ã
Å×ÀÌºí½ºÆäÀ̽º¿¡¼ ¸ñÇ¥ Å×ÀÌºí ½ºÆäÀ̽º·Î À̵¿µË´Ï´Ù. ·Îµå °úÁ¤¿¡¼ À妽º
»ý¼ºÀ» À§ÇÑ ½Ã½ºÅÛ Àӽà Å×ÀÌºí ½ºÆäÀ̽º¸¦ ÁöÁ¤ÇÑ °æ¿ì¿¡¸¸ °¡´ÉÇÕ´Ï´Ù.
ÀÌ ´Ü°è¿¡¼µµ ¸Þ½ÃÁö°¡ »ý¼ºµË´Ï´Ù.
LOAD ÀÛ¾÷Àº µ¥ÀÌÅÍÀÇ Ãß°¡ ¹× ±³Ã¼¸¦ Áö¿øÇÕ´Ï´Ù. LOAD ÀÛ¾÷ Áß¿¡´Â LOAD ÀÛ¾÷¿¡
»ç¿ëÇÒ ¸Å°³(intermediate) Å×À̺íÀ» »ý¼ºÇÕ´Ï´Ù. µ¥ÀÌÅÍ ÆÄÀÏ ´ë½Å CURSOR ŸÀÔµµ
»ç¿ë °¡´ÉÇÕ´Ï´Ù. ±× ¿Ü¿¡µµ ´ÙÀ½°ú °°Àº ´Ù¾çÇÑ ¿É¼ÇµéÀÌ ÀÖ½À´Ï´Ù.
- WARNINGCOUNT : LOAD¸¦ ¾ðÁ¦ ÁßÁöÇÒ Áö¸¦ Á¤ÇØÁÝ´Ï´Ù. n ¹ø° °æ°í¹ß»ý ÈÄ ·Îµå ÀÛ¾÷Àº ÁßÁöµË´Ï´Ù.
- CPU_PARALLELISM : CPUÀÇ degree of parallelismÀ» ÁöÁ¤ÇÕ´Ï´Ù. ±âº»°ªÀº DB2°¡ ÀÚüÀûÀ¸·Î ÀûÀýÇÑ °ªÀ» ÆÇ´ÜÇÏ¿© »ç¿ëÇÕ´Ï´Ù.
- DISK_PARALLELISM : µð½ºÅ©ÀÇ degree of parallelismÀ» ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ °ªÀº »ý¼ºÇÒ ¾²·¹µåÀÇ ¼ö¸¦ °áÁ¤ÇÕ´Ï´Ù. ±âº»°ªÀº DB2°¡ ÀÚüÀûÀ¸·Î ÀûÀýÇÑ °ªÀ» ÆÇ´ÜÇÏ¿© »ç¿ëÇÕ´Ï´Ù.
- DATA BUFFER : LOAD ÀÛ¾÷¿¡ »ç¿ëÇÒ 4K ÆäÀÌÁö ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
- TEMPFILES PATH : LOAD ÀÛ¾÷ Áß »ý¼ºÇÒ ¸Å°³Å×À̺íÀÌ »ý¼ºµÉ À§Ä¡¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
- FOR EXCEPTION : ¹®Á¦ ÇàÀÌ µé¾î°¥ Å×À̺íÀ» ÁöÁ¤ÇÕ´Ï´Ù.
- DUMPFILE : °ÅºÎµÈ ÇàÀÇ ¿¡·¯ ³»¿ëÀ» ±â·ÏÇϴµ¥ »ç¿ëµÉ ÆÄÀÏ ¸íÀ» ÁöÁ¤ÇÕ´Ï´Ù.
- NOROWWARNING : °ÅºÎµÈ Çà¿¡ ´ëÇÑ °æ°í¸¦ ±â·ÏÇÏÁö ¾Êµµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.
LOAD´Â LOAD°úÁ¤ Áß¿¡ »ý¼ºµÇ´Â ÆäÀÌÁöÀÇ Àüü °ø°£À» ÁöÁ¤ÇÒ ¼ö ÀÖ¾î ¼º´ÉÆ©´×À»
Áö¿øÇÕ´Ï´Ù.
- PAGEFREESPACE : °¢ µ¥ÀÌÅÍ ÆäÀÌÁöÀÇ ¿©À¯ºñÀ²(%)À» ÁöÁ¤ÇÕ´Ï´Ù. ÀϹÝÀûÀ¸·Î´Â DB2°¡ °áÁ¤Çϵµ·Ï µÓ´Ï´Ù.
- INDEXFREESPACE : °¢ À妽º ÆäÀÌÁöÀÇ ¿©À¯ºñÀ²(%)À» ÁöÁ¤ÇÕ´Ï´Ù. ÀϹÝÀûÀ¸·Î´Â DB2°¡ °áÁ¤Çϵµ·Ï µÓ´Ï´Ù.
- TOTALFREESPACE : ¿©À¯°ø°£À¸·Î Ãß°¡µÇ´Â Å×À̺í Å©±âÀÇ ºñÀ²(%)
´Ù¸¥ ¿É¼Çµé¿¡ ´ëÇؼ´Â DB2 UDB Data Movement Utilities Guide and Reference¸¦
ÂüÁ¶ÇϽñ⠹ٶø´Ï´Ù.
À̹ø¿£ ÀÏ»ó ÀÛ¾÷¿¡¼ LOAD°¡ ¾î¶»°Ô »ç¿ëµÇ´ÂÁö¿¡ ´ëÇØ »ìÆ캸°Ú½À´Ï´Ù.
IMPORTó·³, LOAD¸¦ È£ÃâÇÏ´Â µ¥´Â GUI¸¦ »ç¿ëÇÏ´Â ¹æ¹ý, ¸í·É¾î¸¦ »ç¿ëÇÏ´Â ¹æ¹ý,
±×¸®°í API¸¦ ÅëÇÏ´Â ¹æ¹ýÀÇ 3°¡Áö°¡ ÀÖ½À´Ï´Ù. ¿©±â¼´Â GUI¿Í ¸í·É¾î¸¦ ÅëÇÑ
¹æ¹ý¸¸À» ¼³¸íÇÏ°Ú½À´Ï´Ù.
- GUI¸¦ »ç¿ëÇÏ´Â ¹æ¹ý
Example .1 - Å×ÀÌºí¿¡ del ÆÄÀÏÀ» LOAD ÇÕ´Ï´Ù.
Import ¿¹Á¦¿¡ »ç¿ëÇÑ employee.del ÆÄÀÏÀ» »ç¿ëÇϵµ·Ï ÇÏ°Ú½À´Ï´Ù.
Á¦¾î¼¾Å͸¦ ÅëÇØ ¼öÇàÇϱâ À§ÇØ
"½ÃÀÛ" --> "ÇÁ·Î±×·¥" --> "IBM DB2" --> "ÀÏ¹Ý °ü¸® µµ±¸" --> "Á¦¾î¼¾ÅÍ"¸¦
Ŭ¸¯ÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ¸ñ·Ï¿¡¼ sample À» ¼±ÅÃÇÕ´Ï´Ù. Ç¥½ÃµÈ Å×À̺í Áß EMPLOYEE
Å×À̺íÀ» ¿À¸¥ÂÊ Å¬¸¯Çؼ ³ªÅ¸³ª´Â ¸Þ´º¿¡¼ "load"¸¦ ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 12 Á¦¾î¼¾Å͸¦ »ç¿ëÇÑ load
µ¥ÀÌÅ͸¦ append ¸ðµå·Î ÇÒ °ÍÀÎÁö, replace ¸ðµå·Î ÇÒ °ÍÀÎÁö¸¦ ¼±ÅÃÇÒ ¼ö ÀÖÀ¸¸ç,
append ¸ðµå·Î ¼öÇà ÇÒ °æ¿ì¿¡´Â Àб⸦ Çã¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
±×¸². 13 Append / Replace ¼±ÅÃ
µ¥ÀÌÅÍ ÆÄÀÏ ¸í°ú ¸Þ½ÃÁö ÆÄÀϸíÀ» ÀÔ·ÂÇÏ°í, µ¥ÀÌÅÍ ÆÄÀÏÀÇ Çü½ÄÀ» ¼±ÅÃÇÕ´Ï´Ù.
±×¸®°í ·Îµå ÇÒ µ¥ÀÌÅͺ£À̽º°¡ ·ÎÄÿ¡ ÀÖ´ÂÁö remote¿¡ ÀÖ´ÂÁöµµ ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 14 °æ·Î¿Í ÆÄÀÏ¸í ¼³Á¤
À̹ø ¿¹Á¦¿¡¼´Â BONUS ¿Í COMM Ä®·³À» Á¦¿ÜÇÑ ³ª¸ÓÁö Ä®·³¸¸À» ·ÎµåÇϵµ·Ï ÇÏ°Ú½À´Ï´Ù.
±×¸². 15 ·Îµå¿¡ Æ÷ÇÔµÉ Ä®·³ ¼±ÅÃ
¼º´É¿¡ ¿µÇâÀ» ÁÙ ¼ö ÀÖ´Â ¿É¼ÇµéÀÌ ÀÖ½À´Ï´Ù. ÀÌ ¿¹Á¦¿¡¼´Â ±âº»°ªÀ» »ç¿ëÇϵµ·Ï
ÇÏ°Ú½À´Ï´Ù.
±×¸². 16 ¼º´É°ú Åë°èÁ¤º¸
·Îµå ´Ü°è¿¡¼ º¹±¸¿¡ °ü·ÃÇÑ ¼±ÅÃÀ» ÇÏ°Ô µË´Ï´Ù. ±âº»°ªÀ» »ç¿ëÇϵµ·Ï ÇÏ°Ú½À´Ï´Ù.
±×¸². 17 Fail, º¹±¸ ¼±ÅÃ
CPU parallelism, ´ýÇÁÆÄÀÏ µîÀÇ ±âŸ ¿É¼ÇÀ» ¼±ÅÃÇÕ´Ï´Ù.
±×¸². 18 °í±Þ ¿É¼Ç ¼±ÅÃ
¸¶Áö¸· ȸ鿡¼´Â ±âº»°ªÀ» ¼±ÅÃÇÏ°í "Finish"¸¦ ¼±ÅÃÇÏ°Ú½À´Ï´Ù.
±×¸². 19 ½ºÄÉÁÙ / Áï½Ã ½ÇÇà ¼±ÅÃ
½ÇÇàÀÌ ¿Ï·áµÇ¸é ¼º°ø¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù.
±×¸². 20 ¼º°ø ¸Þ½ÃÁö
Employee.msg ÆÄÀÏÀ» ¿¾îº¸¸é ÀÐÀº Çà¼ö, °Ç³Ê¶Ú Çà¼ö, °ÅºÎµÈ Çà¼ö, »èÁ¦µÈ Çà¼ö,
commit µÈ Çà ¼ö µîÀ» È®ÀÎ ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- ¸í·É âÀ» »ç¿ëÇÏ´Â ¹æ¹ý
GUI¸¦ ÅëÇÑ ¹æ¹ý°ú °°Àº ³»¿ëÀ» ¸í·É âÀ» ÅëÇØ ¼öÇàÇÏ´Â ¹ýÀ» »ìÆì º¸°Ú½À´Ï´Ù.
¸í·É¾î´Â ´ÙÀ½°ú °°½À´Ï´Ù.
CONNECT TO SAMPLE;
LOAD FROM "E: mp1employee.del" OF DEL METHOD P (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)
MESSAGES "E: mp1employee.msg"
INSERT INTO ADMINISTRATOR.EMPLOYEE
(EMPNO, FIRSTNME, MIDINIT, LASTNAME, WORKDEPT, PHONENO, HIREDATE, JOB, EDLEVEL, SEX, BIRTHDATE, SALARY)
COPY NO INDEXING MODE AUTOSELECT;
CONNECT RESET;
|
XpertMon for DB2 UDB V2
DB »ç¾÷ºÎ
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail : hjlee@iteg.co.kr
URL : http://iteg.co.kr
|
|
|