°ü¸® ¾È³»¼­


Tivoli Storage Manager

BACKUP ¹× RESTORE ¸í·ÉÀ» È£ÃâÇÒ °æ¿ì, µ¥ÀÌÅͺ£À̽º ¶Ç´Â Å×ÀÌºí °ø°£ ¹é¾÷À» °ü¸®Çϱâ À§ÇØ Tivoli Storage Manager(TSM)(ÀÌÀüÀÇ Tivoli ADSM) Á¦Ç°À» »ç¿ëÇϵµ·Ï ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2¿Í ÇÔ²² Tivoli ADSM Ŭ¶óÀÌ¾ðÆ® ¹öÀü 3.1.x.3 ÀÌ»óÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ ÁÖÁ¦ Ç׸ñ¿¡¼­´Â Ãß°¡ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù.

UNIX ±â¹Ý Ç÷§Æû¿ë Tivoli Storage Manager Ŭ¶óÀÌ¾ðÆ® ¼³Á¤

µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥¿¡¼­ TSM ¿É¼ÇÀ» »ç¿ëÇϱâ À§Çؼ­´Â, ¸ÕÀú ´ÙÀ½°ú °°Àº ¼³Á¤ Ȱµ¿ÀÌ ¼öÇàµÇ¾î¾ß ÇÕ´Ï´Ù.

  1. SunOS ¹× Solaris ȯ°æ¿¡¼­, ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ(´Ù¸¥ UNIX ±â¹Ý Ç÷§ÆûÀÇ °æ¿ì, ´Ü°è 2¿¡¼­ ½ÃÀÛÇϽʽÿÀ).
    1. SunOS 5.5.1 ¶Ç´Â Solaris 2.5.1°ú °°ÀÌ Çʼö ¿î¿µ üÁ¦ ·¹º§ÀÌ ¼³Ä¡µÇ¾î ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
    2. Tivoli ADSM Ŭ¶óÀÌ¾ðÆ® ¹öÀü 3.1.x.3 ÀÌ»óÀ» ¼³Ä¡ÇϽʽÿÀ. ÀÌ ¹öÀüÀÇ Å¬¶óÀÌ¾ðÆ®¸¦ ¼³Ä¡Çϱâ Àü¿¡ ÀÌÀü TSM ÆÐŰÁö ¸ðµÎ¸¦ Á¦°ÅÇϽʽÿÀ.
    3. TSMÀÌ /opt/IBMDSMap5, /opt/IBMDSMba5 ¹× /opt/IBMDSMsa5 µð·ºÅ丮¿¡ ¼³Ä¡µÇ¾î ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
    4. ¾øÀ» °æ¿ì, /usr/lib µð·ºÅ丮¿¡¼­ ´ÙÀ½°ú °°Àº ±âÈ£ ¸µÅ©¸¦ ÀÛ¼ºÇϽʽÿÀ.
         libApiDS.so -> libApiDS.so.1
         libApiDS.so.1 -> /opt/IBMDSMap5/api/libApiDS.so.2
      
  2. TSM »ç¿ëÀÚ ±¸¼º ¿É¼Ç ÆÄÀÏ /usr/sbin/dsm.opt ¹× TSM ½Ã½ºÅÛ ±¸¼º ¿É¼Ç ÆÄÀÏ /usr/sbin/dsm.sys¸¦ ÀÛ¼ºÇϰųª ¼öÁ¤ÇÏ¿© »ç¿ëÀÚ È¯°æ¿¡ ¸ÂÃ߽ʽÿÀ.
  3. SunOS ¹× Solaris ȯ°æ¿¡¼­, ´ÙÀ½ ´Ü°è¸¦ ¼öÇàÇϽʽÿÀ(´Ù¸¥ UNIX ±â¹Ý Ç÷§ÆûÀÇ °æ¿ì, ´Ü°è 4¸¦ °è¼ÓÇϽʽÿÀ).
    1. /usr/sbin/dsm.opt ¹× /usr/sbin/dsm.sys¸¦ µð·ºÅ丮 /opt/IBMDSMap5·Î º¹»çÇϽʽÿÀ.
    2. /opt/IBMDSMap5/solaris/dsmaptica¸¦ µð·ºÅ丮 /opt/IBMDSMap5·Î º¹»çÇϽʽÿÀ.
  4. TSMÀÌ »ç¿ëÇϴ ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.

    DSMI_DIR
    API ½Å·Ú ¿¡ÀÌÀüÆ® ÆÄÀÏ(dsmapicta ¶Ç´Â dsmtca)ÀÌ À§Ä¡ÇÑ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù.
    ÁÖ:SunOS ¹× Solaris ȯ°æÀÇ °æ¿ì, À̰ÍÀº /opt/IBMDSMap5·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.

    DSMI_CONFIG
    dsm.opt ÆÄÀÏ¿¡ ´ëÇØ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù. ÀÌ °æ·Î¿¡´Â TSM »ç¿ëÀÚ ¿É¼ÇÀÌ µé¾î ÀÖ½À´Ï´Ù. ´Ù¸¥ µÎ °³ÀÇ º¯¼ö¿Í ´Þ¸®, ÀÌ º¯¼ö´Â ¿ÏÀü °æ·Î ¹× ÆÄÀÏ À̸§À» Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù.
    ÁÖ:SunOS ¹× Solaris ȯ°æÀÇ °æ¿ì, À̰ÍÀº /opt/IBMDSMap5/dsm.opt·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.

    DSMI_LOG
    ¿À·ù ·Î±×(dsierror.log)°¡ ÀÛ¼ºµÉ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù.
  5. TSM ¾ÏÈ£¸¦ ¼³Á¤ÇϽʽÿÀ.

    Tivoli Ŭ¶óÀÌ¾ðÆ®°¡ TSM ¼­¹ö¿Í ÀÎÅÍÆäÀ̽ºÇÒ ¼ö ÀÖÀ¸·Á¸é, ¼­¹ö¿¡ ´ëÇÑ ¾ÏÈ£°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ½ÇÇà °¡´É ÆÄÀÏÀÎ dsmapipw´Â ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ INSTHOME/sqllib/adsm µð·ºÅ丮¿¡ ¼³Ä¡µÇ¾î ÀÖ½À´Ï´Ù. ÀÌ ½ÇÇà ÆÄÀÏ·Î »ç¿ëÀÚ´Â TSM ¾ÏÈ£¸¦ ¼³Á¤ ¹× Àç¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.

    dsmapipw ¸í·ÉÀ» ½ÇÇàÇÏ·Á¸é "root" »ç¿ëÀڷμ­ ·Î±×ÀεǾî¾ß ÇÕ´Ï´Ù. ÀÌ ¸í·ÉÀÌ ½ÇÇàµÉ ¶§, ´ÙÀ½°ú °°Àº Á¤º¸°¡ ÇÁ·ÒÇÁÆ®µË´Ï´Ù.

    ÁÖ:BACKUP ¶Ç´Â RESTORE ¸í·ÉÀ» ½ÇÇàÇÏ´Â »ç¿ëÀÚ´Â ÀÌ ¾ÏÈ£¸¦ ¾Ë Çʿ䰡 ¾ø½À´Ï´Ù. ÀÌ ¸í·ÉÀ» ¼öÇàÇØ¾ß ÇÏ´Â À¯ÀÏÇÑ °æ¿ì´Â Ãʱ⠿¬°áÀ» À§ÇØ ¾ÏÈ£¸¦ ¼³Á¤ÇÒ ¶§¿Í TSM ¼­¹ö¿¡ ¾ÏÈ£°¡ Àç¼³Á¤µÇ¾î ÀÖ´Â °æ¿ìÀÔ´Ï´Ù.
  6. µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ÀÌ ¼öÇàµÇ°í ÀÖ´Â °æ¿ì, ´ÙÀ½À» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.

