Ȩ > Á¦Ç° > XpertMon Admin for DB2 z/OS
 
XpertMon for DB2 LUW
XpertMon Admin for DB2 z/OS
Open Knowledge Viewer
IBM IM Products
 
µ¥ÀÌÅͺ£À̽º¸¦ °ü¸®ÇÏ´Â DBA´Â µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛÀÇ ¾ÈÁ¤ÀûÀÎ ¿î¿µÀ» Ã¥ÀÓÁý´Ï´Ù. µû¶ó¼­ ½Ã½ºÅÛ Monitoring°ú Object°ü¸®, ¼º´ÉÆ©´×°ú °°Àº ÀÛ¾÷µéÀÌ ÀϹÝÀûÀÎ DBA¾÷¹«¶ó°í ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Object°ü¸®´Â ´ëºÎºÐ ¼öÀÛ¾÷À¸·Î ÀÌ·ç¾î Áö¸ç Object°£ÀÇ °ü°è¸¦ ã±â À§Çؼ­´Â SQLÀ» ¼öÇàÇÏ¿©¾ß ÇÕ´Ï´Ù. DBA´Â ÀÌ·¯ÇÑ ´Ü¼øÀÛ¾÷À» ¹Ýº¹ÀûÀ¸·Î ¼öÇàÇØ¾ß ÇÏ¸ç ±×·Î ÀÎÇØ ¸¹Àº ½Ã°£À» »©¾Ñ±â°í ÀÖ´Â °ÍÀÌ Çö½ÇÀÔ´Ï´Ù.

¶ÇÇÑ ¼º´ÉÆ©´×À» À§Çؼ­´Â ¸¹Àº ¾çÀÇ ¼º´Éµ¥ÀÌÅÍÀÇ ¼öÁý°ú ºÐ¼®ÀÌ ÇÊ¿äÇѵ¥ Á¤ÇüÈ­µÇÁö ¾ÊÀº ÀýÂ÷¿Í Æ©´×°ú °ü·ÃµÈ Á¤º¸¸¦ ã´Âµ¥ ÀûÁö ¾ÊÀº ½Ã°£ÀÌ ¼Ò¿äµÇ¾î ½Å¼ÓÇÑ ¼º´É°³¼±À» ±â´ëÇϱ⠾î·Æ½À´Ï´Ù.

XpertMon AdminÀº ITEGÀÇ Ç³ºÎÇÑ °æÇè°ú ¼öÁسôÀº ±â¼ú·ÂÀ» ¹ÙÅÁÀ¸·Î °³¹ßµÈ DB2 for z/OS °ü¸®µµ±¸·Î¼­ È¿À²ÀûÀÎ Object°ü¸®¿Í ½Å¼ÓÇÑ ¼º´ÉÆ©´×À» À§ÇÑ ´Ù¾çÇÑ ±â´ÉµéÀ» Á¦°øÇÕ´Ï´Ù.
XpertMon AdminÀÇ ±â´É ±¸¼º
XpertMon AdminÀº ÀÌ·¯ÇÑ ´Ù¾çÇÑ ±â´ÉµéÀ» ÅëÇØ DBAÀÇ »ý»ê¼ºÀ» ȹ±âÀûÀ¸·Î Çâ»ó½ÃÅ°°í °³¹ßÀÚµéÀÇ SQLÀÛ¼º ¹× Self-tuning´É·Â¹è¾çÀ» ¸ñÇ¥·Î ÇÕ´Ï´Ù. XpertMon AdminÀÇ ¸ðµç ±â´ÉÀº ¼­·Î ¿¬°èÇÒ ¼ö ÀÖµµ·Ï ¼³°èµÇ¾î ÀÖÀ¸¹Ç·Î DBA¿Í °³¹ßÀÚÀÇ ´Ü¼øÇÏ°í ¹Ýº¹ÀûÀÎ ÀÛ¾÷°øÁ¤À» Á¦°ÅÇÒ ¼ö ÀÖ½À´Ï´Ù. µû¶ó¼­ ¸Å¿ì ½±°í ºü¸£°Ô DB2 ObjectÀÇ »ý¼º°ú DDL°ü¸®¸¦ ÇÒ ¼ö ÀÖÀ¸¸ç ½Å¼ÓÇÏ°Ô ÃÖÀûÀÇ SQL·Î TuningÇÒ ¼ö ÀÖ½À´Ï´Ù.
±â´É »ó¼¼ ³»¿ë ºñ°í
Catalog Navigation ¡¤ Data Object : Storage Group, Tablespace, Table,¡¦
¡¤ Program Object : Plan, Collection, Package
¡¤ Function & Authorization
Object°ü¸®
- DDL Generation
- Volume DataÁ¤º¸ µî
SQL Runner ¡¤ Mutiple SQL : SELECT, UPDATE, DELETE, INSERT
¡¤ Open & Save : SQL, Results
SQL ¼öÇà ±â´É
(Windowsȯ°æ)
Explain ¡¤ Explain SQL & Get Access Pat
¡¤ Table & Index Information
¡¤ Statement Costs
Access Path ¹×
SQL TuningÁö¿ø ±â´É
DB2 Command ¡¤ Running DB2 Commands
¡¤ Saving the Commands
DB2¸í·É¾î ¼öÇà ±â´É
(Windowsȯ°æ)
Business SQL ¡¤ Dynamic SQL Management
¡¤ Explain & Get Access Path
¡¤ SQL Statement & Costs
Dynamic SQLÀÇ Access
Path¼öÁý ¹× °ü¸® ±â´É
Performance Report ¡¤ Static SQL & Application
¡¤ PDynamic SQL
DB2PM & DB2QM Data
 

