12Àå

informix dynamic server 7.3 ¼ÂÆÃ ¹× Ȱ¿ë




Ȳ »ó ±¸


1. ÀÎÆ÷¹Í½º Á¦Ç° ºñ±³

1.1 informix-se(standard engine)

1980³âÃÊ¿¡ ÀÎÆ÷¹Í½º´Â Áß¼Ò±â¾÷¿¡ ¾Ë¸ÂÀº °ü°èÇü µ¥ÀÌÅͺ£À̽º¸¦ Ãâ½ÃÇߴµ¥, À̰ÍÀÌ ½Ã½ºÅÛ ¸®¼Ò½º³ª À¯Áöº¸¼ö¸¦ Å©°Ô ¿ä±¸ÇÏÁö ¾Ê´Â informix-seÀÌ´Ù. Ŭ¶óÀ̾ðÆ®/¼­¹ö µ¥ÀÌÅͺ£À̽º ±¸Á¶¿¡¼­ Ŭ¶óÀÌ¾ðÆ®´Â µ¥ÀÌÅ͸¦ ÀúÀåÇϰí, À¯ÁöÇÏ´Â ¼­¹ö·ÎºÎÅÍ ºÐ¸®µÈ ÇÁ·Î¼¼½º¸¦ ÀǹÌÇÑ´Ù. Ŭ¶óÀÌ¾ðÆ®´Â ¹Ýµå½Ã ¼­¹ö°¡ ¿î¿ëµÇ°í ÀÖ´Â ½Ã½ºÅÛÀ¸·ÎºÎÅÍ ºÐ¸®µÇ¾î ¿î¿ëµÉ ÇÊ¿ä´Â ¾ø´Ù. informix-se´Â ´Ù¾çÇÑ Á¾·ùÀÇ Å¬¶óÀÌ¾ðÆ®µéÀÌ sqlÀ» ÅëÇØ¼­ µ¥ÀÌÅÍ¿¡ Á¢±ÙÇÒ ¼ö ÀÖµµ·Ï Çã¿ëÇϰí ÀÖ´Ù. informix-se´Â °ü°èÇü µ¥ÀÌÅͺ£À̽º ¼­¹öÀÏ »Ó¸¸ ¾Æ´Ï¶ó ÀÏ¹Ý »ç¿ëÀÚµéÀÌ Å×ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÒ ¼ö ÀÖµµ·Ï Ŭ¶óÀÌ¾ðÆ® ÅøÀÎ dbaccess¸¦ Á¦°øÇÑ´Ù.

informix-se´Â cost-based optimizer¸¦ Á¦°øÇÏ°í ¼º´É Çâ»óÀ» À§Çؼ­ b+ Æ®¸® À妽º¸¦ »ç¿ëÇÑ´Ù. ¶ÇÇÑ stored procedure¿Í Æ®¸®°Å¸¦ Á¦°øÇÑ´Ù. µ¥ÀÌÅ͸¦ º¸È£Çϱâ À§Çؼ­ entity intergrity(constraints)¿Í referential integrity¸¦ Á¦°øÇÑ´Ù. ¶ÇÇÑ ÇàÀá±Ý, Å×À̺í Àá±Ý, µ¥ÀÌÅͺ£À̽º Àá±ÝÀÇ 3°¡Áö ·¹º§ÀÇ Àá±Ý(data locking)À» Á¦°øÇÑ´Ù. ÇàÀá±Ý(row locking)Àº ´ë·®ÀÇ µ¥ÀÌÅ͸¦ ó¸®ÇÒ ¶§´Â ºÐ¸®µÈ´Ù. ´ë·®ÀÇ µ¥ÀÌÅ͸¦ ó¸®ÇÒ ¶§´Â Å×À̺í Àá±Ý(table locking)ÀÌ È¿À²ÀûÀÌ´Ù. µ¥ÀÌÅͺ£À̽º Àá±Ý(database locking)´Â ¹èÄ¡Àâ(batch job)À» ó¸®ÇÒ ¶§ À¯¸®ÇÏ´Ù.

informix-seÀÇ ÇÑ°è ¶Ç´Â Á¦ÇÑÁ¡Àº oltp(online transaction processing), ¿ÏÀüÇÑ Å¬¶óÀ̾ðÆ®/¼­¹ö ÇüÅÂÀÇ ½Ã½ºÅÛÀÌ ¾Æ´Ï¶ó´Â °ÍÀÌ´Ù. oltp¶ó´Â °ÍÀº ´Ù¾çÇÑ »ç¿ëÀÚ°¡ µ¿½Ã¿¡ Áö¼ÓÀûÀ¸·Î µ¥ÀÌÅ׿¡ Á¢±ÙÇϰí ó¸®ÇÏ´Â °ÍÀ» ÀǹÌÇÑ´Ù. ÀÌ·¯ÇÑ Å¬¶óÀ̾ðÆ®ÀÇ ¿ä±¸¸¦ ó¸®Çϱâ À§Çؼ­ À̸¦ ó¸®ÇÏ´Â ¼­¹ö°¡ Ç×»ó Á¸ÀçÇÑ´Ù.

informix-se´Â Ŭ¶óÀ̾ðÆ®/¼­¹ö ±¸Á¶¸¦ °¡Áö°í ÀÖÁö¸¸, µ¿½Ã »ç¿ëÀÚÀÇ ¿ä±¸¸¦ ó¸®ÇÏ´Â µ¥ ÇѰ谡 ÀÖ´Ù. Áï, µ¿½Ã Á¢¼ÓµÈ Ŭ¶óÀ̾ðÆ®ÀÇ ¼ö°¡ ´Ã¾î³¯¼ö·Ï ó¸® ½Ã°£ÀÇ ´Ã¾î³­´Ù. ¶ÇÇϳªÀÇ ´ÜÁ¡Àº transaction logÀÌ´Ù. µ¥ÀÌÅ͸¦ º¹±¸ÇÏ¿©¾ß ÇÑ´Ù¸é se´Â ¹é¾÷º»À» º¹±¸ÇÏ°í ¹é¾÷µÈ ½ÃÁ¡ºÎÅÍ ÇöÀç±îÁöÀÇ transaction log¸¦ Àû¿ëÇÏ¿©¾ß ÇÑ´Ù. ÀÌ´Â ¸Å¿ì Áö·çÇÑ ÀÛ¾÷ÀÌ µÉ ¼ö ÀÖ´Ù. º¹±¸ ÀÛ¾÷À» ÇÏ´Â µ¿¾ÈÀº ´Ù¸¥ ÀÛ¾÷ÀÇ Ã³¸®°¡ ºÒ°¡´ÉÇÏ´Ù. informix-se¹öÀüÀº Å×ÀÌºí¿¡ 10,000°³ÀÇ Çà ÀÌ»óÀ» ÀÔ·ÂÇÒ ¼ö ¾ø´Ù.