±âŸ Ç÷§Æû¿ë Tivoli Storage Manager Ŭ¶óÀÌ¾ðÆ® ¼³Á¤

µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥¿¡¼­ TSM ¿É¼ÇÀ» »ç¿ëÇϱâ À§Çؼ­´Â, ¸ÕÀú ´ÙÀ½°ú °°Àº ¼³Á¤ Ȱµ¿ÀÌ ¼öÇàµÇ¾î¾ß ÇÕ´Ï´Ù.

  1. TSMÀÌ »ç¿ëÇϴ ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.

    DSMI_DIR
    API ½Å·Ú ¿¡ÀÌÀüÆ® ÆÄÀÏ(dsmapicta ¶Ç´Â dsmtca)ÀÌ À§Ä¡ÇÑ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù.

    DSMI_CONFIG
    dsm.opt ÆÄÀÏ¿¡ ´ëÇØ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù. ´Ù¸¥ µÎ °³ÀÇ º¯¼ö¿Í ´Þ¸®, ÀÌ º¯¼ö´Â ¿ÏÀü °æ·Î ¹× ÆÄÀÏ À̸§À» Æ÷ÇÔÇØ¾ß ÇÕ´Ï´Ù.

    DSMI_LOG
    ¿À·ù ·Î±×(dsierror.log)°¡ ÀÛ¼ºµÉ »ç¿ëÀÚ Á¤ÀÇ µð·ºÅ丮 °æ·Î¸¦ ½Äº°ÇÕ´Ï´Ù.
  2. »ç¿ëÀÚÀÇ ¿î¿µ üÁ¦¿¡ Àû¿ë °¡´ÉÇϸé, TSM ½Ã½ºÅÛ ±¸¼º ¿É¼Ç ÆÄÀÏ(dsm.sys)À»ÀÛ¼º(¶Ç´Â º¯°æ)ÇϽʽÿÀ.
  3. dsm.opt TSM »ç¿ëÀÚ ±¸¼º ¿É¼Ç ÆÄÀÏÀ» ÀÛ¼º(¶Ç´Â º¯°æ)ÇϽʽÿÀ. ȯ°æ º¯¼ö DSMI_CONFIG´Â ÀÌ ÆÄÀÏÀ» Ä«¸®Åµ´Ï´Ù.
  4. TSM ¾ÏÈ£¸¦ ¼³Á¤ÇϽʽÿÀ.

    Tivoli Ŭ¶óÀÌ¾ðÆ®°¡ TSM ¼­¹ö¿Í ÀÎÅÍÆäÀ̽ºÇÒ ¼ö ÀÖÀ¸·Á¸é, ¼­¹ö¿¡ ´ëÇÑ ¾ÏÈ£°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ½ÇÇà °¡´É ÆÄÀÏÀÎ dsmapipw´Â ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ \sqllib\adsm µð·ºÅ丮¿¡ ¼³Ä¡µÇ¾î ÀÖ½À´Ï´Ù ÀÌ ½ÇÇà ÆÄÀÏ·Î »ç¿ëÀÚ´Â TSM ¾ÏÈ£¸¦ ¼³Á¤ ¹× Àç¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.

    dsmapipw ¸í·ÉÀ» ½ÇÇàÇÏ·Á¸é, Áö¿ª °ü¸®Àڷμ­ ·Î±×ÀεǾî¾ß ÇÕ´Ï´Ù ÀÌ ¸í·ÉÀÌ ½ÇÇàµÉ ¶§, ´ÙÀ½°ú °°Àº Á¤º¸°¡ ÇÁ·ÒÇÁÆ®µË´Ï´Ù.

    ÁÖ:BACKUP ¶Ç´Â RESTORE ¸í·ÉÀ» ½ÇÇàÇÏ´Â »ç¿ëÀÚ´Â ÀÌ ¾ÏÈ£¸¦ ¾Ë Çʿ䰡 ¾ø½À´Ï´Ù. ÀÌ ¸í·ÉÀ» ¼öÇàÇØ¾ß ÇÏ´Â À¯ÀÏÇÑ °æ¿ì´Â Ãʱ⠿¬°áÀ» À§ÇØ ¾ÏÈ£¸¦ ¼³Á¤ÇÒ ¶§¿Í TSM ¼­¹ö¿¡ ¾ÏÈ£°¡ Àç¼³Á¤µÇ¾î ÀÖ´Â °æ¿ìÀÔ´Ï´Ù.
  5. µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ÀÌ ¼öÇàµÇ°í ÀÖ´Â °æ¿ì, ´ÙÀ½À» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.

