DB2 Data Links Manager ºü¸¥ ½ÃÀÛ
db2setup À¯Æ¿¸®Æ¼´Â UNIX ±â¹Ý ¿î¿µ üÁ¦¿¡ ¸ðµç DB2 Á¦Ç°À» ¼³Ä¡ÇÏ´Â ±ÇÀå ¹æ¹ýÀÔ´Ï´Ù.
ÀÌ À¯Æ¿¸®Æ¼´Â DB2 Data Links Manager ¼³Ä¡¿¡ ÇÊ¿äÇÑ ¸ðµç Ÿ½ºÅ©¸¦ ¼öÇàÇÒ ¼ö ÀÖ½À´Ï´Ù.
db2setup À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÏÁö ¾ÊÀ¸·Á¸é SMITÀ» »ç¿ëÇÑ DB2 Data Links Manager ¼öµ¿ ¼³Ä¡¿¡¼ ÀÚ¼¼ÇÑ
³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
db2setup À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÏ¿© DB2 Data Links Manager¸¦ ¼³Ä¡ ¹× ±¸¼ºÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- ·çÆ® ±ÇÇÑÀ» °¡Áø »ç¿ëÀÚ·Î ·Î±×ÀÎÇϽʽÿÀ. DCE-DFS ȯ°æ¿¡¼, DLMADMINÀ¸·Î¼
dce_loginµµ ÇÊ¿äÇÕ´Ï´Ù.
- Á¦Ç° CD-ROMÀ» »ðÀÔÇÏ°í ¸¶¿îÆ®ÇϽʽÿÀ.
- cd /cdrom ¸í·ÉÀ» ÀÔ·ÂÇÏ¿©
CD-ROMÀÌ ¸¶¿îÆ®µÈ µð·ºÅ丮·Î º¯°æÇϽʽÿÀ. ¿©±â¼ cdromÀº Á¦Ç° CD-ROMÀÇ ¸¶¿îÆ® ÁöÁ¡ÀÔ´Ï´Ù.
- ./db2setup ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ. 3-4ºÐÀÌ Áö³ª¸é
DB2 ¼³Ä¡ À¯Æ¿¸®Æ¼ âÀÌ ¿¸³´Ï´Ù. ȸéÀÇ Áö½Ã¸¦ µû¶ó ¼³Ä¡ ÇÁ·Î¼¼½º¸¦ ½ÃÀÛÇϽʽÿÀ.
db2setup À¯Æ¿¸®Æ¼´Â /tmp/db2setup.log¿¡¼ ÀÚµ¿À¸·Î
¼³Ä¡ ·Î±×¸¦ »ý¼ºÇÕ´Ï´Ù. ¼³Ä¡ ¿À·ù¸¦ º¸´Ù »ó¼¼È÷ ±â·ÏÇϱâ À§ÇÑ ÃßÀû ÆÄÀÏÀ» »ý¼ºÇÏ·Á¸é
./db2setup -d ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ. ÀÌ ¸í·ÉÀº
/tmp/db2setup.trc¿¡ ÃßÀû ÆÄÀÏÀ» »ý¼ºÇÕ´Ï´Ù.
- »ç¿ë°¡´ÉÇÑ ¿É¼Ç ¹× ÇÊµå »çÀ̸¦ À̵¿ÇÏ·Á¸é Tab
۸¦ ´©¸£½Ê½Ã¿À. ¿É¼ÇÀ» ¼±ÅÃÇϰųª ¼±Åà Ãë¼ÒÇÏ·Á¸é
Enter ۸¦ ´©¸£½Ê½Ã¿À. ¼±ÅÃµÈ ¿É¼ÇÀº º°Ç¥·Î
Ç¥½ÃµË´Ï´Ù.
DB2 Á¦Ç°À» ¼³Ä¡Çϱâ·Î ¼±ÅÃÇÒ ¶§ Á¦Ç°ÀÇ »ç¿ëÀÚ Á¤ÀÇ
¿É¼ÇÀ» ¼±ÅÃÇÏ¿© ¼³Ä¡µÉ ¼±ÅÃÀû ±¸¼º¿ä¼Ò¸¦ º¸°í º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.
DCE-DFS ȯ°æ¿¡¼ ¼³Ä¡ÇÒ °æ¿ì ¼¿ÀÇ ÇÑ ³ëµå¿¡´Â DLFM_DB°¡ Æ÷ÇԵǰí DB2 ¼¹ö·Î¼
¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù. Data Links Manager°¡ ¼³Ä¡µÈ ´Ù¸¥ ¸ðµç ³ëµå´Â DLFM_DB¿¡ ´ëÇÑ
DB2 Ŭ¶óÀÌ¾ðÆ®·Î¼ ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.
¼³Ä¡°¡ ¿Ï·áµÇ°í db2setup À¯Æ¿¸®Æ¼¿¡¼ ³ª°¡±â Àü¿¡,
·Î±× º¸±â¸¦ ¼±ÅÃÇÏ¿© ¼³Ä¡ ÇÁ·Î¼¼½º¸¦ ´Ù½Ã º¼ ¼ö
ÀÖ½À´Ï´Ù. º¸´Ù »ó¼¼ÇÑ ³»¿ëÀº /tmp/db2setup.log ÆÄÀÏ¿¡¼
º¼ ¼öµµ ÀÖ½À´Ï´Ù. ./db2setup -d ¸í·ÉÀ» »ç¿ëÇÏ¿© ¼³Ä¡
¿À·ù¸¦ ĸÃÄÇÑ °æ¿ì, /tmp/db2setup.trc¿¡¼ ÃßÀû ·Î±×¸¦
º¼ ¼ö ÀÖ½À´Ï´Ù.
´ÙÀ½°ú °°Àº Á¶Ä¡°¡ db2setup À¯Æ¿¸®Æ¼¿¡ ÀÇÇØ ¼öÇàµË´Ï´Ù.
- ¼³Ä¡ µð·ºÅ丮
-
DB2 Data Links Manager ¹× DB2 Universal Database´Â /usr/lpp/db2_07_01 µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù. DB2 Data Links Manager´Â DB2 UDB¸¦ »ç¿ëÇÏ¿© ¸µÅ©µÈ
ÆÄÀÏ¿¡ ´ëÇÑ ·Î±×µÈ Á¤º¸¸¦ À¯Áöº¸¼öÇÕ´Ï´Ù.
- ±×·ì ¹× »ç¿ëÀÚ ID
- ¼³Ä¡ Áß¿¡ ¼±ÅÃÇÑ °æ¿ì, DLMADMIN(DB2 Data Links Manager °ü¸®ÀÚ)¿¡ ´ëÇØ ±×·ì ID(gid) ¹× »ç¿ëÀÚ
ID(uid)°¡ ÀÛ¼ºµË´Ï´Ù. DCE-DFS ȯ°æ¿¡¼, uid, user name, gid ¹× ±×·ì À̸§ÀÌ
DLMADMIN¿¡ ´ëÇØ ÀÛ¼ºµÈ DCE ½Äº°ÀÚ¿Í ÀÏÄ¡ÇÏ´ÂÁö È®ÀÎÇϽʽÿÀ.
- ÀνºÅϽº ÀÛ¼º
- Data Link File Manager¿¡ ´ëÇÑ ÀνºÅϽº°¡ ÀÛ¼ºµË´Ï´Ù. ±âº» ±×·ì ¹× »ç¿ëÀÚ
ID¿Í ¿¬°üµÈ ±âº» ÀνºÅϽº¸¦ DLFMÀ̶ó°í ÇÕ´Ï´Ù.
- ·¹Áö½ºÆ®¸® º¯¼ö
- ´ÙÀ½°ú °°Àº ·¹Áö½ºÆ®¸® º¯¼ö°¡ ¼³Á¤µÇ¾î ÀÖ½À´Ï´Ù.
DLFM_PORT=port_number
DLFM_LOG_LEVEL=LOG_ERR
DB2_RR_TO_RS=ON
DB2_HASH_JOIN=ON
DLFM_INSTALL_PATH=$HOME/sqllib/bin
DLFM_INSTANCE_NAME=instance_name
DB2INSTANCE=DLFM_INSTANCE_NAME
DLFM_BACKUP_DIR_NAME=$HOME/dlfmbackup //JFS only
DLFM_BACKUP_DIR_NAME=/:/dlfmbackup //DCE-DFS only
DLFM_BACKUP_TARGET=LOCAL
DLFM_FS_ENVIRONMENT=file_system
¿©±â¼,
- port_number´Â Data Links File Manager¿¡ ´ëÇØ ¿¹¾àµÈ Æ÷Æ® ¹øÈ£ÀÔ´Ï´Ù.
- instance_nameÀº Data Links File Manager ÀνºÅϽº À̸§ÀÔ´Ï´Ù.
- file_systemÀº DCE-DFS ȯ°æ¿¡¼´Â DFS, JFS ȯ°æ¿¡¼´Â NATIVEÀÔ´Ï´Ù.
±âº» ¼³Á¤Àº NATIVEÀÔ´Ï´Ù.
- PATH º¯¼ö
- ´ÙÀ½ º¯¼ö´Â DB2 Data Links Manager °ü¸®ÀÚÀÇ db2profile ¶Ç´Â db2cshrc
½ºÅ©¸³Æ® ÆÄÀÏ¿¡ ¼³Á¤µË´Ï´Ù.
(bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì)
export PATH=$PATH:$HOME/sqllib/bin:$HOME/sqllib/adm:$HOME/sqllib/misc
(C ½©ÀÇ °æ¿ì)
setenv PATH=${PATH}:${HOME}/sqllib/bin:${HOME}/sqllib/adm:${HOME}/sqllib/misc
ÀÌ »ç¿ëÀÚ°¡ ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇÒ ¶§¸¶´Ù DB2 Data Links Manager °ü¸®ÀÚÀÇ db2profile ¶Ç´Â
db2cshrc ½ºÅ©¸³Æ® ÆÄÀÏÀ» ¼öÇàÇÏ·Á¸é, ´ÙÀ½ Ç׸ñÀ»
DB2 Data Links Manager °ü¸®ÀÚÀÇ .profile ½ºÅ©¸³Æ® ÆÄÀÏ¿¡ Ãß°¡ÇϽʽÿÀ.
. INSTHOME/sqllib/db2profile (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì)
source INSTHOME/sqllib db2cshrc (C ½©ÀÇ °æ¿ì)
¿©±â¼ INSTHOMEÀº DB2 Data Links Manager °ü¸®ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.
- °¡»ó ÆÄÀÏ ½Ã½ºÅÛ ¹øÈ£
- JFS ȯ°æ¿¡¼, ´ÙÀ½ Ç׸ñÀÌ /etc/vfs ÆÄÀÏ¿¡
Ãß°¡µË´Ï´Ù.
dlfs 12 /usr/lpp/db2_07_01/bin/dlfs_mnthlp /usr/lpp/db2_07_01/bin/dlfs_fshelper
vfs ¹øÈ£ 12°¡ ÀÌ¹Ì »ç¿ë ÁßÀÎ °æ¿ì, db2setup À¯Æ¿¸®Æ¼´Â °¡»ó ÆÄÀÏ
½Ã½ºÅÛ(VFS)ÀÌ »ç¿ëÇÒ 8-15 »çÀÌÀÇ ¼·Î ´Ù¸¥ ¹øÈ£¸¦ ÁöÁ¤ÇÕ´Ï´Ù.
- DB2 µ¥ÀÌÅͺ£À̽º DLFM_DB ÀÛ¼º
- DCE-DFS ȯ°æ¿¡¼, DLFM_DB µ¥ÀÌÅͺ£À̽º´Â DLFM ¼¹ö ³ëµå¿¡
ÀÛ¼ºµÇÁö ¾Ê¾ÒÀ¸¸ç ¼³Ä¡ ÈÄ ´Ü°è·Î ¼öÇàµÇ¾î¾ß ÇÕ´Ï´Ù.
DLFM Ŭ¶óÀÌ¾ðÆ® ³ëµå¿¡¼, DLFM_DB·ÎÀÇ ¿ø°Ý µ¥ÀÌÅͺ£À̽º īŻ·Î±× Ç׸ñÀÌ ÀÛ¼ºµË´Ï´Ù.
JFS ȯ°æ¿¡¼, DB2 DataLinks Manager°¡ Æ÷ÇÔµÈ ³ëµå¿¡¼ DLFM_DB µ¥ÀÌÅͺ£À̽º°¡
ÀÛ¼ºµË´Ï´Ù.
- DMAPP¿¡ ´ëÇÑ DCE-DFS »çÀü ½ÃÀÛ µî·Ï
- DCE-DFS ȯ°æ¿¡¼, µ¥ÀÌÅÍ °ü¸® ÀÀ¿ëÇÁ·Î±×·¥(DMAPP)ÀÌ ¼³Ä¡µË´Ï´Ù. ÀÌ DMAPP´Â
ÆÄÀÏ À̸§ ¹Ù²Ù±â ¹× »èÁ¦¸¦ ¹æÁöÇÕ´Ï´Ù. DB2 Data Links Manager´Â DMAPP°¡ ½ÃÀÛ ¹×
¼öÇà ÁßÀÎ °æ¿ì¿¡¸¸ ½ÃÀ۵Ǹç, DMAPP´Â DFS ½ÃÀÛ °úÁ¤ÀÇ ÀϺημ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
ÀÌ´Â DFS »çÀü ½ÃÀÛ ½ºÅ©¸³Æ®¸¦ ¼³Ä¡ÇÏ¿© ¼öÇàµË´Ï´Ù. db2setup À¯Æ¿¸®Æ¼´Â ´ÙÀ½ Á¶Ä¡¸¦
¼öÇàÇÏ¿© À̸¦ ¼öÇàÇÕ´Ï´Ù.
- db2setup À¯Æ¿¸®Æ¼´Â /opt/dcelocal/tcl/user_cmd.tclÀÌ
Á¸Àç ¿©ºÎ¸¦ È®ÀÎÇÕ´Ï´Ù. ¾ø´Â °æ¿ì db2setup À¯Æ¿¸®Æ¼°¡ ÀÛ¼ºÇÕ´Ï´Ù.
- DFS°¡ ½ÃÀ۵Ǹé DMAPP°¡ ½ÃÀ۵ǵµ·Ï
/opt/dcelocal/tcl/user_cmd.tcl¿¡ ¸í·ÉÀÌ
Ãß°¡µË´Ï´Ù.
- $HOME/sqllib/adm/dlfsdmap_prestart.dfs·ÎºÎÅÍ
/usr/bin/dlfsdmap_prestart.dfs·ÎÀÇ ¸µÅ©°¡ ÀÛ¼ºµË´Ï´Ù.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]