1.2 informix-online

informix-onlineÀº informix-seÀÇ µÚ¸¦ ÀÕ´Â Á¦Ç°ÀÌ´Ù. 1980³â ÈĹݿ¡ Ãâ½ÃµÈ ÀÌ Á¦Ç°Àº ´õ ¸¹Àº Ŭ¶óÀÌ¾ðÆ® ¿ä±¸ »çÇ×À» ó¸®Çϱâ À§Çؼ­ ¼­¹ö ¿£ÁøÀÌ °³¼± µÇ¾ú´Ù. Ŭ¶óÀÌ¾ðÆ®´Â µ¿ÀÏÇÑ ÄÄÇ»ÅÍ¿¡¼­³ª ȤÀº ³×Æ®¿÷, ¸ðµ©µîÀ» ÅëÇØ¼­ ¼­¹ö¿¡ Á¢±ÙÇÒ ¼ö ÀÖ´Ù. informix-onlineÀº ³ôÀº ½Å·Ú¼º°ú ¾ÈÀü¼ºÀ» º¸ÀåÇÑ´Ù. À¯´Ð½º ȯ°æ¿¡ ÀÚ½ÅÀÌ Á÷Á¢ cpu¸¦ °üÀåÇϰųª µð½ºÅ© i/o¸¦ °üÀåÇÏ¿© ¼º´ÉÀ» °³¼±ÇÒ ¼ö ÀÖ´Ù.

ÀÎÆ÷¹Í½º ¿Â¶óÀÎ ¹öÀüÀº ³¯Â¥, ½Ã°£, ¹®ÀÚ, ¼ýÀÚ µîÀÇ µ¥ÀÌÅÍ ÇüÀ» Áö¿øÇÒ »Ó¸¸ ¾Æ´Ï¶ó ¸ÖƼ¹Ìµð¾î µ¥ÀÌÅ͸¦ ÀúÀåÇÒ ¼ö ÀÖ´Â blob(binary large object)ÇüÀ» Áö¿øÇÑ´Ù. informix-online ¹öÀüÀÌ Çâ»óµÈ ±â´ÉµéÀ» Á¦°øÇÏÁö¸¸ ¾î¶² ´ÜÁ¡µéÀ» °¡Áö°í ÀÖ´Â °Í ¶ÇÇÑ »ç½ÇÀÌ´Ù. ±× ù¹øÂ° ´ÜÁ¡ÀÌ ³»Àå wait queueó¸® ±â´ÉÀÌ ºÎÁ·ÇÏ´Ù´Â °ÍÀÌ´Ù. ÀÌ ±â´ÉÀÇ ºÎÁ·Àº µ¿½Ã¿¡ ¸¹Àº »ç¿ëÀÚÀÇ ¿ä±¸°¡ ÀÖÀ» °æ¿ì, ¼º´ÉÀÇ ÀúÇϰ¡ ¹ß»ýÇÑ´Ù. µ¿½Ã¿¡ ¿©·¯ ¿ä±¸°¡ µé¾î ¿ÔÀ» ¶§ cpu´Â »ç¿ëÀÚÀÇ ¿ä±¸µéÀ» Á¶±Ý¾¿ ó¸® Çϱâ À§Çؼ­ »ç¿ëÀÚµé ÇÁ·Î¼¼½º°£À» ÀÚÁÖ ¿Õº¹ÇÏ°Ô µÈ´Ù.

µÎ¹øÂ° ´ÜÁ¡Àº ÇÏµå µð½ºÅ©¿¡ bad sector°¡ ¹ß»ýÇÏ¿´À» ¶§ ó¸® ¹æ½Ä¿¡ ÇѰ谡 ÀÖ´Ù´Â °ÍÀÌ´Ù. ÇÏµå µð½ºÅ© °Ë»ç³ª °ü¸®´Â À¯´Ð½º ÀÚü¿¡¼­ 󸮸¦ ÇÏ°Ô µÈ´Ù. ÀÌ ¿ÜÀÇ i/o´Â ¿Â¶óÀÎ ¼­¹ö¿¡¼­ °ü¸®ÇÑ´Ù. µû¶ó¼­ bad sector°¡ Æ÷ÇÔµÈ µð½ºÅ©°¡ ¹ß°ß µÇ¾úÀ» °æ¿ì, ¿Â¶óÀÎ ¼­¹ö´Â ¹®Á¦°¡ ¹ß»ýÇÑ Àüü ºÎºÐÀÇ »ç¿ëÀ» Æ÷±âÇÑ´Ù. ¿Â¶óÀÎ ¼­¹ö´Â ÀÌ ¹®Á¦ ¹ß»ýÀÇ ¿øÀο¡ ´ëÇÑ Á¤º¸¸¦ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¿¡°Ô ÀüÇô ¾Ë¸®Áö ¾Ê´Â´Ù. ¸¸ÀÏ bad sector°¡ Á¸ÀçÇÏ´Â ÇÏµå µð½ºÅ©¿¡ ½Ã½ºÅÛ Å×À̺íÀ̳ª ·Î±× È­ÀÏÀÌ Á¸ÀçÇÏ¸é ½Ã½ºÅÛÀº ¸ØÃâ¼öµµ ÀÖ´Ù.

¸¶Áö¸· ´ÜÁ¡Àº blob µ¥ÀÌÅ͸¦ ´Ù·ç´Â ±â´ÉÀÇ ºÎÁ·ÀÌ´Ù. ¿Â¶óÀÎ ¼­¹ö´Â blobµ¥ÀÌÅ͸¦ ´Ù·ç±â À§ÇÑ ÀÚü ±â´ÉÀÌ ¾ø´Ù. Áï µ¥ÀÌÅ͸¦ ÀÔ·ÂÇÏ°í °Ë»öÇϱâ À§ÇÑ ±â´ÉÀÌ ºÎÁ·ÇÑ °ÍÀÌ´Ù. ºÐ»ê µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇϱâ À§Çؼ­´Â informix-star¸¦ ÀÌ¿ëÇØ¾ß ÇÑ´Ù. ¸®¸ðÆ®·Î ÀÛ¾÷ÇÏ´Â »ç¿ëÀÚ¸¦ À§Çؼ­´Â informix-net Á¦Ç°ÀÌ ÀÖ´Ù. informix-netÀº informix-se¸¦ À§Çؼ­ »ç¿ëµÉ ¼öµµ ÀÖ´Ù.

1.3 informix-online dynamic server