Tivoli Storage Manager »ç¿ë¿¡ ´ëÇÑ °í·Á»çÇ×

TSM ¾È¿¡¼­ ƯÁ¤ ±â´ÉÀ» »ç¿ëÇÏ·Á¸é, ±â´ÉÀ» »ç¿ëÇϰí ÀÖ´Â ¿ÀºêÁ§Æ®ÀÇ ¿ÏÀüÇÑ °æ·Î À̸§À» Á¦°øÇØ¾ß ÇÕ´Ï´Ù(OS/2 ¹× Windows NT Ç÷§Æû¿¡¼­´Â / ´ë½Å \°¡ »ç¿ëµÊÀ» ±â¾ïÇϽʽÿÀ). Àüü °æ·Î À̸§Àº ´ÙÀ½°ú °°½À´Ï´Ù.

¿©±â¼­, <database>´Â µ¥ÀÌÅͺ£À̽º º°¸í À̸§À̰í, NODEnnnnÀº ³ëµå ¹øÈ£ÀÔ´Ï´Ù.
ÁÖ:´ë¹®ÀڷΠǥ½ÃµÈ À̸§Àº Ç¥½ÃµÈ ´ë·Î ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.

Windows ¿î¿µ üÁ¦ ¹× OS/2¿¡ ÀÖ´Â ÇöÀç Tivoli Ŭ¶óÀ̾ðÆ®(¹Ù·Î À§¿¡¼­ ¾ð±Ý)´Â ÀçÀÔ·ÂÀÌ °¡´ÉÇϹǷΠ¿©·¯ ÀÔÃâ·Â ¼¼¼ÇÀÌ ´ÜÀÏ ¸Ó½Å¿¡¼­ ¹é¾÷, º¹¿ø ¶Ç´Â ·Îµå À¯Æ¿¸®Æ¼·Î ¾ÈÀüÇÏ°Ô ÀÛ¼ºµÉ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª, »ç¿ëÀÚ´Â ¼³Ä¡µÈ TSM Ŭ¶óÀ̾ðÆ®ÀÇ ¹öÀüÀÌ ÀÌ ±â´ÉÀ» Áö¿øÇϵµ·Ï È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.

