Windows**¿ë EEEÀÇ ºü¸¥ ½ÃÀÛ

µ¥ÀÌÅͺ£À̽º ÀÌÁÖ

ÀÌ ÀýÀº ¹öÀü 5.x¿¡¼­ ¹öÀü 7.1 Çü½ÄÀ¸·Î µ¥ÀÌÅͺ£À̽º¸¦ ÀÌÁÖ ÁßÀÎ °æ¿ì¿¡¸¸ Àû¿ëµË´Ï´Ù. ¹öÀü 6.1¿¡¼­ ¹öÀü 7.1·Î ÀÌÁÖ ÁßÀ̸é, ÀÌ ÀýÀ» °Ç³Ê¶Ù½Ê½Ã¿À.

¹öÀü 7 º¹¼ö ÆÄƼ¼Ç Çü½ÄÀ¸·Î ´ÜÀÏ ÆÄƼ¼Ç ¹öÀü 7 ÀνºÅϽº¸¦ °»½ÅÇÒ °æ¿ì, ÇØ´ç ÀνºÅϽºÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ÀÌÁÖÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.

»çÀü ¹öÀü 7 µ¥ÀÌÅͺ£À̽º°¡ ¹öÀü 7 ÆÄƼ¼Ç µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ¿¡¼­ »ç¿ëÇϱâ À§ÇØ ÀÌÁֵǸé, ÀÌ¿¡ ´ëÇØ ±âº» ³ëµå ±×·ìÀÌ ÀÛ¼ºµË´Ï´Ù. ±âÁ¸ ³ëµå ±×·ì ¹× À̵éÀÇ »ç¿ë ¹æ¹ý¿¡ ´ëÇØ¼­´Â ³ëµå ±×·ì ¹× µ¥ÀÌÅÍ ÆÄƼ¼Ç¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

ÀνºÅϽº¿¡¼­ ¼ÒÀ¯ÇÏ´Â ¹öÀü 5.x µ¥ÀÌÅͺ£À̽º¸¦ ÀÌÁÖÇÏ·Á¸é, ´ÙÀ½°ú °°ÀÌ ÇϽʽÿÀ.

  1. SYSADM ±ÇÇÑÀ» °®´Â »ç¿ëÀÚ °èÁ¤À¸·Î ·Î±×ÀÎÇϽʽÿÀ. ½Ã½ºÅÛ °ü¸® ±×·ì¿¡ ´ëÇÑ ÀÛ¾÷¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
  2. ÀÌÁÖÇÒ µ¥ÀÌÅͺ£À̽º°¡ īŻ·Î±×È­µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ. »ç¿ëÀÚ ½Ã½ºÅÛ¿¡¼­ īŻ·Î±×È­µÈ ¸ðµç µ¥ÀÌÅͺ£À̽º ¸ñ·ÏÀ» °Ë»öÇÏ·Á¸é, db2 list database directory ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ. ÀÌ ¸í·É ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
    DB2 LIST DATABASE DIRECTORY ¸í·É
     
    >>-LIST----+-DATABASE-+--DIRECTORY----+----------------+-------><
               '-DB-------'               '-ON--+-path--+--'
                                                '-drive-'
     
    

    ON path/drive ¸Å°³º¯¼ö´Â Á¤º¸¸¦ ³ª¿­ÇÒ Áö¿ª µ¥ÀÌÅͺ£À̽º µð·ºÅ丮¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼ö°¡ ÁöÁ¤µÇ¾î ÀÖÁö ¾ÊÀ¸¸é, ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮ÀÇ ³»¿ëÀÌ ³ª¿­µË´Ï´Ù. Command Reference¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ë ¹× ¿¹¸¦ ÂüÁ¶ÇϽʽÿÀ.

  3. db2 migrate database ¸í·ÉÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ ÀÌÁÖÇϽʽÿÀ. ÀÌ ¸í·É ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
    DB2MIGRATE DATABASE ¸í·É
     
    >>-MIGRATE----+-DATABASE-+--database-alias---------------------->
                  '-DB-------'
     
    >-----+---------------------------------------+----------------><
          '-USER--username--+------------------+--'
                            '-USING--password--'
     
    

    Command Reference¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ë ¹× ¿¹¸¦ ÂüÁ¶ÇϽʽÿÀ.

SYSCAT DMS Å×ÀÌºí °ø°£À» Æ÷ÇÔÇÏ´Â ¹öÀü 5 µ¥ÀÌÅͺ£À̽º ÀÌÁÖ
SYSCAT DMS(Database Managed Space) Å×ÀÌºí °ø°£ÀÌ µé¾î ÀÖ´Â ¹öÀü 5 µ¥ÀÌÅͺ£À̽º¸¦ ÀÌÁÖÇÒ °æ¿ì, µ¥ÀÌÅͺ£À̽º ÀÌÁÖ Àü¿¡ Å×ÀÌºí °ø°£¿¡ ´ë·« 70 ÆÛ¼¾Æ®ÀÇ ¿©À¯ °ø°£ ºñÀ²ÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù. db2 list tablespaces show detail ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© Å×ÀÌºí °ø°£ÀÇ Å©±â¸¦ Á¡°ËÇÒ ¼ö ÀÖ½À´Ï´Ù.

Å×ÀÌºí °ø°£¿¡ ¿©À¯ °ø°£ÀÌ ÃæºÐÇÏÁö ¾ÊÀ¸¸é, ´ÙÀ½°ú °°Àº ¿À·ù¸¦ ¼ö½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.

   SQL1704N Database migration failed. Reason code 17.

ÀÌ °æ¿ì, ¹öÀü 5 ÀνºÅϽº ÇÏ¿¡¼­ ¹öÀü 5 µ¥ÀÌÅͺ£À̽º¸¦ º¹¿øÇϰí, ALTER TABLESPACE¹®À» »ç¿ëÇÏ¿© ÄÁÅ×À̳ʸ¦ ´õ Ãß°¡ÇÑ ÈÄ, µ¥ÀÌÅͺ£À̽º¸¦ ´Ù½Ã ÀÌÁÖÇØ¾ß ÇÕ´Ï´Ù. Å×ÀÌºí °ø°£ ¹× ALTER TABLESPACE¹®¿¡ ´ëÇØ¼­´Â °ü¸® ¾È³»¼­ ¹× SQL ÂüÁ¶¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.


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