¾È³çÇϼ¼¿ä. DB2 ¹× XpertMon »ç¿ëÀÚ ¿©·¯ºÐ!
¢ß ¾ÆÀÌƼ¿¢½ºÆÛÆ®±×·ì DB »ç¾÷ºÎÀÔ´Ï´Ù.
¿À´ÃÀº ¾î¶² Å×À̺íÀÌ Access µÇ¾ú´ÂÁö ¸ð´ÏÅ͸µ ±â´ÉÀ» ÅëÇÏ¿© È®ÀÎÇÏ´Â ¹æ¹ý¿¡ ´ëÇØ
¼³¸íµå¸®µµ·Ï ÇÏ°Ú½À´Ï´Ù.
Checking whether a table is being accessed
¸ð´ÏÅ͸µÀ» ÅëÇØ ¿øÇÏ´Â ±â°£µ¿¾È ¾î¶² Å×À̺íÀÌ Access µÇ¾ú´ÂÁö ÆǺ°ÇÒ ¼ö ÀÖ½À´Ï´Ù.
¸ÕÀú monitoring switch Áß table event ¿Í °ü·ÃµÈ ½ºÀ§Ä¡ °ªÀ» º¯°æÇÕ´Ï´Ù.
- db2 update dbm cfg using dft_mon_table on
XpertMonÀÇ CFG ±â´ÉÀ» ÀÌ¿ëÇϸé update ÇÒ ¼ö ÀÖÀ¸¸ç, º¯°æÀÌ·ÂÀ» °ü¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- Immediate value °¡ ONÀ̸é , db2stop/db2start ¾øÀÌ ¹Ù·Î Àû¿ëµË´Ï´Ù.
- º¯°æÀÌ·ÂÀ» ÀÌ¿ëÇÏ¸é ¾î´À ½Ã°£¿¡ ¾î¶² ÆĶó¹ÌÅ͸¦ º¯°æÇÏ¿´´ÂÁö ¾Ë ¼ö ÀÖÀ¸¹Ç·Î,
¼º´É ÀÚ·á·Î »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
SnapshotÀ» ÀÌ¿ëÇÏ¿© ÇöÀç »ç¿ëÁßÀÎ Å×ÀÌºí¿¡ ´ëÇÑ Á¤º¸¸¦ °¡Á®¿É´Ï´Ù.
¾Æ·¡¿Í °°ÀÌ snapshot_table() FunctionÀ» ÀÌ¿ëÇÏ¿© ÀÐÀº Çà¼ö°¡ ¸¹Àº ¼ø¼·Î
Å×À̺í Á¤º¸¸¦ º¼ ¼ö ÀÖ½À´Ï´Ù.
- select substr(table_schema,1,20), substr(table_name,1,20), rows_read
from table(snapshot_table(¡®sample¡¯,-1))as s
order by rows_read desc
1 2 ROWS_READ
------------- ------------- ------------
DB2ADMIN EMPLOYEE 32
DB2ADMIN DEPARTMENT 8
XpertMonÀÇ Report ±â´É Áß Object I/O º¸°í¼¸¦ ÀÌ¿ëÇÏ¸é °¢Á¾ Å×ÀÌºí¿¡ ´ëÇÑ
Access ÀÌ·ÂÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
- ¸ÕÀú ¾Æ·¡¿Í °°ÀÌ Object I/O Report ¸¦ Ŭ¸¯ÇÑ ÈÄ ¡®OK¡¯ ¹öÆ°À» ´·¯
µ¥ÀÌÅÍ ¼öÁýÀ» ½ÃÀÛÇÕ´Ï´Ù.
- µ¥ÀÌÅÍ ¼öÁýÀ» ¸¶Ä¡·Á¸é Object I/O Report Ŭ¸¯À» ÇØÁ¦ÇÑ ÈÄ ¡®OK¡¯ ¹öÆ°À» ´©¸¨´Ï´Ù.
µ¥ÀÌÅÍ°¡ ¼öÁýµÈ °¡Àå ÃÖ±Ù ½Ã°£ ¼ÒÀÎÀÌ ¿À¸¥ÂÊ¿¡ ³ªÅ¸³³´Ï´Ù.
- Table I/O ¸¦ Ŭ¸¯ÇÏ¿© Table º¸°í¼¸¦ Ãâ·ÂÇÕ´Ï´Ù. ±â°£À» ¼±ÅÃÇÕ´Ï´Ù.
¿©±â¼´Â 4¿ù 29ÀÏ ÇÏ·çÀüüÀÇ ½Ã°£º° Report ¸¦ Ãâ·ÂÇغ¸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
- ½Ã°£´ëº° Rows Read °¡ ¸¹Àº Å×À̺íÀ» Rows Read ¼øÀ¸·Î order by ÇÑ °á°úÀÔ´Ï´Ù.
Ä÷³À» Ŭ¸¯ÇÏ¸é ¿øÇÏ´Â Ç׸ñÀ¸·Î SortÇÒ ¼ö ÀÖÀ¸¸ç, ½Ã°£º° Result Count ¿ª½Ã
¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- Rows Read ¿Í Write ¿Í Overflow Access, Page Reorg Ç׸ñÀÌ ÀÖ½À´Ï´Ù.
Write ´Â Write Rows ¼ö°¡ ¸¹¾Ò´ø Å×À̺íÀ» ÀǹÌÇϸç, Overflow Access ´Â
Overflow°¡ ÀÖ´Â Row¸¦ Access ÇÑ È½¼ö¸¦ ÀǹÌÇÕ´Ï´Ù. overflow Row ´Â Row°¡
updateµÇ¾î ±âÁ¸ ÆäÀÌÁö¿¡ ÀúÀåÇÒ ¼ö ¾ø¾î ´Ù¸¥ ÆäÀÌÁö¿¡ ÀúÀåÇÑ Row ¸¦ ¸»ÇÕ´Ï´Ù.
Variable ±æÀÌ Ä÷³À» updateÇϰųª, alter table ÇßÀ» °æ¿ì ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.
Page Reorg´Â New Row°¡ insertµÇ¾ú°Å³ª, ±âÁ¸ Row¸¦ updateÇÏ¿´À» °æ¿ì
¿ø·¡ ÀúÀå ÆäÀÌÁö¸¦ Rºó°ø°£À» À籸¼ºÇؼ µ¥ÀÌÅ͸¦ ÀúÀåÇÑ °æ¿ì¸¦ ¸»ÇÕ´Ï´Ù.
Overflow Access ³ª Page Reorg °¡ ¹ß»ýÇÑ Å×À̺íÀÇ °æ¿ì¿¡´Â Reorg¸¦ ¼öÇàÇÏ´Â
°ÍÀÌ ÁÁ½À´Ï´Ù. UDBESE.EMPÀÇ °æ¿ì Page Reorg°¡ ¸¹ÀÌ ¹ß»ýÇÏ¿´À¸¹Ç·Î,
ÇØ´ç Å×À̺íÀ» ReorgÇϸé Insert ³ª update ½Ã ¼º´É°³¼± È¿°ú¸¦ º¼ ¼ö ÀÖ½À´Ï´Ù.
XpertMon for DB2 UDB V2
DB »ç¾÷ºÎ
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail : hjlee@iteg.co.kr
URL : http://iteg.co.kr