?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
????? UDB?? ???? ???? ??? ???? ??, ???? Truncate ??
??? Tip? ??? ????? ?????.

---

???? ???? ???? ??? ??
DB2 UDB ?? ???? Truncate ?? ??? ??? ????.
DELETE
?? ????? ???? ??? delete ???.

• DELETE FROM MYTABLE

???? ??? ??? ????.
?? ??? ?????. ???? ?? ???? ??? ??? ?? ???? ???.
??? ??? ?? ?????.
??? ? ???? ???? ?? 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