IBM Books
(C) IBM Corp. 2000

Net Search Extender

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

DISABLE DATABASE

ÀÌ ¸í·ÉÀº 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¸¦ »ç¿ëÇϱâ À§ÇØ µ¥ÀÌÅͺ£À̽º¿¡¼­ ¼öÁ¤µÈ ´ÙÀ½ »çÇ×ÀÌ »èÁ¦µË´Ï´Ù.

ÆÄÀÏ ½Ã½ºÅÛ ¹× °øÀ¯ ¸Þ¸ð¸®¿¡ ´ëÇÑ º¯°æ
FORCE ¿É¼ÇÀÌ »ç¿ëµÇ¸é ÀÎÅØ½º ÆÄÀÏÀº »èÁ¦µË´Ï´Ù.

FORCE ¿É¼ÇÀ» »ç¿ëÇÏ´Â °æ¿ì Ȱ¼ºÈ­µÈ À妽º ij½Ã¿¡ ´ëÇÑ Ä³½Ã°¡ »èÁ¦µË´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â DROP INDEX¸¦ ÂüÁ¶ÇϽʽÿÀ.


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