?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
??? ????? ???? SQL ??, ? SQL? ? ??? ??? ? ?? ?????
?? ????? ?????.
????? SQL? ???? ??, ??????? ??? ???? ? ????,
??? ???? ???? ???? ???? ?? ? ?????.

---

???? SQL ?? ???

1. ??? ??? ???? ????? SQL? ??????. select * ?? ???? ????. ?? ?? ????? CPU ???? ?????.
   
2. WHERE ?? ??? ???? ??? ???? ??? ????? ???.
   
3. Host ??? ??? ?? ??? ?? Type? ??? ???? ???? ??????. ?? ??? ???, DB2? ???? ??? ? ??? ??? ???? ??? ??? ???. ?? ??, CHAR(6)?? ??? ??? CHAR(4)? CHAR(7) ? ??? ???? ?? ??? ??? ???? DB2? ???? ???? ?? ??? ??? ???? ??? ?????.
   
4. SQL ??? Order by ?? ???? ?? ?? cursor ????? ???? ???, ? ??? ??? Order by ? ??????.
   
5. Select ?? ???? ?? ?? ? ?? ???? SELECT INTO ?? ???? ?? Cursor? ???? ??? ??? ????. ???, ?? ???? ???? ?? ???? FOR UPDATE OF ? ???? Cursor? ???? ?? ???? Row? Exclusivce Lock? ?? ??? ???? ?????? ? ????.
   
6. ?? ??? ???? Select ?? FOR FETCH ONLY ?? ?????.
   
7. DISTINCT? ??? ????. Distinct ? ???? Sort? ?????, ??? ? ??? ??? ???? ??? ???.
   
8. JOIN ? ??? ??? ???? 5? ??? ???? ?? ????. ?? ? ?? ???? ??????, Subquery ??? Join ? ??????. Optimizer ? Join? ??? ? ??? ?? ??? ? ?? ??? ?? ?????. ??? ??? ???? ???? ???? ?????.
   
9. ORDER BY, GROUP BY, DISTINCT, UNION ? ??? ?? ?? ??? Index ? ???? ?? ????.
   
10. ??? ??? SQL ?? ??? SUBSTR ??? ??? ??? ?? ????. ?? ?? ??? ?? ?? substr ?? like? ??????. like? ???? ?? index ? ???? ???.
    

    ?) select custinfo from sales where substr(serial,1,4) = ‘1333’    select custinfo from sales where serial like ‘1333%’

11. SQL? ?? ??(AVG,COUNT,MAX,MIN,SUM)? ??????. SQL? ?? ??? ???? ?? ?? ??? ???????? ??? ???? ??? ? ??????.
    
12. ??? ??? SQL? Scalar ??? ??? ????. ??? ??? ??, ???? ??, ??? ??/??? ???? ?? ???? SQL Scalar ??(INTEGER, DECIMAL, HEX, SUBST?)? ??? ?????.
    
13. ?? ???? ?? ???? ???? ??? ??, ??? ?? ???? ???? ??? ?? ???. ??? DB2 LOG? ??? DB2? ??? ?? ?????? ????? ????? ??? ????.
    
14. ?????, VARCHAR ??? ??? ?? ???. ?? ?? ???? ??? ??? ?? ???? ??? VARCHAR ???? ????? ???? ?? ???.
    
15. <=, >= ??? BETWEEN? ?????. BETWEEN? Optimizer?? ? ???? ?? ??? ???? ????.
    
16. ?? ???? ???, ???? input data? ??? Access ?? ???? ??? ??? ???? ??? ???? ??? ?? DB2 ? sequential prefetch? ???? ??? ??? ?? ? ????.
    
17. multicolumn index? ?? Index? Matching ???? ??? ??? ?????.
    
18. Commit? ????, ????? ??? ????. Commit? ??? ??????.
    
19. LIKE ?? IN? ?????. ?? ??? ? ?? ?? ?? ?? ???, LIKE? ???? ??? IN? ??? ???? ?? ? ??????. ?? ??, ?? Last Name? M?? ???? ?? ???? ????, LIKE ‘m%’ ??? BETWEEN ‘maaaaaaaaaaaaaa’ and ‘mzzzzzzzzzzzzzz’? ??????.
    
20. NOT? ??(EXISTS? ??)? ????. NOT? ?? ?? ??? ????? ????? ???? ???.
    
21. ?? ?????? ?? ?? ?? ?? ?? ???, SELECT ?? ??? ??? ????.
    

    ?) select c1,c2,c3 into :c1, :c2,:c3 from t1 where c1 = :c1

22. SELECT ?? ?? ??? ?? ??? ?? ???, ??? ???? ??? ??? , UNION ?? UNION ALL? ?????.
    
23. ??? ??? Subquery? ??? ?, SQL?? ???? ??? ??? ???? NOT IN ?? NOT EXISTS? ?????. NOT EXISTS? ??? ?, DB2? ?? ???? ?? ?? ????? NOT IN??? ????, DB2? ??? ???? ???? ??? ???? ???.
    
24. JOIN? Subquery ?? ? ??????.

    ?) select eno,ename from emp , proj where workdept = deptno and empno = respemp (O) select eno, ename from emp where workdept = ( select deptno from proj where respemp = emp.empno) (X)

---

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