informix-online dynamic server´Â ÀÌÀüÀÇ Á¦Ç°µéó·³ °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÌ´Ù. ÀÎÆ÷¹Í½º ¹öÀü 5´Â ¿Â¶óÀÎ ¼­¹öÀÇ ¸¶Áö¸· ¹öÀüÀ̾ú°í, ÀÎÆ÷¹Í½º 6Àº »õ·Î¿î dynamic ±â´ÉÀ» Ãß°¡ÇÑ Áß°£¹öÀüÀÌ´Ù. ÇöÀç ¹ßÇ¥µÈ ¹öÀü 7Àº ¿ÏÀüÇÑ online dynamic ¼­¹öÀÌ´Ù. Ãß°¡µÈ ±â´ÉÀº dynamicÀ̶ó ºÒ¸®´Â ±â´ÉÀÌ´Ù. dynamicÀÌ ÀǹÌÇÏ´Â °ÍÀº ÇöÀç ¿î¿ëÁßÀÎ µ¥ÀÌÅͺ£À̽º¿¡ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê°í ¼­¹öÀÇ counfigurationÀ» ¹Ù²Ü ¼ö ÀÖ´Ù´Â °ÍÀÌ´Ù.

shared memory´Â µ¥ÀÌÅͺ£À̽º¸¦ ¿î¿ëÇÏ´Â °¡Àå Áß¿äÇÑ ¿ä¼ÒÁßÀÇ ÇϳªÀÌ´Ù. ¿À·£ ½Ã°£ µ¿¾È ÀÛ¾÷(long transaction)À» ¼öÇàÇÏ´Â ÇÁ·Î¼¼½º´Â ¸¹Àº ¾çÀÇ swap ¸Þ¸ð¸®°¡ ¿ä±¸µÇ¾îÁö°í ¶ÇÇÑ ºñ¹øÇÑ µð½ºÅ© i/o¸¦ ¹ß»ý ½ÃŲ´Ù. À̶§ dsa(dynamic scalable architecture)¸¦ ÀÌ¿ëÇÑ dynamic server´Â ´Éµ¿ÀûÀ¸·Î µ¥ÀÌÅͺ£À̽ºÀÇ ¼º´É¿¡ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê°í ÇÁ·Î¼¼½ºÀÇ ¿ä±¸¿¡ ¸Â°Ô swap ¸Þ¸ð¸®¸¦ Á¶ÀýÇÒ ¼ö ÀÖ´Ù.

¼­¹ö ÇÁ·Î¼¼½ºµéÀº °¡»ó ÇÁ·Î¼¼½º(virtual process)¶ó ºÒ¸®´Â µ¥¸óµé·Î ±¸¼ºµÈ´Ù. ¿Â¶óÀÎ ¼­¹ö´Â tbinit, tbundo, tbpgcl 3°³ÀÇ ÇÁ·Î¼¼½º·Î ±¸¼ºµÇ¾î ÀÖÁö¸¸ dynamic server´Â 11°³ÀÇ °¡»ó ¼­¹ö·Î ±¸¼ºµÇ¾î ÀÖ´Ù. °¡»ó ÇÁ·Î¼¼½º´Â thread¶ó ºÒ¸®´Â multithreaded process·Î ±¸¼ºµÈ´Ù.

°¡»ó ÇÁ·Î¼¼½º´Â ÀÏ·ÃÀÇ Äõ¸®¿Í indexing, join, sortingµîÀÇ ÀÏÀ» ÀÛÀº ´ÜÀ§·Î ³ª´©¾î µ¿½Ã¿¡ ó¸®ÇÒ ¼ö ÀÖ´Â pdq(parallel database query) ´É·ÂÀ» °¡Áö°í ÀÖ´Ù. ´ÙÀ̳ª¹Í ¼­¹ö´Â ¿¹ÃøÇÒ ¼ö ¾ø´Â ½Ã½ºÅÛÀÇ °íÀåÀ¸·ÎºÎÅ͵µ ºü¸¥ º¹±¸¸¦ ¼öÇàÇÒ ¼ö ÀÖ´Â ´É·ÂÀ» °¡Áö°í ÀÖÀ¸¸ç ¶ÇÇÑ µ¥ÀÌÅÍ ¹é¾÷À̳ª configurationÀ» ¼öÁ¤Çϱâ À§ÇÑ µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ Á¤Áö ½Ã°£À» ÃÖ¼ÒÈ­ ȤÀº Á¤Áö ¾øÀÌ ¼öÇàÇÒ ¼ö ÀÖ´Ù. ¿Â¶óÀÎ ¼­¹ö°¡ 3°³ÀÇ ´ÜÁ¡À» °¡Áö°í ÀÖµíÀÌ ´ÙÀ̳ª¹Í ¼­¹ö´Â 2°³ÀÇ ´ÜÁ¡ÀÌ ÀÖ´Ù. ù¹øÂ°´Â ÇÏµå µð½ºÅ©¿¡ bad sector°¡ ¹ß»ýÇÏ¿´À» ¶§ ó¸® ´É·Â ºÎÁ·°ú blob ÇüÀÇ µ¥ÀÌÅÍ Ã³¸®ÀÇ ³»Àå ±â´É ºÎÁ·ÀÌ´Ù. ¿Â¶óÀÎ ¼­¹ö¿Í ¸¶Âù°¡Áö·Î µð½ºÅ© °Ë»ç´Â ¾ÆÁ÷µµ À¯´Ð½º ½Ã½ºÅÛ¿¡ ÀÇÁ¸ÇØ¾ß ÇÑ´Ù. blob µ¥ÀÌÅ͸¦ ÀÔ·ÂÇÏ°í ²¨³»´Â ¹æ¹ýÀºÀÖÀ»Áö¶óµµ µ¥ÀÌÅ͸¦ º¸°Å³ª ¾ÐÃà ȤÀº ¸ðÀ¸´Â ±â´ÉÀº ³»ÀçÇϰí ÀÖÁö ¾Ê´Ù.

1.4 informix-universal server

informix-universal server´Â °´Ã¼-°ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÌ´Ù. ÀüÅëÀûÀÎ °ü°èÇü µ¥ÀÌÅͺ£À̽º´Â »ç¿ëÀÚ°¡ Á¤ÇØÁø µ¥ÀÌÅÍÇü¸¸À» »ç¿ëÇϵµ·Ï Á¦ÇÑÇÏ¿´´Ù. ¶ÇÇÑ blobÇüÀ» Áö¿øÇÏ¿´Áö¸¸ blobÇüÀÇ µ¥ÀÌÅ͸¦ Á¶ÀÛÇϰųª blobÇüÀÇ µ¥ÀÌÅÍ ³»¿ëÀ» ±âÁØÀ¸·Î ã±â °°Àº °ÍÀº Á¦ÇÑ µÇ¾ú´Ù. informix-universal server´Â »ç¿ëÀÚ°¡ »õ·Î¿î µ¥ÀÌÅÍ ÇüÀ» ¸¸µé¼ö ÀÖµµ·Ï Çã¿ëÇÏ°í »õ·Î¿î µ¥ÀÌÅÍ Çü¿¡ ´ëÇØ¼­ sqlÀ» ÅëÇØ¼­ µ¥ÀÌÅÍ¿¡ Á¢±ÙÇÒ ¼ö ÀÖµµ·Ï Çã¿ëÇϰí ÀÖ´Ù.

