?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
???? DB2 UDB? MSSQL? ?? ? ?? ?????.
?? DB2? MSSQL??? ??? ??? ????, ???? DB2? MSSQL???
OBJECT, SECURITY ??? TOOL? ?? ????? ?????.
Containers, table space? file groups
DB2 UDB??, container ? ???? ????? ??, ????, ???????
???? ????. SQL Server???, 'container' ? ??? ???? ??? ???
???? ?????.
DB2 UDB??, table space ? ???? ???? ???? ???? ??? ????
???????. ???????? ??? ?, ????? ???? ??? ??? ?
????. ??? ??? ?????. ?? ??, ?? "hot"?? ???? ???,
??? ???? ???? ??? ????? ??? ? ????. ??? ????
???? ???? ?? ???? ???. ?? database ? default? ????
Table 3??? ?? 3?? ???????? ?????.
Table 3. database? ??? ? default? ???? DB2 UDB table space
Tablespace ? | Description |
SYSCATSPACE | ?????? ???? Catalog Table space |
TEMPSPACE1 | join? sort ?? ??? ???? System temporary tablespace tablespace ?? ?? ? ????. |
USERSPACE1 | ? tablespace? ???? user table? ?????.Tablespace? table ?? ??? ???? ???? ????. |
Database? ???? unit?? ???, ???????? ?????? ????
???? ????. ?? database???? ???? ??? ? ?? ??
????????? ?? ??? ???????? ??? ? ????.
Figure 2?? ??? ??? ??? ???? MYTBLS? ??? MYDB1 ?
??????? MYTBLS? ??? MYDB2 ? ?? ??? ??????? ?????.
SQL Server? DB2 UDB table space? ??? file group? ????.
Table space? ?????, ? ?? ?? ????????? ?? ??? ?? ???
??? ? ????. Figure 1?? ???? ??? ?? ?? 'MyFileGroup'? ???
MYDB1 ? MYDB2 ? ?? file group?? ????.
DB2 UDB table space? SMS (system-managed spaces) or DMS (database-managed spaces)?
??? ? ????. SMS table space? OS? ?? ???? directory?? ?? ?????.
??? ?? ????? ????? ?? ??? ?? ??? ???.
??? SQL Server? data file? ????? (?? ??? ?? ?).
DMS table space? DB2 UDB? ?? ???? file ?? raw devices? ?? ?????.
DMS table space? ??? ??? ????? ?? ?? ??? ???.
?? ??, ??? ??? ????? ?? ?? ??? table space? ?? ???
?? ???? ???.
???, ???? ??? ??? ???? DB CFG?? ??? ? ????.
Table 4? DB2 UDB databases ?? table space? ?? SQL Server databases map?
?????.
Table 4. DB2 UDB databases ?? table space? ?? SQL Server databases map
SQL Server Database | DB2 UDB database ?? table space |
Master | DB2 UDB??? SYSCATSPACE (catalog table space), ? ??? database level??? ?????. |
model | ??? ??? database/table space? ????; ???, DB2? ?????? ??? ???? 'db2look''??? tool? ????. ??? ??? ??????? ???? ?? ??? ??? ?? ????. |
msdb | ??? ? ???? Tool catalog database, ?? ??? ?? create tools catalog ???? ????? |
Northwind | SAMPLE database |
pubs | SAMPLE database |
tempdb | TEMPSPACE1 table space |
distribution | DB2 UDB? ?? DB2 UDB family? ?? replication ??? ?????. DB2? ?? ?? ????? Replication? Information Integrator ?????? ?????. |
Object ?
SQL Server object?? ??? ?? 4???? ?????.
[SQL Server Instance].[Database Name].[Owner].[object name]
?? ??? ? 3??? ????, ????? ??? ?????? ?? ????
DB2 UDB??, object? ? ??? ??? ?? ????.
Schema?.object?
????? ????? ?? ????? ?????. ????? UserID? ???
?? ?? ????. IMPLICIT_SCHEMA??? ?? UserID? ???? ?? ????
???? ????? ??? ? ????. ?? ??, "Peter" ? IMPLICIT_SCHEMA ???
??? ??? ???? ????? ????:
CREATE TABLE WORLD.TABLEA (lastname char(10))
? ???, WORLD? ??? ???? ?????, ??? WORLD.TABLEA? ?????.
?? Peter? ???? ???? ????, default? connection ID?? ???
PETER.TABLEA? ?????.
DB2 UDB?? ???? ???? ?? ?? database? connection???, ? object ??
object ??? ??? ???? ???? ????.
Tables, views, and indexes
SQL Server? DB2 UDB?? Tables, views, indexes? ?? ????. ??? ? ??
GUI? ??, SQL Server's Enterprise Manager GUI tool? DB2 UDB ????? ????.
Enterprise Manager ? index? ???? ?? ? ?? diagram? ???? ???.
DB2 UDB ????? ?? ?? ?? GUI? ?? index? ??? ? ????.
SQL Server ? ?? user ??????? ??? ??? ???? ??? ??????
???. ??? user ?????? ??? DB2 UDB?? ???? unit???.
???, ? ??, table, view ?? index? ? ?? ?? database? ?? ???
?? ? ????. SQL Server? ?? database ?? table? ??? ?????
DB2 UDB federation? ????? ?????.
Configuration files
SQL Server? ???? ??? ?? ??? ?????? ??? Enterprise Manager
GUI? ?????. Enterprise Manager GUI? ????, ??? ?????? ??
?????? ???? ???? Properties? ???? ?? ??? ?? ???
??? ?????. DB2 UDB??, ?? ????? ???? ??? DBM CFG ???
???? ?????? ??? DB CFG ??? ?????.
????? ????, ??? ?????? ???? ???? Configure Parameters?
????, Figure 7? ? ? ????.
Figure 7. DB2 UDB DBM CFG (instance level)
?? ?????? ????, ??? ??????? ???? ????
Configure Parameters? ???? Figure 8? ?? ?????.
Figure 8. DB CFG (database level)
DB2 UDB? ???? ??? ? ?? ?? ????? ?????. ???, ?????
???? ???? ?? ???, ?? ?? ??? ??? ?? ??? ??? DBM?
DB CFG ????? ??? ? ?? autoconfigure ???? ???? ????.
Figure 9?Configuration Advisor? ?????.
Figure 9. DB2 UDB Configuration Advisor
?? ??? ????, DB2 UDB? platform?? ????? DB2 ?? ??? ?????.
?, db2set ???? ???? ??? ??? ?? ???? ???.
Security
SQL ??? ??? ?? ??, ?, ??? ??? ?????.
?, ??? ? ?? ??? ?????:
- Windows ??.
Windows OS ??? ???ID? ??? ?????. ??? SQL????? ???ID?? ?????.
- Mixed mode ??.
SQL Server? sysxlogin??? ??? ??? ?? ??? ID? ??? ?????.
??? ??, User? SQL ??? ?? ? ?? ??? ?? ??? ?? ??????
??? ? ????. ?? ???? ??? ? ?? ? unit? ???????.
????, ?? ????? ????? ???? ?? ??? ????.
??? ?? ???? ???? ?? ??? ? ????.
??? ?? ???? ? ?? ?????.
DB2 UDB??, User? ??????? ???? ?? ??? OS? ?? ???? ????.
??? OS ??? DB2 UDB? ??? ? ???, ??? DB2 UDB ?? ?? ?? ??
?? ?? ? ? ????. ?? ?? ??? ???? ??? ?? ?? ????
GUI? ?? ?? ? ? ????. ?? ?? ??? OS ?? ?? ??????
????? ?? ?? ??? ????? ???. ?? DB2 UDB?? ??? ???
???? ????. ??? authorities? ??? ?????.
DB2 UDB? MS SQL??? user-defined ?????? ?? ???? ????.
??? OS???? ??? ??? ?????. DB2 UDB?? ???? ???
SYSADM, SYSCTRL, SYSMAINT, DBADM ? LOAD???.
? ?, GRANT SQL?? ???? SYSADM, SYSCTRL? SYSMAINT ??? ??? ? ????.
? ??? ???? DBM CFG???? ?????.
??, SYSADM ??? ?? DB2 UDB ??? sysadmin ?? ?? SQL?? ??? ?????.
DB2 UDB? ?? SQL ??? ???? ??? "privilege"? ??? ?????.
?????? ??(connect, createtab ?)? ?????? ???? ??(schema, table, view?)? ????.
Figure 10? ??????? ? ? ?? DB2 UDB ?? ?????.
? ???? ???? tab? DB2 UDB? ?? ???? ??? ?????.
Figure 10. DB2 UDB ??
Table 5? SQL?? ??? DB2 UDB? ?? ?????.
Table 5. SQL ?? ??? DB2 UDB ?? ??
SQL Server | DB2 UDB/b> |
??? ? ?? ??: Windows ??? Mixed mode ?? | OS???? ?? ???? ??? ? ?? ??;SQL ?? Windows ??? ?????. |
Roles | Authorities |
Permissions | Privileges |
Tools
???? SQL Server? DB2 UDB? ???? ?? ??? ?? ??? ????????.
Figure 11? DB2 UDB ??? ???? ????.
Figure 11. DB2 UDB ??
Using the command line
?? CLI? ?????, SQL ??? iSQL ????? ????,
DB2 UDB? command line processor (CLP)? ?????.
Figure 12? DB2 UDB CLP ???????. ??? command prompt window ??
db2cmd ???? ?? command window? ????. ??? CLP? ???? ?? ????
DB2 ???????.
Figure 12. DB2 UDB CLP (Command Line Processor)
SQL ??? DB2 UDB ? ? CLI? GUI?? ?????. SQL??? Query Analyzer ?
????. DB2 UDB? Figure 13??? ?? ????? ?????.
Figure 13. DB2 UDB ????
??
? ??? DB2 UDB V8 for Linux, Windows/ UNIX? MS SQL?? 2000? ?? ????.
SQL Server? Windows ?????? ????, DB2 UDB? Linux /UNIX ?????
??? ? ????. ???, ? ??? ????? Windows ???? ???? ???
? ??? GUI?? ???? ?? ??? ??? ????.
?????, SQL ??? DB2 UDB ??? ?? figures 14? 15????
SQL?? Enterprise Manager ? DB2 UDB ????? ??? ?????? ?????
??? ??? ???.
Figure 14. The MS SQL ?? Enterprise Manager
Figure 15. The DB2 UDB ????
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