?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? 2?? ??? DB2 UDB? MSSQL? ??? ????? ?????.
?? ? ??? ???? ?? ????, ??? DB2? MSSQL??? ??? ?????,
??? DB2? MSSQL??? OBJECT??? ? ????.
???? DB2? MSSQL??? ??? ????/?? ??, ??? database? ??
????? ?????.

---

DB2 UDB Version 8? ??? ?? Microsoft SQL Server 2000??

??
? ????? DB2 UDB for Linux, UNIX, and Windows Version 8? ??? ???
???? ?? MS SQL Server 2000? ??? ???? ??? ????.
?? Microsoft SQL Server 2000 ? 'SQL ??'?? ??
DB2 UDB for Linux, UNIX, and Windows Version 8 ? 'DB2 UDB' ?? ? ????.
?, ? ??? ???? ??? ??????

SQL ??? DB2 UDB? ? ?? ??? ???? SQL??? Windows(INTEL) ??????
????, DB2 UDB? Linux, Unix, Windows? ??? ???? ?????? ?????
????.
???, DB2 UDB ??? ISerise(AS 400)? Z/OS?? ?????.
ISerise? Z/OS DB2 UDB ???? ?? ??? ?? ?? ???? ?????
??? ?? ??? DB2 UDB for Linux, UNIX, and Windows? ?? ?? ???? ????.
??? ????? DB2 UDB Family?? ?? ?????.

??? ?? ??
?? Figure 1? ?? SQL Server ???? Figure 2? DB2 UDB? ?? ?????.
???? ? ??? ?? ?? ??? ??? ? ????.

Figure 1. Microsoft SQL Server 2000 ??

Figure 2. Linux, UNIX, and Windows Version 8? DB2 UDB ??? ??

????? ??
DB2 UDB? "????"? ??? SQL ?? ??? ?? ???? ??? "??"? ?????.
?????, ??? ????? ???? "??" ?? ????. ? ? ?? ????,
????? DB ????? ??? ? ?? ???? ??? ?????.
??? ???????? ? ?????? ?????.
????? shared-nothing ??? ????. ??? ??? ????????
?????? ?? ????? ????? ???????. Figures 1? 2?
PROD? DEV ????? ????? ? ?? ??? ??? ?????.
????? ??? ? ?? ???? ???? ???? ??? ??? ????.
SQL??? "default" ????(only one) ? named ????? ????.
default ????? SQL Server? ?? ???? ? ??? ?????? ?????
?? ?????. named insta????? default ?????? ??? ???????.
??? ?? ???? ?????. computer_nameinstance_name.

?? ????? ?? ? SQL ??? named ????? ?????, ? ??? ?????
?? ??CD? ???? ???. ??? ?? ??? install GUI ? ?????.
?, ? ??? ?? ?? Path? ?????? ????? ??? ??? SQL?? ???
???? ????. ?? ?? ??? ???? ??? ???? ????.
?? ????? ???? ???? install GUI? ????? ???.

DB2 UDB ???, Windows ???? ??? ??? ??, 'DB2' ?? ?????
default? ?????. Linux? UNIX??? 'db2inst1'???. ?? ????
?? ????? ???? ???? db2icrt ?? ????
?? ??? ???. ??? ?? ???? ?? ?? DB2 UDB ????? ?? ? ???
??? ???.

Figure 3? ????? ?? default DB2 UDB ???? "DB2" ? db2icrt ????
??? ? ?? ????? ?????.

Figure 3. DB2 UDB Control Center GUI showing DB2 UDB instances

CLP??? ??? DB2 UDB instance? ???? ?? DB2INSTANCE ????? ?????.
? ??? ?? ?? ???? ???? ???? ????? ?????.
?? ??, ?? DB2INSTANCE ? PROD??, ??? create database MYDB1 ????
????, MYDB1? ???? PROD? ???? ??? ????.
?? DB2 ????? DB? ???? ????, ?? DB2INSTANCE ?? DB2? ?? ??
DB? ???? ?? ????. ????? ?? ?? ?? ?? ??? figure 3??
???? ??? DB2 UDB ???? GUI? ???? ?? ????.

Windows?? DB2 UDB ????? ???? ???? service? ?????? ??
???? ?????. db2idrop ???? DB2? ??? ? ????.
? ???? DB2 UDB ??? ????? ????. ??? Windows? ????,
????? ??? Windows ???? ?????

????, SQL ??? DB2 UDB? ????? ????? ????.
?? ?? SQL??? ????? SQL?? ??? ???? DB2 UDB? ??? ??? ??
SQL??? GUI?? ????? ??? ? ?? DB2 UDB? GUI? ????? ?? ? ?
??? ????.

