ÀÌ Àý¿¡¼´Â IWH.environment ÆÄÀÏ¿¡ ¼³Á¤ÇØ¾ß ÇÒ È¯°æ º¯¼ö¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù. º¯°æÇØ¾ß Çϴ ȯ°æ º¯¼ö´Â START ¹× END ÁÖ¼® Çà »çÀÌ¿¡ ÀÖ½À´Ï´Ù. ±×¸² 2¿¡´Â »ùÇà IWH.environment ÆÄÀÏÀÇ ±¸¼º °¡´É ºÎºÐÀÌ Ç¥½ÃµË´Ï´Ù.
ODBC¿Í DB2 CLI »ç¿ëÀÚ ¸ðµÎ¿¡°Ô ´ÙÀ½ ±ÔÄ¢ÀÌ Àû¿ëµË´Ï´Ù.
DB2 µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â ¿þ¾îÇϿ콺 ¼Ò½º³ª ¸ñÇ¥¿¡ ¾×¼¼½ºÇϱâ À§Çؼ´Â DB2 ȯ°æ ¼½¼Ç¿¡¼ º¯¼ö¸¦ ±¸¼ºÇØ¾ß ÇÕ´Ï´Ù.
ODBC »ç¿ëÀÚ¿¡°Ô ´ÙÀ½ ±ÔÄ¢ÀÌ Àû¿ëµË´Ï´Ù.
AIX¿¡¼, ±âº» °æ·Î´Â /usr/lpp/db2_07_01/odbcÀÔ´Ï´Ù. Solaris ¿î¿µ ȯ°æ¿¡¼ ±âº» °æ·Î´Â /opt/IBMdb2/V7.1/odbcÀÔ´Ï´Ù.
IWH.environment ÆÄÀÏ¿¡¼ÀÇ ¼³Á¤À» º¯°æÇÒ ¶§ ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ® µð¸ÕÀ» Àç½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù.
±×¸² 2. »ùÇà IWH.environment ÆÄÀÏ
# !!!!!!!!!!!!!!!!!!!!!!!!!! ATTENTION !!!!!!!!!!!!!!!!!!!!!!!!!
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
# ! START OF MUST SET ENVIRONMENT VARIABLES SECTION !
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
# ! DB2 environment section. Please set DB2 instance id !
#
DB2INSTANCE=<.... your DB2 instance id ....>
LANG=en_US
LC_ALL=en_US
DB2CODEPAGE=819
export DB2INSTANCE LANG LC_ALL DB2CODEPAGE
# ! If using Data Warehouse Center ODBC driver, set the
# ! IS_ODBC environment variable to the path for
# ! Data Warehouse Center ODBC driver directory.
#
# IS_ODBC=<....your ODBC base install directory>
# Should have path for Data Warehouse Center ODBC driver odbc dir
# ! For essbase udp, set the following path : !
#
# ARBORPATH=<..../essbase>
# export ARBORPATH
# ! If using Oracle ODBC driver, set the following paths: !
#
# ORACLE_HOME=<.... your Oracle client HOME dir ....>
# TNS_ADMIN=<.... your TNS_ADMIN dir ....>
# ORACLE_SID=<.... your ORACLE_SID ....>
# export ORACLE_HOME TNS_ADMIN ORACLE_SID
# ! If using Sybase ODBC driver, set the following paths: !
#
# SYBASE=<.... your Sybase client dir ....>
# DSQUERY=<.... your DSQUERY value ....>
# export SYBASE DSQUERY
# ! If using Informix ODBC driver, set the following paths:!
#
# INFORMIXDIR=<.... your Informix client dir ....>
# INFORMIXSERVER=<.... your Informix Server ....>
# export INFORMIXDIR INFORMIXSERVER
# Environment variables for JCL templates and logs.
# You can choose to change values for following environment variables !
#
VWSPATH=<... the warehouse agent base install directory ...>
VWS_LOGGING=/var/IWH/ # default path
export VWS_LOGGING VWSPATH
# !!!!!!!!!!!!!!!!!!!!!!!!!! ATTENTION !!!!!!!!!!!!!!!!!!!!!!!!!
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
# ! END OF MUST SET ENVIRONMENT VARIABLES SECTION !
# !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ® ȯ°æÀ» ±¸¼ºÇÏ·Á¸é,
IWH.agent.db.interface [ odbc | db2cli ]
¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ® ½ÇÇà ÆÄÀÏ ¹öÀüÀº µÎ °¡Áö°¡ ÀÖ½À´Ï´Ù.
À̰ÍÀº ±âº» ¸µÅ©ÀÔ´Ï´Ù.
¿©·¯ °³ÀÇ DB2 ÀνºÅϽº°¡ ÀÖ´Â °æ¿ì, ¸¶½ºÅÍ DB ÀνºÅϽº°¡ µÉ ÀνºÅϽº¸¦ Çϳª ¼±ÅÃÇØ¾ß ÇÕ´Ï´Ù.
LANG ¹× LC_ALL ȯ°æ º¯¼ö´Â ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®°¡ ·ÎÄÉÀÏÀ» »ç¿ëÀÚÀÇ ÇØ´ç Áö¿ª ·ÎÄÉÀÏ·Î ¼³Á¤Çϵµ·Ï ÁöÁ¤ÇÕ´Ï´Ù.
DB2CODEPAGE º¯¼ö´Â ½Ã½ºÅÛ ÄÚµå ÆäÀÌÁö¸¦ °ãÃľ¹´Ï´Ù. ÀÌ º¯¼ö¸¦ »ç¿ëÇÏ¿© Ŭ¶óÀÌ¾ðÆ®·ÎºÎÅÍ ±âº» ÄÚµå ÆäÀÌÁö¸¦ ÇØ¼®ÇÒ ¼ö ¾ø´Â ¼¹ö¿Í Åë½ÅÇÕ´Ï´Ù. DB2CODEPAGE º¯¼ö´Â ±âº» ÄÚµå ÆäÀÌÁö¸¦ ¼¹ö°¡ Áö¿øÇÏ´Â ÄÚµå ÆäÀÌÁö·Î ¼³Á¤ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â ¼³Ä¡ ¹× ±¸¼º º¸Ãæ ¼³¸í¼¿¡¼ ÂüÁ¶ÇϽʽÿÀ.
±âº» µð·ºÅ丮´Â /var/IWHÀÔ´Ï´Ù.
Solaris ¿î¿µ ȯ°æ ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ®ÀÇ ¾ð¾î ¹öÀüÀ» »ç¿ëÇϰí ÀÖ´Â °æ¿ì, »ç¿ëÀÚ´Â ¿¡ÀÌÀüÆ®°¡ ¹®ÀÚ¿ º¯È¯¿¡ »ç¿ëÇÒ ¼ö ÀÖ´Â »ç¿ëÀÚ Á¤ÀÇ º¯È¯Ç¥¸¦ ¼±ÅÃÇØ¾ß ÇÕ´Ï´Ù. ÀÌ·¸°Ô ÇÏ·Á¸é VWA_LOCALE_TABLE ȯ°æ º¯¼ö¸¦ IWH.environment ÆÄÀÏ¿¡ Ãß°¡Çϰí, ÇØ´ç °ªÀ» »ç¿ëÇϰíÀÚ ÇÏ´Â ÄÚµå ¼¼Æ®(¿¹: en_USÀÇ °æ¿ì 8859-1)·Î ¼³Á¤ÇϽʽÿÀ.
ÀÌµé Æ÷Æ® ¹øÈ£°¡ »ç¿ëÀÚÀÇ ¿î¿µ ȯ°æ¿¡¼ ÀÌ¹Ì »ç¿ë ÁßÀÎ °æ¿ì, ½Ã½ºÅÛÀÇ /etc/services ÆÄÀÏ¿¡¼ ÆùÆ® ¹øÈ£¸¦ º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª, Data Warehouse Center °ü¸® Ŭ¶óÀÌ¾ðÆ®¿Í ¿þ¾îÇϿ콺 ¼¹ö°¡ ¼³Ä¡µÈ ¿öÅ©½ºÅ×À̼ǰú, ¿¬°üµÈ ¸ðµç ¿þ¾îÇϿ콺 ¿¡ÀÌÀüÆ® »çÀÌÆ®¿¡¼ µ¿ÀÏÇÑ Æ÷Æ® ¹øÈ£¸¦ º¯°æÇØ¾ß ÇÕ´Ï´Ù.
¼³Ä¡ ÇÁ·Î¼¼½º´Â »ç¿ëÀÚÀÇ Áö¿ª /etc/services ÆÄÀϸ¸ °»½ÅÇϹǷΠÀÌµé ¼ºñ½º¸¦ Ãß°¡ÇØ¾ß ÇÕ´Ï´Ù.
ps -e | grep vwdaemon
kill pid
¿©±â¼ pid´Â µð¸Õ ÇÁ·Î¼¼½º IDÀÔ´Ï´Ù.
µð¸ÕÀ» ÁßÁöÇϸé ÀÚµ¿À¸·Î Àç½ÃÀ۵˴ϴÙ.