µ¥ÀÌÅÍ ¾ÆÄ«À̺ê

WebSphere Partner Gateway¿¡¼­ ¾ÆÄ«À̺ê´Â ºñȰ¼º »óÅÂ(½ÂÀÎ)ÀÇ ³»¿ëÀ» ¾ÈÀüÇÑ ¸Åü·Î À̵¿½Ã۱â À§ÇØ »ç¿ëµË´Ï´Ù. ¾ÆÄ«À̺ê´Â LG_MSG_ARCHIVE ¹× LG_CERT_ARCHIVE Ç¥¿¡¼­ ÀÌÀü µ¥ÀÌÅ͸¦ Á¦°ÅÇÏ´Â °ÍÀ¸·Î ÀÌ·ç¾îÁý´Ï´Ù. ¶ÇÇÑ ÆÄÀÏ ½Ã½ºÅÛÀÇ ½ÂÀÎ ÀúÀå¼Ò¿¡¼­ ¾ÆÄ«À̺ê·Î payload µ¥ÀÌÅÍ ÆÄÀÏÀ» À̵¿½Ãŵ´Ï´Ù. ½ÂÀÎ µ¥ÀÌÅͰ¡ ÇÊ¿äÇÒ °æ¿ì ¾ÆÄ«À̺êµÈ ÆÄÀÏÀ» º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù.

