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


AIX ¶Ç´Â Solaris¿¡¼­ DLFF(Data Links Filesystem Filter)°¡ Á¦¾îÇÏ´Â µî·ÏµÈ ÆÄÀÏ ½Ã½ºÅÛ ³ª¿­ ¶Ç´Â Ãß°¡

ÀÌ Àý¿¡¼­´Â AIX ¶Ç´Â Solaris¿¡¼­ DLFF(Data Links Filesystem Filter)°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛÀ» ³ª¿­ÇÏ´Â ¹æ¹ý°ú DLFF°¡ Á¦¾îÇϵµ·Ï ´Ù¸¥ ÆÄÀÏ ½Ã½ºÅÛÀ» µî·ÏÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.

ÇöÀç DLFF°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛÀ» ³ª¿­ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ½Ã½ºÅÛ¿¡ DB2 Data Links Manager °ü¸®ÀÚ·Î ·Î±×¿ÂÇϽʽÿÀ.
  2. Data Links ¼­¹ö¿¡¼­ dlfm list registered prefixes ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

    AIX ½Ã½ºÅÛ¿¡¼­ DLFF°¡ ·ÎµåµÈ ÆÄÀÏ ½Ã½ºÅÛÀ» ³ª¿­ÇÏ·Á¸é, lsfs -v dlfs ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

    Solaris ½Ã½ºÅÛ¿¡¼­ DLFF°¡ ·ÎµåµÈ ÆÄÀÏ ½Ã½ºÅÛÀ» ³ª¿­ÇÏ·Á¸é, /sbin/mount -v | awk '$5 == "dlfs"' ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

    DLFF°¡ DCE-DFS ȯ°æ¿¡¼­ ·ÎµåµÈ ÆÄÀÏ ½Ã½ºÅÛÀ» ³ª¿­ÇÏ·Á¸é dfsexport | grep dmlfs ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.

JFS ¶Ç´Â UFS ȯ°æ¿¡¼­ DLFF Ãß°¡

DLFF¸¦ Ãß°¡ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ´ÙÀ½°ú °°ÀÌ DLFF¸¦ »ç¿ëÇϵµ·Ï ÆÄÀÏ ½Ã½ºÅÛÀ» ÁغñÇϽʽÿÀ.
  2. ´ÙÀ½ ¸í·É Áß Çϳª¸¦ ÀÔ·ÂÇÏ¿© ÀÛ¼ºÇÑ ÆÄÀÏ ½Ã½ºÅÛÀ» ¸¶¿îÆ®ÇϽʽÿÀ.
       /usr/lpp/db2_07_01/instance/dlfmfsmd dlfm_mountpoint  //AIX
       /opt/IBMdb2/V7.1/instance/dlfmfsmd dlfm_mountpoint    //Solaris
     
    

    ¿©±â¼­ dlfm_mountpoint´Â ÀÌÀü ´Ü°è¿¡¼­ DLFF¿¡ ´ëÇØ ÀÛ¼ºÇÑ ÆÄÀÏ ½Ã½ºÅÛÀÇ ¸¶¿îÆ® ÁöÁ¡ÀÔ´Ï´Ù.

  3. ·Î±×¾Æ¿ôÇϽʽÿÀ.
  4. ½Ã½ºÅÛ¿¡ DB2 Data Links Manager °ü¸®ÀÚ·Î ·Î±×¿ÂÇϽʽÿÀ.
  5. dlfm start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links File Manager¸¦ ½ÃÀÛÇϽʽÿÀ.
  6. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links Filesystem Filter°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛÀ» µî·ÏÇϽʽÿÀ.
       dlfm add_prefix prefix_path
    

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

    ¿¹¸¦ µé¾î, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links ¼­¹ö°¡ test ÆÄÀÏ ½Ã½ºÅÛ¿¡¼­ Data Links Filesystem Filter¸¦ »ç¿ëÇϵµ·Ï µî·ÏÇϽʽÿÀ.

       dlfm add_prefix /test
    

    ÀÌ¹Ì ÀÖ´Â Á¢µÎºÎ¸¦ °»½ÅÇÏ·Á¸é, ´ÙÀ½ ¸í·É Áß Çϳª¸¦ ÀÔ·ÂÇϽʽÿÀ.

    dlfm update_prefix prefix_path  //JFS
    dlfm update_prefix prefix_path for dfs localpath local_mount_point  //DFS
     
    

