?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? ??? ????? Locking , ????? ??? ????? ?????.
?? ??? ??? ?? ????.

---

Memory Architecture? background processes

???? ?????? ????? ????? ????, Oracle? DB2?? ?? ??
??? ????????.

??. 9 Oracle Memory Architecture and Background Process

Oracle? System Global Area(SGA)? ????? ??? ???? ????? ???
?????. SGA?? statement cache, redo log buffers, data buffer cache ??
????. Program Global Area(PGA)? User Global Area(UGA)? ?? ?????
??? ??? ?? ???? ?? ??? ?? ????.
Oracle? ?? ???? ?? ????? ????? ????? ????? ????
????. ?? ????, 3?? ????? ?? ????? 3 ??? ?????
????? ?????. ???, ????? ? ??? ??? ??????, ???
???? ??? ?? ?? ???? ??? ?? ?? ?????.

??. 10 DB2 UDB Memory Architecture and background processes

DB2? Oracle ?? ????? ??? ?????, DB2? ??? ??? Oracle? ??
????. DB2? ????? ?? ?? ??????? ?? ? ?? ???, ? ???
??? ?????. ??? ?????, DBM CFG ??? ?? ???? ??? ???
DB CFG ??? ?? ?????? ??? ??? ?????. ???? ? ??????
??? ?? ????? ?? ??? ??? ??? ? ????. ?? ??? DB2
??? ??? ?? ????? ????? ??? ????.

Oracle? startup ? ? ????? ??????? ???? ???? ??? ??,
DB2? ?? ??? ???? ?????. ??? DB2? ? ????? ?? ??
??????? ?? ? ?? ? ?????. DB2 ?? ??? ?? ??? ??? ????.

• ???? ?? ??? : db2start ???? ????? ???? db2stop ???? ????? ??? ??? ???? database manager ?? ?? ???
• ?????? ?? ??? : ??????? ??? ??? ??? ??? ? ???? ?????? ?? ???. ???? ????? bufferpool, locklist, database heap, utility heap, package cache, catalog cache ?? ????.
• ?????? ?? ??? : ??????? ??????? ??? ? ????, ?????? ??? ???? ?? agent? ???? ???. ??????? ??? ??????? ?? ??? ???? ????. ??? ?????? ?? ???? ??? ?? ????? ??? ???? ?? ?????.

??? ????? DB2? ?? ??? Linux? UNIX ????? ????? ?????
???? ?? ?? ???? ?????. DB2 ????? ??? ?? ?????.

• ???? ?? : ??? ????? ????? ??? ? ?????.
  1. DB2 Daemon Spawner (db2gds) : ??? ????? ?? ???? global daemon processor (UNIX ??)
  2. DB2 System Controller (db2sysc) : Main DB2 process
  3. DB2 Watchdog (db2wdog) : ?? ?? ????? ?? ????
  4. DB2 Format Log (db2fmtlg) : Oracle? ARCn ? ??. ?? ??? ????? ?? ????.
  
  
• ?????? ?? : ??? ????? ??????? ??? ??? ? ? ?????.
  1. DB2 Log Reader (db2loggr) : Oracle? PMON ????? subset ? ??. ? ????? ???? ??, ???? ? ??? ????.
  2. DB2 Log Writer (db2logw) : ????? ???? ???? ????? ???. Oracle? LGWR? ????.
  3. DB2 Page Cleaner (db2pclnr) : Oracle? DBWR? ????. ? ????? ???? ??? ?? ?? ???? ?? ?? ?? ??? ????.
  4. DB2 Prefetcher (db2pfchr) : ???? ???? ?? ????? ???? ??? ??? ?????.
  5. DB2 Deadlock Detector (db2dlock) : deadlock? ?????.
  
  
• ?????? ?? : ??????? ??? ??? ??????? ??? ?????? ??? ????? ????? ??? ????.
  1. DB2 Communication Manager (db2ipccm) : ??? ?? ?? ?????? ?? inter-process ?? ????
  2. DB2 TCP Manager (db2tcpcm) : TCP/IP? ?? ??? ??? ?????? ?? TCP ?? ?? ????
  3. DB2 Coordinating Agent (db2agent) : ???????? ???? ?? ??? ???? ????
  4. DB2 Subagent (db2agnta) : Idle subagent
  5. Active Subagent (db2agentp) : SMP parallelism? ??? ?? ? ??? ?? ?? ????? ??? ? ???? subagent ? ???? ????