´ÜÀÏ ³ëµå ±¸¼º¿¡¼­, »ç¿ëÀÚ°¡ ´ÙÀ½°ú °°Àº ¹é¾÷ ¸í·ÉÀ» ¹ßÇàÇϵµ·Ï ½ÃµµÇÏ´Â °æ¿ì,

   db2 backup db sample use tsm open 3 sessions

DB2´Â TSMÀÌ ´ÙÁß ¼¼¼ÇÀ» Áö¿øÇÏÁö ¾ÊÀ½À» ¹ß°ßÇϰí SQL2032NÀ» ¸®ÅÏÇÕ´Ï´Ù. °°Àº ½Ã³ª¸®¿À°¡ TSMÀ» »ç¿ëÇÑ ·Îµå »çº»¿¡µµ Àû¿ëµË´Ï´Ù.

±×·¯³ª Windows NT»óÀÇ ´ÙÁß ³í¸® ³ëµå(MLN) ±¸¼º¿¡¼­, DB2´Â °¢ ³í¸® ³ëµå°¡ ÇϳªÀÇ ¼¼¼Ç¸¸À» ÀÛ¼ºÇÏ·Á°í ÇÏ¸é ´ÜÀÏ ¸Ó½Å¿¡¼­ ´ÙÁß ¼¼¼ÇÀÌ »ç¿ëµÊÀ» ¹ß°ß¸øÇÒ ¼öµµ ÀÖÀ½¿¡ ÁÖÀÇÇϽʽÿÀ. ÀÌ·¯ÇÑ ÀÌÀ¯·Î °ü·Ã TSM Ŭ¶óÀÌ¾ðÆ®°¡ ÀçÀÔ·ÂÀ» Áö¿øÇÔÀ» MLN ±¸¼ºÀÌ °ËÁõÇÏ´Â °ÍÀº ¸Å¿ì Áß¿äÇÕ´Ï´Ù. ´ÙÁß ³í¸® ³ëµå°¡ TSMÀ» »ç¿ëÇÏ¿© º´·Ä·Î ¹é¾÷, º¹¿ø ¶Ç´Â ·ÎµåÁßÀ̸é, DB2´Â ³í¸® ³ëµå°¡ ½ÇÁ¦·Î °°Àº ¹°¸® Çϵå¿þ¾î¿¡ »óÁÖÇÏ´Â °æ¿ì¶óµµ °¢ ³ëµå°¡ ´ÜÀϼ¼¼ÇÀ» »ç¿ëÇÏ·Á°í Çϸé Á¶ÀÛÀ» ÁøÇàÇϵµ·Ï ÇÕ´Ï´Ù. À̰ÍÀº ¹é¾÷ ½Ãµµ°¡ ½ÇÆÐÇÏ°Ô Çϸç, ·Îµå ÇÁ·Î¼¼½º¸¦ Á¤Áö½ÃŰ¹Ç·Î, °¡Àå ÃÖ±ÙÀÇ TSM Ŭ¶óÀÌ¾ðÆ® ¾øÀÌ ½ÃµµÇؼ­´Â ¾È µË´Ï´Ù.

