µ¥ÀÌÅͺ£À̽º ¿¬°á

ÆÄÀÏÀÇ DB_CONNECTIVITY ¼½¼Ç¿¡ ÀÖ´Â ¸Å°³º¯¼ö´Â DBMS(Database Management System)¿ÍÀÇ InterChange Server Àüü »óÈ£ ÀÛ¿ëÀ» Á¦¾îÇÕ´Ï´Ù.

MAX_CONNECTIONS

InterChange Server°¡ DBMS ¼­¹ö¿Í µ¿½Ã¿¡ ¼³Á¤ÇÒ ¼ö ÀÖ´Â ¿¬°á ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼ö´Â InterChange ServerÀÇ ÃÑ ¿¬°á ¼ö¸¦ Á¦¾îÇÕ´Ï´Ù. À̺¥Æ® °ü¸®ÀÚ, ÀúÀå¼Ò, Æ®·£Àè¼Ç ¹× ÇÃ·Î¿ì ¸ð´ÏÅ͸µ ¼½¼Ç¿¡ ÀÖ´Â À¯»çÇÑ ¸Å°³º¯¼ö´Â ƯÁ¤ ¼­ºñ½º¿¡ ÇÒ´çµÇ´Â ¿¬°á ¼ö¸¦ Á¦¾îÇÕ´Ï´Ù.

ÀÌ ¸Å°³º¯¼ö¿¡ ´ëÇÑ °ªÀ» ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é InterChange Server´Â IDLE_TIMEOUT ¸Å°³º¯¼ö¸¦ »ç¿ëÇÏ¿© ±âº» 2ºÐ ¶Ç´Â ÁöÁ¤µÈ ½Ã°£ µ¿¾È ´ë±âÇÑ ÈÄ¿¡ ¿¬°áÀ» ½Ã°£ Á¾·áÇÏ¿© ÇÊ¿äÇÑ ¸¸Å­ÀÇ ¿¬°á ¼ö¸¦ »ç¿ëÇÕ´Ï´Ù.

¿¹Á¦: MAX_CONNECTIONS = 100

±âº»°ª

MAX_CONNECTIONS = 20
 

MAX_CONNECTION_POOLS

InterChange Server°¡ InterChange ServerÀÇ ¿¬°á ij½Ã¿¡ ´ëÇØ ÀÛ¼ºÇÏ´Â ÃÖ´ë ¿¬°á Ç® ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ÇöÀç ¼­¹ö´Â ÀúÀå¼Ò, À̺¥Æ® °ü¸®, Æ®·£Àè¼Ç ¹× ÇÃ·Î¿ì ¸ð´ÏÅ͸µ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ÇϳªÀÇ ¿¬°á Ç® °¢°¢À» ÀÛ¼ºÇÕ´Ï´Ù.

¿ÀºêÁ§Æ® °£ °ü°è¸¦ ÀÛ¼ºÇÒ ¶§ °ü°è ·±Å¸ÀÓ µ¥ÀÌÅÍÀÇ ÀúÀ念¿ª¿¡ »ç¿ëÇÒ µ¥ÀÌÅͺ£À̽º¸¦ ÁöÁ¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ µ¥ÀÌÅͺ£À̽º·ÎÀÇ ¿¬°áÀº ÀúÀå¼Ò, À̺¥Æ® °ü¸®, Æ®·£Àè¼Ç ¹× ÇÃ·Î¿ì ¸ð´ÏÅ͸µ µ¥ÀÌÅͺ£À̽º¿Í °°Àº ¹æ¹ýÀ¸·Î °ü¸®µË´Ï´Ù. MAX_CONNECTION_POOLS ¸Å°³º¯¼ö¿¡ »ç¿ëµÈ ¼öº¸´Ù ¸¹Àº µ¥ÀÌÅͺ£À̽º¸¦ ÁöÁ¤ÇÑ °æ¿ì ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³ª ÃÖ´ë ¿¬°á Ç® ¼ö¿¡ µµ´ÞÇßÀ½À» ¾Ë·ÁÁÝ´Ï´Ù.