¶ÇÇÑ XpertMon AdminÀº DB2 for z/OS°¡µ¿ Áß¿¡ ¹ß»ýÇÏ´Â ¼º´Éµ¥ÀÌÅ͸¦ ¼öÁýÇÏ°í °ü¸®Çϱâ À§ÇØ ÀÚüÀûÀÎ PDW¸¦ °¡Áö°í ÀÖÀ¸¸ç À̸¦ ÀÌ¿ëÇÏ¿© »ó¼¼ÇÑ ¼º´ÉºÐ¼®ÀÌ °¡´ÉÇÕ´Ï´Ù. ¼º´ÉºÐ¼® Áß ¹ß°ßµÇ´Â ¹®Á¦ÀÇ SQLÀº NavigationÀ» ÅëÇØ ¹Ù·Î TuningÇÒ ¼ö Àִ ȯ°æÀ» Á¦°øÇÕ´Ï´Ù. ±×¸®°í ÃßÀ̺м®À» ÅëÇÏ¿© Àå±âÀûÀÎ ÀÚ¿ø »ç¿ë·®¿¹ÃøÀÌ °¡´ÉÇÕ´Ï´Ù.
XpertMon AdminÀÇ ±â´É ±¸¼º

XpertMon AdminÀº Statics SQL¿¡ ´ëÇÑ ¼öÇà Àü ¼º´É°ü¸®±â´É »Ó¸¸ ¾Æ´Ï¶ó Dynamic SQL¿¡ ´ëÇÑ ¼öÇà Àü ¼º´É°ü¸®±â´ÉÀ» Áö¿øÇÕ´Ï´Ù. ÀÌ´Â ¼öÇàµÇ±â Àü¿¡´Â Access pathÁ¤º¸¸¦ ¾Ë ¼ö ¾ø´Â Dynamic SQLÀÇ ÇѰ踦 ³Ñ¾î¼± µ¶Ã¢ÀûÀÎ ¹æ¹ýÀÔ´Ï´Ù. Business SQL·Î ¸í¸íµÈ ÀÌ ±â´ÉÀº ¼¼°è¿¡¼­ ÃÖÃÊ·Î ITEG¿¡¼­ ¹ß¸íÇÑ °ÍÀÌ ÀÎÁ¤µÇ¾î ƯÇ㸦 ȹµæÇÏ¿´½À´Ï´Ù.

XpertMon Admin´Â ±¹³»ÃÖÃÊÀÇ °­·ÂÇÑ DB2 for z/OS°ü¸® µµ±¸·Î¼­ DBA¿Í °³¹ßÀÚÀÇ »ý»ê¼ºÀ» Çâ»ó½ÃÅ°°í ¼º´É°ü¸®¸¬ ÅëÇØ ±â¾÷ÀÇ TCO (Total Cost of Ownership)¸¦ Àý°¨ÇÒ ¼ö ÀÖ´Â ÃÖ»óÀÇ ¼±ÅÃÀÌ µÉ °ÍÀÔ´Ï´Ù.

XpertMon Admin ºê·Î¼Å
XpertMon Admin ¼Ò°³ÀÚ·á
XpertMon Admin µ¿¿µ»ó ÀÚ·á
XpertMon ƯÇãÁ¤º¸