Locking Mechanism
Oracle ??? lock? ??, ?? ?? ?????. Oracle Lock Manager ? ?????
??? ???? ?? row ?? lock? ???, ?? SQL ?? ???? ??????
????? ?? lock? ? ? ????.

1. SET TRANSACTION ISOLATION LEVEL
2. LOCK TABLE
3. SELECT FOR UPDATE

Oracle? undo segment? undo data? ???? Multi Version Read Consistency
????? ?????.

DB2 ? Uncommitted Read, Cursor Stability, Read Stability, Repeatable Read ??
ANSI ?? isolation level? ?????. Uncommitted Read? ???? ???,
???? commit ? ??? ?? ? ? ????. Isolation level? ?? row lock?
????? ????. ???????? lock? ? ? ?? ????? ??? ????,
???, row ? ??? ???? ??? ?????? ????? lock ? ? ? ????.

LOCK TABLE ???? ???? ?? row lock ?? ???? lock? ? ? ????.
Oracle? ?? DB2??? lock? ??? ???? ?? ???? ?????.
LOCKLIST ?????? ?? ????? lock? ?? ??? ???? ?????
????, MAXLOCKS ?? ????? ?? ??????? lock? ?? ??? ??
????? ????? ?????.

Security
Oracle ? DB2 ?? ?? ? ?? ?? ??? ?? ??????? ?????.
Oracle?? ??? ?? 4?? ??? ????? ????.

• Database : ??????? ??? ?? ? ??? ?????.
• External : OS? ???? ???? ??? ??? ?????.
• Global Authentication and Authorization : SSL? ?? ????? ???? ?????.
• Proxy Authentication and Authorization : middle-tire ??? ??? ?????.

?? ??? CRAETE USER ???? ???? ???? ??? ? ?????.
???? ?? ??? ?? ?? Data Dictionary ?? ????.

DB2??? ???? ?????? ?? ???? ?? OS? ?? ?????.
?????? ??? ??? ?????? ???? ???? ?? ????.
OS ??? ???? DB2? ??? ? ??? DB2? authority? privilege? ?? ??
??? ? ? ?? ? ? ?? ????. ??? ???? ???? ?? ?????
?? ???? ??? ? ????. ?? OS? ???? ???? ????? ?????.

DB2?? "role"??? ??? ??, ??? Oracle? role? ??? "authority"??
??? ?????, ?? ?? ???? ????? ???? ??? ? ????.

DB2? ???? authority? SYSADM, SYSCTRL, SYSMAINT, DBADM, LOAD? ????.
SYSADM, SYSCTRL, SYSMAINT authority ? GRANT ??? ??? ? ????.
? ?? authority? database manager configuration file? ???? ??? ????
??? ? ????.
DB2?? Oracle? ??? ? ??? ????? privilege? ??? privilege??
??? ?????. ?????? privilege(connect, createtab ?) ? ??????
???? privilege(schema , table , view ?) ????.
??. 11??? XpertMon? SQL Runner ??? ?? DB2? ????? ?? ?? ?????.
SYSCAT.****AUTH? ???? ? ????? ?? ??? ?? ? ? ????.

??. 11 DB2 UDB Security
Privilege? authority?? ?? ?????? ??? ??? ??? ????.
DB2? Oracle? ???? ???? ??? ???? ??? ????.
User Authentication and Authorization
Oracle? ???? ??? ? ????? ????? dictionary? ???? ?????.
DB2? ??? ??? ????? ????, ???? ???? ??? ?????.
Oracle? DB2 ?? LDAP? ?????.
(Oracle Internet Directory? IBM Directory Server) Oracle? DB2 ?? single sign in(SSO)? ?????.
Data Encryption
Oracle ? ???? ??? ???? ??? ??? ???? ??? ???? ??
???? ?????.
DB2? ?? ??? ??? ???? ?????.

Network Encryption
Oracle? Oracle Advanced Security ? ?? ???? ???? ?????.
Oracle? DES, 3DES ??? RC4 industry standard encryption? ?????.
DB2? ???? ???? ????? ????? ????. ??? Tivoli SecureWay??
???? ??? ?? ???? ???? ?????.