»ç¿ë ÁßÀÎ µ¥ÀÌÅͺ£À̽º ¼ö¸¦ ¼ö¿ëÇÏ·Á¸é MAX_CONNECTION_POOLS ¸Å°³º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ÃÖ¼Ò°ªÀº 8ÀÏÀÔ´Ï´Ù.

¿¹: MAX_CONNECTION_POOLS = 60

±âº»°ª

MAX_CONNECTION_POOLS = 50 
 

MAX_DEADLOCK_RETRY_COUNT

¿¹¿Ü°¡ ¹ß»ýÇϱâ Àü¿¡ Æ®·£Àè¼ÇÀÌ Àç½ÃµµÇÏ´Â ÃÖ´ë Ƚ¼ö¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ±ÇÀåµÇ´Â Àç½Ãµµ Ƚ¼ö´Â 5ÀÔ´Ï´Ù. °ªÀÌ 0À¸·Î ¼³Á¤µÇ¸é, ½ÃÀÛ ½Ã InterChange Server¿¡ ÀÇÇØ °æ°í°¡ Ãâ·ÂµÇ¸ç, ±³Âø »óŰ¡ ¹ß»ýÇÏ´Â °æ¿ì Æ®·£Àè¼ÇÀº Àç½ÃµµµÇÁö ¾Ê½À´Ï´Ù. ÀÌ·Î ÀÎÇØ InterChange Server°¡ Á¾·áµÉ ¼ö ÀÖ½À´Ï´Ù.

Àç½Ãµµ ´ë±â ½Ã°£À» ÁöÁ¤ÇÏ·Á¸é DEADLOCK_RETRY_INTERVAL ¸Å°³º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ±ÇÀå ½Ã°£Àº 20ÃÊÀÔ´Ï´Ù.

±âº»°ª

MAX_DEADLOCK_RETRY_COUNT = 5 
 

DEADLOCK_RETRY_INTERVAL

Àç½Ãµµ ´ë±â ½Ã°£À» ÁöÁ¤ÇÕ´Ï´Ù. ±ÇÀå ½Ã°£Àº 20ÃÊÀÔ´Ï´Ù. Àç½Ãµµ ½Ã°£À» ³Ê¹« ±æ°Ô ¼³Á¤ÇÏ¸é ½Ã½ºÅÛÀÌ ºÒÇÊ¿äÇÏ°Ô ´À·ÁÁú ¼ö ÀÖ½À´Ï´Ù.

InterchangeSystem.cfg ÆÄÀÏÀÇ [DB_CONNECTIVITY] ¼½¼Ç¿¡¼­ ÀÌ °ªÀ» ¼³Á¤ÇϽʽÿÀ.

±âº»°ª

DEADLOCK_RETRY_INTERVAL = 20 
 

IDLE_TIMEOUT

InterChange Server¿Í DBMS ¼­¹ö °£ ¿¬°áÀÌ ²÷¾îÁö±â Àü¿¡ ¿¬°áÀÌ ´ë±âÇÏ´Â ÃÖ´ë ½Ã°£À» ÁöÁ¤ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼ö´Â MAX_CONNECTIONS ¸Å°³º¯¼ö¿Í ÇÔ²² ÀÛµ¿ÇÏ¿© ´ë±â ¿¬°áÀ» ÇØÁ¦Çϰí ÇØ´ç ¿¬°áÀ» »ç¿ë °¡´ÉÇÑ ¿¬°á ij½Ã·Î ¸®ÅÏÇÕ´Ï´Ù.

ÀÌ ¸Å°³º¯¼ö¿¡ ´ëÇÑ °ªÀ» ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é InterChange Server´Â ±âº»°ª 2ºÐÀ» »ç¿ëÇÕ´Ï´Ù. »ç¿ëÀÚ°¡ ÁöÁ¤ÇÏ´Â °ªÀÇ ´ÜÀ§´Â ºÐÀÔ´Ï´Ù.

¿¹Á¦: IDLE_TIMEOUT = 4

±âº»°ª

IDLE_TIMEOUT = 2 
 

JDBC_LOG

JDBC ·Î±ëÀÇ Ãâ·Â ÆÄÀÏÀ» ÁöÁ¤ÇÕ´Ï´Ù.

