ÀÌÀü¿¡ DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Á¤ÀÇµÈ ¿ø°Ý DB2 UDB µ¥ÀÌÅͺ£À̽º°¡ ÀÖ´Â
Data Links ¼¹ö¸¦ µî·ÏÇϽʽÿÀ.
- ÀÛ¼ºÇÑ VALIDATE
ÀνºÅϽº¿¡¼ ½Ã½ºÅÛ °ü¸®(SYSADM) ±ÇÇÑÀ» °¡Áø
À¯È¿ÇÑ DB2 »ç¿ëÀÚ ID·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ. ±âº»°ªÀ¸·Î, ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ
1Â÷ ±×·ì¿¡ ¼ÓÇÏ´Â ¸ðµç
»ç¿ëÀÚ´Â ÀνºÅϽº¿¡ ´ëÇØ SYSADM ±ÇÇÑÀ» °¡Áý´Ï´Ù.
ÀÚ¼¼ÇÑ
³»¿ëÀº ¼¹öÀÇ ºü¸¥ ½ÃÀÛ
¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.
- ´ÙÀ½°ú °°ÀÌ
db2profile
¶Ç´Â db2cshrc
½ºÅ©¸³Æ®¸¦ ¼öÇàÇϽʽÿÀ.
. INSTHOME/sqllib/db2profile (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì)
source INSTHOME/sqllib/db2cshrc (C ½©ÀÇ °æ¿ì)
¿©±â¼ INSTHOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ
Ȩ µð·ºÅ丮ÀÔ´Ï´Ù.
- db2start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿©
VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇϽʽÿÀ.
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DATALINK µ¥ÀÌÅÍ À¯Çü¿¡ ÀÇÇØ ¸µÅ©µÇ´Â
ÆÄÀÏÀ» Á¦¾îÇÒ Data Links ¼¹ö¸¦ µî·ÏÇϽʽÿÀ.
db2 "add datalinks manager for database database_alias==>
using node hostname port port_number" //UFS
¿©±â¼,
- database_alias´Â µ¥ÀÌÅͺ£À̽ºÀÇ º°¸íÀÔ´Ï´Ù.
- hostnameÀº Data Links ¼¹öÀÇ ¿ÏÀüÇÑ È£½ºÆ® À̸§ÀÔ´Ï´Ù.
- port_number´Â Data Links ¼¹ö¿Í DB2 ¼¹ö °£ÀÇ Åë½Å¿ëÀ¸·Î
¿¹¾àÇÑ Æ÷Æ® ¹øÈ£ÀÔ´Ï´Ù. ÀÌ Æ÷Æ® ¹øÈ£´Â DB2 Data Links Manager ¼³Ä¡
Áß¿¡ ÁöÁ¤µÈ °ÍÀÔ´Ï´Ù.
UFS ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "add datalinks manager for database staff using==>
node dlmserver.services.com port 50100"
- µî·ÏµÈ Data Links Manager¸¦ ³ª¿ÇÏ·Á¸é, ´ÙÀ½ ¸í·ÉÀ»
ÀÔ·ÂÇϽʽÿÀ.
db2 list datalinks managers for db staff
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿©
STAFF µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.
db2 connect to staff
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ÀÛ¼ºÇÑ
EMPLOYEE Å×ÀÌºí¿¡ Ç׸ñÀ» »ðÀÔÇϽʽÿÀ.
db2 "insert into employee values (001,'Paul','Smith',==>
dlvalue('http://hostname/controlled_file'))"
¿©±â¼,
- hostnameÀº Data Links ¼¹öÀÇ ¿ÏÀüÇÑ È£½ºÆ® À̸§ÀÔ´Ï´Ù.
- controlled_fileÀº Data Links ¼¹ö¿¡¼ Á¦¾îÇÒ
ÆÄÀÏÀÇ Àüü °æ·Î À̸§ÀÔ´Ï´Ù.
- ·Î±×¾Æ¿ôÇϽʽÿÀ.