TSM¿¡¼­ ¹é¾÷ ¹× ·Î±× ¾ÆÄ«ÀÌºê °ü¸®

db2adutl À¯Æ¿¸®Æ¼¸¦ ÅëÇØ ¹é¾÷, ·Î±×, TSMÀ» »ç¿ëÇÏ¿© ÀúÀåµÈ ·Îµå »çº» À̹ÌÁö¸¦ Á¶È¸, ¹ßÃé ¹× »èÁ¦ÇÒ ¼ö ÀÖ½À´Ï´Ù. À¯Æ¿¸®Æ¼´Â UNIX Ç÷§ÆûÀÇ INSTHOME/sqllib/misc µð·ºÅ丮¿¡ ¼³Ä¡µÇ¸ç, Intel Ç÷§ÆûÀÇ \sqllib\misc µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù.
ÁÖ:¹é¾÷À¸·Î ·Î±× ÆÄÀÏÀ» À¯ÁöÇÏ·Á°í ÇÒ ¼ö ÀÖ½À´Ï´Ù. TSMÀ» »ç¿ëÇÒ ¶§, TSMÀÇ Á¦¾î¿¡¼­ ·Î±× ÆÄÀÏÀ» À̵¿ÇÏ·Á°í ÇÕ´Ï´Ù. À̰ÍÀº User ExitÀ¸·Î ¼öÇàµË´Ï´Ù. ºÎ·Ï F, µ¥ÀÌÅͺ£À̽º º¹±¸¸¦ À§ÇÑ User Exit¿¡¼­ User Exit¸¦ »ç¿ëÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

db2adutl À¯Æ¿¸®Æ¼¸¦ ÅëÇØ »ç¿ë °¡´ÉÇÑ ¸ðµç ¿É¼ÇÀº ´ÙÀ½°ú °°½À´Ï´Ù.

±×¸² 66. db2adutl¿¡ ´ëÇÑ ±¸¹®


SQLD0ADU

¿©±â¼­,

QUERY
DB2 ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ TSM ¼­¹ö¸¦ Á¶È¸ÇÕ´Ï´Ù.

EXTRACT
TSM ¼­¹ö¿¡¼­ Áö¿ª ¸Ó½Å ¹× µð·ºÅ丮·Î DB2 ¿ÀºêÁ§Æ®¸¦ º¹»çÇÕ´Ï´Ù.

DELETE
¹é¾÷ ¿ÀºêÁ§Æ®¸¦ ºñȰ¼ºÈ­Çϰųª TSM ¼­¹ö¿¡¼­ ·Î±× ¾ÆÄ«À̺긦 »èÁ¦ÇÕ´Ï´Ù.

VERIFY
¼­¹ö¿¡ ÀÖ´Â ¹é¾÷ »çº»¿¡ ´ëÇØ Àϰü¼º Á¡°ËÀ» ¼öÇàÇÕ´Ï´Ù(ÀÌ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¸é ³×Æ®¿öÅ©¸¦ ÅëÇØ Àüü ¹é¾÷ À̹ÌÁö°¡ Àü¼ÛµÈ´Ù´Â Á¡À» À¯ÀÇÇϽʽÿÀ).

TABLESPACE
Å×ÀÌºí °ø°£ ¹é¾÷ À̹ÌÁö¸¸À» Æ÷ÇÔÇÕ´Ï´Ù.

FULL
Àüü µ¥ÀÌÅͺ£À̽º ¹é¾÷ À̹ÌÁö¸¸À» Æ÷ÇÔÇÕ´Ï´Ù.

LOADCOPY
·Îµå »çº» À̹ÌÁö¸¸À» Æ÷ÇÔÇÕ´Ï´Ù.

LOGS
·Î±× ¾ÆÄ«À̺ê À̹ÌÁö¸¸À» Æ÷ÇÔÇÕ´Ï´Ù.

BETWEEN sn1 AND sn2
·Î±× ¼øÂ÷ ¹øÈ£ 1°ú ·Î±× ¼øÂ÷ ¹øÈ£ 2 »çÀÌÀÇ ·Î±×¸¦ »ç¿ëÇϱâ À§ÇØ ÀÌ ¿É¼ÇÀ» ÁöÁ¤ÇÕ´Ï´Ù.