Windows services
DB2 UDB? ?? Windows services? ?? Table 1? ????.
Table 1. DB2 UDB Windows services

Service ?	Description
DB2 - instance ?	??? ??? ????? ?????. ??? ?? SQL?? database? ?????. DB2? ?? ???? ????? ?? ???? database? ?? ???? ??? ? ????. ??? ? ?? ???? ?????. ?? ???? ???? ???, ? ??? ?? ???? ????.
DB2 Governor	DB2 databases? ??? application? ??? ???? monitor?? ?? ??? ?????. ?? ??, ? ?? ??? ?? ?? ???? ??? ??, ? ??? ???? application? force????
DB2 JDBC Applet Server	JDBC type 3 driver? ???? DB2 application? ???? JDBC Server? ?????.
DB2 License Server	DB2 license ???? ????.
DB2 Remote Command Server	?? ???? ?? inter-partition ??.
DB2 Security Server	DB2 database ??? client computer?? ??? ?? ?? ??
DB2DAS - DB2DAS00	DB2 ?? ?????. Local? remote database ??? ?????. ????? DB2 ????? DB2DAS00???. ? ??? jobs, alerts?? ???? catalog database ?? ?????.

Figure 4? DB2 ????? DB2 UDB Windows ???? ?????.
??? PROD ? DEV ????? db2icrt ???? ?????.

Figure 4. DB2 UDB Windows services
???? DB2 UDB? ???? Windows service? ?????, SQL Server??? ??
???? ??? ???. ?? Table 2? ??.
Table 2. SQL Server Windows services? DB2 UDB Windows services? ??

SQL Server Service	DB2 UDB Windows Service
MSSQLServer service. ? ????default SQL Server ????? ??	DB2 - DB2-0 service. ? ???? default instance 'DB2'? ??
MSSQL	DB2 -
SQLServerAgent	DB2DAS - DB2DAS00. ? service? DB2 ?? Server (DAS)* ? ??
SQLAgent	DB2DAS-DB2DAS00. ? service? DB2 ?? Server (DAS)* ? ??
Microsoft ?? ????Coordinator (MS DTC)	Sync Point Manager (SPM) ? ??? UOW? ?? DB CFG ???? SPM_NAME? DBM? sync point manager instance?? ??.
Microsoft Search	DB2 UDB Windows service? ???? ?? ??; ???, Net Search Extender software? ??

* DAS? DB2 machine? ?????.

Databases
SQL Server??, Figure 1? ?? ????? ?? ?? database? ??? ? ????.
? database? ???? unit??? ??user database? metadata? master database?
?????. ????, ??? ?? ? ?? database? ???? access ?????.
Instance? ??? ? tempdb, master, model, Northwind ?? ?? ?? database?
default? ?????.

SQL Server? metadata? ????? ? ??? ?????:
???? ??? (master database? ?? system table? ????),
?????? ??(user database ??? system table? ????).
master? tempdb? ????? ?? database??? ?????. View? ?? ??????
user database? ??? ? default? ?????
DB2 UDB??, ????? Figure 2???? ?? ?? database? ??? ? ????.
???database? ??? ???? unit???. ? database? ??? catalog table
space (metadata? ????), temporary table space? user table space? ??? ????.
SQL Server? master database ?? metadata ??? ???? database? ????.
??, SQL Server? tempdb?? ?? ???? ???? ?? database? ????.
DB2 UDB? DB2 ??? ??? ? ?? ?? database? ???? system database
directory ?? ???? ??? ???? ????. ? ????? instance level??
?????. Figure 2 ? DB2 UDB? ? database? ???? ?????. ???, SQL Server?
???? ? database? ??? ???? ??? ??? ?? ?? ?????.
instance? ??? ? default? ???? database? ????. create database ????
database? ????? ???. Figures 5,6??? ?? ????? ?? ???????
??? ?? ????.

Figure 5. ???? GUI? ???? DB2 UDB database ??

Figure 6. ???? GUI? ???? DB2 UDB database ?? (continued)
Figure 6??, Show Command? ??? ? ?? ?? ????? ? ? ????.
?? DB2 UDB ????GUI ??? ????? ??????? ???? SQL ? ??
???? ?????. ? ???? ?? ?? ??? ??? ?? ????? ??? ?
?? Command Line Processor (CLP) tool?? ????GUI tool??? ????
??? ? ????. ? ??? ?? SQL ??? iSQL? Query Analyzer? ?????.

Database??? ????? ?? ??? ?? ????. ??? ?? application?
?? ??? ???? federation ??? ???? ???. federation? ?? ???
resources section?? ??? ???.

---

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