OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼
DB2 OLAP Server°¡ »ç¿ëÇÏ´Â Å×À̺í, ƯÈ÷ »ç½Ç ¹× Ű Å×À̺íÀº ¹Ì»ç¿ë °ø°£À»
Àç¿ä±¸Çϱâ À§ÇØ Ç×»ó À籸¼ºÇϰųª Á¶°¢ ¸ðÀ½À» ¼öÇàÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ´Â µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ÀÇ ÇØ´ç µµ±¸¸¦ »ç¿ëÇÏ¿©
À̰ÍÀ» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.
DB2¸¦ »ç¿ëÁßÀ̶ó¸é, ´ÙÀ½ ½Ã³ª¸®¿À¿¡¼¿Í °°ÀÌ REORG ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.
- CUBECATALOG Å×ÀÌºí¿¡¼ ÇàÀ» ¼±ÅÃÇϰí, À籸¼ºÇÏ·Á´Â ÀÀ¿ëÇÁ·Î±×·¥°ú
µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ RELCUBEID ¹× FACTTABLECOUNT¸¦ °áÁ¤ÇϽʽÿÀ. À̸¦
¼öÇàÇϱâ À§ÇÑ SQL¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.
SELECT RELCUBEID, FACTTABLECOUNT FROM CUBECATALOG WHERE APPNAME='Myapp'
AND CUBENAME='MyCube'
ÀÌ ¿¹¿¡¼´Â ´ÙÀ½À» °¡Á¤ÇÕ´Ï´Ù.
- RELCUBEID°¡ 6À̰í FACTTABLECOUNT°¡ 4À̸ç, ³× °³ÀÇ »ç½Ç
Å×À̺í(CUBE6FACT1, CUBE6FACT2, CUBE6FACT3 ¹× CUBE6FACT4)À» °¡Áö°Ô µË´Ï´Ù.
- ³× °³ÀÇ »öÀÎ(CUBE6FINDEX1, CUBE6FINDEX2, CUBE6FINDEX3, CUBE6FINDEX4)À»
°¡Áö°í ÀÖ½À´Ï´Ù.
- Ű Å×À̺íÀº ¾î¶² À籸Á¶È°¡ ¼öÇàµÇ¾ú´ÂÁö¿¡ µû¶ó CUBE6KEYA ¶Ç´Â
CUBE6KEYB Áß ÇϳªÀÔ´Ï´Ù. Ű Å×ÀÌºí »öÀÎÀº CUBE6KINDEXÀÔ´Ï´Ù.
- ¸ðµç »ç½Ç Å×À̺í°ú Ű Å×ÀÌºí¿¡¼ REORGCHK¸¦ ¼öÇàÇÕ´Ï´Ù.
¿¹:
reorgchk on table userid.cube6fact1
reorgchk on table userid.cube6fact2
reorgchk on table userid.cube6fact3
reorgchk on table userid.cube6fact4
reorgchk on table userid.cube6keya
- ¿©±â¼ REORGCHK´Â REORG(ÇØ´çµÇ´Â »öÀΰú
ÇÔ²² Å×À̺íÀ» REORG)ÇØ¾ß ÇÔÀ» ³ªÅ¸³À´Ï´Ù. ¿¹:
reorg table userid.cube6fact3 index userid.cube6findex3
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]