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