ÀÌÀü¿¡ DATALINK µ¥ÀÌÅÍ À¯ÇüÀÌ Á¤ÀÇµÈ ¿ø°Ý DB2 UDB µ¥ÀÌÅͺ£À̽º°¡ ÀÖ´Â Data Links ¼¹ö¸¦ µî·ÏÇϽʽÿÀ.
. INSTHOME/sqllib/db2profile (bash, Bourne ¶Ç´Â Korn ½©ÀÇ °æ¿ì) source INSTHOME/sqllib/db2cshrc (C ½©ÀÇ °æ¿ì)
¿©±â¼ INSTHOMEÀº ÀνºÅϽº ¼ÒÀ¯ÀÚÀÇ È¨ µð·ºÅ丮ÀÔ´Ï´Ù.
db2 "add datalinks manager for database database_alias==> using node hostname port port_number" //JFS -OR- db2 "add datalinks manager for database database_alias using==> cell cell-name dlminstance instance-name" //DCE-DFS
¿©±â¼,
JFS ¿¹¿¡¼´Â ´ÙÀ½ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "add datalinks manager for database staff using==> node dlmserver.services.com port 50100"
DCE-DFS ¿¹¿¡¼´Â ´ÙÀ½ÀÇ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 "add datalinks manager for database staff using==> cell services.com dlminstance dlmadmin"
db2 connect to staff
db2 "insert into employee values (001,'Paul','Smith',==> dlvalue('http://hostname/controlled_file'))"
¿©±â¼,
DCE-DFS ȯ°æ¿¡¼, ÀÌ ¿¹¿¡¼ »ç¿ëµÈ URLÀ» dfs://.../cellname/fs/...·Î ¹Ù²Ù½Ê½Ã¿À. ÀÌ ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ£®
db2 "insert into employee values (001,'Paul','Smith',==> dlvalue('dfs://.../services.com/test/pictures/psmith.bmp'))"