¾È³çÇϼ¼¿ä. DB2 ¹× XpertMon »ç¿ëÀÚ ¿©·¯ºÐ!
¢ß ¾ÆÀÌƼ¿¢½ºÆÛÆ®±×·ì DB »ç¾÷ºÎÀÔ´Ï´Ù.
À̹øÁÖ¿¡´Â UDB¿¡¼ Å×À̺íÀÇ µ¥ÀÌÅ͸¦ ·Î±×¸¦ »ç¿ëÇÏÁö ¾Ê°í, °£ÆíÇÏ°Ô Truncate ÇÏ´Â
¸î°¡Áö Tip¿¡ ´ëÇؼ »ìÆ캸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
Å×À̺íÀÇ µ¥ÀÌÅ͸¦ »èÁ¦ÇÏ´Â ¸î°¡Áö ¹æ¹ý
DB2 UDB ¿¡¼ Å×À̺íÀ» Truncate ÇÏ´Â ¸î°¡Áö ¹æ¹ýÀÌ ÀÖ½À´Ï´Ù.
DELETE
°¡Àå ÀϹÝÀûÀ¸·Î »ç¿ëÇÏ´Â ¹æ¹ýÀº delete ÀÔ´Ï´Ù.
¿©±â¿¡´Â ¸î°¡Áö ´ÜÁ¡ÀÌ ÀÖ½À´Ï´Ù.
¸ÕÀú ·Î±×¸¦ »ç¿ëÇÕ´Ï´Ù. »èÁ¦ÇØ¾ß ÇÏ´Â µ¥ÀÌÅÍ°¡ ¸¹´Ù¸é ·Î±×ÀÇ ¾çµµ °í·ÁÇØ¾ß ÇÕ´Ï´Ù.
±×¸®°í ½Ã°£ÀÌ ¸¹ÀÌ ¼Ò¿äµË´Ï´Ù.
°Ô´Ù°¡ ÀÌ Å×ÀÌºí¿¡ Àû¿ëµÇ¾î ÀÖ´Â delete Æ®¸®°Å°¡ ÀÖ´Ù¸é ÇÔ²² ¿µÇâÀ» ¹Þ°Ô µË´Ï´Ù.
LOAD REPLACE
replace ¹æ½ÄÀ¸·Î LOAD ¸¦ ¼öÇàÇÕ´Ï´Ù.
- LOAD FROM MYEMPTYFILE OF DEL REPLACE INTO MYTABLE
MYEMPTYFILEÀº ºó ÆÄÀÏÀ̸§ÀÔ´Ï´Ù.
ÀÌ·¸°Ô ÇÏ¸é ·Î±×¸¦ »ç¿ëÇÏÁö ¾ÊÀ¸¸é¼, ÀÛ¾÷½Ã°£µµ ª½À´Ï´Ù.
±×·¯³ª, ÀÌ Å×ÀÌºí¿¡ constraint °¡ °É·Á ÀÖ´Ù¸é, check-pending ÀÌ °É¸®°Ô µË´Ï´Ù.
ÀÌ·± °æ¿ì SET INTEGRITY ¸í·É¾î¸¦ ¼öÇàÇÏ¿© Å×À̺íÀ» Á¤»ó »óÅ·Π¸¸µé¾î¾ß ÇÕ´Ï´Ù.
V8.1 ¿¡¼´Â ¾Æ·¡¿Í °°ÀÌ CURSOR ¸¦ ÀÌ¿ëÇÑ LOAD ¸¦ ¼öÇàÇصµ µË´Ï´Ù.
- DECLARE MYCURSOR CURSOR FOR SELECT * FROM MYTABLE WHERE 1=0
- LOAD FROM MYCURSOR OF CURSOR REPLACE INTO MYTABLE
ALTER TABLE - ACTIVATE NOT LOGGED INITIALLY
¼¼ ¹ø° ¹æ¹ýÀº Alter TableÀÇ ACTIVATE NOT LOGGED INITIALLYÀýÀ» »ç¿ëÇÏ´Â °ÍÀÔ´Ï´Ù.
- ALTER TABLE MYTABLE ACTIVATE NOT LOGGED INITIALLY WITH EMPTY TABLE
ÀÌ ¸í·É¾î¸¦ »ç¿ëÇϸé, load replace ¿Í ¸¶Âù°¡Áö·Î ·Î±×¸¦ »ç¿ëÇÏÁö ¾ÊÀ¸¸é¼,
ªÀº ½Ã°£¿¡ Å×À̺íÀ» truncate ÇÒ ¼ö ÀÖ°í, constraint µµ º¸È£ÇÒ ¼ö ÀÖ½À´Ï´Ù.
´Ü, ÀÌ ¹æ¹ýÀ» »ç¿ëÇÏ·Á¸é Å×À̺íÀ» ÀÛ¼ºÇÒ ¶§ NOT LOGGED INITIALLY ·Î ÀÛ¼ºÇÏ¿©¾ß ÇÕ´Ï´Ù.
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