ÆÄÀÏÀº Àüü °æ·Î¸¦ ÁöÁ¤ÇÏÁö ¾Ê´Â ÇÑ, $HOME/IBM/WebSphereICS/bin µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù.

¸Å°³º¯¼ö°¡ ÆÄÀÏ¿¡ ³ªÅ¸³ªÁö ¾Ê°Å³ª ÁÖ¼® ó¸®µÈ °æ¿ì ·Î±ëÀº ¹ß»ýÇÏÁö ¾Ê½À´Ï´Ù.

¿¹Á¦:

JDBC_LOG = jdbc.out($HOME/IBM/WebSphereICS/bin µð·ºÅ丮)

±âº»°ª

ÀÌ ¸Å°³º¯¼öÀÇ ±âº»°ªÀº ¾ø½À´Ï´Ù.

DBMS

µ¥ÀÌÅͺ£À̽º ¼­¹ö À¯ÇüÀ» ÁöÁ¤ÇÕ´Ï´Ù. °ªÀº DB2, SQLSERVER(Microsoft SQL Server) ¶Ç´Â ORACLE(Oracle Server)ÀÌ µÉ ¼ö ÀÖ½À´Ï´Ù.
UNIX

Oracle Server, DB2 Server ¶Ç´Â Microsoft SQL Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. UNIX ½Ã½ºÅÛÀÇ À¯ÀÏÇÏ°Ô È£È¯ °¡´ÉÇÑ µ¥ÀÌÅͺ£À̽º ¼­¹ö´Â Oracle°ú DB2ÀÌÁö¸¸ Windows ½Ã½ºÅÛÀÇ Microsoft SQL Server¿Í UNIXÀÇ InterChange Server¸¦ ÇÔ²² ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.

Linux

Oracle Server, DB2 Server ¶Ç´Â Microsoft SQL Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù. Linux ½Ã½ºÅÛÀÇ À¯ÀÏÇÏ°Ô Áö¿øµÇ´Â µ¥ÀÌÅͺ£À̽º ¼­¹ö´Â DB2ÀÌÁö¸¸ ´Ù¸¥ ½Ã½ºÅÛÀÇ OracleÀ̳ª Microsoft SQL Server¿Í LinuxÀÇ InterChange Server¸¦ ÇÔ²² ½ÇÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.

Windows

µ¥ÀÌÅͺ£À̽º ¼­¹ö¿¡ ´ëÇØ Oracle Server, DB2 Server ¶Ç´Â Microsoft SQL Server¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

¿¹Á¦:

DBMS = ORACLE 
  
 DBMS = SQLSERVER
  
 DBMS = DB2
 

DRIVER

DBMS¸¦ Áö¿øÇÏ´Â µå¶óÀ̹öÀÇ À̸§À» ÁöÁ¤ÇÕ´Ï´Ù. °¡´ÉÇÑ °ªÀº ´ÙÀ½°ú °°½À´Ï´Ù.


Ç¥ 35. Áö¿øµÇ´Â DBMS À¯Çü°ú ÇÔ²² »ç¿ëµÇ´Â µå¶óÀ̹ö
DBMS À¯Çü µå¶óÀ̹ö À̸§ µå¶óÀ̹ö Ŭ·¡½º À̸§
MS SQL Server IBM ºê·£µå À¯Çü 4 µå¶óÀ̹ö com.ibm.crossworlds.jdbc. sqlserver.SQLServerDriver
Oracle IBM ºê·£µå À¯Çü 4 µå¶óÀ̹ö com.ibm.crossworlds.jdbc.

oracle.OracleDriver

DB2 Server DB2 JDBC À¯Çü 2 µå¶óÀ̹ö COM.ibm.db2.jdbc.app.DB2Driver

DB_CONNECT_RETRIES

¿¬°áÀÌ Áß´ÜµÈ °ÍÀ» ¹ß°ßÇÑ ÈÄ ¼­¹ö°¡ µ¥ÀÌÅͺ£À̽º¿¡ ´Ù½Ã ¿¬°áÀ» ½ÃµµÇϴ Ƚ¼öÀÇ ÃÖ´ë ¼ýÀÚ¸¦ ÁöÁ¤ÇÕ´Ï´Ù. ±ÇÀåµÇ´Â Àç½Ãµµ Ƚ¼ö´Â 3ÀÔ´Ï´Ù. ÀÌ °ªÀÌ 0À¸·Î ¼³Á¤µÇ¾î ÀÖÀ¸¸é µ¥ÀÌÅͺ£À̽º ¿¬°á º¹¿ø·ÂÀ» »ç¿ëÇÏÁö ¾Êµµ·Ï ÀüȯÇÏ´Â °Í°ú µ¿ÀÏÇÕ´Ï´Ù.