SHOW INACTIVE
ºñȰ¼ºÈ­µÈ ¹é¾÷ ¿ÀºêÁ§Æ®¸¦ Æ÷ÇÔÇÕ´Ï´Ù.

TAKEN AT timestamp
½Ã°£¼ÒÀÎÀ¸·Î ¹é¾÷ À̹ÌÁö¸¦ ÁöÁ¤ÇÕ´Ï´Ù.

KEEP n
½Ã°£¼ÒÀÎÀ¸·Î ÃÖ±ÙÀÇ nÀ» Á¦¿ÜÇϰí ÁöÁ¤ À¯ÇüÀÇ ¸ðµç ¿ÀºêÁ§Æ®¸¦ ºñȰ¼ºÈ­ÇÕ´Ï´Ù.

OLDER THAN timestamp ¶Ç´Â n_days
timestamp ¶Ç´Â nÀÏ µ¿¾È º¸´Ù À̸¥ ½Ã°£¼ÒÀÎÀ» °¡Áø ¿ÀºêÁ§Æ®°¡ ºñȰ¼ºÈ­µË´Ï´Ù.

DATABASE database_name
database_name¸¸À¸·Î ¿¬°üµÈ ¿ÀºêÁ§Æ®·Î ÀÛ¾÷Çϵµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.

NODE node_number
³ëµå node_number¸¸À¸·Î ÀÛ¼ºµÈ ¿ÀºêÁ§Æ®·Î ÀÛ¾÷Çϵµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.

PASSWORD password
ÀÌ ³ëµå¿¡ ´ëÇÑ TSM Ŭ¶óÀÌ¾ðÆ® ¾ÏÈ£¸¦ ÁöÁ¤ÇÕ´Ï´Ù(ÇÊ¿äÇÑ °æ¿ì). ƯÁ¤ µ¥ÀÌÅͺ£À̽º°¡ ÁöÁ¤µÇ°í ¾ÏÈ£°¡ Á¦°øµÇÁö ¾ÊÀº °æ¿ì, tsm_password µ¥ÀÌÅͺ£À̽º ±¸¼º ¸Å°³º¯¼ö¿¡ ÁöÁ¤ÇÑ °ªÀÌ TSM¿¡ Àü´ÞµÇ¸ç, ±×·¸Áö ¾ÊÀº °æ¿ì¾ÏÈ£°¡ »ç¿ëµÇÁö ¾Ê½À´Ï´Ù.

NODENAME node_name
ƯÁ¤ TSM ³ëµå À̸§¸¸À¸·Î ¿¬°üµÈ À̹ÌÁö·Î ÀÛ¾÷Çϵµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.

OWNER owner
node_number¸¸À¸·Î ÀÛ¼ºµÈ ¿ÀºêÁ§Æ®·Î ÀÛ¾÷Çϵµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.

WITHOUT PROMPTING
¿ÀºêÁ§Æ®°¡ »èÁ¦µÇ±â Àü¿¡ °ËÁõÇϵµ·Ï ÇÁ·ÒÇÁÆ®µÇÁö ¾Ê½À´Ï´Ù.

°¢ ¸í·ÉÀ» »ç¿ëÇÒ ¶§, DATABASE ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¿© ÀÛ¾÷ÇϰíÀÚ ÇÏ´Â µ¥ÀÌÅͺ£À̽º¸¦ ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. EXTRACT ¹× DELETE ¸í·ÉÀÇ °æ¿ì, WITHOUT PROMPTING ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¿© ¼±ÅÃÀ» È®ÀÎÇÏ´Â ÇÁ·ÒÇÁÆ®°¡ Á¦½ÃµÇÁö ¾Êµµ·Ï ¿ä±¸ÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÀÌ À¯Æ¿¸®Æ¼ÀÇ QUERY ¸í·ÉÀ» »ç¿ëÇÏ¿© ¹é¾÷, ·Î±× ¹× ·Îµå »çº» À̹ÌÁö¸¦ ³ª¿­ÇÒ ¼ö ÀÖ½À´Ï´Ù. ¹é¾÷Àº Àüü µ¥ÀÌÅͺ£À̽º, Å×ÀÌºí °ø°£ ¶Ç´Â µÑ ´Ù°¡ µÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¸í·ÉÀ» »ç¿ëÇÒ ¶§ ±âº»°ªÀº µÎ °¡Áö À¯ÇüÀÇ ¹é¾÷, ¸ðµç ·Îµå »çº» À̹ÌÁö, ¸ðµç ·Î±×¸¦ ³ª¿­ÇÏ´Â °ÍÀÔ´Ï´Ù. ¸ðµç ·Î±×¸¦ º¸´Â ´ë½Å, ³ª¿­µÉ ·Î±× ¹üÀ§¸¦ ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. »ç¿ëÁßÀÌ ¾Æ´Ñ ¹é¾÷À» º¸±â À§ÇØ ¿äûÇÒ ¼öµµ ÀÖ½À´Ï´Ù.

