XpertMon for DB2 UDB News Letter :
XpertMon for DB2 UDB ??? ????? ????? ? DB2 ??? ??? ???????
DB2 UDB ???? ? XpertMon for DB2 UDB ???? ? ???? ???? ?? ?ITEG ???.

XpertMon for DB2 UDB? ?? ??? ??? ???? ???? ??? DB2 Know-How? ????
????? DB2 ???? ?? ?? ????? ??? ? ??? ????
DB2 ?? ???? Tool???.
??? ??? ?????? ???? ??? ??? ???? ??? ?? ?????
DB2 UDB? ???? ??? ???? ???, ??? ???? ?????? ????
???? ????? ???? ?????.
????? DB2? ?? XpertMon? ????? ?????? ??? ??? ???
??? ? ????.

???? ? ????? ?? ???? ?? ??? ??? ??, ????? ? ?????
???? ?? ???? ???? ??,?????,???? ????? ???????.


DB2 UDB V8 ? Infinite LOG ??

• LOG Full ??? V7 ????? ?? ??
  
• Infinite Log (????) ?? ? ?? ??
  
• ?? ?? ???(1) - LOG FULL ??
  
• ?? ?? ???(2) - ?? ??? ??
  
• XpertMon ? ???? Logging ????

LOG FULL ??? ?? ??

? ?? ?? ?????? ???? Commit ?? ?? ???? ??? Transaction?? ??
‘LOG FULL’ ??? ??? ??? ??? ????.
DATABASE? ????? ???? ??? LOG? ????? ??? ????? LOG ???
???? ???? LOG FULL ??? ???? ???.

??? ???? ???? ??? ????? ??? ???? ??? ??????
?? ?? ??? LOG ??? ???? ????. ???, ?? ???? ??
?? Application ? ?? LOG ??? ????? ?? ??? ????? ? ? ????.
??? LOG ???? ??? ?? ?? ?? ? ?? ????.
LOG? ??? ?? ??? ??? ????.

??	V 7 (MIN / MAX)	V 8 (MIN / MAX)
???? ?? 1? ?? ??	2/128	2/256
???? ?? 2? ?? ??	0/126	0/254
?? ?? ??	128	256
???? ??	65,535(4KB)	262,144(4KB)
?? ?? ?? ??	32GB	256GB

Infinite LOG (?? ??) ?? ? ?? ??
V8?? LOG? ??? ??? ?? ???? ??? ??? ???? 256GB? ??? ????.
???? ?? LOG ??? 256GB?? ?? ???? ?? Long Transaction? ???? ???
??? ???????
V8?? ??? ???? Infinite ??? ????? ?? ?? ??? ?? ? ? ????.

Infinite LOG ??? ?????? ??? ?? ??????.
?? DB CFG ?? ? userexit ?? ?? ON ???, logsecond ?? ?? -1? ??? ???.
(?? ? ?? ?? ? logsecond ?? ?? ???? ???? userexit ?? ?? ????
???.)
???? ??? ????.

• db2 update db cfg for sample using userexit on
  
• db2 update db cfg for sample using logsecond -1
  

?? ?? ???(1) - LOG FULL ??

??? ??? ???? ??? ??? ??? ???? ?? ?? ??? ??? commit??
Long Transaction? ???? ???? ??? Infinite LOG? ??? ????? ?????
?????.

?? ???? ?? ?? ???? ???????.

• DB? : SAMPLE , TABLE? : EMPLOYEE , ?? : 100? ? ??
  

?? ?? file???? ??? ??? ?? ??? ???? primary logs? ?????.

• db2 update db cfg for samle using logfilsiz 4
  
• db2 update db cfg for sample using logsecond 0
  
• db2 update db cfg for sample using logprimary 256
  
• db2 connect reset
  
• db2 connect to sample
  

?? ????? ?? ?? ?? ??? ????? ??? ?? ??? ????.

• db2 get db cfg for sample |grep “Log”
  

Log file size(4KB) (LOGFILSIZ)=4
Number of primary log files (LOGPRIMARY)=256
Number Of secondary log files (LOGSECOND)=0
User exit for logging enabled (USEREXIT)=OFF

??? ?? !
XpertMon ? DBM/CFG ??? ???? ?? ?? ????? ?? ??? ? ????.


???? ?? ?? SQL? ??? ???. ??? ?? ??? ??? ????.

• db2 update employee set salary=salary +1.0
  

SQL0964C The transaction log for the database is full. SQLSTATE=57011

?? ERROR? ? ??? ????? LOG ??? MAX? ??? ??? ??? ????
?????? LOG ??? ???? ??? ? ?????.

?? ?? ???(2) - ?? ??? ??

? ???? Infinite LOG ??? ???? ?? ??? ?? ?? ?? ??? ??? ????.
?? Primary log ??? 3?? ?????.

• db2 update db cfg for sample using logprimary 3
  

? ?? infinite logging? ??? ? ??? ??? ??? ????.

• db2 update db cfg for sample using userexit on
  
• db2 update db cfg for sample using logsecond -1
  
• db2 connect reset
  

< ???? >
? ??? Archive Logging? ???? ?? ??? ??? ?? ????.
?? Circular Logging? ???? ??? infinite? ???? ?? Archive Logging
???? ??? ? ??? ??? ??? ????.


?? ?? ?? ?? ????? ?? ?? EMPLOYEEE ???? UPDATE ? ???? ???.

• db2 update employee set salary=salary +1.0
  

DB20000I The SQL command completed successfully.
logsecond =-1 ??? Infinite LOG? ??? ???? ??? LOG? ?? ??? ????
?? Active LOG ????? ???? ?? USEREXIT ? ???? Active LOG?
?? ????? Archive ??? Application? ?? ? ? ?? ???.


XpertMon? ???? Logging ????
??, XpertMon? ???? SQL? ????? ???? ???? ?????.


??? ??? ????? ?? Component? ???? ???????.



?? ??? ?? ?? ????? Application? ???? ?? LOG ? ?? ? ? ????.
??? ??? ????? 72? Handle ?? ??? ???, IP ? 200.0.0.109 ????? ???
Application ???.
???? ??? CPU(?) ? system CPU 0.29?, user CPU 1.69????.
Lock ? 3?? held ?? ???, Sort ? ???? ?? ???, ???? ???? Log? ??
20MB ???.

? ? ??? ??? Application? ?????? ? ? ????.


?? 75,351?? Row? ??? ?????, ?? Application? ???? SQL ??? ? ?
????.

---

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