Audit Trail
Oracle? ???? ????? ?? audit trail? ?????.
Log miner ?? ???? ??? ?? ??? ??? ???? ???.
DB2? ??? ??? ?? ?? ??? ?????. db2audit ????? ??? ???
?????.

Tools
?????? ?? ? ??, ????, ?? GUI, ???? ??, ??? ?? ?
?? -?? ? ? ?? ?? ???????. ??.12 ? DB2 GUI ??? ??? ????.

??. 12 DB2 GUI Tools Oracle? DB2 ?? ?? ??? ??? ????? ???????.

Database Creation and Maintenance
Oracle ? ?????? ??? ?? GUI? Database Configuration Assistant(dbca)?,
?????? ??? ???? Oracle Enterprise Manager? ?????.
DB2? ????? ??????? ???? ??? ? ????.

Network
Oracle? ???? ??? ?? ?? Network Configuration Assistant(netca)?
?????. ? ?? ???? ???, Oracle Network Manager? ???? service naming,
listener, profile , Oracle name server ?? ?? ? ? ????. DB2??? CATALOG
??? ?? ??? ??????? ???? ? ? ????. ???? ???
?? ??? DB2 UDB Configuration Assistant GUI? ?? ??? ? ????.

Administration
Oracle Enterprise Manager? ???? ?? ??? ??? ??? ??? ?????.
DB2 ????? Oracle Enterprise Manager? ??? ??? ?????.
DB2 ?????? ??? ??? ????? DDL? DML ??? ??? ? ????.
??? ???? Oracle? SQL*PLUS ????? ?????.
??.13? DB2 UDB ??? ??????.

??.13 DB2 UDB Command Line Processor
??.14? ?? SQL Runner? ???? SQL?? ??? ? ????.
??. 14 XpertMon SQL Runner
Performance Tuning
Oracle Enterprise Manager? Change Management Pack, Tuning Pack, Diagnostic Pack?
???? ??? ?? ?????. DB2 ??? ???? ??? ?? GUI ??
Event Analyzer, Health Center, Indoubt Transaction Manager, Memory Visualizer? ?????.

Data movement
Oracle? delimited text ??? ???? ???? ?? SQL Loader(sqlldr)? ?????.
??? import? export? ????? ??? import(imp) ? export(exp)? ?????.
DB2? Oracle ? ??? import, export, load ????? ?????. ? ??? ??
????? ??? ??? ??? DB2? db2move ????? ?????.

Backup and Recovery
Oracle hot ??? ?? ???? Recovery Manager? ?????.
DB2??? backup ???? ????? ??? ??? ??? ? ????.

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

Oracle	DB2 UDB	??
Instance	Instance	DB2? ? ????? ?? ??????? ??? ? ??.
Database	Database
initSID.ora ?? SPFILE	DBM CFG ? DB CFG	DB2 ? 2??? ??? ???? - Database manager Configuration (DBM CFG - ???? ??) ? Database Configuration (DB CFG - ?????? ??). ?? ?? ?????? Oracle???? ???? ?? ????.
Table space	Table space	DB2? SMS ? DMS ??? ????. DMS ??? ????? Oracle? ??? ????? ????.
Data Block	Page	DB2? 4K, 8K, 16K, 32K ???? ????. 1 row? ??? ? ??? ?? ??? ? ??? ??. DB2??? 1 row? ??? Oracle???? ?? ???? ??? ??? ? ??.
Extent	Extent
Data File	DMS Table space Container	DMS ??? ????? ????? ???? raw device? ??? ? ??.
Redo Log File	Transaction Log File
Data Buffer	Buffer pool	DB2? ??? ??? ?? ? ?? ??, ??? ?? ??? ? ??. ?? ??? ??? ??? ????? ???? ?? ?? ??? ??? ?? ?? ?? ???? ??.
SGA	Database Manager ? Database Shared memory
Data Dictionary	Catalog
Library cache	Package cache
Large Pool	Utility Heap
Data Dictionary Cache	Catalog cache
SYSTEM table space	SYSCATSPACE table space

?.3 Summary of Oracle vs. DB2 UDB concepts

---

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