Àç½Ãµµ ´ë±â ½Ã°£À» ÁöÁ¤ÇÏ·Á¸é DB_CONNECT_INTERVAL ¸Å°³º¯¼ö¸¦ »ç¿ëÇϽʽÿÀ. ±ÇÀå ½Ã°£Àº 60ÃÊÀÔ´Ï´Ù.

ÀÌ ¸Å°³º¯¼ö¿Í DB_CONNECT_INTERVALÀº °ü°è¿¡¼­ »ç¿ëÇÏ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ ¿¬°á º¹¿ø·ÂÀ» °áÁ¤ÇÕ´Ï´Ù. ÀÌ µÎ ¸Å°³º¯¼ö´Â ±âŸ µ¥ÀÌÅͺ£À̽º °ü·Ã ¼½¼Ç (¿¹: À̺¥Æ® °ü¸®, ÀúÀå¼Ò, Æ®·£Àè¼Ç °ü¸®, ÇÃ·Î¿ì ¸ð´ÏÅ͸µ ¹× »ç¿ëÀÚ ·¹Áö½ºÆ®¸®)¿¡ ÀÖ´Â ÇØ´ç ¸Å°³º¯¼öÀÇ ±âº»°ªÀ» ¼³Á¤ÇÏ´Â µ¥µµ »ç¿ëµË´Ï´Ù. µÎ ¸Å°³º¯¼ö°¡ ÇØ´ç ¼½¼Ç¿¡ ¸íÈ®È÷ Á¤ÀǵÇÁö ¾Ê´Â °æ¿ì, ÀÌ ¼½¼Ç¿¡ Á¤ÀÇµÈ °ªÀ» »ç¿ëÇÕ´Ï´Ù.

ÁÖ:
DB_CONNECT_RETRIES ¸Å°³º¯¼ö´Â InterChange Server ±¸¼º ¸¶¹ý»ç¿¡ Ç¥½ÃµÇÁö ¾ÊÀ¸¸ç System Manager¸¦ »ç¿ëÇÏ¿© InterchangeSystem.cfgÀÇ [DB_CONNECTIVITY] ¼½¼ÇÀ» ÆíÁýÇÏ¿© º¯°æÇØ¾ß ÇÕ´Ï´Ù.

±âº»°ª

DB_CONNECT_RETRIES = 3
 

DB_CONNECT_INTERVAL

µ¥ÀÌÅͺ£À̽º ¿¬°á Àç½Ãµµ ´ë±â ½Ã°£À» ÁöÁ¤ÇÕ´Ï´Ù. ±ÇÀå ½Ã°£Àº 60ÃÊÀÔ´Ï´Ù.

InterchangeSystem.cfg ÆÄÀÏÀÇ [DB_CONNECTIVITY] ¼½¼Ç¿¡¼­ ÀÌ °ªÀ» ¼³Á¤ÇϽʽÿÀ. »ç¿ëÀÚ°¡ ÁöÁ¤ÇÏ´Â °ªÀÇ ´ÜÀ§´Â ÃÊÀÔ´Ï´Ù.

ÁÖ:
DB_CONNECT_INTERVAL ¸Å°³º¯¼ö´Â InterChange Server ±¸¼º ¸¶¹ý»ç¿¡ Ç¥½ÃµÇÁö ¾ÊÀ¸¸ç System Manager¸¦ »ç¿ëÇÏ¿© InterchangeSystem.cfgÀÇ [DB_CONNECTIVITY] ¼½¼ÇÀ» ÆíÁýÇÏ¿© º¯°æÇØ¾ß ÇÕ´Ï´Ù.

±âº»°ª

DB_CONNECT_INTERVAL = 60
 

Copyright IBM Corp. 1997, 2004