OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼­


°ü°èÇü µ¥ÀÌÅͺ£À̽º Á¶°¢ ¸ðÀ½(À籸¼º)

DB2 OLAP Server°¡ »ç¿ëÇÏ´Â Å×À̺í, ƯÈ÷ »ç½Ç ¹× Ű Å×À̺íÀº ¹Ì»ç¿ë °ø°£À» Àç¿ä±¸Çϱâ À§ÇØ Ç×»ó À籸¼ºÇϰųª Á¶°¢ ¸ðÀ½À» ¼öÇàÇÒ Çʿ䰡 ÀÖ½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ´Â µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ÀÇ ÇØ´ç µµ±¸¸¦ »ç¿ëÇÏ¿© À̰ÍÀ» ¼öÇàÇØ¾ß ÇÕ´Ï´Ù.

Windows NT ¹× UNIX¿¡¼­ Á¶°¢ ¸ðÀ½

DB2¸¦ »ç¿ëÁßÀ̶ó¸é, ´ÙÀ½ ½Ã³ª¸®¿À¿¡¼­¿Í °°ÀÌ REORG ¸í·ÉÀ» »ç¿ëÇϽʽÿÀ.

  1. CUBECATALOG Å×ÀÌºí¿¡¼­ ÇàÀ» ¼±ÅÃÇϰí, À籸¼ºÇÏ·Á´Â ÀÀ¿ëÇÁ·Î±×·¥°ú µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇÑ RELCUBEID ¹× FACTTABLECOUNT¸¦ °áÁ¤ÇϽʽÿÀ. À̸¦ ¼öÇàÇϱâ À§ÇÑ SQL¹®Àº ´ÙÀ½°ú °°½À´Ï´Ù.

    SELECT RELCUBEID, FACTTABLECOUNT FROM CUBECATALOG WHERE APPNAME='Myapp'
      AND CUBENAME='MyCube'
    

    ÀÌ ¿¹¿¡¼­´Â ´ÙÀ½À» °¡Á¤ÇÕ´Ï´Ù.

  2. ¸ðµç »ç½Ç Å×À̺í°ú Ű Å×ÀÌºí¿¡¼­ 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
     
    
  3. ¿©±â¼­ REORGCHK´Â REORG(ÇØ´çµÇ´Â »öÀΰú ÇÔ²² Å×À̺íÀ» REORG)ÇØ¾ß ÇÔÀ» ³ªÅ¸³À´Ï´Ù. ¿¹:

    reorg table userid.cube6fact3 index userid.cube6findex3
    


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]