µ¥ÀÌÅͺ£À̽º ¾÷±×·¹À̵å

´ÙÀ½ ÇÁ·Î½ÃÀú¿¡¼­´Â DBLoader¸¦ »ç¿ëÇÏ¿© ¾÷±×·¹À̵åµÈ ¹öÀü¿¡ ¸Â°Ô µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» °»½ÅÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.

  1. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© µ¥ÀÌÅͺ£À̽º ·Î´õ¸¦ ¼³Ä¡ Á¦°ÅÇϽʽÿÀ(Windows¿¡¼­´Â °ü¸®ÀÚ »ç¿ëÀÚ·Î, UNIX¿¡¼­´Â ·çÆ® »ç¿ëÀÚ·Î).

    {INSTALL DIR}/DBLoader/_uninst/uninstall

    Áß¿ä:
    ¼³Ä¡ Á¦°Å Áß¿¡ µ¥ÀÌÅͺ£À̽º »èÁ¦¸¦ ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À. ¹é¾÷ÇÏÁö ¾ÊÀº °æ¿ì¿¡ µ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÏ¸é µ¥ÀÌÅͰ¡ À¯½ÇµË´Ï´Ù. ±âÁ¸ µ¥ÀÌÅͺ£À̽º´Â ÈÄ¼Ó ´Ü°è¿¡¼­ ¾÷±×·¹À̵åµË´Ï´Ù.
  2. µ¥ÀÌÅͺ£À̽º°¡ ÀÌ ¸±¸®½º¿¡ ´ëÇØ Áö¿øµÇ´Â ¿ä±¸»çÇ×À» ÃæÁ·½ÃŰ´ÂÁö °ËÁõÇÏ·Á¸é Ç÷§Æû, Çϵå¿þ¾î ¹× ¼ÒÇÁÆ®¿þ¾î ¿ä±¸»çÇ×À» ÂüÁ¶ÇϽʽÿÀ. ÇÊ¿äÇÑ °æ¿ì, °è¼ÓÇϱâ Àü¿¡ °»½ÅÇϽʽÿÀ.
  3. »ç¿ë ÁßÀÎ ¿î¿µ üÁ¦¿¡ ¸Â´Â setup* ½ÃÀÛ ÇÁ·Î±×·¥À» »ç¿ëÇÏ¿© ¸Åü À§Ä¡¿¡¼­ µ¥ÀÌÅͺ£À̽º ·Î´õ¸¦ ½ÇÇàÇϽʽÿÀ. ¿¹¸¦ µé¾î, ´ÙÀ½À» ÀÔ·ÂÇϽʽÿÀ.
    {CD_ROM/MEDIA DIR}/DBLoader/setup*
    ÁÖ:
    WindowsÀÇ °æ¿ì, µ¥ÀÌÅͺ£À̽º¸¦ ¼ÒÀ¯ÇÏ´Â »ç¿ëÀÚ·Î ·Î±×ÀÎÇß´ÂÁö È®ÀÎÇϽʽÿÀ. ±×·¯ÇÑ »ç¿ëÀÚ´Â º¸Åë DB2ADMINÀÔ´Ï´Ù.

    ¾Æ·¡ ÁöħÀ» µû¸£½Ê½Ã¿À.

    1. ÀÌÀü ¹öÀü¿¡ »ç¿ëµÈ µ¿ÀÏÇÑ ÀÔ·Â °ªÀ» ÁöÁ¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é, »ç¿ëÀÚ ID, ¾ÏÈ£, µ¥ÀÌÅͺ£À̽º º¥´õ µîÀÌ ÀÖ½À´Ï´Ù. ¹öÀü 4.2.2 À̻󿡼­´Â »ç¿ëÀÚ ÀÔ·Â Á¤º¸¸¦ install_cfg.properties¶ó´Â ÆÄÀÏ¿¡ ÀúÀåÇÕ´Ï´Ù. ÀÌ ÆÄÀÏÀº ÀÌÀü ÀÔ·ÂÀ» °ËÅäÇÏ´Â µ¥ »ç¿ëµÉ ¼ö ÀÖ½À´Ï´Ù.
    2. ±¸¼º ±âº»°ªÀ» °ËÁõÇϰí, ÇÊ¿äÇÑ °æ¿ì À̸¦ ´ëüÇϽʽÿÀ.
    3. ÀÚµ¿À¸·Î SQL ÆÄÀÏ ½ÇÇàÀ» ¼±ÅÃÇÏÁö ¸¶½Ê½Ã¿À.
      ÁÖ:
      µ¥ÀÌÅͺ£À̽º°¡ ÀÌ¹Ì Á¸ÀçÇÔÀ» ¾Ë·ÁÁÖ´Â °æ°í°¡ ¼ö½ÅµË´Ï´Ù. ÀÌ °æ°í¸¦ ¹«½ÃÇØµµ µË´Ï´Ù.
  4. {INSTALL DIR}/DBLoader/scripts/DB2 ¶Ç´Â {INSTALL DIR}/DBLoader/scripts/Oracle µð·ºÅ丮¿¡ ÀÖ´Â BCGUpgrade*.sql ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇϽʽÿÀ.
    ÁÖ:
    °¢ BCGUpgrade_from-ver_to-ver.sql ½ºÅ©¸³Æ®´Â ½Ã½ºÅÛ¿¡ Àû¿ëµÇ´Â °¡Àå ¿À·¡µÈ ¹öÀüºÎÅÍ ½ÃÀÛÇÏ¿© °¢ ÈÄ¼Ó ½ºÅ©¸³Æ®±îÁö ½ÇÇàµÇ¾î¾ß ÇÕ´Ï´Ù.

    DB2

    ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    1. UNIX: su - db2inst1
      Windows: DB2CLP ½ÃÀÛ
      ÁÖ:
      WindowsÀÇ °æ¿ì, µ¥ÀÌÅͺ£À̽º¸¦ ¼ÒÀ¯ÇÏ´Â »ç¿ëÀÚ·Î ·Î±×ÀÎÇß´ÂÁö È®ÀÎÇϽʽÿÀ. ±×·¯ÇÑ »ç¿ëÀÚ´Â º¸Åë DB2ADMINÀÔ´Ï´Ù.
    2. db2start(µ¥ÀÌÅͺ£À̽º°¡ ½ÃÀÛµÇÁö ¾ÊÀº °æ¿ì)
    3. db2 connect to bcgapps(¿©±â¼­ bcgapps´Â µ¥ÀÌÅͺ£À̽º À̸§)
    4. cd {INSTALL DIR}/DBLoader/scripts/DB2
    5. ±âÁ¸ ¹öÀü¿¡ µû¶ó ´ÙÀ½ ½ºÅ©¸³Æ® Áß Çϳª¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ ¾÷±×·¹À̵åÇϽʽÿÀ.

      4.2.0 - 4.2.1:
      db2 -td! -f BCGUpgrade_420_421.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_420_421.log

      4.2.1.0 - 4.2.1(Fix Pack 1Àº ¼³Ä¡µÇÁö ¾ÊÀ½):
      db2 -td! -f BCGUpgrade_421_421FP1.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_421_421FP1.log

      4.2.1.1 - 4.2.2:
      db2 -td! -f BCGUpgrade_421FP1_422.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_421FP1_422.log

      4.2.2 - 4.2.2.2(Fix Pack 2´Â ¼³Ä¡µÇÁö ¾ÊÀ½):
      db2 -td! -f BCGUpgrade_422_422FP2.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_422_422FP2.log

      4.2.2.2 - 4.2.2.3(Fix Pack 3Àº ¼³Ä¡µÇÁö ¾ÊÀ½):
      db2 -td! -f BCGUpgrade_422FP2_422FP3.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_422FP2_422FP3.log

      4.2.2.3 - 4.2.2.4(Fix Pack 4´Â ¼³Ä¡µÇÁö ¾ÊÀ½):
      db2 -td! -f BCGUpgrade_422FP3_422FP4.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_422FP3_422FP4.log

      4.2.2.4 - 6.0:
      db2 -td! -f BCGUpgrade_422FP4_600.sql -z
        /tmp/bcgdbloader/logs/BCGUpgrade_422FP4_600.log
    6. save_inputs ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ¿© DBLoader »ç¿ëÀÚ ÀÔ·ÂÀ» µ¥ÀÌÅͺ£À̽º¿¡ ·ÎµåÇϽʽÿÀ. ¿¹¸¦ µé¸é ´ÙÀ½°ú °°½À´Ï´Ù.
      db2 -td! -f save_inputs.sql -z
        /tmp/bcgdbloader/logs/save_inputs.log
    7. Set_Grants.sql ½ºÅ©¸³Æ®¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ÇÊ¿äÇÑ »ç¿ë ±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é ´ÙÀ½°ú °°½À´Ï´Ù.
      db2 -td! -vf Set_Grants.sql >/tmp/bcgdbloader/logs/Set_Grants.log

    Oracle

    ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

    ÁÖ:
    WindowsÀÇ °æ¿ì, °ü¸®ÀÚ »ç¿ëÀÚ·Î ·Î±×ÀÎÇØ¾ß ÇÕ´Ï´Ù.

    1. cd {INSTALL DIR}/DBLoader/scripts/Oracle
    2. ±âÁ¸ ¹öÀü¿¡ µû¶ó ´ÙÀ½ ½ºÅ©¸³Æ® Áß Çϳª¸¦ ½ÇÇàÇÏ¿© µ¥ÀÌÅͺ£À̽º¸¦ ¾÷±×·¹À̵åÇϽʽÿÀ.
      4.2.1.0 - 4.2.1(Fix Pack 1Àº ¼³Ä¡µÇÁö ¾ÊÀ½):
      sqlplus -L bcgapps/password @BCGUpgrade_421_421FP1.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_421_421FP1.log

      4.2.1.1 - 4.2.2:
      sqlplus -L bcgapps/password @BCGUpgrade_421FP1_422.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_421FP1_422.log

      4.2.2 - 4.2.2(Fix Pack 2´Â ¼³Ä¡µÇÁö ¾ÊÀ½):
      sqlplus -L bcgapps/password @BCGUpgrade_422_422FP2.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_422_422FP2.log

      4.2.2.2 - 4.2.2.3(Fix Pack 3Àº ¼³Ä¡µÇÁö ¾ÊÀ½):
      sqlplus -L bcgapps/password @BCGUpgrade_422FP2_422FP3.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_422FP2_422FP3.log

      4.2.2.3 - 4.2.2.4(Fix Pack 4´Â ¼³Ä¡µÇÁö ¾ÊÀ½):
      sqlplus -L bcgapps/password @BCGUpgrade_422FP3_422FP4.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_422FP3_422FP4.log

      4.2.2.4 - 6.0:
      sqlplus -L bcgapps/password @BCGUpgrade_422FP4_600.sql
        >/tmp/bcgdbloader/logs/BCGUpgrade_422FP4_600.log
    3. save_inputs.sql ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ¿© DBLoader »ç¿ëÀÚ ÀÔ·ÂÀ» µ¥ÀÌÅͺ£À̽º¿¡ ·ÎµåÇϽʽÿÀ. ¿¹¸¦ µé¸é ´ÙÀ½°ú °°½À´Ï´Ù.
      sqlplus -L bcgapps/password @save_inputs.sql
        >/tmp/bcgdbloader/logs/save_inputs.log
    4. Grants_Syns.sql ½ºÅ©¸³Æ®¸¦ »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º¿¡ ÇÊ¿äÇÑ »ç¿ë ±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ. ¿¹¸¦ µé¸é ´ÙÀ½°ú °°½À´Ï´Ù.
      sqlplus -L bcgapps/password @Grants_Syns.sql >/tmp/bcgdbloader/logs/
       Grants_Syns.log

Copyright IBM Corp. 2003, 2005