DCE-DFS ȯ°æ¿¡¼­ DLFF Ãß°¡

AIX¿¡¼­ DCE-DFS ȯ°æ¿¡ Data Links Filesystem Filter¸¦ Ãß°¡ÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. ·çÆ®·Î ·Î±×ÀÎ ¹× DFS °ü¸®Àڷμ­ dce_loginÇϽʽÿÀ.
  2. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ³í¸®Àû º¼·ýÀ» ÀÛ¼ºÇϽʽÿÀ.
       mklv -y aggregate_name -t aggregate_type lfs rootvg 1
    

    ¿©±â¼­ aggregate_nameÀº ³í¸®Àû º¼·ýÀÇ À̸§À», aggregate_typeÀº ÁýÇÕ À¯ÇüÀ», rootvg´Â ³í¸®Àû º¼·ý À¯ÇüÀ̸ç 1Àº ³í¸®Àû ÆÄƼ¼ÇÀÇ ¹øÈ£ÀÔ´Ï´Ù.

  3. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ³í¸®Àû º¼·ý¿¡¼­ ÁýÇÕÀ» ÀÛ¼ºÇϽʽÿÀ.
       newaggr -aggregate /dev/dmtest -block 8192 -frag 1024 -overwrite
    

    ¿©±â¼­ /dev/dmtest´Â ÀåÄ¡ ÆÄÀϷμ­ Á¦°øµÈ Á¶ÁýÇÕ À̸§À» ³ªÅ¸³À´Ï´Ù. ÀÌ ÁýÇÕ À̸§ÀÌ ÀÌ¹Ì Á¸ÀçÇÏ´Â °æ¿ì, -overwrite ¿É¼ÇÀº ÁýÇÕ¿¡¼­ ¸ðµç µ¥ÀÌÅ͸¦ »èÁ¦ÇÕ´Ï´Ù.

  4. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ÁýÇÕÀ» ÃʱâÈ­ÇÏ°í ³»º¸³»½Ê½Ã¿À.
       mkdfslfs -d /dev/dmtest -n dmtest
    

    ¿©±â¼­ /dev/dmtest´Â ÁýÇÕÀÇ ÀåÄ¡ À̸§ÀÔ´Ï´Ù.

  5. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ÁýÇÕ¿¡¼­ ÆÄÀÏ ¼¼Æ®¸¦ ÀÛ¼ºÇϽʽÿÀ.
       mkdfslfs -f dmtest1.ft -m /:/dmtest/dmtest1 -n dmtest
    

    ¿©±â¼­ /:/dmtest/dmtest1Àº DFS À̸§ °ø°£ÀÇ ¸¶¿îÆ® ÁöÁ¡À» ³ªÅ¸³»¸ç dmtest´Â ÁýÇÕÀÇ À̸§À» ³ªÅ¸³À´Ï´Ù.
    ÁÖ:DFS À̸§ °ø°£¿¡¼­ µð·ºÅ丮¸¦ ÀÛ¼ºÇÒ ±ÇÇÑ ¹× À¯È¿ÇÑ dce_loginÀ» °¡Á®¾ß ÇÕ´Ï´Ù.

  6. /opt/dcelocal/var/dfs/dfstab ÆÄÀÏÀ» ÆíÁýÇϰí lfs¿¡¼­ dmlfs·Î ÀÛ¼ºÇÑ ÁýÇÕ¿¡ ´ëÇÑ Ç׸ñÀ» º¯°æÇϽʽÿÀ. ¿¹¸¦ µé¾î, ÀÌ ÆÄÀÏ¿¡´Â ´ÙÀ½°ú À¯»çÇÑ °¢ ÁýÇÕ¿¡ ´ëÇÑ Ç׸ñÀÌ ÀÖ½À´Ï´Ù.
       # blkdev aggname aggtype aggid [UFS fsid]
       /dev/aggrdev1 aggrname1 lfs 1
       /dev/aggrdev2 aggrname2 lfs 2
     
    

    Data Link°¡ Á¦¾îÇÒ ¸ðµç ÁýÇÕ¿¡ ´ëÇØ aggtype¸¦ dmlfs·Î º¯°æÇϽʽÿÀ. ÆÄÀÏÀ» ÀúÀåÇÏ°í ´ÝÀ¸½Ê½Ã¿À.

    ÁÖ:

    1. SMIT¸¦ »ç¿ëÇÏ¿© ÁýÇÕÀ» ÀÛ¼ºÇÒ ¶§, ÁýÇÕ ID ¿ª½Ã ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇÏÁö¸¸ ±âº» ID´Â »ç¿ë°¡´ÉÇÑ ´ÙÀ½ Á¤¼ö°ªÀÔ´Ï´Ù.

    2. ÁýÇÕÀ» ÀÌ¹Ì ³»º¸³½ °æ¿ì, ÀÌ ´Ü°è ¹× ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϱâ Àü¿¡ ÁýÇÕÀ» ´Ù½Ã °¡Á®¿Í¾ß ÇÕ´Ï´Ù.
  7. ´ÙÀ½ ¸í·ÉÀ» ¼öÇàÇÏ¿© ÁýÇÕ¿¡¼­ DFS SMT¸¦ »ç¿ë°¡´ÉÇÏ°Ô ÇϽʽÿÀ.
       dmaggr -aggregate name [{-on | -off}] [{-needapp | -noneedapp}] [-help]
     
    

    ÀÌ ¸í·ÉÀ» ¼öÇàÇÏ´Â µ¿¾È Ç×»ó -needapp ¿É¼ÇÀ» »ç¿ëÇϵµ·Ï ±ÇÀåÇÕ´Ï´Ù.

  8. Data Links Filesystem Filter°¡ Á¦¾îÇÒ ¼ö ÀÖµµ·Ï ÁýÇÕÀ» ³»º¸³»½Ê½Ã¿À.
  9. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Data Links Filesystem Filter°¡ Á¦¾îÇÏ´Â ÆÄÀÏ ½Ã½ºÅÛÀ» µî·ÏÇϽʽÿÀ.
       dlfm add_prefix prefix_path
    

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

  10. DCE-DFS ÆÄÀÏ ¼¼Æ®¸¦ µî·ÏÇÏ·Á¸é, dlfm add_prefix /test ¸í·É ¶Ç´Â ´ÙÀ½ º¯¼ö Áß Çϳª¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
       dlfm add_prefix for dfs rwpath prefix_path
    

    ÀÌ ¸í·ÉÀº DCE-DFS¿¡ ´ëÇÑ Àбâ Àü¿ë °æ·Î¸¦ ÁöÁ¤ÇÕ´Ï´Ù.

       dlfm add_prefix for dfs rwpath prefix_path localpath local_mount_point
    

    ¿©±â¼­ local_mount_point´Â Á¢µÎºÎÀÇ ¿ø½Ã ÆÄÀÏ ½Ã½ºÅÛ ¸¶¿îÆ® Æ÷ÀÎÆ®¸¦ ³ªÅ¸³À´Ï´Ù. ¿ø½Ã ÆÄÀÏ ½Ã½ºÅÛ ¸¶¿îÆ® Æ÷ÀÎÆ®´Â ÆÄÀÏÀÇ ±â·Ï ¹× °Ë»ö ¼º´ÉÀ» Çâ»ó½Ã۴µ¥ »ç¿ëµË´Ï´Ù. DFS ȯ°æ¿¡¼­ÀÇ µð½ºÅ© ¹é¾÷À» À§ÇÑ ¼º´É Çâ»ó¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
    ÁÖ:DFS ÆÄÀÏ ¼¼Æ®°¡ »óÁÖÇÏ´Â ³ëµå·ÎºÎÅÍ ¸ðµç dlfm add_prefix ¸í·ÉÀ» ¹ßÇàÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ¸í·ÉÀ» ¹ßÇàÇÑ ÈÄ, µ¿ÀÏÇÑ ³ëµå¿¡¼­ dlfm start ¸í·ÉÀ» ¹ßÇàÇØ¾ß ÇÕ´Ï´Ù.