informix-universal server´Â informix-online dynamic server¿¡ ±âÃʸ¦ µÎ°í ÀÖÀ¸¹Ç·Î ´ÙÀ̳ª¹Í ¼­¹öÀÇ ¸ðµç ±â´ÉÀ» ¼ö¿ëÇϰí ÀÖ´Ù. informix-universal serverÀÇ Æ¯Â¡Àº µ¥ÀÌÅ͸¦ °ü¸®ÇÏ´Â ¸ðµâÀ» ¼­¹ö¿¡ plug-in ½Ãų ¼ö ÀÖ´Ù´Â °ÍÀÌ´Ù. ¼­¹ö¿¡ plug-inµÈ µ¥ÀÌÅÍ Çü, Æã¼Ç, Á¢±Ù ¹æ¹ýµîÀº µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ¿¡ ³»ÀåµÈ ±â´Éµé°ú µ¿ÀÏÇÏ°Ô Ãë±ÞµÈ´Ù.

2. informix ¼³Ä¡Çϱâ

2.1 »ç¿ëÀÚ µî·Ï°ú ȯ°æ ¼³Á¤

ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇϱâÀü¿¡ ÇØÁÖ¾î¾ß ÇÒ Áß¿äÇÑ ¸î°¡Áö »çÇ×µéÀÌ ÀÖ´Ù. ¿ì¼± À¯´Ð½ºconfigurationÀ» Á¶ÀýÇÏ°í »ç¿ëÀÚ¸¦ ¸¸µé°í ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇÒ µð·ºÅ丮¸¦ Á¤ÇÏ´Â °ÍÀÌ´Ù.

2.1.1 »ç¿ëÀÚ µî·Ï

·çÆ®·Î ·Î±×ÀÎÇÏ¿© ±×·ì°ú »ç¿ëÀÚ¸íÀ» informix·Î ¸¸µç´Ù. ȤÀº linuxconf ÅøÀ» ÀÌ¿ëÇÏ¿© »ç¿ëÀÚ¸¦ »ý¼ºÇÑ´Ù.

[root@angra angra]# groupadd informix

[root@angra angra]# adduser informix


2.1.2 ȯ°æ¼³Á¤

ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇϱâÀü¿¡ ¼³Á¤ÇؾßÇÒ È¯°æº¯¼öµéÀº informixserver, informixdir, path, onconfig, informixterm 5°³°¡ ÀÖ´Ù.

* informixserver - ÀÎÆ÷¹Í½º instanceÀÇ À̸§À» ÀǹÌÇÑ´Ù. »ç¿ëÀÚ°¡ ¿øÇÏ´Â À̸§À¸·Î ¼³Á¤ÇÏ¿© ÁÖ¸éµÈ´Ù.

* informixdir - ÀÎÆ÷¹Í½º°¡ ¼³Ä¡µÉ ±âº» µð·ºÅ丮ÀÌ´Ù.

* path - »ç¿ëÀÚ°¡ Àý´ë °æ·Î¸¦ ÁöÁ¤ÇÏÁö ¾Ê´Â´Ù¸é ÀÎÆ÷¹Í½º ¼­¹ö°¡ ½ÇÇàÈ­ÀϵéÀ» ãÀ» ¼ö ÀÖ´Â ±âº» µð·ºÅ丮ÀÌ´Ù. ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇÏ°í ½ÇÇàÇϱâ À§Çؼ­ ¹Ýµå½Ã $informixdir/bin À» Æ÷ÇÔÇϰí ÀÖ¾î¾ß ÇÑ´Ù.

* onconfig - »ç¿ëÀÚ°¡ ¼±ÅÃÀûÀ¸·Î ÁöÁ¤ÇÒ ¼ö ÀÖ´Ù. ¸¸¾à ÁöÁ¤ÇÏÁö ¾Ê´Â´Ù¸é $informixdir/etc/onconfigÀ» µðÆúÆ®·Î »ç¿ëÇÑ´Ù. onconfig°¡ ÁöÁ¤µÈ´Ù¸é $informixdir/etc/${onconfig}À» »ç¿ëÇÏ°Ô µÉ °ÍÀÌ´Ù.

* informixterm - Å͹̳ο¡ ±â¹ÝÇÑ ÇÁ·Î±×·¥µé(dbaccess, onmonitor, 4gl ÇÁ·Î±×·¥)ÀÌ Á¤»óÀûÀ¸·Î Àß µ¿ÀÛÇÏ°Ô Çϱâ À§Çؼ­ ¼³Á¤ÇÑ´Ù.

2.1.3 shared memory

shared memory´Â ÀÎÆ÷¹Í½º¿Í »ç¿ëÀÚ ÇÁ·Î¼¼½º°£ÀÇ ºü¸¥ Åë½ÅÀ» °¡´ÉÇÏ°Ô ÇÏ´Â ¼ö´ÜÀÌ´Ù. shared memoryÀÇ ¼³Á¤Àº À¯´Ð½º ¹öÀü¸¶´Ù ´Ù¸£±â ¶§¹®¿¡ ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇÑ ÈÄ $informixdir/release/en_us/0333/ids_7.3À» º¸¸é ¸®´ª½ºÀ» À§ÇÑ ¼³Á¤ È­ÀÏÀÌ ÀÖ´Ù.

2.1.4 services entries

ÀÎÆ÷¹Í½º¸¦ À§ÇÑ services entriesÀº /etc/services È­ÀÏ¿¡ ¼³Á¤µÇ¾î¾ß ÇÑ´Ù. »ç¿ëÀÚ°¡ ¼³Á¤ÇÒ ¼­ºñ½ºµéÀº ´ÙÀ½°ú °°´Ù.

* nettcp 1400/tcp - nettcp´Â ÀÎÆ÷¹Í½º ¿Â¶óÀÎ ¹öÀü 6, 7¿¡¼­ ³×Æ®¿÷ Åë½ÅÀ» À§Çؼ­ »ç¿ëµÈ´Ù.

* sqlexec 1399/tcp - sqlexec´Â ÀÎÆ÷¹Í½º ¹öÀü 5¿¡¼­ ³×Æ®¿÷ Åë½ÅÀ» À§Çؼ­ »ç¿ëµÈ´Ù.

