(C) IBM Corp. 2000
Net Search Extender
°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
¿ä¾à |
---|
- ½Ã±â
- µ¥ÀÌÅͺ£À̽º¿¡¼ ´õ ÀÌ»ó ÅØ½ºÆ® °Ë»öÀ» ÀÛ¼ºÇÒ Çʿ䰡 ¾øÀ» ¶§
- ¸í·É
- DISABLE DATABASE FOR TEXT
- ±ÇÇÑ ºÎ¿©
- µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ DBADM
|
DB2 Net Search Extender°¡ »ç¿ëÇÒ µ¥ÀÌÅͺ£À̽º°¡ ÁغñµÇ¸é ƯÁ¤ °ü¸® º¯°æ»çÇ×ÀÌ ÀÛ¼ºµË´Ï´Ù.
ÀÌ ÀýÀº ÀÌ ÇÁ·Î¼¼½º¸¦ º¹¿øÇÏ´Â µ¥ µµ¿òÀÌ µÇ´Â ÇÔ¼ö¸¦ ¼³¸íÇÕ´Ï´Ù.
¿¬°áµÈ µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏÁö ¾ÊÀ¸·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2text DISABLE DATABASE FOR TEXT
µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë ºÒ°¡´ÉÇÑ °æ¿ì, ´ÙÀ½ ¿ÀºêÁ§Æ®µµ »èÁ¦µË´Ï´Ù.
- µ¥ÀÌÅͺ£À̽º°¡ »ç¿ë °¡´ÉÇßÀ» ¶§ ÀÛ¼ºµÈ DB2 Net Search Extender īŻ·Î±× ºä
- DB2 Net Search ExtenderÀÇ SQL ÇÔ¼ö(UDF) ¼±¾ð
µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ë ¾ÈÇÔÀ¸·Î ¼³Á¤ÇÏ°í ¸ðµç ÅØ½ºÆ® À妽º¸¦ Á¦°ÅÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
db2text DISABLE DATABASE for text force
|
---|
Âü°í
µ¥ÀÌÅͺ£À̽º¿¡¼ Á¤ÀÇµÈ ÅØ½ºÆ® À妽º°¡ ÀÖÀ» °æ¿ì, µ¥ÀÌÅͺ£À̽º »ç¿ë ¾ÈÇÔÀº
½ÇÆÐµË´Ï´Ù. ÀÌ À妽ºµéÀ» Çϳª¾¿ Á¦°ÅÇÑ ´ÙÀ½ ¹®Á¦Á¡ÀÌ ¹ß»ýÇÏ´ÂÁö
È®ÀÎÇϽʽÿÀ. ÅØ½ºÆ®ÀÇ µ¥ÀÌÅͺ£À̽º »ç¿ë ¾ÈÇÔ °Á¦ ¸í·ÉÀ» »ç¿ëÇÒ °æ¿ì,
µ¥ÀÌÅͺ£À̽ºÀÇ Net Search Extender īŻ·Î±× Å×À̺íÀÌ Á¦°ÅµÊÀ» º¸ÁõÇÕ´Ï´Ù.
À妽ºÀÇ ÀϺΰ¡ ¿ÏÀüÈ÷ »èÁ¦µÇÁö ¸øÇÒ °æ¿ì¿¡´Â,
¼öµ¿À¸·Î Á¤¸®ÇØ¾ß ÇÒ ÀÚ¿øÀÌ ¿©ÀüÈ÷ ÀÖ´Ù´Â °ÍÀ» ÀǹÌÇÕ´Ï´Ù. ´ÙÀ½ÀÌ Æ÷ÇԵ˴ϴÙ.
- À妽º, ÀÛ¾÷ ¹× ij½Ã µð·ºÅ丮ÀÇ ÆÄÀÏ
- ctedem.datÀÇ ½ºÄÉÁÙ·¯ Ç׸ñ
- º¹Á¦ ĸó ¿É¼ÇÀ» »ç¿ëÇÏ¿© ÀÛ¼ºµÈ À妽º¿¡¼, ¸®¸ðÆ® µ¥ÀÌÅͺ£À̽ºÀÇ IBMSNAP_SIGNAL,
IBMSNAP_PRUNE_SET ¹×
IBMSNAP_PRUNCNTL Ç׸ñÀº ¼öµ¿À¸·Î »èÁ¦µÇ¾î¾ß
ÇÕ´Ï´Ù. ÀÌ Ç׸ñµéÀº APPLY_QUAL="NSE"||<instance name> ¹× TARGET_SERVER= <database
name> ¸í·ÉÀ» »ç¿ëÇÏ¿© ½±°Ô ½Äº°µÉ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½ ¿¹¿¡¼ ÀνºÅϽº´Â DB2ÀÌ°í µ¥ÀÌÅͺ£À̽º´Â SAMPLEÀÔ´Ï´Ù.
DELETE FROM <ccSchema>.IBMSNAP_SIGNAL
WHERE SIGNAL_INPUT_IN IN
(SELECT MAP_ID FROM <ccSchema>.IBMSNAP_PRUNCNTL
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE');
DELETE FROM <ccSchema>.IBMSNAP_PRUNCNTL
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE';
DELETE FROM <ccschema>.IBMSNAP_PRUNE_SET
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE';
|
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]