DFS ȯ°æ¿¡¼­ÀÇ µð½ºÅ© ¹é¾÷À» À§ÇÑ ¼º´É Çâ»ó

´ÙÀ½ ½Ã³ª¸®¿À¸¦ °í·ÁÇϽʽÿÀ.

ÆÄÀÏ °ü¸® ÇÁ·Î±×·¥À¸·Î µî·ÏµÈ µÎ °³ÀÇ Á¢µÎºÎ°¡ ÀÖ½À´Ï´Ù. µÎ Á¢µÎºÎ´Â ´ÙÀ½°ú °°½À´Ï´Ù.

¾ÆÄ«ÀÌºê µð·ºÅ丮´Â DFS ÆÄÀÏ ¼¼Æ®¿©¾ß ÇÕ´Ï´Ù(¿¹. /.../cellname/fs/dlfm_backup/).

DFS ¼¿ÀÇ µÎ ³ëµå¿¡ ÀÖ´Â DB2 ·¹Áö½ºÆ®¸® º¯¼öµéÀº ´ÙÀ½°ú °°ÀÌ ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.

   db2set DLFM_BACKUP_TARGET=LOCAL db2set DLFM_BACKUP_DIR_NAME=/.../cellname/fs/dlfm_backup/

ÆÄÀÏÀÇ ¾ÆÄ«À̺ê´Â ´ÙÀ½°ú °°ÀÌ ÀÛ¼ºµË´Ï´Ù.

  1. prfx1¿¡ »óÁÖÇÏ´Â ÆÄÀÏÀÇ °æ¿ì, node1¿¡¼­ ¼öÇà ÁßÀÎ º¹»ç µð¸ÕÀº ´ÙÀ½ µð·ºÅ丮¿¡ ¾ÆÄ«À̺긦 ¸¸µì´Ï´Ù.
      
    /.../cellname/fs/dlfm_backup/node1/_prfx1/
    
  2. prfx2¿¡ »óÁÖÇÏ´Â ÆÄÀÏÀÇ °æ¿ì, node2¿¡¼­ ¼öÇà ÁßÀÎ º¹»ç µð¸ÕÀº ´ÙÀ½ µð·ºÅ丮¿¡ ¾ÆÄ«À̺긦 ¸¸µì´Ï´Ù.
      
    /.../cellname/fs/dlfm_backup/node2/_prfx2/
    