* oncockpit 1401/tcp - oncockpitÀº »ç¿ëÀÚ°¡ ¼±ÅÃÀûÀ¸·Î ¼³Á¤ÇÒ ¼ö ÀÖ°í ÀÎÆ÷¹Í½º ¼º´É¿¡ °ü·ÃµÈ ³»¿ëÀ» ±×·¡ÇÈ È­¸é¿¡¼­ º¸¿©ÁØ´Ù.

* egm 1402/tcp - ¸¸ÀÏ enterprise gateway manager¸¦ ¼³Ä¡ÇßÀ» °æ¿ì, ÇÊ¿ä·Î ÇÏ´Â ¼­ºñ½º Çʵå´Ù.

* secondserver 1402/tcp - ´Ù¸¥ ÀνºÅϽº¸¦ ¿î¿ëÇÒ ¶§ ÇÊ¿äÇÑ ¼­ºñ½º Çʵå´Ù.

2.2 ¼³Ä¡ °úÁ¤

2.2.1 ÇÏµå µð½ºÅ©

ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇϱâÀü¿¡ ÀÎÆ÷¹Í½º¸¦ ¾îµð¿¡ ¼³Ä¡ÇÒ °ÍÀΰ¡¸¦ °áÁ¤ÇÏ¿©¾ß ÇÑ´Ù. º¸Åë 4gl°ú esqlÀ» Æ÷ÇÔÇÑ ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇÑ´Ù¸é ÃÖ¼Ò 60m ~ 90mÀÇ free space°¡ ÇÊ¿äÇÏ´Ù.

2.2.2 ¼³Ä¡ ¼ø¼­

ÀÎÆ÷¹Í½º´Â ´ÙÀ½°ú °°Àº ¼ø¼­·Î ¼³Ä¡°¡ µÇ¾î¾ß ÇÑ´Ù.

* application development tools

- informix-4gl

- informix-4gl rapid development package

- informix-4gl interactive debugger

* sql application programming interfaces(apis)

- informix-sql

- informix-esql/c

- informix-esql/cobol

- informix-conncet

- informix-cli

* database servers

- informix-online dynamic server

- informix-online dynamic server runtime facility

* additional products

- c-isam

- c-isam runtime facility

* informix message and corrections

- informix-online/optional

- informix-enterprise gateway for drda

- informix-enterprise gateway manager

2.2.3 cd·ÎºÎÅÍ ÀÎÆ÷¹Í½º º¹»çÇϱâ

´ÙÀ½ °úÁ¤Àº cd·ÎºÎÅÍ ÀÎÆ÷¹Í½º¸¦ ¼³Ä¡ÇÑ´Ù´Â °¡Á¤ÇÏ¿¡¼­ ÁøÇàÇÑ´Ù. ÀÎÆ÷¹Í½º dynamic serverÀÇ ¹èÆ÷ÆÇÀº rpmÇüÅ·Π¹èÆ÷µÈ´Ù. rpm ¹èÆ÷ÆÇÀ» ÀνºÅçÇÏ¿´´Ù°í ÇØ¼­ ÀÎÆ÷¹Í½º ¼³Ä¡°¡ ¿Ï·áµÈ °ÍÀÌ ¾Æ´Ï°í ½ÇÁ¦ ÀνºÅçµÇ¾î¾ß ÇÒ ÀÎÆ÷¹Í½º ÇÁ·Î±×·¥µéÀÌ ¼³Ä¡ µÈ°ÍÀÌ´Ù. rpm ¹èÆ÷ÆÇÀÇ ±âº» ¼³Ä¡ µð·ºÅ丮´Â /opt/informixÀ̹ǷΠ»ç¿ëÀÚ°¡ ¼³Ä¡Çϰí ÇÏ´Â µð·ºÅ丮·Î À̵¿Çϵµ·Ï rpm ¼³Ä¡½Ã ÁöÁ¤ÇØ ÁÖµµ·Ï ÇÏÀÚ.

À§¿¡¼­ ¾ð±ÞÇÏ¿´µíÀÌ ÀÎÆ÷¹Í½º ¼³Ä¡ ¼ø¼­´Â client sdkµéºÎÅÍ ¼³Ä¡µÇ¾î¾ß ÇÑ´Ù. ¼³Ä¡ °úÁ¤Àº ´ÙÀ½°ú °°´Ù.

--------------------------------------------------------------------------

[root@angra ids]# rpm -ivh --relocate /opt/informix=/home/informix/ clisdk.rpm

/home/informix % ls

mail/ clientsdkcontent.tar installclientsdk*

/home/informix % ./installclientsdk

informix-client sdk version 2.10.uc2

copyright (c) 1991-1998 informix software, inc.

is clientsdk being installed along with informix dynamic server with

universal data option (release 9, required to be run as user "informix")?

(yes or no)

yes

extracting files from clientsdkcontent file...

installing clientsdk as user informix...

installation script

installation script requirements:

- a user "informix" and a group "informix" must be known to the system.

- the product source files must have been loaded by user informix

- this installation procedure must be run by user informix.

this script will change the owner, group, and mode of

many of the files of this package in this directory.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

