ÀÌ Àý¿¡´Â ±¸¼º ÆÄÀÏÀÇ ¼½Ä°ú, ±× ÆÄÀÏ¿¡ Æ÷Ç﵃ ¼ö ÀÖ´Â ¸Å°³º¯¼öµéÀÇ ±¸¹®¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸°¡ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù. ¶ÇÇÑ, °¢ ¸Å°³º¯¼ö¿¡ ´ëÇØ ÁöÁ¤ÇÒ ¼ö ÀÖ´Â ¿Ã¹Ù¸¥ °ª¿¡ °üÇÑ ÀÚ¼¼ÇÑ Á¤º¸µµ ¼ö·ÏµÇ¾î ÀÖ½À´Ï´Ù.
±¸¼º ÆÄÀÏ¿¡´Â ¸Å°³º¯¼ö¸¦ ÁöÁ¤ÇÏ´Â ¼¼ °¡Áö Á¾·ùÀÇ ¼½¼ÇÀÌ ÀÖ½À´Ï´Ù.
rsm.cfg ÆÄÀÏÀÇ ÀÌ ¼¼ °¡Áö ¼½¼ÇÀº °¢ ·¹º§¿¡¼ ´ëü °ªÀ» ÁöÁ¤ÇÒ ¼ö ÀÖ´Â °èÃþ ±¸Á¶¸¦ Çü¼ºÇÕ´Ï´Ù. DB2 OLAP Server´Â µ¥ÀÌÅͺ£À̽º³ª ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡ ´ëü°ªÀ» ÁöÁ¤ÇÏÁö ¾ÊÀ¸¸é RSM ¼½¼ÇÀÇ ¼³Á¤°ªÀ» »ç¿ëÇÕ´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥À» ÀÛ¼ºÇϰųª ½ÃÀÛÇÒ ¶§, DB2 OLAP Server´Â ±× ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ±¸¼º ÆÄÀÏÀÇ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» ã¾Æ¼ RSM ¼½¼Ç¿¡ ÀÖ´Â °ªÀ» ±× ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡¼ ¹ß°ßµÇ´Â °ªÀ¸·Î ´ëüÇÕ´Ï´Ù. µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϰųª ½ÃÀÛÇÒ ¶§, DB2 OLAP Server´Â ÇöÀç ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ¼½¼Ç ³»ÀÇ ÇØ´ç µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ±¸¼º ÆÄÀÏ¿¡¼ µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ã¾Æ¼ ÀÀ¿ëÇÁ·Î±×·¥¿¡ ÀÖ´Â °ªÀ» ±× µ¥ÀÌÅͺ£À̽º ¼½¼Ç¿¡¼ ¹ß°ßµÇ´Â °ªÀ¸·Î ´ëüÇÕ´Ï´Ù.
±¸¼º ÆÄÀÏ¿¡¼ ¸Å°³º¯¼ö Çü½ÄÀº ´ÙÀ½°ú °°½À´Ï´Ù.
tag=value
tag´Â ¸Å°³º¯¼ö À̸§À̰í, value´Â º¯¼ö(¿¹: µ¥ÀÌÅͺ£À̽º À̸§, ¹øÈ£ ¶Ç´Â ¹®ÀÚ¿)ÀÇ °ªÀ̳ª °¡´ÉÇÑ °ªÀÇ ¸ñ·Ï(¿¹: ºÐ¸® ·¹º§ÀÇ ¸ñ·Ï)¿¡¼ ¼±ÅÃÇÏ´Â °ªÀÔ´Ï´Ù. ÅØ½ºÆ® °ªÀº µû¿ÈÇ¥·Î ¹Áö ¾Ê½À´Ï´Ù.
¼±ÅÃÇÑ ÆíÁý±â¸¦ »ç¿ëÇÏ¿© ±¸¼º ÆÄÀÏÀ» ÆíÁýÇÒ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½ ÀÏ·ÃÀÇ ¿¹´Â Windows NT, UNIX ¹× OS/390¿ë ±âº» ¹× °í±Þ »ùÇà ±¸¼º ÆÄÀÏÀ» º¸¿©ÁÝ´Ï´Ù.
±×¸² 7ÀÇ »ùÇÃÀº Windows NT ¶Ç´Â UNIX¿ë ±âº» ±¸¼º Å×À̺íÀÔ´Ï´Ù. ½Ã½ºÅÛ °ü¸®ÀÚ´Â DB2 OLAP Server°¡ TSOLAP¿¡ ¸ðµç Å×ÀÌºí µ¥ÀÌÅ͸¦ ÀúÀåÇÏ°í ¸ðµç »öÀÎ µ¥ÀÌÅͰ¡ TSOLAPX°¡ µÇµµ·Ï Ãʱ⠱¸¼º ÆÄÀÏÀ» ¼³Á¤ÇÕ´Ï´Ù. »ç¿ëÀÚÀÇ ¸ðµç Å¥ºê¸¦ °°Àº µ¥ÀÌÅͺ£À̽º ¹× Å×ÀÌºí °ø°£¿¡ À§Ä¡½ÃŰ·Á°í ÇÒ ¶§ ÀÌ ±¸¼º ÆÄÀϰú °°Àº ±âº» ±¸¼º ÆÄÀÏÀ» »ç¿ëÇϽʽÿÀ.
±×¸² 7. Windows NT ¶Ç´Â UNIX¿¡¼ÀÇ ±âº» ±¸¼º ÆÄÀÏ
/* Config file - system defaults */ [RSM] /* Required tag to start the main section */ RDB_NAME = OLAP /* Default to using the OLAP database */ RDB_USERID = ROLAP /* Specify the userid */ RDB_PASSWORD = xxxxxxxx /* Specify the password */ TABLESPACE = IN TSOLAP INDEX IN TSOLAPX /* All tables will go in this */ /* one tablespace */ |
±×¸² 8Àº ¼±ÅÃÀû ¸Å°³º¯¼ö°¡ OLAP ÀÀ¿ëÇÁ·Î±×·¥ ¹× ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ´ëüµÇ´Â Windows NT ¹× UNIX¿ë ±¸¼º ÆÄÀÏÀ» º¸¿©ÁÝ´Ï´Ù. ´õ ¸¹Àº µ¥ÀÌÅͺ£À̽º¿¡ ¸Âµµ·Ï ´õ ¸¹Àº Å×ÀÌºí °ø°£À» »ç¿ëÇÏ·Á°í ÇÒ °æ¿ì ÀÌ¿Í °°Àº ±¸¼º ÆÄÀÏÀ» »ç¿ëÇϽʽÿÀ. ÀÌ ¿¹¿¡¼, ±Þ¿© µ¥ÀÌÅÍ´Â TSPR¿¡ ÀÖ°í, ±Þ¿© Å×ÀÌºí »öÀÎÀº TSPRX¿¡ ÀÖ½À´Ï´Ù. ÀÌÀÍ ¹× ¼Õ½Ç µ¥ÀÌÅÍ´Â TSPL¿¡ ÀÖ°í ÀÌÀÍ ¹× ¼Õ½Ç Å×ÀÌºí »öÀÎÀº TSPLX¿¡ ÀÖ½À´Ï´Ù. ´Ù¸¥ ¸ðµç Å×À̺íÀº TSOLAP¿¡ »óÁÖÇϸç, ÇØ´çµÇ´Â »öÀεéÀº TSOLAPX¿¡ »óÁÖÇÕ´Ï´Ù. ¶ÇÇÑ °¢ ´ÙÂ÷¿ø µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ º°µµÀÇ »ç½Ç Å×ÀÌºí ¹× »ç½Ç Å×ÀÌºí »öÀÎÀÌ ÀÖ½À´Ï´Ù.
±×¸² 8. Windows NT ¶Ç´Â UNIX¿¡¼ÀÇ °í±Þ ±¸¼º ÆÄÀÏ
/* Config file - system defaults */ [RSM] /* Required tag to start the main section */ RDB_NAME = OLAP /* Default to using the OLAP database */ RDB_USERID = ROLAP /* Specify the userid */ RDB_PASSWORD = xxxxxxxx /* Specify the password */ TABLESPACE = IN TSOLAP INDEX IN TSOLAPX /* Tables go here unless */ /* overridden below */ /* Application - Accounts */ [ACCOUNTS] RDB_NAME = ACCTS /* Application uses its own database */ /* Application - Accounts : Database - Payroll */ <Payroll> TABLESPACE = IN TSPR INDEX IN TSPRX /* Non-fact tables have their */ /* own tablespaces */ FACTS = IN TSPRF INDEX IN TSPRFX /* Fact table has its own */ /* tablespaces */ /* Application - Accounts : Database - Profit and Loss */ <PandL> TABLESPACE = IN TSPL INDEX IN TSPLX /* Non-fact tables have their*/ /* own tablespaces */ FACTS = IN TSPLF INDEX IN TSPLFX /* Fact table has its own */ /* tablespaces */ |
±¸¼º ÆÄÀÏ¿¡ ÁÖ¼®À» ÀÔ·ÂÇÏ·Á¸é, ´ÙÀ½ ±ÔÄ¢À» µû¸£½Ê½Ã¿À.
¿¹:
/*This is a valid comment.*/
/*This is valid.*/ TAG=VALUE /*And this is valid.*/ /*This is not valid*/
±¸¼º ÆÄÀÏÀº ´ÙÀ½ÀÇ Çì´õ ű׷Π½ÃÀÛÇÕ´Ï´Ù.
[RSM]
±¸¼º ÆÄÀÏ¿¡´Â ´ÙÀ½ ¸Å°³º¯¼öµµ µé¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
RDB_NAME = databasename
¿©±â¼ databasenameÀº DB2 OLAP Server¿¡¼ OLAP ÀÀ¿ëÇÁ·Î±×·¥ ¹× µ¥ÀÌÅͺ£À̽º¸¦ ÀúÀåÇÒ °ü°èÇü µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù.
±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¿¡ ¼³¸íµÇ¾î ÀÖ´Â ¸ðµç ¸Å°³º¯¼ö°¡ RSM ¼½¼Ç¿¡¼ À¯È¿ÇÕ´Ï´Ù.
RSM ¼½¼Ç¿¡ ÀÖ´Â ¸Å°³º¯¼ö ¼¼Æ®¸¦ ´ëüÇÒ ¸Å°³º¯¼ö°¡ µé¾î ÀÖ´Â ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀº ÀÀ¿ëÇÁ·Î±×·¥ÀÇ À̸§À» ³ªÅ¸³»´Â ű׷Π½ÃÀÛÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, ÀÀ¿ëÇÁ·Î±×·¥ À̸§ÀÌ SAMPLEÀ̸é, ±×¸² 7¿¡ ³ª¿Í ÀÖ´Â °Íó·³, [SAMPLE] ű׸¦ »ç¿ëÇÏ¿© ±× ÀÀ¿ëÇÁ·Î±×·¥¿¡ ´ëÇÑ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀ» Æ÷ÇÔ½Ãų ¼ö ÀÖ½À´Ï´Ù.
ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀº RSM ¼½¼ÇÀÇ ¸¶Áö¸· ¸Å°³º¯¼ö ´ÙÀ½¿¡ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
´ÙÀ½ ¸Å°³º¯¼ö°¡ ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡ ´ëÇØ À¯È¿ÇÕ´Ï´Ù.
°¢ ¸Å°³º¯¼ö¿¡ ´ëÇÑ ¼³¸íÀº ±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¸¦ ÂüÁ¶ÇϽʽÿÀ.
ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼Ç¿¡¼ ¼³Á¤µÈ ¸Å°³º¯¼ö¸¦ ´ëüÇÒ ¸Å°³º¯¼ö°¡ µé¾î ÀÖ´Â µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ÀÛ¼ºÇÒ ¼ö ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀº <database> ű׷Π½ÃÀÛÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, SAMPLE ÀÀ¿ëÇÁ·Î±×·¥¿¡ BASIC µ¥ÀÌÅͺ£À̽º°¡ ÀÖÀ¸¸é, <BASIC>À» »ç¿ëÇÏ¿© ±× µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀ» ½ÃÀÛÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽º ¼½¼ÇÀº ÇØ´çµÇ´Â ÀÀ¿ëÇÁ·Î±×·¥ ¼½¼ÇÀÇ ¸¶Áö¸· ¸Å°³º¯¼ö ´ÙÀ½¿¡ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
TABLESPACE, FACTS, PARTITIONING, FINDEX, KINDEX ¸Å°³º¯¼ö¸¸ÀÌ µ¥ÀÌÅͺ£À̽º ¼½¼Ç¿¡¼ À¯È¿ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼öµé¿¡ ´ëÇØ¼´Â ±¸¼º ÆÄÀÏ ¸Å°³º¯¼ö¿¡ ¼³¸íµÇ¾î ÀÖ½À´Ï´Ù.