|
|
|
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À» ½ÇÇà ½ÃÄѺ¸µµ·Ï ÇÑ´Ù.