IBM å
(C) IBM Corp. 2000

Net Search Extender

°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼­

DB2 º¹Á¦¸¦ »ç¿ëÇÏ´Â ÁõºÐ À妽º °»½ÅÀ¸·Î º°Äª¿¡ ´ëÇÑ ÅØ½ºÆ® À妽º ÀÛ¼º

º¹Á¦ ĸÃÄ Å×À̺íÀ» »ç¿ëÇÑ º°Äª¿¡ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇϱâ Àü¿¡ ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.

Âü°í

´ÙÀ½ ´Ü°è´Â ÇÁ·Î¼¼½ºÀÇ °³¿ä¸¸ Á¦°øÇÏ¸ç ¿¹Á¦´Â ¾ø½À´Ï´Ù.

  1. ¸ðµç ¼­¹ö Á¤ÀÇ ¹× ·¦ÆÛ Á¤ÀÇ¿¡ ´ëÇÑ DB2 Æä´õ·¹ÀÌÆ¼µå µ¥ÀÌÅͺ£À̽º¸¦ ¼³Á¤ÇϽʽÿÀ.
  2. ¸®¸ðÆ® ¼­¹öÀÇ º¹Á¦ Á¦¾î Å×ÀÌºí ¹× Ä¸ÃÄ ÇÁ·Î±×·¥À» ¼³Á¤ÇϽʽÿÀ. ¿©±â¿¡ º°Äª¿¡ ´ëÇÑ ¼Ò½º Å×À̺íÀÌ ÀÖ½À´Ï´Ù. DB2 º¹Á¦ ¾È³» ¹× ÂüÁ¶¼­, ¹öÀü 8ÀÇ Á¦ 2 Àå "º¹Á¦ ¼³Á¤"À» ÂüÁ¶ÇϽʽÿÀ. DB2°¡ º°ÄªÀ» ÀÚµ¿À¸·Î ÀÛ¼ºÇÏÁö ¾ÊÀ¸¸é, ´ÙÀ½ Å×À̺íÀÇ ½ºÅ°¸¶ À̸§ Áß Çϳª¸¦ »ç¿ëÇÏ¿© Æä´õ·¹ÀÌÆ¼µå DB2 µ¥ÀÌÅͺ£À̽º¿¡ º°ÄªÀ» ÀÛ¼ºÇϽʽÿÀ.

    ÀÌ ´Ü°è ÀÌÈÄ¿¡ º¹Á¦ Á¦¾î Å×ÀÌºí¿¡ ´ëÇÑ º°ÄªÀ» Æä´õ·¹ÀÌÆ¼µå DB2 µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â ÇϳªÀÇ "ĸó Á¦¾î ½ºÅ°¸¶"¿¡¼­ º°ÄªÀ¸·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ½ºÅ°¸¶ À̸§Àº DB2TEXT CREATE INDEX ¸í·ÉÀÇ °æ¿ì¿¡ Áß¿äÇÕ´Ï´Ù.

  3. º¹Á¦ ¼Ò½º·Î Å×À̺íÀ» µî·ÏÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 º¹Á¦ ¾È³» ¹× ÂüÁ¶¼­, ¹öÀü 8ÀÇ Á¦ 3 Àå "º¹Á¦ ¼Ò½º·Î Å×ÀÌºí ¹× ºä µî·Ï"À» ÂüÁ¶ÇϽʽÿÀ. ÀÛ¼ºµÉ À妽ºÀÇ º°Äª µî·Ï¿¡ ´ëÇÑ Á¦ÇÑ»çÇ×Àº *** ÆäÀÌÁö¸¦ ÂüÁ¶ÇϽʽÿÀ.
  4. DB2°¡ µî·Ï ´Ü°è¿¡¼­ º°ÄªÀ» ÀÚµ¿À¸·Î ÀÛ¼ºÇÏÁö ¾ÊÀº °æ¿ì, º¹Á¦ ĸÃÄ Å×ÀÌºí¿¡ ´ëÇÑ º°ÄªÀ» Æä´õ·¹ÀÌÆ¼µå µ¥ÀÌÅͺ£À̽º¿¡ ÀÛ¼ºÇϽʽÿÀ. º¹Á¦ ĸó Å×À̺íÀº µ¥ÀÌÅÍ º¯°æ(CD) Å×ÀÌºí ¶Ç´Â µ¥ÀÌÅÍ ÀϰüµÈ º¯°æ(CCD) Å×À̺íÀÔ´Ï´Ù. ÀÌ º°ÄªÀº DB2TEXT CREATE INDEX ¸í·ÉÀÇ ¸Å°³º¯¼öÀÔ´Ï´Ù.

    Ä÷³ À̸§ IBMSNAP_OPERATION, IBMSNAP_COMMITSEQ, IBMSNAP_INTENTSEQ ¹× ±âº» Ű Ä÷³ À̸§Àº º¯°æÇÏÁö ¸¶½Ê½Ã¿À.

  5. DB2 º¹Á¦ ¼Ò½º¸¦ »ç¿ë ÁßÀÎ °æ¿ì, ĸÃÄ ÇÁ·Î±×·¥ÀÌ ½ÇÇà ÁßÀÎÁö È®ÀÎÇϽʽÿÀ. Capture ÇÁ·Î±×·¥¿¡ ÄÝµå ½ºÅ¸Æ®(cold start)¸¦ »ç¿ëÇÏÁö ¸¶½Ê½Ã¿À. ÄÝµå ½ºÅ¸Æ®¸¦ »ç¿ëÇÒ °æ¿ì IBMSNAP_SIGNAL Å×ÀÌºí¿¡¼­ APPLY_QUAL LIKE 'NSE%'¿¡ ´ëÇÑ ¸ðµç ÇàÀ» ´Ù½Ã »ðÀÔÇØ¾ß ÇÕ´Ï´Ù. ´ÙÀ½ SQL¹®¿¡¼­ ¼öÇà ¹æ¹ýÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
    INSERT INTO <capture control schema>.IBMSNAP_SIGNAL
    SELECT CURRENT TIMESTAMP, 'CMD', 'CAPSTART', MAP_ID, 'P' 
    FROM <capture control schema>.IBMSNAP_PRUNCNTL
    WHERE APPLY_QUAL LIKE 'NSE%';
    
  6. º¹Á¦¸¦ »ç¿ëÇÏ´Â º°Äª¿¡ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ¿¹¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
    DB2TEXT
    CREATE INDEX <indexname> FOR TEXT ON <nickname> (< text column>)
    REPLICATION CAPTURE TABLE <capture nickname>
    CONTROL TABLE SCHEMA <capture control schema>
    


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]