ÀÌ À¯Æ¿¸®Æ¼ÀÇ EXTRACT ¸í·ÉÀ¸·Î TSMÀ¸·ÎºÎÅÍ »ç¿ëÀÚÀÇ ÇöÀç µð·ºÅ丮 ¹é¾÷, ·Î±× ¶Ç´Â µÎ °¡Áö ¸ðµÎ¸¦ TSM ¼­¹ö¿¡¼­ º¹»çÇÒ ¼ö ÀÖ½À´Ï´Ù. ¹é¾÷Àº Àüü µ¥ÀÌÅͺ£À̽º, Å×ÀÌºí °ø°£ ¶Ç´Â µÑ´Ù°¡ µÉ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¸í·ÉÀ» »ç¿ëÇÒ °æ¿ì, »ç¿ëÁßÀÎ ¹é¾÷ À̹ÌÁö ¹× °¢ ·Î±×¸¦ ³ª¿­ÇÏ´Â °ÍÀº ±ÔÁ¤ÀÚ°¡ ¾ø´Â ±âº»°ªÀÔ´Ï´Ù. À̶§, ¹ßÃéÇÒ ¹é¾÷ ¹× ·Î±×¸¦ ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. ¸ðµç ·Î±×¸¦ º¸´Â ´ë½Å, ³ª¿­µÉ ·Î±× ¹üÀ§¸¦ ¼±ÅÃÇÒ ¼öµµ ÀÖ½À´Ï´Ù. »ç¿ëÁßÀÌ ¾Æ´Ñ ¹é¾÷À» º¸±â À§ÇØ ¿äûÇÒ ¼öµµ ÀÖ½À´Ï´Ù. ¹ßÃéÇÒ Æ¯Á¤¹é¾÷Àº TAKEN AT <timestamp> ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¿© ¼±ÅÃµÉ ¼ö ÀÖ½À´Ï´Ù.

ÀÌ À¯Æ¿¸®Æ¼ÀÇ DELETE ¸í·ÉÀ» »ç¿ëÇÏ¿© ·Î±×¸¦ »èÁ¦Çϰųª TSMÀ¸·ÎºÎÅÍ ¹é¾÷À» ºñȰ¼ºÈ­ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¸í·ÉÀ» »ç¿ëÇÒ °æ¿ì, »ç¿ëÁßÀÎ ¹é¾÷ À̹ÌÁö ¹× °¢ ·Î±×¸¦ ³ª¿­ÇÏ´Â °ÍÀº ±ÔÁ¤ÀÚ°¡ ¾ø´Â ±âº»°ªÀÔ´Ï´Ù. À̶§, »èÁ¦/ºñȰ¼ºÈ­ÇÒ ¹é¾÷ ¹× ·Î±×¸¦ ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. KEEP nÀ¸·Î ÀÌ ¸í·ÉÀ» ±ÔÁ¤ÇÏ¿© ÃÖ±ÙÀÇ n ¹é¾÷À» º¸°üÇÒ ¼ö ÀÖ½À´Ï´Ù. OLDER [THAN] <timestamp> ¶Ç´Â n DAYS¸¦ »ç¿ëÇÏ¿© ¸í·ÉÀ» ±ÔÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. À̰ÍÀº ÁÖ¾îÁø ³¯Â¥(½Ã°£¼ÒÀÎ)º¸´Ù ¿À·¡µÇ°Å³ª ÁöÁ¤µÈ ³¯Â¥º¸´Ù ¿À·¡µÈ ¹é¾÷À» »èÁ¦ÇÕ´Ï´Ù. ¸ðµç ·Î±×¸¦ º¸´Â ´ë½Å, ³ª¿­µÉ ·Î±× ¹üÀ§¸¦ ¼±ÅÃÇÒ ¼öµµ ÀÖ½À´Ï´Ù. »èÁ¦ÇÒ Æ¯Á¤ ¹é¾÷Àº TAKEN AT <timestamp> ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¿© ¼±ÅÃµÉ ¼ö ÀÖ½À´Ï´Ù.

