(C) IBM Corp. 2000
Net Search Extender
°ü¸® ¹× »ç¿ëÀÚ ¾È³»¼
ÀÌ ¸í·ÉÀº DB2 Net Search Extender°¡ µ¥ÀÌÅͺ£À̽º¿¡ ¼öÇàÇÑ º¯°æ»çÇ×À» ½ÇÇà Ãë¼ÒÇÕ´Ï´Ù.
±ÇÇÑ ºÎ¿©
µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ë ¾ÈÇÔÀ¸·Î ¼³Á¤ÇÏ·Á¸é µ¥ÀÌÅͺ£À̽º °ü¸®Àڷμ ÀÌ ¸í·ÉÀ» ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.
À̰ÍÀº DBADM ±ÇÇÑÀ» °¡Á®¾Æ ÇÕ´Ï´Ù.
¸í·É ±¸¹®
>>-DISABLE-DATABASE-FOR-TEXT--+-------+------------------------->
'-FORCE-'
>--+----------------------+------------------------------------><
'-|connection-options|-'
connection-options:
|--+--------------------------------------------------------------+--|
'-CONNECT-TO--database-name--+-------------------------------+-'
'-USER--userid--USING--password-'
¸í·É ¸Å°³º¯¼ö
- CONNECT TO database-name
- ÀÌ ¸í·ÉÀÇ ¸ñÇ¥ÀÎ µ¥ÀÌÅͺ£À̽º À̸§. DB2DBDFT°¡ ¼³Á¤µÇ¾î ÀÖ°í »ç¿ëÀÚ°¡ Çʼö DB2 ±ÇÇÑÀÌ ºÎ¿©µÈ »ç¿ëÀÚ ID¸¦ »ç¿ëÇÏ¿© ¸í·ÉÀ» ½ÇÇà ÁßÀ̸é
ÀÌ ¸Å°³º¯¼ö¸¦ »ý·«ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- USER userid USING password
- password¿Í userid¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.
- FORCE
- µ¥ÀÌÅͺ£À̽º¿¡¼ °Á¦·Î ¸ðµç DB2 Net Search Extender À妽º¸¦ »èÁ¦ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â DROP INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.
¿ëµµ
ÀÌ ¸í·ÉÀº ´õ ÀÌ»ó ´Ù¸¥ DB2 Net Search Extender ¸í·É¿¡¼ »ç¿ëÇÒ ¼ö ¾øµµ·Ï ¿¬°áµÈ µ¥ÀÌÅͺ£À̽º¸¦ Àç¼³Á¤ÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º¿¡ Àüü ÅØ½ºÆ® À妽º°¡ Á¸ÀçÇÒ °æ¿ì FORCE ¿É¼ÇÀ» »ç¿ëÇÏÁö
¾ÊÀ¸¸é ÀÌ ¸í·ÉÀº ½ÇÆÐÇÕ´Ï´Ù.
ÀÌ ¸í·ÉÀº DB2 ÀνºÅϽº ¼ÒÀ¯ÀڷκÎÅÍ DBADM ±ÇÇÑÀ»
Á¦°ÅÇÏÁö ¾Ê½À´Ï´Ù.
Âü°í |
---|
µ¥ÀÌÅͺ£À̽º¿¡¼ Á¤ÀÇµÈ ÅØ½ºÆ® À妽º°¡ ÀÖÀ» °æ¿ì, µ¥ÀÌÅͺ£À̽º »ç¿ë ¾ÈÇÔÀº
½ÇÆÐµË´Ï´Ù. ÀÌ À妽ºµéÀ» Çϳª¾¿ Á¦°ÅÇÑ ¹®Á¦Á¡ÀÌ ¹ß»ýÇÏ´ÂÁö
È®ÀÎÇϽʽÿÀ. ÅØ½ºÆ®ÀÇ µ¥ÀÌÅͺ£À̽º »ç¿ë ¾ÈÇÔ °Á¦ ¸í·ÉÀ» »ç¿ëÇÒ °æ¿ì,
µ¥ÀÌÅͺ£À̽ºÀÇ 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';
|
- µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ º¯°æ
- DB2 Net Search Extender¸¦ »ç¿ëÇϱâ À§ÇØ µ¥ÀÌÅͺ£À̽º¿¡¼ ¼öÁ¤µÈ ´ÙÀ½ »çÇ×ÀÌ
»èÁ¦µË´Ï´Ù.
- µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â DB2 Net Search Extender īŻ·Î±× ºä
- DB2 Net Search Extender°¡ ÀÛ¼ºÇÑ ¸ðµç µ¥ÀÌÅͺ£À̽º ¿ÀºêÁ§Æ®
- ÆÄÀÏ ½Ã½ºÅÛ ¹× °øÀ¯ ¸Þ¸ð¸®¿¡ ´ëÇÑ º¯°æ
- FORCE ¿É¼ÇÀÌ »ç¿ëµÇ¸é ÀÎÅØ½º ÆÄÀÏÀº »èÁ¦µË´Ï´Ù.
FORCE ¿É¼ÇÀ» »ç¿ëÇÏ´Â °æ¿ì Ȱ¼ºÈµÈ À妽º ij½Ã¿¡ ´ëÇÑ
ij½Ã°¡ »èÁ¦µË´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â DROP INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]