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


2. DB2 Data Links ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æ ÀÛ¼º

DB2 UDB ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æÀ» ÀÛ¼ºÇÑ ÈÄ DB2 Data Links ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æÀ» ÀÛ¼ºÇϽʽÿÀ.

Data Links ¼­¹ö¿¡¼­ Å×½ºÆ® ȯ°æÀ» ÀÛ¼ºÇÏ·Á¸é, 4°¡Áö ÇÏÀ§ Ÿ½ºÅ©¸¦ ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.

ÆÄÀÏ ½Ã½ºÅÛ Áغñ

UFS(UNIX File System)¸¦ ÀÛ¼ºÇÏ¿© Data Links Manager ¼³Ä¡¸¦ Å×½ºÆ®ÇÒ ¼ö ÀÖ½À´Ï´Ù.

DB2 Data Links ¼­¹ö¿¡¼­ UFS(UNIX File System) ÀÛ¼º

DB2 Data Links ¼­¹ö¿¡¼­ UFS¸¦ ÀÛ¼ºÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ·çÆ® ±ÇÇÑÀ» °¡Áø »ç¿ëÀÚ·Î ·Î±×ÀÎÇϽʽÿÀ.
  2. ´ÙÀ½°ú °°ÀÌ Data Links Filesystem Filter¸¦ »ç¿ëÇϵµ·Ï UFS¸¦ ÁغñÇϽʽÿÀ.
    1. newfs À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÏ¿© UFS ÆÄÀÏ ½Ã½ºÅÛÀ» ÀÛ¼ºÇϽʽÿÀ. ±âÁ¸ÀÇ UFS ÆÄÀÏ ½Ã½ºÅÛÀ» »ç¿ëÇÒ ¼öµµ ÀÖ½À´Ï´Ù. »õ·Î¿î ÆÄÀÏ ½Ã½ºÅÛ ÀÛ¼º¿¡ ÇÊ¿äÇÑ ¿É¼Ç¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº Solaris Á¦Ç° ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
    2. /etc/vfstab ÆÄÀÏÀ» ¿­°í ´ÙÀ½°ú °°ÀÌ Ç׸ñÀ» ±â·ÏÇϽʽÿÀ.
         /dev/dsk/c0t0d0s6 /dev/rdsk/c0t0d0s6 /dlfs   dlfs - yes Basefs=ufs
      

      ¿©±â¼­ c0t0d0s6´Â ÀÌ ¿¹ÀÇ »ùÇà °ªÀÔ´Ï´Ù.

  3. ÆÄÀÏ ½Ã½ºÅÛ µî·Ï Á¤º¸¸¦ ¼öÁ¤ÇÏ¿© Data Links Filesystem FilterÀÇ Á¦¾îÇÏ¿¡ ÀÖµµ·Ï ÇÏ°í ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ¸¶¿îÆ®ÇϽʽÿÀ.
       /opt/IBMdb2/V7.1/instance/dlfmfsmd dlfm_mountpoint
    

    ¿©±â¼­ dlfm_mountpoint´Â »ç¿ëÇϰí ÀÖ´Â UFSÀÇ ¸¶¿îÆ® ÁöÁ¡ÀÔ´Ï´Ù.

    ÀÌ ¿¹¿¡¼­, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®

       /opt/IBMdb2/V7.1/instance/dlfmfsmd /test
    
  4. ·Î±×¾Æ¿ôÇϽʽÿÀ.

DLFF¸¦ ÀÌ¿ëÇÑ ÆÄÀÏ ½Ã½ºÅÛ µî·Ï

DLFF(Data Links File Filter)¸¦ ÀÌ¿ëÇÏ¿© /test ÆÄÀÏ ½Ã½ºÅÛÀ» µî·ÏÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ½Ã½ºÅÛ¿¡ DB2 Data Links Manager °ü¸®ÀÚ·Î ·Î±×¿ÂÇϽʽÿÀ.
  2. ´ÙÀ½°ú °°ÀÌ db2profile ¶Ç´Â db2cshrc ½ºÅ©¸³Æ®¸¦ ¼öÇàÇϽʽÿÀ.
       . INSTHOME/sqllib/db2profile    (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì)
       source INSTHOME/sqllib/db2cshrc (C ½©ÀÇ °æ¿ì)
    

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

  3. dlfm start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links File Manager¸¦ ½ÃÀÛÇϽʽÿÀ.
  4. dlfm see ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links File Manager°¡ ¿Ã¹Ù·Î ½ÃÀ۵Ǿú´ÂÁö È®ÀÎÇϽʽÿÀ.

    Data Links File Manager ¹é¿£µå ÇÁ·Î¼¼½º°¡ ½ÃÀÛµÇ¾î ½ÇÇàÁßÀÎ °æ¿ì, ´ÙÀ½°ú À¯»çÇÑ Ãâ·ÂÀÌ Ç¥½ÃµË´Ï´Ù.

       PID   PPID  PGID      RUSER    EUSER   ETIME   COMMAND
       7624  49852  55994     dlfm     dlfm    02:44   dlfmd
       49852     1 55994     dlfm     dlfm    02:44   dlfmd
    
    ·
    ·
    ·
    56510 49852 55994 dlfm root 02:44 dlfm_chownd
  5. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DLFF(Data Links Filesystem Filter)°¡ Á¦¾îÇÏ´Â UFS°¡ ¸¶¿îÆ®µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
        /sbin/mount -v | awk '$5 == "dlfs"'  
    

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

       /dev/dsk/c0t1d0s0 on /dlfstest type dlfs rw/suid/Basefs=ufs on Sat May 27 12:39:34 2000
       /dev/dsk/c0t2d0s0 on /dlfstest type dlfs rw/suid/Basefs=ufs on Sat May 27 12:39:34 2000
                            
    
  6. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links Filesystem Filter°¡ Á¦¾îÇÏ´Â µå¶óÀ̺êÀÇ °øÀ¯ À̸§À» µî·ÏÇϽʽÿÀ.
       dlfm add_prefix prefix_path
     
    

    ¿©±â¼­ prefix_path´Â DLFF°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛÀÇ À§Ä¡ÀÔ´Ï´Ù.

    ´ÙÀ½ ¸í·ÉÀº test ÆÄÀÏ ½Ã½ºÅÛ¿¡¼­ DLFF¸¦ »ç¿ëÇϱâ À§ÇØ Data Links ¼­¹ö¸¦ µî·ÏÇÕ´Ï´Ù.

       dlfm add_prefix /test
    

