µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¿¡ »õ ±¸¼º Ãß°¡
»õ ±¸¼ºÀ» µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¿¡ Ãß°¡ÇÏ·Á¸é ´ÙÀ½ ±¸¹®À» ÂüÁ¶ÇϽʽÿÀ. ¿¹¸¦ µé¾î, ¿ÀºêÁ§Æ® o1Àº col1, col2, lastupdate, col3 ¿À» Æ÷ÇÔÇÏ´Â Å×À̺í R1À¸·Î ±¸¼ºµË´Ï´Ù. lastupdate°¡ nÀÏ ÀüÀ̰í col1ºÎÅÍ 10ÀÚ±îÁöÀÇ ¸ðµç ¿ÀºêÁ§Æ®¸¦
»èÁ¦Çϵµ·Ï µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¸¦ ±¸¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
DB2 ¸í·É ÇÁ·ÒÇÁÆ®¸¦ ¿©½Ê½Ã¿À.
- ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
db2 insert into cleanconf (objectname, type, statement, namearg, sequence,
daysarg) values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and
(days(CURRENT TIMESTAMP) - days(lastupdate)) > ?', 'no', 1, 'yes')
´ÙÀ½ SQL¹®À» ½ÇÇàÇϽʽÿÀ.
insert into cleanconf (objectname, type, statement, namearg, sequence,
daysarg) values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and (days(CURRENT TIMESTAMP) -
days(lastupdate)) > ?', 'no', 1, 'yes')
- SQLPlus ¸í·ÉâÀ» ¿©½Ê½Ã¿À.
- ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
insert into cleanconf (objectname, type, statement, namearg, sequence, daysarg)
values ('o1', 'obsolete', 'delete from r1 where col1 > 10 and (sysdate -
lastupdate) > ?', 'no', 1, 'yes')
¿©±â¼?´Â ´ÙÀ½ ¸í·ÉÇà¿¡¼ -days ¸Å°³º¯¼ö·Î ¹Ù²ò´Ï´Ù. 'no'´Â ¸í·É¹®¿¡¼ name ¸Å°³º¯¼ö°¡ »ç¿ëµÇÁö ¾ÊÀ½À» ³ªÅ¸³À´Ï´Ù. 'yes'´Â ¸í·É¹®¿¡¼ -days ¸Å°³º¯¼ö°¡ »ç¿ëµÊÀ» ³ªÅ¸³À´Ï´Ù.
'obsolete'´Â ¿ÀºêÁ§Æ® o1ÀÇ Á¤¸® À¯ÇüÀ» ¼³¸íÇÕ´Ï´Ù. ´Ù¸¥ ´Ü¾î¸¦ »ç¿ëÇÒ ¼öµµ ÀÖÁö¸¸, µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼ ¸í·ÉÀ» ½ÇÇàÇÒ ¶§ -type Àμö¿¡ ÀÖ´Â ´Ü¾î¿Í °°Àº ´Ü¾î¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
¿¹
µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼ ¸í·ÉÀ» ½ÇÇàÇÏ¿© »õ Å×ÀÌºí¿¡¼ 2ÀÏÀÌ Áö³ ·¹Äڵ带 »èÁ¦ÇÏ·Á¸é ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
dbclean -object o1 -db dbname -type obsolete -days 2 -loglevel 1
dbclean -object o1 -db dbname -type obsolete -days 2 -loglevel 1 -dbtype oracle
-dbuser user -dbpasswd password
. dbclean.sh -object o1 -db dbname -type obsolete -days 2 -loglevel 1
. dbclean.sh -object o1 -db dbname -type obsolete -days 2 -loglevel 1 -dbtype oracle -dbuser user -dbpasswd password
CLNWCSDB DATABASE(dbname) SCHEMA(schema_name) PASSWD(instance_password) OBJECT('o1')
TYPE('obsolete') LOGLEVEL(1) DAYS(2)
ÁÖ: Oracle dbname ¸Å°³º¯¼ö·Î´Â host:port:sid
¸¦ »ç¿ëÇϽʽÿÀ(¿¹: myhost:1521:mydb).
