Business Integration Connect¿¡¼ ¾ÆÄ«À̺ê´Â ºñȰ¼º »óÅÂ(°ÅºÎµÇÁö ¾ÊÀº) ³»¿ëÀ» ¾ÈÀüÇÑ ¸Åü·Î À̵¿½Ã۱â À§ÇØ »ç¿ëµË´Ï´Ù. ¾ÆÄ«À̺ê´Â LG_MSG_ARCHIVE ¹× LG_CERT_ARCHIVE Å×ÀÌºí¿¡¼ ÀÌÀü µ¥ÀÌÅ͸¦ Á¦°ÅÇÏ´Â °ÍÀ¸·Î ÀÌ·ç¾îÁý´Ï´Ù. ¶ÇÇÑ ÆÄÀÏ ½Ã½ºÅÛÀÇ ½ÂÀÎ ÀúÀå¼Ò¿¡¼ ¾ÆÄ«À̺ê·Î payload µ¥ÀÌÅÍ ÆÄÀÏÀ» À̵¿½Ãŵ´Ï´Ù. ½ÂÀÎ µ¥ÀÌÅͰ¡ ÇÊ¿äÇÒ °æ¿ì ¾ÆÄ«À̺êµÈ ÆÄÀÏÀ» º¹¿øÇÒ ¼ö ÀÖ½À´Ï´Ù.
Oracle:
OracleÀÇ °æ¿ì, µ¥ÀÌÅͺ£À̽º¸¦ ³»º¸³¾ ¼ö ÀÖµµ·Ï catexp.sql ¶Ç´Â catalog.sql ½ºÅ©¸³Æ®¸¦ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ¼¼ºÎ»çÇ×Àº Oracle ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ. catexp.sql ¶Ç´Â catalog.sql ½ºÅ©¸³Æ®´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ÇÑ ¹ø¸¸ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ³»º¸³»±â¸¦ ¼öÇàÇϱâ Àü¿¡ ´Ù½Ã ½ÇÇàÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.
³»º¸³»±â¸¦ »ç¿ëÇϱâ Àü¿¡ ´ÙÀ½À» È®ÀÎÇϽʽÿÀ.
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
¾ÆÄ«ÀÌºê ¹× msgarchive.txt ·Î±× ÆÄÀÏÀÌ /tmp/2003-01-01 Æú´õ¿¡ Ãß°¡µË´Ï´Ù.
UNIX: /opt/IBM/WBIConnect/bin
Windows: \WBIConnect_Install_Dir\bin
ÀÌ ½ºÅ©¸³Æ®´Â ½ÂÀÎ ÆÄÀÏ ÀúÀå ½Ã½ºÅÛÀÌ ÀÖ´Â ½Ã½ºÅÛ¿¡¼ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù. ¶ÇÇÑ ÀÌ ½ºÅ©¸³Æ®´Â ¿î¿µÀÚ/·çÆ® Ư±ÇÀ» »ç¿ëÇÏ¿© ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.
Oracle: execute AR_NONREP_MAINTENANCE(YYYY-MM-DD)
DB2: call AR_NONREP_MAINTENANCE(YYYY-MM-DD)