µð·ºÅ丮 /.../cellname/fs/dlfm_backup/node[1-2] ¹× /.../cellname/fs/dlfm_backup/node[1-2]/_prfx[1-2]°¡ ½Ãµ¿½Ã ÀÛ¼ºµË´Ï´Ù.

µð½ºÅ© ¹é¾÷ ÃÖÀûÈ­ Ãß°¡ Á¤º¸ 1

ÇÑ °³ÀÇ ¹é¾÷ ÆÄÀÏ ¼¼Æ® ´ë½Å ¿©·¯ °³ÀÇ ¹é¾÷ DFS ÆÄÀÏ ¼¼Æ®¸¦ ÀÛ¼ºÇÏ¿© ÆÄÀÏ ¼¼Æ® ¾ÆÄ«À̺ê Áö¿ªÈ­ÀÇ ÀåÁ¡À» ÀÌ¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. À§ ½Ã³ª¸®¿À¿¡¼­ °ü¸®ÀÚ´Â ´ÙÀ½°ú °°ÀÌ µÎ °³ÀÇ ¹é¾÷ ÆÄÀÏ ¼¼Æ®¸¦ ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.

   /.../cellname/fs/dlfm_backup/node1/

ÀÌ´Â º»·¡ ³ëµå1¿¡ ÀÖ½À´Ï´Ù.

  
   /.../cellname/fs/dlfm_backup/node2/

