°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
ÇÔ¼ö ±¸¹®
db2ext.TextSearch( IN query VARCHAR(4096), IN indexSchema VARCHAR(128), IN indexName VARCHAR(128), IN resultFirstRow INTEGER, IN resultNumberRows INTEGER, IN scoringFlag INTEGER, IN searchTermCountsFlag INTEGER, OUT searchTermCounts VARCHAR(4096), OUT totalNumberOfResults INTEGER )
ÇÔ¼ö ¸Å°³º¯¼ö
´ÙÀ½Àº ÀÔ·Â ¸Å°³º¯¼öÀÔ´Ï´Ù.
À̸¦ Äõ¸® °á°ú ¸ñ·ÏÀÇ ÃÖ´ë Ç÷¡±× Å©±â¸¦ ÆÇº°ÇÏ´Â Äõ¸®ÀÇ "°á°ú Á¦ÇÑ" Ç¥Çö½Ä°ú È¥µ¿ÇÏÁö ¸¶½Ê½Ã¿À.
°ªÀº 0 ÀÌ»óÀ̾î¾ß ÇÕ´Ï´Ù. ¿©±â¼ 0Àº ¸ðµç °á°ú¸¦ ¸®ÅÏÇØ¾ß ÇÔÀ» ÀǹÌÇÕ´Ï´Ù.
Âü°í |
---|
´õ Å« °á°ú ¼¼Æ®°¡ ¿äûµÉ °æ¿ì, Àӽà »ç¿ëÀÚ Å×ÀÌºí ½ºÆäÀ̽º°¡ »ç¿ë °¡´ÉÇÑÁö È®ÀÎÇϽʽÿÀ. »ç¿ë °¡´ÉÇÑ °ÍÀÌ ¾øÀ¸¸é, Å×ÀÌºí ½ºÆäÀ̽º¸¦ ÀÛ¼ºÇϽʽÿÀ. ´ÙÀ½ ¿¹´Â UNIX Ç÷§Æû¿¡¼ Å×ÀÌºí ½ºÆäÀ̽º¸¦ ÀÛ¼ºÇÕ´Ï´Ù. db2 "create user temporary tablespace tempts managed by system using('/work/tempts.ts')" |
ÇÔ¼ö ¸Å°³º¯¼ö
´ÙÀ½Àº Ãâ·Â ¸Å°³º¯¼öÀÔ´Ï´Ù.
ÀÚ¼¼ÇÑ Á¤º¸´Â searchTermCountsFlag¸¦ ÂüÁ¶ÇϽʽÿÀ.
¶ÇÇÑ Äõ¸®¿¡¼ STOP SEARCH AFTER ¶Ç´Â RESULT LIMITÀ» SCORE ±¸¹®°ú ÇÔ²² »ç¿ëÇÏ´Â °æ¿ì ÀÌ ¼ö¸¦ ´õ ÀÌ»ó ½Å·ÚÇÒ ¼ö ¾ø½À´Ï´Ù.
¿ëµµ
½ºÅä¾îµå ÇÁ·Î½ÃÀú¿¡¼ ¸®ÅÏÇÑ °á°ú ¼¼Æ®ÀÇ Ä÷³Àº DB2TEXT CREATE INDEX ¸í·ÉÀÇ RESULT COLUMNS ¿É¼Ç¿¡¼ Á¦°øÇÕ´Ï´Ù. scoringFlag=1À̸é DOUBLE À¯ÇüÀÇ Ä÷³ÀÌ Ãß°¡µË´Ï´Ù. ÀÌ Ä÷³¿¡´Â SCORE °ªÀÌ µé¾î ÀÖ½À´Ï´Ù.
ù ¹øÂ° Äõ¸®¿Í µ¿ÀÏÇÑ ¹®ÀÚ¿·Î µÎ ¹øÂ° Äõ¸®ÀÇ ¼º´ÉÀ» Áõ°¡½ÃŰ·Á¸é ´ÙÀ½ ¿É¼ÇÀ» »ç¿ëÇϽʽÿÀ. totalNumberOfResults°¡ ÇÊ¿äÇÏÁö ¾ÊÀº ´Ù¸¥ Ä¿¼ â¿¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
°Ë»öÀ» À§ÇØ ¿Ã¹Ù¸¥ ³ëµå¿¡ ¿¬°áµÇ¾ú´ÂÁö È®ÀÎÇÏ·Á¸é DB2NODE ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.
UNIXÀÇ °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
export DB2NODE=<no>
¸ðµç ¹°¸®Àû ³ëµå°¡ µ¿±âÈ ½Ã°£À» °®´Â °ÍÀÌ ¸Å¿ì Áß¿äÇÑ »çÇ×ÀÓÀ» Âü°íÇϽʽÿÀ.
WindowsÀÇ °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
set DB2NODE= <no>
Âü°í |
---|
ÀνºÅϽº ¼ÒÀ¯ÀÚ ID¿Í ´Ù¸¥ ºÐ¸®(fenced) »ç¿ëÀÚ ID´Â ÆÄƼ¼ÇµÈ µ¥ÀÌÅͺ£À̽º¿¡¼´Â À¯È¿ÇÏÁö ¾Ê½À´Ï´Ù. |