ÁÖÀÇ:
ƯÁ¤ µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» Á¦°ÅÇÏ¸é ½Ã½ºÅÛ¿¡ ÀúÀåµÈ ÆÄÀÏ¿¡ ´ëÇÑ Á¤º¸°¡ Á¦°ÅµË´Ï´Ù. µ¥ÀÌÅͺ£À̽º Å×À̺íÀ» Á¦°ÅÇϱâ Àü¿¡ ÀÌÀü ÆÄÀÏ Á¦°Å¸¦ °ËÅäÇϽʽÿÀ.
  1. Ç¥¿¡¼­ ¾ÆÄ«À̺ê·Î µ¥ÀÌÅ͸¦ º¹»çÇÏ·Á¸é ³»º¸³»±â ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇϽʽÿÀ.

    Oracle

    OracleÀÇ °æ¿ì, µ¥ÀÌÅͺ£À̽º¸¦ ³»º¸³»·Á¸é catexp.sql ¶Ç´Â catalog.sql ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ¼¼ºÎ»çÇ×Àº Oracle ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ. catexp.sql ¶Ç´Â catalog.sql ½ºÅ©¸³Æ®´Â µ¥ÀÌÅͺ£À̽º¿¡¼­ ÇÑ ¹ø¸¸ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ³»º¸³»±â¸¦ ¼öÇàÇϱâ Àü¿¡ ´Ù½Ã ½ÇÇàÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.

    ÁÖ:
    ½ºÅ©¸³Æ® ÆÄÀÏÀÇ ½ÇÁ¦ À̸§Àº »ç¿ë ÁßÀÎ ¿î¿µ üÁ¦¿¡ µû¶ó ´Ù¸¨´Ï´Ù. ½ºÅ©¸³Æ® ÆÄÀÏ À̸§°ú ½ºÅ©¸³Æ® ÆÄÀÏ¿¡ ´ëÇØ ½ÇÇàÇÏ´Â ¸Þ¼Òµå´Â Oracle ¿î¿µ üÁ¦ ƯÁ¤ ¹®¼­¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.

    ³»º¸³»±â¸¦ »ç¿ëÇϱâ Àü¿¡ ´ÙÀ½À» È®ÀÎÇϽʽÿÀ.

    ³»º¸³»±â ½ºÅ©¸³Æ®´Â Oracle Ŭ¶óÀÌ¾ðÆ®°¡ ¼³Ä¡µÈ ½Ã½ºÅÛ¿¡¼­ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ¶ÇÇÑ, ORACLE HOME, ORACLE SID ¹× ORACLE PATH ȯ°æ º¯¼ö¸¦ Á¤ÀÇÇØ¾ß ÇÕ´Ï´Ù. ½ºÅ©¸³Æ®´Â Ç÷§Æû¿¡ µû¶ó ´ÙÀ½ Áß Çϳª¿¡ À§Ä¡ÇÕ´Ï´Ù.

    UNIX: /opt/{INSTALL DIR}/DBLoader/scripts/Oracle/export.sh

    Windows: \{INSTALL DIR}\DBLoader\scripts\Oracle\export.bat OracleÀÇ °æ¿ì, ³»º¸³»±â ½ºÅ©¸³Æ®´Â ´ÙÀ½ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.

    ³»º¸³»±â ½ºÅ©¸³Æ®ÀÇ ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.

     ./export <system password> <connect string>
      <destination directory> <schema name> <cut off date YYYYMMDD>

    ³»º¸³»±â ½ºÅ©¸³Æ® ¿¹Á¦´Â ´ÙÀ½°ú °°½À´Ï´Ù.

     ./export password connectstring /tmp bcgapps 20030101

    ¾ÆÄ«À̺ê(export.dmp) ¹× export.log ÆÄÀÏÀÌ /tmp/20030101 Æú´õ¿¡ Ãß°¡µË´Ï´Ù.

    DB2

    ³»º¸³»±â ½ºÅ©¸³Æ®´Â µ¥ÀÌÅͺ£À̽º¿ÍÀÇ ¿¬°áÀ» ¼³Á¤ÇÑ ÈÄ DB2 ¸í·É â¿¡¼­ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ½ºÅ©¸³Æ®´Â ´ÙÀ½ Áß Çϳª¿¡ ÀÖÀ¸¸ç Ç÷§Æû¿¡ µû¶ó ´Ù¸¨´Ï´Ù.

    UNIX: /opt/{INSTALL DIR}/DBLoader/scripts/DB2/export.sh

    Windows: \{INSTALL DIR}\DBLoader\scripts\DB2\export.bat DB2ÀÇ °æ¿ì, ³»º¸³»±â ½ºÅ©¸³Æ®´Â ´ÙÀ½ ¸Å°³º¯¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.

    ³»º¸³»±â ½ºÅ©¸³Æ®ÀÇ ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.

     ./export <cutoff date YYYY-MM-DD> <archive location>
      <database name> <database user name> <database password>

    ³»º¸³»±â ½ºÅ©¸³Æ® ¿¹Á¦´Â ´ÙÀ½°ú °°½À´Ï´Ù.

     ./export 2003-01-01 /tmp bcgapps bcgapps
      db2inst1 pa55word

    ÁÖ:
    ³»º¸³»±â ½ºÅ©¸³Æ®´Â ¹«½ÃÇØµµ µÇ´Â SQL3100W °æ°í¸¦ Á¦°øÇÕ´Ï´Ù.

    ¾ÆÄ«ÀÌºê ¹× msgarchive.txt ·Î±× ÆÄÀÏÀÌ /tmp/2003-01-01 Æú´õ¿¡ Ãß°¡µË´Ï´Ù.

  2. ¾ÆÄ«ÀÌºê ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ¿© ÆÄÀÏ ½Ã½ºÅÛÀÇ ½ÂÀÎ ÀúÀå¼Ò¿¡¼­ ¾ÆÄ«À̺ê·Î payload µ¥ÀÌÅÍ ÆÄÀÏÀ» º¹»çÇϽʽÿÀ. ÀÌ ½ºÅ©¸³Æ®´Â ½ÂÀÎ ÆÄÀÏ ÀúÀå ½Ã½ºÅÛÀÌ ÀÖ´Â ½Ã½ºÅÛ¿¡¼­ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ½ºÅ©¸³Æ®´Â ´ÙÀ½ °æ·Î Áß Çϳª¿¡ ÀÖÀ¸¸ç Ç÷§Æû¿¡ µû¶ó ´Ù¸¨´Ï´Ù.

    UNIX: /opt/{INSTALL DIR}/bin

    Windows: \{INSTALL DIR}\bin

    1. setenv ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇÏ¿© PATH ¹× CLASSPATH º¯¼ö°¡ ÀûÀýÇÏ°Ô ¼³Á¤µÇ¾î ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
    2. DBArchiveParams.properties ÆÄÀÏÀº archive ½ºÅ©¸³Æ®°¡ ÇÊ¿äÇÑ ¸ðµç Á¤º¸¸¦ °¡Á®¿À´Â µ¥ »ç¿ëµË´Ï´Ù. DBArchiveParams.properties ÆÄÀÏÀ» ÆíÁýÇÏ¿© ¿Ã¹Ù¸¥ ¸Å°³º¯¼ö°¡ Àü´ÞµÇ´ÂÁö È®ÀÎÇϽʽÿÀ. ÀÚ¼¼ÇÑ Á¤º¸´Â »ùÇà ÀÔ·ÂÀ» ÂüÁ¶ÇϽʽÿÀ. Ç׸ñÀÌ ¿Ã¹Ù¸¥ µ¥ÀÌÅͺ£À̽º À¯Çü¿¡ ÇØ´çµÇ´ÂÁö È®ÀÎÇϽʽÿÀ. ¸¶°¨ ³¯Â¥´Â 1´Ü°è¿¡¼­ »ç¿ëÇÑ °Í°ú µ¿ÀÏÇØ¾ß ÇÕ´Ï´Ù. DB_ARCHIVE_TASK ¸Å°³º¯¼ö´Â 1·Î À¯ÁöÇØ¾ß ÇÕ´Ï´Ù.
    3. ¾ÆÄ«ÀÌºê ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇϽʽÿÀ. º¹»ç °á°ú´Â DBOutput.txt ÆÄÀÏ¿¡ ÁöÁ¤µÈ ´ë·Î ´ë»ó µð·ºÅ丮¿¡ º¸°üµË´Ï´Ù.
    ÁÖÀÇ:
    À§ÀÇ 1 ¹× 2´Ü°è¿¡¼­´Â µ¥ÀÌÅÍ ÀúÀå¼ÒÀÇ µ¥ÀÌÅ͸¦ ¾ÆÄ«À̺ê À§Ä¡·Î º¹»çÇÕ´Ï´Ù. º¹»ç Á¶ÀÛÀÌ ¿Ï·áµÉ ¶§±îÁö µ¥ÀÌÅÍ ÀúÀå¼Ò¿¡¼­ µ¥ÀÌÅ͸¦ Á¦°ÅÇÏ´Â 3°ú 4´Ü°è´Â ½ÇÇàÇÏÁö ¸¶½Ê½Ã¿À.
  3. DBArchiveParams.properties ÆÄÀÏÀÇ DB_ARCHIVE_TASK ¸Å°³º¯¼ö¸¦ 0À¸·Î ¼³Á¤ÇϽʽÿÀ.
  4. ¾ÆÄ«ÀÌºê ½ºÅ©¸³Æ®¸¦ ´Ù½Ã ½ÇÇàÇÏ¿© ÆÄÀÏ ½Ã½ºÅÛÀÇ ½ÂÀÎ ÀúÀå¼Ò¿¡¼­ payload µ¥ÀÌÅÍ ÆÄÀÏÀ» Á¦°ÅÇϽʽÿÀ.

    ÀÌ ½ºÅ©¸³Æ®´Â ½ÂÀÎ ÆÄÀÏ ÀúÀå ½Ã½ºÅÛÀÌ ÀÖ´Â ½Ã½ºÅÛ¿¡¼­ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ¶ÇÇÑ ÀÌ ½ºÅ©¸³Æ®´Â °ü¸®ÀÚ ¶Ç´Â ·çÆ® Ư±ÇÀ» »ç¿ëÇÏ¿© ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.

  5. AR_NONREP_MAINTENANCE µ¥ÀÌÅͺ£À̽º ÀúÀå ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÏ¿© LG_MSG_ARCHIVE ¹× LG_CERT_ARCHIVE Ç¥¿¡¼­ ¾ÆÄ«ÀÌºê µ¥ÀÌÅ͸¦ Á¦°ÅÇϽʽÿÀ. ÀÔ·Â ¸Å°³º¯¼ö·Î ¸¶°¨ ³¯Â¥°¡ »ç¿ëµË´Ï´Ù. ÀÌ ÀúÀå ÇÁ·Î½ÃÀú´Â µ¥ÀÌÅͺ£À̽º¿¡¼­ »ç¿ë °¡´ÉÇÏ¸ç ¼³Ä¡ Áß Ãß°¡µË´Ï´Ù.

    AR_NONREP_MAINTENANCE ÀúÀå ÇÁ·Î½ÃÀúÀÇ ±¸¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.

    Oracle: execute AR_NONREP_MAINTENANCE(YYYY-MM-DD)
    DB2: call AR_NONREP_MAINTENANCE(YYYY-MM-DD)

Copyright IBM Corp. 2003, 2005