DB2 UDB µ¥ÀÌÅͺ£À̽º µî·Ï

Data Links File Manager¿¡ »õ µ¥ÀÌÅͺ£À̽º¸¦ µî·ÏÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ½Ã½ºÅÛ¿¡ DB2 Data Links Manager °ü¸®ÀÚ·Î ·Î±×¿ÂÇϽʽÿÀ.
  2. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Á¤ÀÇµÈ DB2 UDB µ¥ÀÌÅͺ£À̽º¸¦ µî·ÏÇϽʽÿÀ.
        dlfm add_db database instance hostname
    

    ¿©±â¼­,

    ´ÙÀ½ ¸í·ÉÀº ¿ÏÀüÇÑ È£½ºÆ® À̸§ÀÌ db2server.services.comÀÎ DB2 UDB ¼­¹öÀÇ VALIDATE ÀνºÅϽº¿¡ »óÁÖÇÏ´Â STAFF¶ó°í ÇÏ´Â µ¥ÀÌÅͺ£À̽º¸¦ µî·ÏÇÕ´Ï´Ù.

        dlfm add_db staff validate db2server.services.com
    

    µî·ÏµÈ µ¥ÀÌÅͺ£À̽º¸¦ ³ª¿­ÇÏ·Á¸é, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

       dlfm list registered databases
    

    ÀÌ ¸í·ÉÀ» ¼öÇàÇÒ ¶§, DLFM_DB¸¦ ÁöÁ¤ÇÏÁö ¸¶½Ê½Ã¿À. DLFM_DB´Â Data Links File Manager°¡ Á¦¾îÇÏ´Â ÆÄÀÏÀ» ÃßÀûÇÏ´Â µ¥ »ç¿ëµÇ´Â Áö¿ª µ¥ÀÌÅͺ£À̽ºÀÔ´Ï´Ù.

  3. ·Î±×¾Æ¿ôÇϽʽÿÀ.

µî·ÏµÈ Á¢µÎºÎ¸¦ ³ª¿­ÇÏ·Á¸é, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

dlfm list registered prefixes

»ùÇà ÆÄÀÏ ÀÛ¼º

»ùÇà ÆÄÀÏÀ» ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. DB2 Data Links Manager °ü¸®ÀÚ°¡ ¾Æ´Ñ »ç¿ëÀÚ·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ.
  2. DLFF(Data Links Filesystem Filter)°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛ¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DB2 ¼­¹ö°¡ Á¦¾îÇÒ ÆÄÀÏÀ» ÀúÀåÇÒ µð·ºÅ丮¸¦ ÀÛ¼ºÇϽʽÿÀ.
       mkdir filesystem_name/directory_name
    

    ¿©±â¼­,

    DB2 Data Links Manager °ü¸®ÀÚ´Â DLFF°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛ¿¡ ÀÖ´Â ÆÄÀÏÀ̳ª µð·ºÅ丮ÀÇ ¼ÒÀ¯ÀÚ°¡ ¾Æ´Ï¾î¾ß ÇÕ´Ï´Ù. /test ÆÄÀÏ ½Ã½ºÅÛ¿¡ pictures¶ó°í ÇÏ´Â µð·ºÅ丮¸¦ ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

       mkdir /test/pictures
    
  3. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ¸ðµç »ç¿ëÀÚ°¡ ÇØ´ç µð·ºÅ丮¿¡ ÆÄÀÏÀ» ÀÛ¼ºÇÒ ¼ö ÀÖµµ·Ï pictures µð·ºÅ丮ÀÇ »ç¿ë±ÇÇÑÀ» º¯°æÇϽʽÿÀ.
       chmod 777 /test/pictures
    
  4. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links File Manager°¡ °ü¸®ÇÒ psmith.bmp¶ó´Â ÆÄÀÏÀ» /test/pictures µð·ºÅ丮¿¡ ÀÛ¼ºÇϽʽÿÀ.
       echo "This is a picture of Paul Smith." > /test/pictures/psmith.bmp
    
  5. ·Î±×¾Æ¿ôÇϽʽÿÀ.

»ùÇà ÆÄÀÏÀÎ psmith.bmp´Â ÅØ½ºÆ® ÆÄÀÏÀ̸ç .bmp È®ÀåÀÚ°¡ ÀǹÌÇÏ´Â °Í°ú´Â ´Ù¸£°Ô ºñÆ®¸ÊÀÌ ¾Æ´Õ´Ï´Ù. ¼³Ä¡¸¦ È®ÀÎÇϱâ À§Çؼ­ ÀÌ ÆÄÀÏÀº DATALINKS µ¥ÀÌÅÍ À¯ÇüÀ¸·Î Á¤ÀÇµÈ Å×ÀÌºí¿¡ »ðÀÔµÈ »ç¿øÀÇ »çÁøÀ» ³ªÅ¸³À´Ï´Ù.


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