ÀÌÀü¿¡ DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Á¤ÀÇµÈ ¿ø°Ý DB2 UDB µ¥ÀÌÅͺ£À̽º°¡ ÀÖ´Â
Data Links ¼¹ö¸¦ µî·ÏÇÏ·Á¸é, ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- ÀÛ¼ºÇÑ VALIDATE
ÀνºÅϽº¿¡¼ ½Ã½ºÅÛ °ü¸®(SYSADM) ±ÇÇÑÀ» °¡Áø
À¯È¿ÇÑ DB2 »ç¿ëÀÚ ID·Î ½Ã½ºÅÛ¿¡ ·Î±×¿ÂÇϽʽÿÀ. ±âº»°ªÀ¸·Î, Áö¿ª °ü¸®ÀÚ
±×·ì¿¡ ¼ÓÇÏ´Â ¸ðµç »ç¿ëÀÚ´Â ÀνºÅϽº¿¡
´ëÇØ SYSADM ±ÇÇÑÀ» °¡Áý´Ï´Ù. ÀÚ¼¼ÇÑ
³»¿ëÀº ¼¹öÀÇ ºü¸¥ ½ÃÀÛ
¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE
ÀνºÅϽº°¡ ÇöÀç ÀνºÅϽºÀÎÁö È®ÀÎÇϽʽÿÀ.
db2 get instance
ÀÌ ¸í·ÉÀº ´ÙÀ½ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù.
The current database manager instance is: VALIDATE
ÀÌ·¯ÇÑ Ãâ·ÂÀÌ Ç¥½ÃµÇÁö ¾ÊÀ¸¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
set DB2INSTANCE=VALIDATE
db2 get instance
- db2start ¸í·ÉÀ» ÀÔ·ÂÇÏ¿©
VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇϽʽÿÀ.
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© DATALINK µ¥ÀÌÅÍ À¯Çü¿¡ ÀÇÇØ ¸µÅ©µÇ´Â
ÆÄÀÏÀ» Á¦¾îÇÒ Data Links ¼¹ö¸¦ µî·ÏÇϽʽÿÀ.
db2 "add datalinks manager for database database_alias using node hostname port port_number"
¿©±â¼,
- database_alias´Â µ¥ÀÌÅͺ£À̽ºÀÇ º°¸íÀÔ´Ï´Ù.
- hostnameÀº Data Links ¼¹öÀÇ ¿ÏÀüÇÑ È£½ºÆ® À̸§ÀÔ´Ï´Ù.
- port_number´Â Data Links ¼¹ö¿Í DB2 ¼¹ö °£ÀÇ Åë½Å¿ëÀ¸·Î
¿¹¾àÇÑ Æ÷Æ® ¹øÈ£ÀÔ´Ï´Ù. ÀÌ Æ÷Æ® ¹øÈ£´Â DB2 Data Links Manager ¼³Ä¡
Áß¿¡ ÁöÁ¤µÈ °ÍÀÔ´Ï´Ù.
ÀÌ ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2 "add datalinks manager for database staff using node dlmserver.services.com port 50100"
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿©
STAFF µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇϽʽÿÀ.
db2 connect to staff
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ÀÛ¼ºÇÑ
EMPLOYEE Å×ÀÌºí¿¡ Ç׸ñÀ» »ðÀÔÇϽʽÿÀ.
db2 "insert into employee values (001,'Paul','Smith',==>
dlvalue('unc:\\unc_name\controlled_file'))"
¿©±â¼,
- unc_nameÀº Data Links ¼¹ö¿¡¼ Data Links Filesystem Filter°¡ Á¦¾îÇÏ´Â ÆÄÀÏÀÇ ¿ÏÀüÇÑ À§Ä¡ÀÔ´Ï´Ù.
- controlled_fileÀº Data Links ¼¹ö¿¡¼ Á¦¾îÇÒ ÆÄÀÏ À̸§ÀÔ´Ï´Ù.
ÀÌ ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2 "insert into employee values (001,'Paul','Smith',==>
dlvalue('unc:\\dlmserver.services.com\cdrive\pictures\psmith.bmp'))"
- ·Î±×¾Æ¿ôÇϽʽÿÀ.