enter your serial number (for example, inf#x999999) >

aac#a538645

enter your serial number key (uppercase letters only) >

ghtljj

warning!

this software, and its authorized use and number of users, are

subject to the applicable license agreement with informix software, inc.

if the number of users exceeds the licensed number, the excess users may

be prevented from using the software. unauthorized use or copying may

subject you and your company to severe civil and criminal liabilities.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

installing directory .

installing directory bin

...

installing directory gls/lc11/zh_tw

**************************************************************

to complete the installation of informix-client sdk,

run /home/informix/run_as_root.clientsdk as root.

**************************************************************

informix user portion of installation of informix-client sdk complete.

--------------------------------------------------------------------------

Ŭ¶óÀÌ¾ðÆ® sdk¸¦ ÀνºÅçÇÑ ÈÄ ¼³Ä¡ÇÒ ÀÎÆ÷¹Í½º Á¦Ç°Àº dynamic serverÀÌ´Ù.

¼³Ä¡ °úÁ¤Àº ´ÙÀ½°ú °°´Ù. ÀÌ °úÁ¤Àº root ±ÇÇÑÀ¸·Î ¼³Ä¡¸¦ ÇÏ¿©¾ß ÇÑ´Ù.

--------------------------------------------------------------------------

[root@angra ids]# rpm -ivh --relocate /opt/informix=/home/informix/ ids.rpm

[root@angra informix]# ./installserver

informix dynamic server version 7.30.uc5

copyright (c) 1986-1998 informix software, inc.

installation and configuration script

this installation procedure must be run by a privileged user (super user)

it will change the owner, group, mode, (and other file attributes on

secure systems) of all files of this package in this directory.

there must be a user "informix" and a group "informix" known to the system.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

enter your serial number (for example, inf#x999999) >

aac#a538645

enter your serial number key (uppercase letters only) >

ghtljj

warning!

this software, and its authorized use and number of users, are

subject to the applicable license agreement with informix software, inc.

if the number of users exceeds the licensed number, the excess users may

be prevented from using the software. unauthorized use or copying may

subject you and your company to severe civil and criminal liabilities.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

installing directory .

...

installing directory gls/lc11/zh_tw

installing shared libraries in system directories ...

linking /usr/lib/iosm07a.so from lib/iosm07a.so

linking /usr/lib/ipldd07a.so from #lib/ipldd07a.so

installation of informix dynamic server complete.

--------------------------------------------------------------------------

¸¶Áö¸·À¸·Î »ç¿ëÀÚ°¡ ¼³Ä¡ÇÒ °ÍÀº ÇÑ±Û ¸Þ½ÃÁö ÆÑÀÌ´Ù. ÀÌ ÇÁ·Î±×·¥Àº »ç¿ëÀÚ°¡

ÇÑ±Û ¸Þ½ÃÁö¸¦ ¿øÇÏÁö ¾ÊÀ» °æ¿ì, ¼³Ä¡ÇÏÁö ¾Ê¾Æµµ ¹«¹æÇÏ´Ù.

--------------------------------------------------------------------------

[root@angra gls]# cp ls913k.tar $informixdir

[root@angra gls]# tar xvf ls913k.tar

installkokr

lsinstall.ko

lsinst_dir/lslist

lsinst_dir/ls913ko.tar

lsinst_dir/ls724ko.tar

lsinst_dir/ls720ko.tar

[root@angra informix]# ./lsinstall.ko

select engine product version

-----------------------------

1 : version 7.20 (gls)

2 : version 7.22 (gls)

3 : version 7.23 (gls)

4 : version 7.24 (gls)

5 : version 9.12 (gls)

6 : version 9.13 (gls)

-----------------------------

please input number (n - none, q - quit)

4

select tool product version

-----------------------------

1 : version 2.00 (clientsdk)

-----------------------------

please input number (n - none, q - quit)

1

... install language-supplement korean for version 7.24

informix korean language supplement version 7.24.uc1

copyright (c) 1995-1997 informix software, inc.

installation script

this installation procedure must be run by root (super-user).

it will change the owner, group, and mode of all files of this

package in this directory. there must be a user "informix" and a

group "informix" known to the system.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

enter your serial number (for example, inf#x999999) >

aac#a538645

enter your serial number key (uppercase letters only) >

ghtljj

warning!

this software, and its authorized use and number of users, are

subject to the applicable license agreement with informix software, inc.

if the number of users exceeds the licensed number, the excess users may

be prevented from using the software. unauthorized use or copying may

subject you and your company to severe civil and criminal liabilities.

press return to continue,

or the interrupt key (usually ctrl-c or del) to abort.

installing directory .

installing directory etc

...

installing directory msg/ko_kr/e00c

installation of informix korean language supplement complete.

--------------------------------------------------------------------------

À̷νá ÀÎÆ÷¹Í½º ¼³Ä¡°¡ ¿Ï·áµÇ¾ú´Ù. ´ÙÀ½Àº ÀÎÆ÷¹Í½ºÀÇ ÃʱâÈ­ °úÁ¤À» º¸µµ·Ï

ÇÏÀÚ.

2.3 ÀÎÆ÷¹Í½º ±âµ¿Áغñ

ÀÎÆ÷¹Í½º¸¦ Á¤»óÀûÀ¸·Î ¼³Ä¡ÇÏ¿´À¸¸é ´ÙÀ½Àº ÀÎÆ÷¹Í½º¸¦ ±âµ¿ ½Ã۱â À§Çؼ­ ¾à°£ÀÇ ´Ü°è¸¦ °ÅÃÄ¾ß ÇÑ´Ù. ½ÇÁ¦ »ç¿ëÀÚ°¡ ¹Ù²Ù¾î ÁÖ¾î¾ß ÇÒ ÆÄÀÏÀº ${informixdir}/etc/onconfig¿Í ${informixdir}/etc/sqlhostsÀÌ´Ù. »ùÇ÷ΠÁ¦°øµÇ´Â onconfig.std¿Í sqlhosts.demo È­ÀÏÀ» ${informixdir}/etc µð·ºÅ丮¿¡¼­ ãÀ» ¼ö ÀÖÀ» °ÍÀÌ´Ù. ÀÌ È­ÀϵéÀ» onconfig¿Í sqlhost È­ÀÏ·Î º¹»çÇÏ¿© »ç¿ëÀÚ°¡ Á÷Á¢ ÆíÁýÇÑ ÈÄ ÀÎÆ÷¹Í½º¸¦ ±âµ¿ÇÏ¿©µµ µÈ´Ù. ÇÏÁö¸¸ ÀÎÆ÷¹Í½º ȯ°æ¿¡ Àͼ÷ÇÏÁö ¾ÊÀº »ç¿ëÀÚ¶ó¸é ´ÙÀ½ÀÇ °úÁ¤À» °ÅÃļ­ ÀÚµ¿À¸·Î »ý¼ºµÇ´Â onconfig È­ÀÏÀ» »ç¿ëÇϰí sqlhost È­Àϸ¸ ÆíÁýÇÏ´Â °ÍÀÌ ÆíÇÒ °ÍÀÌ´Ù.

2.3.1 ¼öµ¿À¸·Î ÀÎÆ÷¹Í½º ¼³Á¤Çϱâ

¼ÕÀ¸·Î Á÷Á¢ onconfig È­ÀÏÀ» ¼öÁ¤ÇÏ´Â »ç¿ëÀÚ°¡ Á÷Á¢ ¼öÁ¤ÇØ¾ß ÇÏ´Â Ç׸ñÀº ´ÙÀ½°ú °°´Ù.

* rootname : root µ¥ÀÌÅͺ£À̽º ¿µ¿ª¿¡ ºÎ¿©ÇϰíÀÚ ÇÏ´Â À̸§.

* rootpath : root µ¥ÀÌÅͺ£À̽º È­ÀÏÀÌ Á¸ÀçÇÏ´Â °æ·Î(path) À̸§.

* rootoffset : rootpathÀÇ ½ÃÀÛÁ¡¿¡¼­ °Ç³Ê¶Û kilobytesÀÇ ±æÀÌ.

* rootsize : root µ¥ÀÌÅͺ£À̽º ¿µ¿ªÀÇ Å©±â

* dbservername : ÀÎÆ÷¹Í½º ÀνºÅϽºÀÇ À̸§.

* nettype : »ç¿ëÇÒ ³×Æ®¿÷ Á¾·ù¿Í ³×Æ®¿÷À¸·Î ¿äûÀÌ µé¾î¿À´Â »óȲÀ» °¨½ÃÇÒ ÇÁ·Î¼¼½ºÀÇ ¼ö.

* multiprocessor : ÀÎÆ÷¹Í½º¸¦ »ç¿ëÇÏ´Â ½Ã½ºÅÛÀÌ ¿©·¯°³ÀÇ cpu¸¦ °¡Áö°í ÀÖ´ÂÁöÀÇ ¿©ºÎ

* numcpuvps : °¡»ó cpu ÇÁ·Î¼¼½ºÀÇ ¼ö.

* single_cpu_vp : °¡»ó cpu ÇÁ·Î¼¼½ºÀÇ ¼ö¸¦ 1°³·Î Á¦ÇÑÇÒ °ÍÀÎÁöÀÇ ¿©ºÎ

* numaiovps : i/o vpÀÇ ¼ö.

2.3.2 onmonitor¸¦ ÀÌ¿ëÇÏ¿© ÀÎÆ÷¹Í½º ¼³Á¤Çϱâ

ÀÎÆ÷¹Í½ºÀÇ onmonitor ÅøÀ» »ç¿ëÇÏ¿© ÀÎÆ÷¹Í½º¸¦ ÃʱâÈ­ Çϱâ·Î °áÁ¤Çß´Ù¸é, »ç¿ëÀÚ°¡ ÀÔ·ÂÇØ¾ßÇÒ °ªµé¿¡ ÇÁ·ÒÇÁÆ®¸¦ º¸¿©ÁÙ °ÍÀÌ´Ù. ÀÎÆ÷¹Í½º ÅøÀ» »ç¿ëÇϱâ Àü¿¡ ¸ÕÀú ÇØ¾ßÇÒ ÀÏÀº ´ÙÀ½°ú °°ÀÌ root µ¥ÀÌÅͺ£À̽º ½ºÆäÀ̽º°¡ Á¸ÀçÇÒ °÷À» Á¤ÇÏ°í »ý¼ºÇÒ ·çÆ® µ¥ÀÌÅͺ£À̽º ½ºÆäÀ̽ºÀÇ À̸§À» ¸¸µå´Â °ÍÀÌ´Ù.

-------------------------------------------------------------------------

/home/informix % mkdir data

/home/informix % cd data

/home/informix/data % touch rootdbs

/home/informix/data % ls -al

total 2

drwxr-xr-x 2 informix informix 1024 jun 23 12:14 ./

drwxr-xr-x 18 informix informix 1024 jun 23 12:14 ../

-rw-r--r-- 1 informix informix 0 jun 23 12:14 rootdbs

/home/informix/data % chmod 660 rootdbs

--------------------------------------------------------------------------

À§¿Í °°Àº ÃʱâÈ­ ÀÛ¾÷À» ¸¶ÃÆÀ¸¸é, ÀÎÆ÷¹Í½º »ç¿ëÀÚ »óÅ¿¡¼­ ÇÁ·ÒÇÁÆ®¿¡

onmonitor¸¦ ÀÔ·ÂÇÏÀÚ. ±×·¯¸é ¾Æ·¡¿Í °°Àº È­¸éÀÌ ³ªÅ¸³¯ °ÍÀÌ´Ù.

¸¸¾à, È­¸é¿¡ Á¦´ë·Î µÈ, onmonitor Ãʱâ È­¸éÀÌ ¶ßÁö ¾Ê´Â´Ù¸é ¿©·¯ºÐÀÇ È¯°æº¯¼ö Áß¿¡ term º¯¼ö¿Í lines º¯¼ö¸¦ ¾Ë¸Â°Ô ¸ÂÃçÁֱ⠹ٶõ´Ù. ¾Æ¸¶ ´ëºÎºÐÀº term=vt100, lines=24·Î ¸ÂÃá´Ù¸é º° ¹«¸® ¾øÀÌ »ç¿ëÇÒ ¼ö ÀÖÀ» °ÍÀÌ´Ù.

ÃʱâÈ­ È­¸éÀ» ¶ç¿ü´Ù¸é, parameters ¸Þ´º¸¦ ¼±ÅÃÇÏÀÚ. parameters ¸Þ´º·ÎºÎÅÍ initialize ¸Þ´º¸¦ ¼±ÅÃÇÑ´Ù. ¿©±â¼­ºÎÅÍ »ç¿ëÀÚ°¡ ¼³Á¤ÇÏ¿©¾ß ÇÒ Ç׸ñµé¿¡ ÇÁ·ÒÇÁÆ®°¡ ±ôºýÀÏ °ÍÀÌ´Ù. ¿©·¯ºÐÀÌ °ªÀ» ¼³Á¤ µµÁß ¼³Á¤À» Áß´ÜÇÏ°í ºüÁ®³ª°¡°í ½Í´Ù¸é delete ۸¦ ´©¸£°Å³ª ctrl-c۸¦ ´©¸£¸é µÈ´Ù. ¼³ÀýÀ» Á¤»óÀûÀ¸·Î ¸¶Ä¡°í ½ÍÀ¸¸é esc۸¦ ´©¸£°í ºüÁ® ³ª¿À¸é µÈ´Ù.

disk parameterÈ­¸é¿¡¼­ Á¦ÀÏ ¸ÕÀú ¼³Á¤ÇØ ÁÖ¾î¾ß ÇÏ´Â °ªÀº Å×ÀÌÇÁ µå¶óÀ̹ö¿¡ ´ëÇÑ °ÍÀÌ´Ù. ¸¸¾à Å×ÀÌÇÁ µå¶óÀ̹ö¸¦ »ç¿ëÇÏ°í ½Í´Ù¸é Àû´çÇÑ °ªÀ» ³Ö°í, »ç¿ëÇÏÁö ¾ÊÀ» °æ¿ì´Â /dev/nullÀ» ¼³Á¤ÇÑ´Ù. ÀÌ È­¸éÀ» ºüÁ® ³ª°¡±â Àü¿¡ root size, primary path, root offsetÀ» ¼³Á¤ÇØ¾ß ÇÑ´Ù.

´ÙÀ½ È­¸éÀ¸·Î ³Ñ¾î°¡¸é ¼³Á¤ÇØ¾ß ÇÒ Çʵå´Â ¼­¹ö À̸§°ú ¼­¹öÀÇ º°¸íÀ» ¸¸µå´Â °ÍÀÌ´Ù. °è¼Ó ÁøÇàÇϱâ À§Çؼ­ esc ۸¦ ´©¸¥´Ù.

shared memory ¼³Á¤À» ¸¶Ä¡¸é nettype ¼³Á¤ È­¸éÀÌ ³ª¿Â´Ù. ÀÌ È­¸éÀº cpu¿Í °ü·ÃµÈ ±¸¼º Çʵåµé·Î ±¸¼ºµÇ¾î ÀÖ´Ù. ¿©±â¼­ »ç¿ëÀÚ°¡ ¼³Á¤ÇØ¾ß ÇÏ´Â ºÎºÐÀº nettype ÇʵåÀÌ´Ù. »ç¿ëÀÚ°¡ ipc¿Í tcp¿¡ °ü·ÃµÈ »çÇ×µéÀ» ¼³Á¤ÇØ ÁÖ°í ³Ñ¾î°¡¸é µÈ´Ù. ÀÌ ¼³Á¤Àº sqlhosts È­ÀÏ¿¡ ¼³Á¤°ú µ¿ÀÏÇÏ°Ô ¹Ý¿µÀÌ µÇ¾î¾ß ÇÑ´Ù.

´ÙÀ½¿¡ À̾îÁö´Â È­¸éµéÀº Ưº°ÇÑ ¼³Á¤À» ÇÊ¿ä·Î ÇÏÁö ¾ÊÀ¸´Ï, ¿¹Á¦ ±×¸²¿¡ ³ª¿Í

ÀÖ´Â µ¥·Î ¼³Á¤ÇÏ°í °è¼Ó ÁøÇàÇÏ¸é µÈ´Ù.


À§ÀÇ ¼³Á¤À» Á¤»óÀûÀ¸·Î ¸¶ÃÆ´Ù¸é onmonitor´Â µ¥ÀÌÅͺ£À̽º¸¦ »ý¼ºÇϰí ÃʱâÈ­¸¦ ÇÒ °ÍÀÌ´Ù. ÀÌ ¸ðµç °úÁ¤ÀÌ ¼øÁ¶·Ó°Ô ÁøÇàµÇ¾ú´Ù¸é, »ç¿ëÀÚ´Â ´ÙÀ½°ú °°Àº °úÁ¤À» °ÅÃļ­ ¼³Á¤ÀÌ Á¤»óÀûÀ¸·Î Àû¿ëµÇ¾ú´ÂÁö¸¦ È®ÀÎÇϵµ·Ï ÇÏÀÚ.

onmonitor¸¦ ºüÁ® ³ª¿À¸é ÀÎÆ÷¹Í½º µ¥ÀÌÅͺ£À̽º°¡ ±âµ¿µÇ¾î ÀÖ´Â »óÅÂÀ̹ǷΠÇÁ·ÒÇÁÆ® »óÅ¿¡¼­ onmode -ky¸¦ ÀÔ·ÂÇØ¼­ µ¥ÀÌÅͺ£À̽º¸¦ Á¤Áö ½Ã۵µ·Ï ÇÑ´Ù. ±× ´ÙÀ½ sqlhostsÈ­ÀÏÀ» ¿­¾î¼­ Àû´çÇÑ ÆíÁýÀ» ÇØ¾ß ÇÑ´Ù. ÀÌ °úÁ¤Àº onmonitor¸¦ ÀÌ¿ëÇÏ¿© ÃʱâÈ­ Çϱâ Àü¿¡ ÇØµµ »ó°ü ¾ø´Ù.

sqlhost È­ÀÏÀº 4°³ÀÇ Çʵå·Î ±¸¼ºµÈ´Ù. ù¹øÂ°´Â ¼­¹ö À̸§ÀÌ°í µÎ¹øÂ° Çʵå´Â ¿¬°á ¹æ½ÄÀ» ³ªÅ¸³»´Â ÇʵåÀÌ´Ù. µÎ¹øÂ° Åë½Å Çʵå´Â ipc(onipcshm), berkely socket(onsoctcp), tli socket(ontlitcp) µîÀ» Áö¿øÇÑ´Ù.

--------------------------------------------------------------------------

${informixdir}/etc/sqlhosts

# sccsid: @(#)sqlhosts.demo 9.2 7/15/93 15:20:45

# description:

# default sqlhosts file for running demos.

#

#**************************************************************************

#demo_on onipcshm on_hostname on_servername

#demo_se seipcpip se_hostname sqlexec

angra onipcshm angra sqlipc

angra onsoctcp angra sqlexec

--------------------------------------------------------------------------

¼¼¹øÂ° Çʵå´Â ÀÎÆ÷¹Í½º°¡ ¼³Ä¡µÇ¾î Àִ ȣ½ºÆ®ÀÇ À̸§ÀÌ´Ù. ³×¹øÂ° Çʵå´Âservice°¡ »ç¿ëÇÒ Æ÷Æ®ÀÇ À̸§ÀÌ´Ù. ³×¹øÂ° Çʵå´Â À̸§Àº /etc/services È­ÀÏ¿¡ ÀÖ´Â ¼­ºñ½º À̸§, Æ÷Æ® ±×¸®°í Åë½Å ÇÁ·ÎÅäÄÝ ÇʵåÀÇ ¼­ºñ½º À̸§°ú °°¾Æ¾ß ÇÑ´Ù.

--------------------------------------------------------------------------

/etc/services

#informix serices

sqlipc 2001/tcp

sqlexec 2002/tcp

--------------------------------------------------------------------------

À§ÀÇ ¼³Á¤ÀÌ Àß µÇ¾ú´Ù¸é ÇÁ·ÒÇÁÆ® »óÅ¿¡¼­ oninitÀ» Ä¡¸é ÀÎÆ÷¹Í½º¸¦ ±âµ¿

µÉ °ÍÀÌ´Ù. ±×¸®°í 'onstat -'¸¦ ÀÔ·ÂÇÏ¸é ´ÙÀ½°ú °°Àº ¸Þ½ÃÁö¸¦ È®ÀÎ ÇÒ ¼ö ÀÖÀ»

°ÍÀÌ´Ù.

--------------------------------------------------------------------------

/home/informix % onstat -

informix dynamic server version 7.30.u -- on-line -- up 04:17:02 -- 8888 kbytes

--------------------------------------------------------------------------

¿©±â±îÁö ¿Ô´Ù¸é ¿©·¯ºÐÀº ÀÌÁ¦ ¿ÏÀüÇÑ ÀÎÆ÷¹Í½º µ¥ÀÌÅͺ£À̽º¸¦ °®°Ô µÈ°ÍÀÌ´Ù.

¸¶Áö¸·À¸·Î ÇÁ·ÒÇÁÆ®¿¡¼­ dbaccessdemo7À̶ó°í Ãļ­ µ¥¸ð¿ë µ¥ÀÌÅͺ£À̽º¸¦ »ý¼º ½Ã۰í, À̸¦ ÀÌ¿ëÇØ¼­ sqlÀ» ½ÇÇà ½ÃÄѺ¸µµ·Ï ÇÑ´Ù.