ÀÌ´Â º»·¡ ³ëµå2¿¡ ÀÖ½À´Ï´Ù.

ÀÌ·¯ÇÑ ¹æ½ÄÀ¸·Î node1¿¡ ÀÖ´Â ÆÄÀÏ ¼¼Æ®(Áï, fileset1)¿¡ ¼ÓÇÑ ÆÄÀÏÀÇ ¾ÆÄ«À̺ê´Â º»·¡ node1ÀÎ ¾ÆÄ«ÀÌºê ÆÄÀÏ ¼¼Æ®¿¡ ´ëÇØ ¼öÇàµË´Ï´Ù. ±× °á°ú ³×Æ®¿öÅ© Åë½Å·®ÀÌ °¨¼ÒµË´Ï´Ù.
ÁÖ:node1 ¹× node2¿¡¼­ DLFM_BACKUP_TARGET ¹× DLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö´Â °è¼ÓÇØ¼­ Â÷·Ê´ë·Î LOCAL ¹× /.../cellname/fs/dlfm_backup/À¸·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.

µð½ºÅ© ¹é¾÷ ÃÖÀûÈ­ Ãß°¡ Á¤º¸ 2

°ü¸®ÀÚ´Â DLFM_BACKUP_DIR_LOCAL_MP ·¹Áö½ºÆ®¸® º¯¼ö¸¦ »ç¿ëÇÏ¿© DFS Ŭ¶óÀÌ¾ðÆ® Ä³½¬¸¦ »ý·«ÇÒ ¼ö ÀÖ½À´Ï´Ù. µð½ºÅ© ¹é¾÷ ÃÖÀûÈ­ Ãß°¡ Á¤º¸ 1ÀÌ »ç¿ë ÁßÀÎ °æ¿ì¿¡¸¸ ÇØ´çµË´Ï´Ù. ¶ÇÇÑ, DFS ÆÄÀÏ ¼¼Æ®´Â ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇÏ¿© ¿ø½Ã JFS(Journaled File System)·Î¼­ ¸¶¿îÆ®µÇ¾î¾ß ÇÕ´Ï´Ù.

  1. ÆÄÀÏ ¼¼Æ® fileset1(Á¢µÎºÎ: /.../cellname/fs/dlfm_backup/node1)Àº ´ÙÀ½ ¸í·ÉÀ» ¹ßÇàÇÏ¿© JFS·Î¼­ /local_backup/node1¿¡¼­ ¸¶¿îÆ®µÉ ¼ö ÀÖ½À´Ï´Ù.
       mount -v lfs -o aggregate=lfstest1 -n node1 fileset1
    /local_backup/node1
    

    ¿©±â¼­ lfstest1Àº fileset1ÀÌ ÀÖ´Â ÁýÇÕüÀÔ´Ï´Ù.

  2. DLFM_BACKUP_TARGET ¹× DLFM_BACKUP_DIR_NAME ·¹Áö½ºÆ®¸® º¯¼ö¸¦ ¼³Á¤ÇÏ´Â °Í ¿Ü¿¡µµ, ´ÙÀ½°ú °°ÀÌ DB2 ·¹Áö½ºÆ®¸® º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.
       db2set DLFM_BACKUP_DIR_LOCAL_MP=/local_backup/
    

ÁÖ:¿ø½Ã JFS ¸¶¿îÆ® ÁöÁ¡¿¡ ³ëµå À̸§ÀÌ Æ÷ÇԵǾú¾îµµ DLFM_BACKUP_DIR_LOCAL_MP¿¡´Â Æ÷ÇÔµÇÁö ¾Ê¾Ò½À´Ï´Ù.


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