DB2 Data Links Manager ºü¸¥ ½ÃÀÛ


3. DB2 UDB µ¥ÀÌÅͺ£À̽º¸¦ ÀÌ¿ëÇÑ Data Links ¼­¹ö ·¹Áö½ºÅÍ

ÀÌÀü¿¡ DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Á¤ÀÇµÈ ¿ø°Ý DB2 UDB µ¥ÀÌÅͺ£À̽º°¡ ÀÖ´Â Data Links ¼­¹ö¸¦ µî·ÏÇϽʽÿÀ.

  1. ÀÛ¼ºÇÑ VALIDATE ÀνºÅϽº¿¡¼­ ½Ã½ºÅÛ °ü¸®(SYSADM) ±ÇÇÑÀ» °¡Áø À¯È¿ÇÑ DB2 »ç¿ëÀÚ ID·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ. ±âº»°ªÀ¸·Î, ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ 1Â÷ ±×·ì¿¡ ¼ÓÇÏ´Â ¸ðµç »ç¿ëÀÚ´Â ÀνºÅϽº¿¡ ´ëÇØ SYSADM ±ÇÇÑÀ» °¡Áý´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº ¼­¹öÀÇ ºü¸¥ ½ÃÀÛ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.
  2. ´ÙÀ½°ú °°ÀÌ db2profile ¶Ç´Â db2cshrc ½ºÅ©¸³Æ®¸¦ ¼öÇàÇϽʽÿÀ.
       . INSTHOME/sqllib/db2profile    (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì)
       source INSTHOME/sqllib/db2cshrc (C ½©ÀÇ °æ¿ì)
    

    ¿©±â¼­ INSTHOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.

  3. db2start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇϽʽÿÀ.
  4. ´ÙÀ½ ¸í·É Áß Çϳª¸¦ ÀÔ·ÂÇÏ¿© DATALINK µ¥ÀÌÅÍ À¯Çü¿¡ ÀÇÇØ ¸µÅ©µÇ´Â ÆÄÀÏÀ» Á¦¾îÇÒ Data Links ¼­¹ö¸¦ µî·ÏÇϽʽÿÀ.
       db2 "add datalinks manager for database database_alias==>
         using node hostname port port_number" //JFS
    -OR-
       db2 "add datalinks manager for database database_alias using==>
         cell cell-name dlminstance instance-name" //DCE-DFS
    

    ¿©±â¼­,

    JFS ¿¹¿¡¼­´Â ´ÙÀ½ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

       db2 "add datalinks manager for database staff using==>
         node dlmserver.services.com port 50100"
    

    DCE-DFS ¿¹¿¡¼­´Â ´ÙÀ½ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

       db2 "add datalinks manager for database staff using==>
         cell services.com dlminstance dlmadmin"
    
  5. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© STAFF µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.
       db2 connect to staff
    
  6. ´ÙÀ½ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© EMPLOYEE Å×ÀÌºí¿¡ Ç׸ñÀ» »ðÀÔÇϽʽÿÀ.
       db2 "insert into employee values (001,'Paul','Smith',==>
         dlvalue('http://hostname/controlled_file'))"
    

    ¿©±â¼­,

    DCE-DFS ȯ°æ¿¡¼­, ÀÌ ¿¹¿¡¼­ »ç¿ëµÈ URLÀ» dfs://.../cellname/fs/...·Î ¹Ù²Ù½Ê½Ã¿À. ÀÌ ¿¹¿¡¼­, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®

       db2 "insert into employee values (001,'Paul','Smith',==>
         dlvalue('dfs://.../services.com/test/pictures/psmith.bmp'))"
    
  7. ·Î±×¾Æ¿ôÇϽʽÿÀ.


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