?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? DB2LOOK? ??? optimizer access plan ???? ? ??? db2exfmt?
detail? ??(DBM/DB CFG ????)? ?? ????? ?????.
db2exfmt output? ?? ??
DBM ?? ????
DBM ????? ?? ??? db2 get dbm cfg ???? ???? DBM ?????
update?? ??? db2 "update dbm cfg using ? ?????
Parallelism:
? ????? inter ?? intra-partition parallelism? ????? ?????.
?? ??? Multiple ????? ? DPF??, inter-partition parallelism?? ?? ????.
?? ?? ??? SMP(intra-partition? ???) ?? ?????, intra-partition
parallelism?? ?? ????.
?? ? ? (intra-parallel? ???? Multiple ??? ??) ?? ???, inter ?
intra-partition parallelism? ? ????.
??? ?????, ?? inter ? intra-partition parallelism? ??? ? ?????
NONE???.
CPU Speed (cpuspeed):
CPU Speed(??? milliseconds)? ?? operation? ???? cost? ???? ???
SQL optimizer? ?? ?????.
Communications speed: (comm_bandwidth)
???? ???(?? Megabytes)?? ???? ? ?? ???? DB ???? ???
??? ?? operation? ???? cost? ???? ??? SQL optimizer? ?? ?????.
DB ?? ????
DB ????? ?? ??? db2 get db cfg for db? ???? ???? DB ?????
update?? ??? db2 "update db cfg for db? using "? ?????.
Buffer pool size:
db2exfmt output?? ??? ???? ??? ???? default? buffpage? ?????,
syscat.bufferpools? ??? ??? ? ???? ??? ?? buffpage ?????
?????. ??? ??? DB? ??? ??? page? ? ????.
?? ?? ??? ?? ???? ??? ??? ??? ???.
Table 1. Buffer pool setup
| BUFFERPOOLNAME | SIZE |
| IBMDEFAULTBP | 1000 |
| BP1 | 1000 |
| BP2 | 4000 |
| BPIND1 | 1000 |
| BPIND2 | 1000 |
| BPLONG | 1000 |
| BPTEMP | 1000 |
| Total: | 10,000 |
db2exfmt output? ?? ??? ???? ???? ? ???? ?????.
??? ?? ?? 10,000? ?? ????.
Note) ??? ??? ???? ?? ?? ???? ?? ?????.
?? ????? ????? ?? ???? ?? ?? ? ??? db2fopt ???
db2look? -fd ??? ???? ?????.
MPP??, ??? ???? ??? ? ??? ??? ???? optimizer? opt_buffpage?
??? ?????. ????, ??? ?? ? Tool? ???? ??? ?????.
Sort heap size (SORTHEAP)
? ????? ?? sort? ??? ? ?? ?? ??? ???? ??? ?? ??
sort? ??? ? ?? ????? ???? ?? ?? ?????.
????? ?? ?? ????, ??, db2look? -fd ??? ???? ??? ???
|
!db2fopt SAMPLE update opt_sortheap 256; |
??? sortheap ?? ????? ?????. ??? optimizer? ??? sortheap ???
??? ???, ?? ??? ??? runtime? ???? sortheap? DB CFG???
sortheap ??? ?????.
opt_buffpage??, ???????? ??????? sortheap? ?? ????
??? ? ??? opt_sortheap? ??? ? ????.
Database heap size: (DBHEAP)
DB? ??? dbheap? ?? DBM? DB? Connect? ?? application? dbheap? ?????.
?? dbheap? ???, ???, ???????, ???? control block ??? ?????.
Lock list size: (LOCKLIST)
? ????? lock list? ??? ????? ?? ?????.
Maximum lock list: (MAXLOCKS)
? ????? DBM? lock? escalation ?? ?? application? ?? ???
lock list? %? ?????. Locklist? maxlock? scan(??? ??, ??? ??)??
??? ?? lock? ??? ???? ?? ????.
?? ?? index scan? ?? ??? ????.
IXSCAN: (Index Scan)
TABLOCK : (Table Lock intent)
INTENT SHARE |
Note : ?? lock ???? ?????? test ???? db2exfmt output? ????? ?? ????.
Average applications: (AVG_APPLS)
? ????? ??? ?? ???? ??? access plan? ?? run-time? ????
???? ?? ?? SQL optimizer? ?? ?????.
(???? DB? connection? ?? ???? application? ?? ??? ???)
Optimization Level: (DFT_QUERYOPT)
?? ?? ??? SQL ??? ???? ? optimization? ?? degree? optimizer?
????? ???? ????.
Query Degree: (DFT_DEGREE)
SQL?? inter-partition parallelism? degree???. ?? Any? setting?? ???
???? CPU? ?? ?????.
?? Any? ?????, intra-parallel? ???? ? ?????? ????? CPU??
??? ??? ????.
Number of frequent values retained: (NUM_FREQVALUES)
? ????? "With Distribution" ??? Runstats?? ??? ? ??????
"?? ??? ?"? ?? ???? ????.
Number of quantiles retained: (NUM_QUANTILES)
quantile ?? ???? ? ????? Runstats? With Distribution ???? ???? ???.
????? ?? ??????? frequent? quantile? ?? ?? ?? ??? ??
? ????(NUM_FREQVALUES? NUM_QUANTILES)? ?????? ??? ????? ??? ???.
SQL statement heap (4KB): (STMTHEAP)
SQL? Heap? SQL?? ???? ?? SQL ????? ?????? ?????.
? ????? ? ????? ???? ?????. ?? ????? ?? ???????
? ?? ??? ?? ???? ??? Statement Heap? ????? SQL0101 ????
? ????. ?? SQL0437W RC=1? ???? ??, dynamic join? ?? Statement Heap?
??? ??? join? ???? ???.
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
|
|
|
