BACKUP ¹× RESTORE ¸í·ÉÀ» È£ÃâÇÒ °æ¿ì, µ¥ÀÌÅͺ£À̽º ¶Ç´Â Å×ÀÌºí °ø°£ ¹é¾÷À» °ü¸®Çϱâ À§ÇØ Tivoli Storage Manager(TSM)(ÀÌÀüÀÇ Tivoli ADSM) Á¦Ç°À» »ç¿ëÇϵµ·Ï ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2¿Í ÇÔ²² Tivoli ADSM Ŭ¶óÀÌ¾ðÆ® ¹öÀü 3.1.x.3 ÀÌ»óÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. ´ÙÀ½ ÁÖÁ¦ Ç׸ñ¿¡¼´Â Ãß°¡ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥¿¡¼ TSM ¿É¼ÇÀ» »ç¿ëÇϱâ À§Çؼ´Â, ¸ÕÀú ´ÙÀ½°ú °°Àº ¼³Á¤ Ȱµ¿ÀÌ ¼öÇàµÇ¾î¾ß ÇÕ´Ï´Ù.
libApiDS.so -> libApiDS.so.1 libApiDS.so.1 -> /opt/IBMDSMap5/api/libApiDS.so.2
ÁÖ: | SunOS ¹× Solaris ȯ°æÀÇ °æ¿ì, À̰ÍÀº /opt/IBMDSMap5·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù. |
ÁÖ: | SunOS ¹× Solaris ȯ°æÀÇ °æ¿ì, À̰ÍÀº /opt/IBMDSMap5/dsm.opt·Î ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù. |
Tivoli Ŭ¶óÀÌ¾ðÆ®°¡ TSM ¼¹ö¿Í ÀÎÅÍÆäÀ̽ºÇÒ ¼ö ÀÖÀ¸·Á¸é, ¼¹ö¿¡ ´ëÇÑ ¾ÏÈ£°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ½ÇÇà °¡´É ÆÄÀÏÀÎ dsmapipw´Â ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ INSTHOME/sqllib/adsm µð·ºÅ丮¿¡ ¼³Ä¡µÇ¾î ÀÖ½À´Ï´Ù. ÀÌ ½ÇÇà ÆÄÀÏ·Î »ç¿ëÀÚ´Â TSM ¾ÏÈ£¸¦ ¼³Á¤ ¹× Àç¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
dsmapipw ¸í·ÉÀ» ½ÇÇàÇÏ·Á¸é "root" »ç¿ëÀڷμ ·Î±×ÀεǾî¾ß ÇÕ´Ï´Ù. ÀÌ ¸í·ÉÀÌ ½ÇÇàµÉ ¶§, ´ÙÀ½°ú °°Àº Á¤º¸°¡ ÇÁ·ÒÇÁÆ®µË´Ï´Ù.
ÁÖ: | BACKUP ¶Ç´Â RESTORE ¸í·ÉÀ» ½ÇÇàÇÏ´Â »ç¿ëÀÚ´Â ÀÌ ¾ÏÈ£¸¦ ¾Ë Çʿ䰡 ¾ø½À´Ï´Ù. ÀÌ ¸í·ÉÀ» ¼öÇàÇØ¾ß ÇÏ´Â À¯ÀÏÇÑ °æ¿ì´Â Ãʱ⠿¬°áÀ» À§ÇØ ¾ÏÈ£¸¦ ¼³Á¤ÇÒ ¶§¿Í TSM ¼¹ö¿¡ ¾ÏÈ£°¡ Àç¼³Á¤µÇ¾î ÀÖ´Â °æ¿ìÀÔ´Ï´Ù. |
µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥¿¡¼ TSM ¿É¼ÇÀ» »ç¿ëÇϱâ À§Çؼ´Â, ¸ÕÀú ´ÙÀ½°ú °°Àº ¼³Á¤ Ȱµ¿ÀÌ ¼öÇàµÇ¾î¾ß ÇÕ´Ï´Ù.
Tivoli Ŭ¶óÀÌ¾ðÆ®°¡ TSM ¼¹ö¿Í ÀÎÅÍÆäÀ̽ºÇÒ ¼ö ÀÖÀ¸·Á¸é, ¼¹ö¿¡ ´ëÇÑ ¾ÏÈ£°¡ ÀÖ¾î¾ß ÇÕ´Ï´Ù. ½ÇÇà °¡´É ÆÄÀÏÀÎ dsmapipw´Â ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ \sqllib\adsm µð·ºÅ丮¿¡ ¼³Ä¡µÇ¾î ÀÖ½À´Ï´Ù ÀÌ ½ÇÇà ÆÄÀÏ·Î »ç¿ëÀÚ´Â TSM ¾ÏÈ£¸¦ ¼³Á¤ ¹× Àç¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
dsmapipw ¸í·ÉÀ» ½ÇÇàÇÏ·Á¸é, Áö¿ª °ü¸®Àڷμ ·Î±×ÀεǾî¾ß ÇÕ´Ï´Ù ÀÌ ¸í·ÉÀÌ ½ÇÇàµÉ ¶§, ´ÙÀ½°ú °°Àº Á¤º¸°¡ ÇÁ·ÒÇÁÆ®µË´Ï´Ù.
ÁÖ: | BACKUP ¶Ç´Â RESTORE ¸í·ÉÀ» ½ÇÇàÇÏ´Â »ç¿ëÀÚ´Â ÀÌ ¾ÏÈ£¸¦ ¾Ë Çʿ䰡 ¾ø½À´Ï´Ù. ÀÌ ¸í·ÉÀ» ¼öÇàÇØ¾ß ÇÏ´Â À¯ÀÏÇÑ °æ¿ì´Â Ãʱ⠿¬°áÀ» À§ÇØ ¾ÏÈ£¸¦ ¼³Á¤ÇÒ ¶§¿Í TSM ¼¹ö¿¡ ¾ÏÈ£°¡ Àç¼³Á¤µÇ¾î ÀÖ´Â °æ¿ìÀÔ´Ï´Ù. |
TSM ¾È¿¡¼ ƯÁ¤ ±â´ÉÀ» »ç¿ëÇÏ·Á¸é, ±â´ÉÀ» »ç¿ëÇϰí ÀÖ´Â ¿ÀºêÁ§Æ®ÀÇ ¿ÏÀüÇÑ °æ·Î À̸§À» Á¦°øÇØ¾ß ÇÕ´Ï´Ù(OS/2 ¹× Windows NT Ç÷§Æû¿¡¼´Â / ´ë½Å \°¡ »ç¿ëµÊÀ» ±â¾ïÇϽʽÿÀ). Àüü °æ·Î À̸§Àº ´ÙÀ½°ú °°½À´Ï´Ù.
¿©±â¼, <database>´Â µ¥ÀÌÅͺ£À̽º º°¸í À̸§À̰í, NODEnnnnÀº ³ëµå ¹øÈ£ÀÔ´Ï´Ù.
ÁÖ: | ´ë¹®ÀڷΠǥ½ÃµÈ À̸§Àº Ç¥½ÃµÈ ´ë·Î ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù. |
ÀÌ ¸Å°³º¯¼ö¿¡ ±ÇÀåµÈ °ªÀº 6 000ÃÊÀÔ´Ï´Ù.
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 Ŭ¶óÀÌ¾ðÆ® ¾øÀÌ ½ÃµµÇؼ´Â ¾È µË´Ï´Ù.
db2adutl À¯Æ¿¸®Æ¼¸¦ ÅëÇØ ¹é¾÷, ·Î±×, TSMÀ» »ç¿ëÇÏ¿© ÀúÀåµÈ ·Îµå »çº» À̹ÌÁö¸¦ Á¶È¸, ¹ßÃé ¹× »èÁ¦ÇÒ ¼ö ÀÖ½À´Ï´Ù. À¯Æ¿¸®Æ¼´Â UNIX Ç÷§ÆûÀÇ INSTHOME/sqllib/misc µð·ºÅ丮¿¡ ¼³Ä¡µÇ¸ç, Intel Ç÷§ÆûÀÇ \sqllib\misc µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù.
ÁÖ: | ¹é¾÷À¸·Î ·Î±× ÆÄÀÏÀ» À¯ÁöÇÏ·Á°í ÇÒ ¼ö ÀÖ½À´Ï´Ù. TSMÀ» »ç¿ëÇÒ ¶§, TSMÀÇ Á¦¾î¿¡¼ ·Î±× ÆÄÀÏÀ» À̵¿ÇÏ·Á°í ÇÕ´Ï´Ù. À̰ÍÀº User ExitÀ¸·Î ¼öÇàµË´Ï´Ù. ºÎ·Ï F, µ¥ÀÌÅͺ£À̽º º¹±¸¸¦ À§ÇÑ User Exit¿¡¼ User Exit¸¦ »ç¿ëÇÏ´Â ¹æ¹ý¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ. |
db2adutl À¯Æ¿¸®Æ¼¸¦ ÅëÇØ »ç¿ë °¡´ÉÇÑ ¸ðµç ¿É¼ÇÀº ´ÙÀ½°ú °°½À´Ï´Ù.
![]() |
¿©±â¼,
°¢ ¸í·ÉÀ» »ç¿ëÇÒ ¶§, 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 »ç¿ëÀÇ ¿¹¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
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