DB2ÀÇ °æ¿ì, TSM ±âº» ±ÔÁ¤À» »ç¿ëÇÒ °ÍÀ» ±ÇÀåÇÕ´Ï´Ù. ¹é¾÷ À̸§ ÁöÁ¤ ±Ô¾à¿¡ ´ëÇÑ º¯°æ»çÇ×À¸·Î °¢ ¹é¾÷Àº ÀÌÁ¦ °íÀ¯ÇÕ´Ï´Ù. ±âÁ¸ ¹é¾÷À» »èÁ¦ÇÏ·Á¸é, »ç¿ëÁßÀÎ »çº»ÀÌ º¸°üµÇÁö ¾Êµµ·Ï ±ÔÁ¤À» ¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.

ÀÌ À¯Æ¿¸®Æ¼ »ç¿ëÀÇ ¿¹´Â db2adutl »ç¿ëÀÇ ¿¹¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

db2adutl »ç¿ëÀÇ ¿¹

db2 backup database rawsampl use adsm
¹é¾÷¿¡ ¼º°øÇß½À´Ï´Ù. ÀÌ ¹é¾÷ À̹ÌÁö¿¡ ´ëÇÑ ½Ã°£¼ÒÀÎÀº 19970929130942ÀÔ´Ï´Ù.

db2adutl query
 
Query for database RAWSAMPL
 
Retrieving full database backup information.
   full database backup image: 1, Time: 19970929130942,
                                  Oldest log: S0000053.LOG, Sessions used: 1
   full database backup image: 2, Time: 19970929142241,
                                  Oldest log: S0000054.LOG, Sessions used: 1
 
Retrieving table space backup information.
   table space backup image: 1, Time: 19970929094003,
                                  Oldest log: S0000051.LOG, Sessions used: 1
   table space backup image: 2, Time: 19970929093043,
                                  Oldest log: S0000050.LOG, Sessions used: 1
   table space backup image: 3, Time: 19970929105905,
                                  Oldest log: S0000052.LOG, Sessions used: 1
 
Retrieving log archive information.
   Log file: S0000050.LOG
   Log file: S0000051.LOG
   Log file: S0000052.LOG
   Log file: S0000053.LOG
   Log file: S0000054.LOG
   Log file: S0000055.LOG

db2adutl delete full taken at 19950929130942 db rawsampl
 
µ¥ÀÌÅͺ£À̽º RAWSAMPL¿¡ ´ëÇÑ Á¶È¸
 
¿ÏÀüÇÑ µ¥ÀÌÅͺ£À̽º ¹é¾÷ Á¤º¸ °Ë»ö Áß. ±â´Ù¸®½Ê½Ã¿À.
 
   ¿ÏÀüÇÑ µ¥ÀÌÅͺ£À̽º ¹é¾÷ À̹ÌÁö: RAWSAMPL.0.db26000.0.19970929130942.001
 
   ÀÌ ¹é¾÷ À̹ÌÁö¸¦ ºñȰ¼ºÈ­ÇϰڽÀ´Ï±î(Y/N)? y
 
     °è¼ÓÇϽðڽÀ´Ï±î(Y/N)? y

db2adutl query
 
Query for database RAWSAMPL
 
Retrieving full database backup information.
   full database backup image: 2, Time: 19950929142241,
                            Oldest log: S0000054.LOG, Sessions used: 1
 
Retrieving table space backup information.
   table space backup image: 1, Time: 19950929094003,
                            Oldest log: S0000051.LOG, Sessions used: 1
   table space backup image: 2, Time: 19950929093043,
                            Oldest log: S0000050.LOG, Sessions used: 1
   table space backup image: 3, Time: 19950929105905,
                            Oldest log: S0000052.LOG, Sessions used: 1
 
Retrieving log archive information.
   Log file: S0000050.LOG
   Log file: S0000051.LOG
   Log file: S0000052.LOG
   Log file: S0000053.LOG
   Log file: S0000054.LOG
   Log file: S0000055.LOG


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