DB2 UDB ¼¹ö¿¡¼ Å×½ºÆ® ȯ°æ ÀÛ¼ºÀ» ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
ÀÌ ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© VALIDATE¶ó´Â ÀνºÅϽº¸¦ ÀÛ¼ºÇϽʽÿÀ.
mkgroup testers mkuser pgrp='testers' groups='testers' home='/home/validate' validate /usr/lpp/db2_07_01/instance/db2icrt -u validate validate
db2 get instance
ÀÌ ¸í·ÉÀº ´ÙÀ½ Ãâ·ÂÀ» ¸®ÅÏÇÕ´Ï´Ù.
The current database manager instance is: VALIDATE
ÀÌ·¯ÇÑ Ãâ·ÂÀÌ Ç¥½ÃµÇÁö ¾ÊÀ¸¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
set DB2INSTANCE=VALIDATE db2 get instance
db2 update dbm cfg using datalinks yes
DB2 ¼¹ö¿¡¼ DB2 Data Links ManagerÀÇ ±â´ÉÀ» »ç¿ëÇÏÁö ¾ÊÀ¸·Á¸é DATALINKS µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º ¸Å°³º¯¼ö¸¦ no·Î ¼³Á¤ÇϽʽÿÀ.
ÁÖ: | ÀνºÅϽºÀÇ µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º ÆÄÀÏÀÇ ¼³Á¤À» º¯°æÇÑ °æ¿ì, º¯°æ»çÇ×ÀÌ Àû¿ëµÇ·Á¸é ÀνºÅϽº¸¦ ÁßÁöÇÏ°í ´Ù½Ã ½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù(db2stop ¹× db2start ¸í·É »ç¿ë). ÀÌ ¿¹¿¡¼´Â VALIDATE ÀνºÅϽº¸¦ ½ÃÀÛÇÏÁö ¾Ê¾ÒÀ¸¹Ç·Î db2start ¸í·É¸¸À» ½ÇÇàÇÕ´Ï´Ù. °ü¸® ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ |
ÀÌ ¿¹¿¡¼, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© STAFF¶ó°í ÇÏ´Â µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϽʽÿÀ.
db2 create database staff
db2 connect to staff
db2 "create table employee (id int, fname varchar(30), lname varchar(30), picture datalink linktype url file link control integrity all read permission db write permission blocked recovery yes on unlink restore)"
db2 connect reset