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

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

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

    Oracle:

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

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

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

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

    UNIX: /opt/IBM/WBIConnect/DBLoader/scripts/Oracle/export.sh
     

    Windows: \WBIConnect_Install_Dir\DBLoader\scripts\Oracle\export.bat
     

    OracleÀÇ °æ¿ì export ½ºÅ©¸³Æ®¿¡´Â ´ÙÀ½ ¸Å°³º¯¼ö°¡ »ç¿ëµË´Ï´Ù.

    ±¸¹®: ./export <½Ã½ºÅÛ ¾ÏÈ£> <connect ¹®ÀÚ¿­> <´ë»ó µð·ºÅ丮> <½ºÅ°¸¶ À̸§> <¸¶°¨ ³¯Â¥ YYYYMMDD>

    ¿¹: ./export password connectstring /tmp bcgapps 20030101

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

    DB2:

    export ½ºÅ©¸³Æ®´Â µ¥ÀÌÅͺ£À̽º¿ÍÀÇ ¿¬°áÀ» ¼³Á¤ÇÑ ÈÄ db2 ¸í·É â¿¡¼­ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ½ºÅ©¸³Æ®´Â ´ÙÀ½¿¡ À§Ä¡ÇÕ´Ï´Ù.

    UNIX: /opt/IBM/WBIConnect/DBLoader/scripts/DB2/export.sh
     

    Windows: \WBIConnect_Install_Dir\DBLoader\scripts\DB2\export.bat
     

    DB2ÀÇ °æ¿ì export ½ºÅ©¸³Æ®¿¡´Â ´ÙÀ½ ¸Å°³º¯¼ö°¡ »ç¿ëµË´Ï´Ù.

    ±¸¹®: ./export <¸¶°¨ ³¯Â¥ YYYY-MM-DD> <¾ÆÄ«À̺ê À§Ä¡> <µ¥ÀÌÅͺ£À̽º À̸§> <µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ À̸§> <µ¥ÀÌÅͺ£À̽º ¾ÏÈ£>

    ¿¹: ./export 2003-01-01 /tmp bcgapps bcgapps db2inst1 pa55word

    ÁÖ:
    export´Â ¹«½ÃÇØµµ µÇ´Â SQL3100W °æ°í¸¦ Á¦°øÇÕ´Ï´Ù.

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

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

    UNIX: /opt/IBM/WBIConnect/bin
     

    Windows: \WBIConnect_Install_Dir\bin
     

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

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

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

    Oracle: execute AR_NONREP_MAINTENANCE(YYYY-MM-DD)
     

    DB2: call AR_NONREP_MAINTENANCE(YYYY-MM-DD)
     

Copyright IBM Corp. 1997, 2004