º¹Á¦ ĸó Å×À̺íÀ» »ç¿ëÇÑ º°Äª¿¡ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇϱâ Àü¿¡ ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ.
- ¸ðµç ¼¹ö Á¤ÀÇ ¹× ·¦ÆÛ Á¤ÀÇ¿¡ ´ëÇÑ DB2 Æä´õ·¹ÀÌÆ¼µå µ¥ÀÌÅͺ£À̽º¸¦ ¼³Á¤ÇϽʽÿÀ.
- ¸®¸ðÆ® ¼¹öÀÇ º¹Á¦ Á¦¾î Å×ÀÌºí ¹× Ä¸Ã³ ÇÁ·Î±×·¥À» ¼³Á¤ÇϽʽÿÀ. ¿©±â¿¡ º°Äª¿¡ ´ëÇÑ ¼Ò½º Å×À̺íÀÌ ÀÖ½À´Ï´Ù. DB2 º¹Á¦
¾È³»¼ ¹× ÂüÁ¶¼, ¹öÀü 8ÀÇ Á¦ 2 Àå "º¹Á¦ ¼³Á¤"À» ÂüÁ¶ÇϽʽÿÀ.
DB2°¡ º°ÄªÀ» ÀÚµ¿À¸·Î ÀÛ¼ºÇÏÁö ¾ÊÀ¸¸é, ´ÙÀ½ Å×À̺íÀÇ ½ºÅ°¸¶ À̸§
Áß Çϳª¸¦ »ç¿ëÇÏ¿© Æä´õ·¹ÀÌÆ¼µå DB2 µ¥ÀÌÅͺ£À̽º¿¡ º°ÄªÀ» ÀÛ¼ºÇϽʽÿÀ.
- IBMSNAP_SIGNAL
- IBMSNAP_PRUNE_SET
- IBMSNAP_PRUNCNTL
- IBMSNAP_REGISTER
- IBMSNAP_REG_SYNC(ºñDB2 ¸®¸ðÆ® ¼Ò½º Àü¿ë)
ÀÌ ´Ü°è ÀÌÈÄ¿¡ º¹Á¦ Á¦¾î Å×ÀÌºí¿¡ ´ëÇÑ º°ÄªÀ» Æä´õ·¹ÀÌÆ¼µå
DB2 µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â ÇϳªÀÇ "ĸó Á¦¾î ½ºÅ°¸¶"¿¡¼ º°ÄªÀ¸·Î
»ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ½ºÅ°¸¶ À̸§Àº DB2TEXT CREATE INDEX ¸í·ÉÀÇ °æ¿ì¿¡ Áß¿äÇÕ´Ï´Ù.
- º¹Á¦ ¼Ò½º·Î Å×À̺íÀ» µî·ÏÇϽʽÿÀ. ÀÚ¼¼ÇÑ ³»¿ëÀº
DB2 º¹Á¦ ¾È³» ¹× ÂüÁ¶¼, ¹öÀü 8ÀÇ
Á¦ 3 Àå "º¹Á¦ ¼Ò½º·Î Å×ÀÌºí ¹× ºä µî·Ï"À» ÂüÁ¶ÇϽʽÿÀ.
ÀÛ¼ºµÉ À妽ºÀÇ º°Äª µî·Ï¿¡ ´ëÇÑ Á¦ÇÑ»çÇ×Àº *** ÆäÀÌÁö¸¦ ÂüÁ¶ÇϽʽÿÀ.
- DB2°¡ µî·Ï ´Ü°è¿¡¼ º°ÄªÀ» ÀÚµ¿À¸·Î ÀÛ¼ºÇÏÁö ¾ÊÀº °æ¿ì,
º¹Á¦ ĸó Å×ÀÌºí¿¡ ´ëÇÑ º°ÄªÀ» Æä´õ·¹ÀÌÆ¼µå µ¥ÀÌÅͺ£À̽º¿¡ ÀÛ¼ºÇϽʽÿÀ.
º¹Á¦ ĸó Å×À̺íÀº µ¥ÀÌÅÍ º¯°æ(CD) Å×ÀÌºí ¶Ç´Â
µ¥ÀÌÅÍ Àϰü º¯°æ(CCD) Å×À̺íÀÔ´Ï´Ù. ÀÌ º°ÄªÀº DB2TEXT CREATE INDEX ¸í·ÉÀÇ ¸Å°³º¯¼öÀÔ´Ï´Ù.
Ä÷³ À̸§ IBMSNAP_OPERATION,
IBMSNAP_COMMITSEQ,
IBMSNAP_INTENTSEQ ¹× ±âº» Ű Ä÷³ À̸§Àº º¯°æÇÏÁö ¸¶½Ê½Ã¿À.
- 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%';
- º¹Á¦¸¦ »ç¿ëÇÏ´Â º°Äª¿¡ ÅØ½ºÆ® À妽º¸¦ ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ¿¹¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
DB2TEXT
CREATE INDEX <indexname> FOR TEXT ON <nickname> (< text column>)
REPLICATION CAPTURE TABLE <capture nickname>
CONTROL TABLE SCHEMA <capture control schema>