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


1. DB2 UDB ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æ ÀÛ¼º

DB2 UDB ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æ ÀÛ¼ºÀ» ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ·çÆ® ±ÇÇÑÀ» °¡Áø »ç¿ëÀÚ·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ.
  2. db2icrt ¸í·ÉÀ» »ç¿ëÇÏ¿© DB2 ¼­¹ö¿¡ ÀνºÅϽº¸¦ ÀÛ¼ºÇϽʽÿÀ. ÀÌ ÀνºÅϽº´Â DATALINK µ¥ÀÌÅÍ À¯Çü Ä÷³ÀÌ µé¾î ÀÖ´Â Å×À̺íÀÌ »óÁÖÇÒ µ¥ÀÌÅͺ£À̽º¸¦ Æ÷ÇÔÇÕ´Ï´Ù. ÀνºÅϽº ÀÛ¼º¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â °ü¸® ¾È³»¼­: °èȹÀ» ÂüÁ¶ÇϽʽÿÀ.

    ÀÌ ¿¹¿¡¼­, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE¶ó´Â ÀνºÅϽº¸¦ ÀÛ¼ºÇϽʽÿÀ.

       mkgroup testers
       mkuser pgrp='testers' groups='testers' home='/home/validate' validate
          /usr/lpp/db2_07_01/instance/db2icrt -u validate validate
    
  3. ·Î±×¾Æ¿ôÇϽʽÿÀ.
  4. ÀÛ¼ºÇÑ VALIDATE ÀνºÅϽº¿¡¼­ ½Ã½ºÅÛ °ü¸®(SYSADM) ±ÇÇÑÀ» °¡Áø À¯È¿ÇÑ DB2 »ç¿ëÀÚ ID·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ. ±âº»°ªÀ¸·Î, ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ 1Â÷ ±×·ì¿¡ ¼ÓÇÏ´Â ¸ðµç »ç¿ëÀÚ´Â ÀνºÅϽº¿¡ ´ëÇØ SYSADM ±ÇÇÑÀ» °¡Áý´Ï´Ù. ÀÚ¼¼ÇÑ ³»¿ëÀº ¼­¹öÀÇ ºü¸¥ ½ÃÀÛ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.
  5. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE ÀνºÅϽº°¡ ÇöÀç ÀνºÅϽºÀÎÁö È®ÀÎÇϽʽÿÀ.
       db2 get instance
    

    ÀÌ ¸í·ÉÀº ´ÙÀ½ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù.

        The current database manager instance is:  VALIDATE
    

    ÀÌ·¯ÇÑ Ãâ·ÂÀÌ Ç¥½ÃµÇÁö ¾ÊÀ¸¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

       set DB2INSTANCE=VALIDATE
       db2 get instance
    
  6. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE ÀνºÅϽº ±¸¼º ÆÄÀÏ¿¡¼­ DATALINKS µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º ¸Å°³º¯¼ö¸¦ YES·Î ¼³Á¤ÇϽʽÿÀ.
       db2 update dbm cfg using datalinks yes
    

    DB2 ¼­¹ö¿¡¼­ DB2 Data Links ManagerÀÇ ±â´ÉÀ» »ç¿ëÇÏÁö ¾ÊÀ¸·Á¸é DATALINKS µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º ¸Å°³º¯¼ö¸¦ no·Î ¼³Á¤ÇϽʽÿÀ.

  7. db2start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇϽʽÿÀ.
    ÁÖ:ÀνºÅϽºÀÇ µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º ÆÄÀÏÀÇ ¼³Á¤À» º¯°æÇÑ °æ¿ì, º¯°æ»çÇ×ÀÌ Àû¿ëµÇ·Á¸é ÀνºÅϽº¸¦ ÁßÁöÇÏ°í ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù(db2stop ¹× db2start ¸í·É »ç¿ë). ÀÌ ¿¹¿¡¼­´Â VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇÏÁö ¾Ê¾ÒÀ¸¹Ç·Î db2start ¸í·É¸¸À» ½ÇÇàÇÕ´Ï´Ù. °ü¸® ¾È³»¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ
  8. db2 create database ¸í·ÉÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϽʽÿÀ. ÀÌ µ¥ÀÌÅͺ£À̽º¿¡´Â DATALINK µ¥ÀÌÅÍ À¯ÇüÀ» »ç¿ëÇÏ´Â Å×À̺íÀÌ µé¾î ÀÖ°Ô µË´Ï´Ù. db2 create database ¸í·É¿¡ ´ëÇÑ Á¤º¸´Â Command Reference¸¦ ÂüÁ¶ÇϽʽÿÀ.

    ÀÌ ¿¹¿¡¼­, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© STAFF¶ó°í ÇÏ´Â µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϽʽÿÀ.

       db2 create database staff
    
  9. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© STAFF µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.
       db2 connect to staff
    
  10. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ¹æ±Ý ÀÛ¼ºÇÑ STAFF µ¥ÀÌÅͺ£À̽º¿¡ DATALINK·Î Á¤ÀÇµÈ Ä÷³ÀÌ ÀÖ´Â EMPLOYEE¶ó´Â Å×À̺íÀ» ÀÛ¼ºÇϽʽÿÀ.
       db2 "create table employee (id int, fname varchar(30), lname varchar(30),
            picture datalink linktype url file link control integrity all
          read permission db write permission blocked recovery yes on
          unlink restore)"
    
  11. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ÀÌ µ¥ÀÌÅͺ£À̽º·ÎÀÇ ¿¬°áÀ» ¸ðµÎ Á¾·áÇϽʽÿÀ.
      db2 connect reset
    
  12. ·Î±×¾Æ¿ôÇϽʽÿÀ.


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