OLAP ¼³Ä¡ ¹× »ç¿ëÀÚ ¾È³»¼
DB2 Universal Database ¹× Net.Data¸¦ Áö¿øÇÏ´Â ÀÓÀÇÀÇ ¿î¿µ üÁ¦¿¡¼ À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÒ
¼ö ÀÖ½À´Ï´Ù. ¿î¿µ üÁ¦¿¡¼ Net.Data Live Connection °ü¸® ÇÁ·Î±×·¥ ¹× Perl LEµµ Áö¿øÇØ¾ß ÇÕ´Ï´Ù.
ÀÌ·± ¿î¿µ üÁ¦¿¡´Â Windows NT, OS/2, AIX ¹× Solaris Operating EnvironmentÀÌ Æ÷ÇԵ˴ϴÙ.
ÇÁ·Î±×·¥À» ½ÃÀÛÇÒ MIME À¯Çü ¼³Á¤¿¡ ´ëÇØ¼´Â Information Catalog Manager Administration Guide¸¦
ÂüÁ¶ÇϽʽÿÀ.
À¥ ¼¹ö¿¡¼ ÀÎÁõÀ» »ç¿ë °¡´ÉÇÏ°Ô ÇØ¾ß ÇÕ´Ï´Ù. ÀÎÁõÀ» »ç¿ë °¡´ÉÇϰÔ
ÇÏ·Á¸é °¢ »ç¿ëÀÚ´Â »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÀÔ·ÂÇÏ¿© À¥¿ë Information Catalog Manager¿¡ ¾×¼¼½ºÇؾß
ÇÕ´Ï´Ù. Net.Data Live Connection °ü¸® ÇÁ·Î±×·¥¿¡¼ µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» °ü¸®ÇϹǷΠ»ç¿ëÀÚ´Â
µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¾Ë Çʿ䰡 ¾ø½À´Ï´Ù.
Á¤º¸ īŻ·Î±×ÀÇ Á¤º¸ ¹Î°¨µµ¿¡ µû¶ó À¥ ¼¹öÀÇ ÇØ´ç º¸¾È ·¹º§À» ±¸ÇöÇØ¾ß
ÇÕ´Ï´Ù. À¥ ¼¹öÀÇ ÀÎÁõ ±â´ÉÀ» ³Ñ¾î¼± Ãß°¡ º¸¾ÈÀ» È®º¸ÇÏ·Á¸é ¾ÏÈ£È
¹× Ű·Î º¸¾È ÆÐŰÁö¸¦ ¼³Ä¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. °í±Þ À¥
¼¹ö º¸¾È¿¡ ´ëÇØ¼´Â IBM SecureWay(Websphere °è¿ÀÇ ÀϺÎ)¿¡ ´ëÇÑ
¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡Çϱâ Àü¿¡ ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- IBM HTTP À¥ ¼¹ö°¡ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
- À¥ ¼¹ö Æ÷Æ® ¹øÈ£¸¦ È®ÀÎÇϽʽÿÀ. À¥ ¼¹ö¿¡ 80(ÀϹÝÀûÀÎ ±âº»°ª)
ÀÌ¿ÜÀÇ Æ÷Æ®°¡ ÀÖÀ» °æ¿ì µµ¸ÞÀÎ À̸§À» ±¸¼ºÇÒ ¶§ À¥ ÁÖ¼ÒÀÇ È£½ºÆ®
À̸§¿¡ Æ÷Æ® ¹øÈ£¸¦ Ãß°¡ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
http://hostname:portnumber/¿Í °°½À´Ï´Ù.
- À¥ ¼¹ö¿¡ \IBM HTTP Server\icm°ú °°Àº
Net.Data ½ÇÇà ÆÄÀÏÀ» Æ÷ÇÔÇÒ icmÀ̶ó´Â µð·ºÅ丮¸¦ ÀÛ¼ºÇϽʽÿÀ.
ÀÌ µð·ºÅ丮¸¦ Net.Data cgi-bin µð·ºÅ丮·Î Áö½ÃÇϽʽÿÀ. ÀÌ µð·ºÅ丮¿¡
db2www.exe ½ÇÇà ÆÄÀÏÀ» ³ÖÀ¸½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- ´ÙÀ½°ú °°ÀÌ À¥ ¼¹ö¿¡ À¥¿ë Information Catalog Manager ÆÄÀÏÀ» ¼³Ä¡ÇϽʽÿÀ.
- À¥ ¼¹ö ¿öÅ©½ºÅ×À̼ÇÀÇ CD-ROM µå¶óÀ̺꿡 DB2 Universal Database CD-ROMÀ»
³ÖÀ¸½Ê½Ã¿À. ±×·¯¸é ·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼ DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦ ´©¸¥ ÈÄ
´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¸¦ Á¦¿ÜÇÑ ¸ðµç ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
- ºÎ¼Ó ±¸¼º¿ä¼Ò¸¦ ´©¸£½Ê½Ã¿À.
- ºÎ¼Ó ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ À¥¿ë Information Catalog ManagerÀÇ
¼±ÅöõÀ» ¼±ÅÃÇÏ°í ´Ù¸¥ ¸ðµç ¼±ÅöõÀº Áö¿ö¾ß ÇÕ´Ï´Ù.
- °è¼ÓÀ» ´©¸£½Ê½Ã¿À.
- ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ Åë½Å ÇÁ·ÎÅäÄÝ ±¸¼º¿ä¼Ò,
ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ÀÎÅÍÆäÀ̽º ±¸¼º¿ä¼Ò ¹×
°ü¸® ¹× ±¸¼º µµ±¸ ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸ ±¸¼º¿ä¼Ò°¡ ¿©ÀüÈ÷ ¼±ÅõǾî
ÀÖ¾î¾ß ÇÕ´Ï´Ù.
- ´ÙÀ½À» ´·¯ ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ.
¼³Ä¡ ÇÁ·Î±×·¥¿¡¼ ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ¸¸µì´Ï´Ù.
- \sqllib\icmweb\macro
- \sqllib\icmweb\html
- \sqllib\icmweb\icons
- \sqllib\icmweb\macro µð·ºÅ丮¿¡¼
Net.Data ¸ÅÅ©·Î µð·ºÅ丮(º¸Åë \db2www\macro)·Î
¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» º¹»çÇϽʽÿÀ.
- \sqllib\icmweb\html¿¡¼
À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮(º¸Åë \IBM HTTP
Server\htdocs)·Î ¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» º¹»çÇϽʽÿÀ.
- \sqllib\icmweb\icons µð·ºÅ丮¿¡¼
À¥ ¼¹öÀÇ À̹ÌÁö µð·ºÅ丮(º¸Åë \IBM HTTP
Server\icons)·Î ¸ðµç dg*.gif ÆÄÀÏÀ» º¹»çÇϽʽÿÀ. ÀÌ µð·ºÅ丮°¡
dg_config.hti ÆÄÀÏ¿¡ ÀÖ´Â image_path
º¯¼öÀÇ °ªÀÌ µË´Ï´Ù.
- ÆÄÀÏ ¹× ¼¹ö À̸§À» º¹»çÇÑ µð·ºÅ丮¸¦ Æ÷ÇÔÇϵµ·Ï
dg_config.hti ÆÄÀÏÀ»
ÆíÁýÇϽʽÿÀ. macro_path º¯¼ö¿¡¼´Â »ç¿ëÀÚ ¾×¼¼½º¸¦
Á¦¾îÇϵµ·Ï À¥ ¼¹ö¿¡ ¼³Á¤µÈ º°¸íÀ» »ç¿ëÇÕ´Ï´Ù.
dg_config.hti ÆÄÀÏÀº ´ÙÀ½°ú °°¾Æ¾ß ÇÕ´Ï´Ù.
%DEFINE {
server_name="http://winntserver.ibm.com/"
image_path="$(server_name)icons/"
macro_path="$(server_name)icm/db2www.exe/"
help_path="$(server_name)"
%}
- ±âÁ¸ À¥ ÆäÀÌÁö¿¡ ¸µÅ©¸¦ Ãß°¡Çϰųª À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ´ëÇÑ
¸µÅ©·Î À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇϽʽÿÀ.
À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇÏ·Á¸é icm.html ÆÄÀÏÀ»
ÆíÁýÇÏ¿© ´ÙÀ½°ú °°Àº ÇàÀ» Ãß°¡ÇϽʽÿÀ.
<html><head>
<title>À¥¿ë Information Catalog Manager</title>
</head>
<body bgcolor=white>
<p><a href=/icm/db2www.exe/dg_home.mac/Logon>
À¥¿ë Information Catalog Manager</a>
</body>
</html>
HTML ±âº» µð·ºÅ丮(º¸Åë \IBM HTTP
Server\htdocs)¿¡ ÆÄÀÏÀ» ³ÖÀ¸½Ê½Ã¿À.
- À¥ ¼¹ö¿¡¼ °¢ À¥¿ë Information Catalog Manager »ç¿ëÀÚ¿¡ ´ëÇØ ±âº» »ç¿ëÀÚ ÀÎÁõÀ» »ç¿ëÇϽʽÿÀ.
À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ¾×¼¼½ºÇÏ¸é »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯´Â ¸Þ½ÃÁö°¡
Ç¥½ÃµË´Ï´Ù. ÇØ´ç °ªÀ» ÀÔ·ÂÇϸé HTTP ȯ°æ º¯¼ö REMOTE_USER°¡
¼³Á¤µË´Ï´Ù. ÀÌ º¯¼ö´Â »ç¿ëÀÚ¿¡°Ô »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯°í ÁÖ¼®À»
ÀÛ¼ºÇϰí, °»½ÅÇÏ°í »èÁ¦ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
- º°¸íÀ» ¼³Á¤ÇϽʽÿÀ.
Net.Data CGI ÇÁ·Î±×·¥ DB2WWW°¡ ÀÖ´Â
µð·ºÅ丮ÀÇ º°¸í icmÀ» ÀÛ¼ºÇϽʽÿÀ.
dg_config.hti ÆÄÀÏ¿¡ Á¤ÀÇµÈ macro_path
º¯¼ö¿¡¼ ÀÌ º°¸íÀ» »ç¿ëÇÕ´Ï´Ù.
macro_path="$(server_name)icm/db2www.exe/"
º°¸í µð·ºÅ丮 icm¿¡¼ »ç¿ëÀÚ ID ¹× ¾ÏÈ£ ÀÎÁõÀÌ »ç¿ëµÇ¾î¾ß
ÇÕ´Ï´Ù. ÀÎÁõÀ» »ç¿ëÇÏ·Á¸é httpd.conf ÆÄÀÏÀ»
ÆíÁýÇϽʽÿÀ. ÀÌ ÆÄÀÏÀº º¸Åë \IBM HTTP Server\conf
µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. ´ÙÀ½°ú °°Àº ScriptAlias Áö½Ã¹®À» Ãß°¡ÇϽʽÿÀ.
ScriptAlias /icm/ "c:/IBM HTTP Server/icm/"
¶ÇÇÑ httpd.conf ÆÄÀÏ¿¡ ´ÙÀ½°ú °°ÀÌ
¾×¼¼½º ÆÄÀÏ À̸§À» Á¤ÀÇÇÏ´Â Áö½Ã¹®ÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
AccessFileName .htaccess
- °¢ À¥¿ë Information Catalog Manager »ç¿ëÀÚ¿¡ ´ëÇØ ÀÎÁõµÈ »ç¿ëÀÚ ID ¹× ¾ÏÈ£°¡ µé¾î°¥ ¾ÏÈ£
ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ. htpasswd ¸í·ÉÀ» »ç¿ëÇÏ¿© ¾ÏÈ£ ÆÄÀÏÀ» ÀÛ¼ºÇϰí
ÆíÁýÇϽʽÿÀ.
¿¹¸¦ µé¾î, »ç¿ëÀÚ ID ADMIN¿¡ ´ëÇÑ ¾ÏÈ£ ÆÄÀÏ
c:/IBM HTTP Server/icmweb.pwd¸¦
ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½°ú °°Àº ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
htpasswd -c c:/IBM HTTP Server/icmweb.pwd ADMIN
-c ¿É¼ÇÀ» ÁöÁ¤ÇÏ¸é ¾ÏÈ£ ÆÄÀÏÀ» ÀÛ¼ºÇÒ ¶§ ¾ÏÈ£¸¦
ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
¾ÏÈ£¸¦ ÀÔ·ÂÇ϶ó´Â ¸Þ½ÃÁö°¡ Ç¥½ÃµÇ¸é
ADMINPW¸¦ ÀÔ·ÂÇϽʽÿÀ.
ADMINPW2 ¾ÏÈ£·Î ´Ù¸¥ »ç¿ëÀÚ ID, ADMIN2¸¦
Ãß°¡ÇÏ·Á¸é ´ÙÀ½°ú °°Àº ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
htpasswd c:/IBM HTTP Server/icmweb.pwd ADMIN2 ADMINPW2
ÁÖ¼®ÀÌ ÀÛ¼ºµÉ ¶§ »ç¿ëÀÚ ID°¡ Á¤º¸ īŻ·Î±× Å×ÀÌºí¿¡ ÀúÀåµÇ¹Ç·Î,
»ç¿ëÀÚ ID´Â 8ÀÚ ÀÌÇÏ¿©¾ß ÇÕ´Ï´Ù.
- \IBM HTTP Server\icm\ µð·ºÅ丮¿¡
´ëÇÑ ¾×¼¼½º¸¦ Á¦ÇÑÇϽʽÿÀ.
- \IBM HTTP Server\icm\ µð·ºÅ丮¿¡
¾×¼¼½ºÇÒ ¶§ ÀÎÁõÀ» ¿ä±¸ÇÏ·Á¸é httpd.conf
ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ. ÀÌ ÆÄÀÏÀº º¸Åë \IBM HTTP
Server\conf µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù.
´ÙÀ½°ú °°ÀÌ \IBM HTTP
Server\icm µð·ºÅ丮¿¡ ´ëÇÑ Áö½Ã¹®À» Ãß°¡ÇϽʽÿÀ.
<Directory "c:/IBM HTTP Server/icm">
AllowOverride AuthConfig
Options None
</Directory>
- AuthName, AuthType, AuthUserFile·Î
\IBM HTTP Server\icm µð·ºÅ丮¿¡
.htaccess¶ó´Â ÆÄÀÏÀ» ÀÛ¼ºÇϰí
´ÙÀ½°ú °°ÀÌ ¼³Á¤µÈ Áö½Ã¹®À» ¿ä±¸ÇϽʽÿÀ.
AuthName ICMWeb
AuthType Basic
AuthUserFile "c:/IBM HTTP Server/icmweb.pwd"
require valid-user
ÀϺΠÆíÁý±â¿¡¼ ÆÄÀÏ À̸§ ¹× ÆÄÀÏ È®ÀåÀÚ¸¦ ¿ä±¸ÇϹǷÎ
htaccess.txt À̸§À¸·Î ÆÄÀÏÀ» ÀÛ¼ºÇϰí
ÀúÀåÇÑ ´ÙÀ½ ±× À̸§À» .htaccess·Î
¹Ù²ã¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
ÀÌ·± º¯°æ»çÇ×À» Àû¿ëÇÏ·Á¸é À¥ ¼¹ö¸¦ ÁßÁöÇÑ ÈÄ Àç½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù.
ÁÖ: | ÀÌ´Â IBM HTTP À¥ ¼¹ö¿¡¼ ÀÎÁõÀ» »ç¿ëÇÒ ¼ö ÀÖ´Â
ÇÑ °¡Áö ¹æ¹ýÀÔ´Ï´Ù. ÇÊ¿äÇÑ °æ¿ì, Ãß°¡ º¸¾È ÆÐŰÁö·Î ´õ º¹ÀâÇÑ
µð·ºÅ丮 ±¸Á¶, »ç¿ëÀÚ ±×·ì ¹× »ç¿ë±ÇÇÑÀ» ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
±âº» ÀÎÁõ ¼³Á¤¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â IBM HTTP À¥ ¼¹ö ¹®¼¿¡¼
ã¾Æº¼ ¼ö ÀÖ½À´Ï´Ù. °í±Þ À¥ ¼¹ö º¸¾È¿¡ ´ëÇØ¼´Â IBM
SecureWay(Websphere °è¿ÀÇ ÀϺÎ)¿¡ ´ëÇÑ ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
|
- À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÏ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ Live Connection °ü¸® ÇÁ·Î±×·¥À»
½ÇÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ \db2www\connect\dtwcm.cnf¸¦
ÆíÁýÇÏ¿© À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL ºí·ÏÀ»
Ãß°¡ÇϽʽÿÀ.
°³ÀÎ¿ë Æ÷Æ® ¹øÈ£ 7100 ¹× °ø¿ë Æ÷Æ® ¹øÈ£ 7110¿¡¼ ½ÃÀÛÇÏ¿© ÃÖ¼ÒÇÑ
ÇÁ·Î¼¼½º, ÃÖ´ë ¼¼ ÇÁ·Î¼¼½º·Î ICMSAMP µ¥ÀÌÅͺ£À̽º¸¦ Ãß°¡ÇÏ·Á¸é
´ÙÀ½°ú °°Àº ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
CLIETTE DTW_SQL:ICMSAMP{
MIN_PROCESS=1
MAX_PROCESS=3
START_PRIVATE_PORT=7100
START_PUBLIC_PORT=7110
EXEC_NAME=./dtwcdb2
DATABASE=ICMSAMP
BINDFILE=NOT_USED
LOGIN=*USE_DEFAULT
PASSWORD=*USE_DEFAULT
}
ICMSAMP µ¥ÀÌÅͺ£À̽º¿¡ 6°³ÀÇ Æ÷Æ®(7100, 7101, 7102, 7110, 7111,
7112)°¡ ÇÒ´çµË´Ï´Ù. ÇØ´ç Æ÷Æ®°¡ »ç¿ë °¡´ÉÇÏ¸ç ´Ù¸¥ ÀÀ¿ëÇÁ·Î±×·¥¿¡¼
»ç¿ëÇÏÁö ¾Ê¾Æ¾ß ÇÕ´Ï´Ù. °¢ CLIETTE DTW_SQL ºí·Ï¿¡ ´ëÇØ ´Ù¸¥ Æ÷Æ®
¹øÈ£ ¹üÀ§¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â Net.Data Administration and Programming Guide¸¦
ÂüÁ¶ÇϽʽÿÀ.
- LOGIN °ªÀ» µ¥ÀÌÅͺ£À̽ºÀÇ »ç¿ëÀÚ ID·Î ¼³Á¤Çϰí PASSWORD °ªÀ»
µ¥ÀÌÅͺ£À̽ºÀÇ ¾ÏÈ£·Î ¼³Á¤ÇϽʽÿÀ. µ¥ÀÌÅͺ£À̽º°¡ Áö¿ªÀ̸é
*USE_DEFAULT¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
- SQL È£Ãâ¿¡ Live Connection °ü¸® ÇÁ·Î±×·¥À» »ç¿ëÇϵµ·Ï Net.Data ÃʱâÈ ÆÄÀÏÀ»
¼³Á¤ÇϽʽÿÀ. À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮¿¡¼
DB2WWW.INI ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ.
ENVIRONMENT DTW_SQL¹®ÀÌ CLIETTE "DTW_SQL:$(DATABASE)"·Î
³¡³ª¾ß ÇÕ´Ï´Ù.
¿¹:
ENVIRONMENT (DTW_SQL) DTWSQL(IN DATABASE,LOGIN,PASSWORD,
TRANSACTION_SCOPE,SHOWSQL,ALIGN,START_ROW_NUM)
CLIETTE "DTW_SQL:$(DATABASE)"
- /DB2WWW/CONNECT/dtwcm.exe ½ÇÇà ÆÄÀÏÀ»
»ç¿ëÇÏ¿© Live Connection °ü¸® ÇÁ·Î±×·¥À» ½ÃÀÛÇϽʽÿÀ. À¥¿ë Information Catalog Manager¿¡¼ µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÒ ¼ö
ÀÖµµ·Ï Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ¾î¾ß ÇÕ´Ï´Ù. Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÃÀ۵Ǹé À¥ ¼¹ö¿¡¼ Live Connection °ü¸® ÇÁ·Î±×·¥ âÀ»
ÃÖ¼ÒÈÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â Net.Data Administration and Programming Guide¸¦ ÂüÁ¶ÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ »ç¿ëÇϱâ Àü¿¡ ¼³Ä¡ ÈÄ »ç¿ëÀÚ Á¤ÀǴܰ踦 µû¸£½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡Çϱâ Àü¿¡ ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- IBM HTTP À¥ ¼¹ö°¡ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
- À¥ ¼¹ö Æ÷Æ® ¹øÈ£¸¦ È®ÀÎÇϽʽÿÀ. À¥ ¼¹ö¿¡ 80(ÀϹÝÀûÀÎ ±âº»°ª)
ÀÌ¿ÜÀÇ Æ÷Æ®°¡ ÀÖÀ» °æ¿ì µµ¸ÞÀÎ À̸§À» ±¸¼ºÇÒ ¶§ À¥ ÁÖ¼ÒÀÇ È£½ºÆ®
À̸§¿¡ Æ÷Æ® ¹øÈ£¸¦ Ãß°¡ÇϽʽÿÀ. ¿¹¸¦ µé¸é,
http://hostname:portnumber/¿Í °°½À´Ï´Ù.
- À¥ ¼¹ö¿¡ /usr/lpp/HTTPServer/share/icm/°ú
°°Àº Net.Data ½ÇÇà ÆÄÀÏÀ» Æ÷ÇÔÇÒ icmÀ̶ó´Â µð·ºÅ丮¸¦ ÀÛ¼ºÇϽʽÿÀ.
ÀÌ µð·ºÅ丮¸¦ Net.Data cgi-bin µð·ºÅ丮·Î Áö½ÃÇϽʽÿÀ. ÀÌ µð·ºÅ丮¿¡
db2www ½ÇÇà ÆÄÀÏ(º¸Åë
/usr/lpp/internet/server_root/cgi-bin
µð·ºÅ丮¿¡ ÀÖ´Â)À» ³ÖÀ¸½Ê½Ã¿À.
- º¸Åë /usr/lpp/HTTPServer/share/htdocsÀÎ
¹®¼ ·çÆ® µð·ºÅ丮¿¡ db2www.ini ÆÄÀÏ(º¸Åë
/usr/lpp/internet/server_root/pub/ µð·ºÅ丮¿¡
ÀÖ´Â)À» º¹»çÇϽʽÿÀ. ´ÙÀ½°ú °°ÀÌ db2www.ini
ÆÄÀÏÀ» ÆíÁýÇÑ ÈÄ DB2 ÀνºÅϽº ¹× °æ·Î¸¦ °»½ÅÇϽʽÿÀ.
DB2INSTANCE db2
MACRO_PATH /usr/lpp/internet/db2www/macro
INCLUDE_PATH /usr/lpp/internet/db2www/macro
HTML_PATH /usr/lpp/HTTPServer/share/htdocs
EXEC_PATH /usr/lpp/internet/db2www/macro
DTW_LOG_DIR /usr/lpp/internet/db2www/logs
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- ·çÆ® ±ÇÇÑÀÌ ÀÖ´Â »ç¿ëÀÚ·Î ·Î±×ÀÎÇϽʽÿÀ.
- DB2 Universal Database CD-ROMÀ» ³Ö¾î ¸¶¿îÆ®ÇϽʽÿÀ. CD-ROM ¸¶¿îÆÃ¿¡
´ëÇØ¼´Â UNIX¿ë DB2 ºü¸¥ ½ÃÀÛÀ» ÂüÁ¶ÇϽʽÿÀ.
- cd /cdromÀ» ÀÔ·ÂÇÏ¿© CD-ROMÀÌ ¸¶¿îÆ®µÈ µð·ºÅ丮·Î
º¯°æÇϽʽÿÀ. ¿©±â¼ cdromÀº Á¦Ç° CD-ROMÀÇ ¸¶¿îÆ® ÁöÁ¡ÀÔ´Ï´Ù.
- ./db2setup ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ. ¾ó¸¶ ÈÄ DB2 V7 ¼³Ä¡ âÀÌ ¿¸³´Ï´Ù.
- ¼³Ä¡ÇÏ·Á´Â Á¦Ç° ¹× ¼³Ä¡Çϵµ·Ï »ç¿ë Çã°¡µÈ Á¦Ç°À» ¼±ÅÃÇϽʽÿÀ.
ÅÇ Å°¸¦ ´·¯ °Á¶Ç¥½ÃµÈ ¿É¼ÇÀ» º¯°æÇϽʽÿÀ. Enter¸¦ ´·¯ ¿É¼ÇÀ»
¼±ÅÃÇϰųª ¼±ÅÃÃë¼ÒÇϽʽÿÀ. ¿É¼ÇÀ» ¼±ÅÃÇÏ¸é º°Ç¥°¡ ±× ¿·¿¡ Ç¥½ÃµË´Ï´Ù.
¼³Ä¡ÇÏ·Á´Â DB2 Á¦Ç°ÀÇ ¼±ÅÃÀû ±¸¼º¿ä¼Ò¸¦ ¼±ÅÃÇϰųª ¼±ÅÃÃë¼ÒÇÏ·Á¸é
»ç¿ëÀÚ Á¤ÀÇ ¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ. ¾ðÁ¦µç ÀÌÀü
âÀ¸·Î µ¹¾Æ°¡·Á¸é Ãë¼Ò ¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ.
- DB2 Á¦Ç° ¹× ±× ±¸¼º¿ä¼Ò¸¦ ¼±ÅÃÇÑ ÈÄ¿¡ È®ÀÎÀ»
¼±ÅÃÇÏ¿© ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ.
DB2 Á¦Ç° ¶Ç´Â ±¸¼º¿ä¼Ò ¼³Ä¡ Áß ÀÚ¼¼ÇÑ Á¤º¸ ¶Ç´Â Áö¿øÀ» ¹ÞÀ¸·Á¸é µµ¿ò¸»
¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ.
¼³Ä¡ ÇÁ·Î±×·¥¿¡¼ ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ¸¸µì´Ï´Ù.
- \sqllib\icmweb\macro
- \sqllib\icmweb\html
- \sqllib\icmweb\icons
- Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ \sqllib\icmweb\macro
µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ Net.Data ¸ÅÅ©·Î µð·ºÅ丮(º¸Åë
/usr/lpp/internet/db2www/macro)·Î
¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» º¹»çÇϽʽÿÀ. ÀÌ·± ÆÄÀÏ¿¡ ´ëÇÑ »ç¿ë±ÇÇÑÀ»
°ø¿ë Àбâ·Î ¼³Á¤ÇÏ·Á¸é chmod ugo+r *¸¦ ÀÔ·ÂÇϽʽÿÀ.
- Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ \sqllib\icmweb\html
µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮(º¸Åë
/usr/lpp/HTTPServer/share/htdocs)·Î
¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» º¹»çÇϽʽÿÀ. ÀÌ·± ÆÄÀÏ¿¡ ´ëÇÑ »ç¿ë±ÇÇÑÀ»
°ø¿ë Àбâ·Î ¼³Á¤ÇÏ·Á¸é chmod ugo+r *¸¦ ÀÔ·ÂÇϽʽÿÀ.
- Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ \sqllib\icmweb\icons
µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ À̹ÌÁö µð·ºÅ丮(º¸Åë
/usr/lpp/HTTPServer/share/icons)·Î
¸ðµç dg*.gif ÆÄÀÏÀ» º¹»çÇϽʽÿÀ. ÀÌ µð·ºÅ丮°¡
dg_config.hti ÆÄÀÏ¿¡ ÀÖ´Â image_path º¯¼öÀÇ
°ªÀÌ µË´Ï´Ù. ÀÌ·± ÆÄÀÏ¿¡ ´ëÇÑ »ç¿ë±ÇÇÑÀ» °ø¿ë Àбâ·Î ¼³Á¤ÇÏ·Á¸é
chmod ugo+r *¸¦ ÀÔ·ÂÇϽʽÿÀ.
- ÆÄÀÏ ¹× ¼¹ö À̸§À» º¹»çÇÑ µð·ºÅ丮¸¦ Æ÷ÇÔÇϵµ·Ï
dg_config.hti ÆÄÀÏÀ»
ÆíÁýÇϽʽÿÀ. macro_path º¯¼ö¿¡¼´Â »ç¿ëÀÚ ¾×¼¼½º¸¦
Á¦¾îÇϵµ·Ï À¥ ¼¹ö¿¡ ¼³Á¤µÈ º°¸íÀ» »ç¿ëÇÕ´Ï´Ù.
dg_config.hti ÆÄÀÏÀº ´ÙÀ½°ú °°¾Æ¾ß ÇÕ´Ï´Ù.
%DEFINE {
server_name="http://aixserver.ibm.com/"
image_path="$(server_name)icons/"
macro_path="$(server_name)icm/db2www/"
help_path="$(server_name)"
%}
- ±âÁ¸ À¥ ÆäÀÌÁö¿¡ ¸µÅ©¸¦ Ãß°¡Çϰųª À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ´ëÇÑ
¸µÅ©·Î À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇϽʽÿÀ.
À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇÏ·Á¸é icm.html ÆÄÀÏÀ»
ÆíÁýÇÏ¿© ´ÙÀ½°ú °°Àº ÇàÀ» Ãß°¡ÇϽʽÿÀ.
<html><head>
<title>À¥¿ë Information Catalog Manager</title>
</head>
<body bgcolor=white>
<p><a href=/icm/db2www/dg_home.mac/Logon>
À¥¿ë Information Catalog Manager</a>
</body>
</html>
º¸Åë /usr/lpp/HTTPServer/share/htdocsÀÎ
¹®¼ ·çÆ® µð·ºÅ丮¿¡ ÆÄÀÏÀ» ³ÖÀ¸½Ê½Ã¿À.
- À¥ ¼¹ö¿¡¼ °¢ À¥¿ë Information Catalog Manager »ç¿ëÀÚ¿¡ ´ëÇØ ±âº» »ç¿ëÀÚ ÀÎÁõÀ» »ç¿ëÇϽʽÿÀ.
À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ¾×¼¼½ºÇÏ¸é »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯´Â ¸Þ½ÃÁö°¡
Ç¥½ÃµË´Ï´Ù. ÇØ´ç °ªÀ» ÀÔ·ÂÇϸé HTTP ȯ°æ º¯¼ö REMOTE_USER°¡
¼³Á¤µË´Ï´Ù. ÀÌ º¯¼ö´Â »ç¿ëÀÚ¿¡°Ô »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯°í ÁÖ¼®À»
ÀÛ¼ºÇϰí, °»½ÅÇÏ°í »èÁ¦ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
- º°¸íÀ» ¼³Á¤ÇϽʽÿÀ.
Net.Data CGI ÇÁ·Î±×·¥ DB2WWW°¡ ÀÖ´Â
µð·ºÅ丮ÀÇ º°¸í icmÀ» ÀÛ¼ºÇϽʽÿÀ.
dg_config.hti ÆÄÀÏ¿¡
Á¤ÀÇµÈ macro_path º¯¼ö¿¡¼ ÀÌ º°¸íÀ» »ç¿ëÇÕ´Ï´Ù.
macro_path="$(server_name)icm/db2www/"
º°¸í µð·ºÅ丮 icm¿¡¼ »ç¿ëÀÚ ID ¹× ¾ÏÈ£ ÀÎÁõÀÌ »ç¿ëµÇ¾î¾ß
ÇÕ´Ï´Ù. ÀÎÁõÀ» »ç¿ëÇÏ·Á¸é httpd.conf
ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ. ÀÌ ÆÄÀÏÀº º¸Åë
/usr/lpp/HTTPServer/etc/ µð·ºÅ丮¿¡
ÀÖ½À´Ï´Ù. ´ÙÀ½°ú °°Àº ScriptAlias Áö½Ã¹®À» Ãß°¡ÇϽʽÿÀ.
ScriptAlias /icm/ /usr/lpp/HTTPServer/share/icm
¶ÇÇÑ httpd.conf ÆÄÀÏ¿¡ ´ÙÀ½°ú °°ÀÌ
¾×¼¼½º ÆÄÀÏ À̸§À» Á¤ÀÇÇÏ´Â Áö½Ã¹®ÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
AccessFileName .htaccess
- °¢ À¥¿ë Information Catalog Manager »ç¿ëÀÚ¿¡ ´ëÇØ ÀÎÁõµÈ »ç¿ëÀÚ ID ¹× ¾ÏÈ£°¡ µé¾î°¥
¾ÏÈ£ ÆÄÀÏÀ» ÀÛ¼ºÇϽʽÿÀ. htpasswd ¸í·ÉÀ» »ç¿ëÇÏ¿© ¾ÏÈ£ ÆÄÀÏÀ»
ÀÛ¼ºÇÏ°í ÆíÁýÇϽʽÿÀ.
¿¹¸¦ µé¾î, »ç¿ëÀÚ ID ADMIN¿¡ ´ëÇÑ ¾ÏÈ£ ÆÄÀÏ
/usr/lpp/HTTPServer/share/icmweb.pwd¸¦
ÀÛ¼ºÇÏ·Á¸é ´ÙÀ½°ú °°Àº ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
htpasswd -c /usr/lpp/HTTPServer/share/icmweb.pwd ADMIN
-c ¿É¼ÇÀ» ÁöÁ¤ÇÏ¸é ¾ÏÈ£ ÆÄÀÏÀ» ÀÛ¼ºÇÒ ¶§ ¾ÏÈ£¸¦
ÀÔ·ÂÇØ¾ß ÇÕ´Ï´Ù.
¾ÏÈ£¸¦ ÀÔ·ÂÇ϶ó´Â ¸Þ½ÃÁö°¡ Ç¥½ÃµÇ¸é ADMINPW¸¦
ÀÔ·ÂÇϽʽÿÀ.
ADMINPW2 ¾ÏÈ£·Î ´Ù¸¥ »ç¿ëÀÚ ID, ADMIN2¸¦ Ãß°¡ÇÏ·Á¸é ´ÙÀ½°ú °°Àº
¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
htpasswd /usr/lpp/HTTPServer/share/icmweb.pwd ADMIN2 ADMINPW2
ÁÖ¼®ÀÌ ÀÛ¼ºµÉ ¶§ »ç¿ëÀÚ ID°¡ Á¤º¸ īŻ·Î±× Å×ÀÌºí¿¡ ÀúÀåµÇ¹Ç·Î,
»ç¿ëÀÚ ID´Â 8ÀÚ ÀÌÇÏ¿©¾ß ÇÕ´Ï´Ù.
- /usr/lpp/HTTPServer/share/icm
µð·ºÅ丮¿¡ ´ëÇÑ ¾×¼¼½º¸¦ Á¦ÇÑÇϽʽÿÀ.
- /usr/lpp/HTTPServer/share/icm
µð·ºÅ丮¿¡ ¾×¼¼½ºÇÒ ¶§ ÀÎÁõÀ» ¿ä±¸ÇÏ·Á¸é
httpd.conf ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ.
ÀÌ ÆÄÀÏÀº º¸Åë /usr/lpp/HTTPServer/etc/
µð·ºÅ丮¿¡ ÀÖ½À´Ï´Ù. ´ÙÀ½°ú °°ÀÌ
/usr/lpp/HTTPServer/share/icm
µð·ºÅ丮¿¡ ´ëÇÑ Áö½Ã¹®À» Ãß°¡ÇϽʽÿÀ.
<Directory /usr/lpp/HTTPServer/share/icm>
AllowOverride AuthConfig
Options None
</Directory>
- AuthName, AuthType, AuthUserFile·Î
/usr/lpp/HTTPServer/share/icm µð·ºÅ丮¿¡
.htaccess¶ó´Â ÆÄÀÏÀ» ÀÛ¼ºÇÏ°í ´ÙÀ½°ú °°ÀÌ
¼³Á¤µÈ Áö½Ã¹®À» ¿ä±¸ÇϽʽÿÀ.
AuthName ICMWeb
AuthType Basic
AuthUserFile /usr/lpp/HTTPServer/share/icmweb.pwd
require valid-user
ÀϺΠÆíÁý±â¿¡¼ ÆÄÀÏ À̸§ ¹× ÆÄÀÏ È®ÀåÀÚ¸¦ ¿ä±¸ÇϹǷÎ
htaccess.txt À̸§À¸·Î ÆÄÀÏÀ» ÀÛ¼ºÇϰí
ÀúÀåÇÑ ´ÙÀ½ ±× À̸§À» .htaccess·Î
¹Ù²ã¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
ÀÌ·± º¯°æ»çÇ×À» Àû¿ëÇÏ·Á¸é À¥ ¼¹ö¸¦ ÁßÁöÇÑ ÈÄ Àç½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù.
ÁÖ: | ÀÌ´Â IBM HTTP À¥ ¼¹ö¿¡¼ ÀÎÁõÀ» »ç¿ëÇÒ ¼ö ÀÖ´Â ÇÑ °¡Áö
¹æ¹ýÀÔ´Ï´Ù. ÇÊ¿äÇÑ °æ¿ì, Ãß°¡ º¸¾È ÆÐŰÁö·Î ´õ º¹ÀâÇÑ µð·ºÅ丮 ±¸Á¶,
»ç¿ëÀÚ ±×·ì ¹× »ç¿ë±ÇÇÑÀ» ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±âº» ÀÎÁõ ¼³Á¤¿¡ ´ëÇÑ
ÀÚ¼¼ÇÑ Á¤º¸´Â IBM HTTP À¥ ¼¹ö ¹®¼¿¡¼ ã¾Æº¼ ¼ö ÀÖ½À´Ï´Ù. °í±Þ À¥
¼¹ö º¸¾È¿¡ ´ëÇØ¼´Â IBM SecureWay(Websphere °è¿ÀÇ ÀϺÎ)¿¡ ´ëÇÑ
¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
|
- À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÏ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ Live Connection °ü¸® ÇÁ·Î±×·¥À»
½ÇÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ
/usr/lpp/internet/db2www/db2/dtwcm.cnf¸¦
ÆíÁýÇÏ¿© À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL ºí·ÏÀ»
Ãß°¡ÇϽʽÿÀ.
°³ÀÎ¿ë Æ÷Æ® ¹øÈ£ 7100 ¹× °ø¿ë Æ÷Æ® ¹øÈ£ 7110¿¡¼ ½ÃÀÛÇÏ¿© ÃÖ¼ÒÇÑ
ÇÁ·Î¼¼½º, ÃÖ´ë ¼¼ ÇÁ·Î¼¼½º·Î ICMSAMP µ¥ÀÌÅͺ£À̽º¸¦ Ãß°¡ÇÏ·Á¸é
´ÙÀ½°ú °°Àº ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
CLIETTE DTW_SQL:ICMSAMP{
MIN_PROCESS=1
MAX_PROCESS=3
START_PRIVATE_PORT=7100
START_PUBLIC_PORT=7110
EXEC_NAME=./dtwcdb2
DATABASE=ICMSAMP
BINDFILE=NOT_USED
LOGIN=*USE_DEFAULT
PASSWORD=*USE_DEFAULT
}
ICMSAMP µ¥ÀÌÅͺ£À̽º¿¡ 6°³ÀÇ Æ÷Æ®(7100, 7101, 7102, 7110, 7111,
7112)°¡ ÇÒ´çµË´Ï´Ù. ÇØ´ç Æ÷Æ®°¡ »ç¿ë °¡´ÉÇÏ¸ç ´Ù¸¥ ÀÀ¿ëÇÁ·Î±×·¥¿¡¼
»ç¿ëÇÏÁö ¾Ê¾Æ¾ß ÇÕ´Ï´Ù. °¢ CLIETTE DTW_SQL ºí·Ï¿¡ ´ëÇØ ´Ù¸¥ Æ÷Æ®
¹øÈ£ ¹üÀ§¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â Net.Data Administration and Programming Guide¸¦
ÂüÁ¶ÇϽʽÿÀ.
- LOGIN °ªÀ» µ¥ÀÌÅͺ£À̽ºÀÇ »ç¿ëÀÚ ID·Î ¼³Á¤Çϰí PASSWORD °ªÀ»
µ¥ÀÌÅͺ£À̽ºÀÇ ¾ÏÈ£·Î ¼³Á¤ÇϽʽÿÀ. µ¥ÀÌÅͺ£À̽º°¡ Áö¿ªÀ̸é
*USE_DEFAULT¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
- SQL È£Ãâ¿¡ Live Connection °ü¸® ÇÁ·Î±×·¥À» »ç¿ëÇϵµ·Ï Net.Data ÃʱâÈ ÆÄÀÏÀ» ¼³Á¤ÇϽʽÿÀ.
À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮(º¸Åë
/usr/lpp/HTTPServer/share/htdocs)¿¡¼
DB2WWW.INI ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ.
ENVIRONMENT DTW_SQL¹®ÀÌ CLIETTE "DTW_SQL:$(DATABASE)"·Î
³¡³ª¾ß ÇÕ´Ï´Ù.
¿¹:
ENVIRONMENT (DTW_SQL) DTWSQL(IN DATABASE,LOGIN,PASSWORD,
TRANSACTION_SCOPE,SHOWSQL,ALIGN,START_ROW_NUM)
CLIETTE "DTW_SQL:$(DATABASE)"
- /usr/lpp/internet/db2www/db2/dtwcm ½ÇÇà
ÆÄÀÏÀ» »ç¿ëÇÏ¿© Live Connection °ü¸® ÇÁ·Î±×·¥À» ½ÃÀÛÇϽʽÿÀ. À¥¿ë Information Catalog Manager¿¡¼ µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅÍ¿¡
¾×¼¼½ºÇÒ ¼ö ÀÖµµ·Ï Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ¾î¾ß ÇÕ´Ï´Ù. Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÃÀ۵Ǹé À¥
¼¹ö¿¡¼ Live Connection °ü¸® ÇÁ·Î±×·¥ âÀ» ÃÖ¼ÒÈÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â
Net.Data Administration and Programming Guide¸¦ ÂüÁ¶ÇϽʽÿÀ.
ÁÖ: | Live Connection °ü¸® ÇÁ·Î±×·¥Àº db2www.ini
ÆÄÀÏ¿¡ ÁöÁ¤µÈ DB2 ÀνºÅϽº·Î ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
dtwcm ½ÇÇà ÆÄÀÏÀ» ½ÇÇàÇϱâ Àü¿¡
DB2 ȯ°æÀÌ ¼³Á¤µÇ¾î¾ß ÇÕ´Ï´Ù.
|
- ·Î±× ¾Æ¿ôÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ »ç¿ëÇϱâ Àü¿¡ ¼³Ä¡ ÈÄ »ç¿ëÀÚ Á¤ÀǴܰ踦 µû¸£½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡Çϱâ Àü¿¡ ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- À¥ ¼¹ö ¼ÒÇÁÆ®¿þ¾î°¡ À¥ ¼¹ö¿¡ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß ÇÕ´Ï´Ù.
- À¥ ¼¹ö¿¡ 80(ÀϹÝÀûÀÎ ±âº»°ª) ÀÌ¿ÜÀÇ Æ÷Æ® ¹øÈ£°¡ ÀÖÀ» °æ¿ì
http://hostname:portnumber/ À¥ ÁÖ¼ÒÀÇ È£½ºÆ® À̸§¿¡
Æ÷Æ® ¹øÈ£¸¦ Ãß°¡ÇϽʽÿÀ.
- Net.Data¸¦ ¼³Ä¡Çϸé À¥ ¼¹öÀÇ CGI-BIN ¹× HTML µð·ºÅ丮¸¦ ¹¯´Â
¸Þ½ÃÁö°¡ Ç¥½ÃµË´Ï´Ù. CGI ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ´Â À¥ ¼¹öÀÇ µð·ºÅ丮
¹× HTML ÆÄÀÏÀÇ ¹®¼ ·çÆ® µð·ºÅ丮¸¦ ÁöÁ¤ÇØ¾ß ÇÕ´Ï´Ù. Net.Data CGI
ÇÁ·Î±×·¥ db2www°¡ ÀÌ CGI-BIN µð·ºÅ丮¿¡
µé¾î°©´Ï´Ù. Net.Data DB2WWW.INI ÆÄÀÏÀº
¹®¼ ·çÆ® µð·ºÅ丮¿¡ µé¾î°©´Ï´Ù.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÏ·Á¸é ´ÙÀ½°ú °°ÀÌ ½ÇÇàÇϽʽÿÀ.
- ´ÙÀ½°ú °°ÀÌ À¥ ¼¹ö ¶Ç´Â Windows NT ¿öÅ©½ºÅ×À̼ǿ¡ À¥¿ë Information Catalog Manager ÆÄÀÏÀ»
¼³Ä¡ÇϽʽÿÀ.
- À¥ ¼¹ö ¿öÅ©½ºÅ×À̼ÇÀÇ CD-ROM µå¶óÀ̺꿡 DB2 Universal Database CD-ROMÀ»
³ÖÀ¸½Ê½Ã¿À. ±×·¯¸é ·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼ DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦ ´©¸¥ ÈÄ
´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¸¦ Á¦¿ÜÇÑ ¸ðµç ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
- ºÎ¼Ó ±¸¼º¿ä¼Ò¸¦ ´©¸£½Ê½Ã¿À.
- ºÎ¼Ó ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ À¥¿ë Information Catalog ManagerÀÇ
¼±ÅöõÀ» ¼±ÅÃÇÏ°í ´Ù¸¥ ¸ðµç ¼±ÅöõÀº Áö¿ö¾ß ÇÕ´Ï´Ù.
- °è¼ÓÀ» ´©¸£½Ê½Ã¿À.
- ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ Åë½Å ÇÁ·ÎÅäÄÝ ±¸¼º¿ä¼Ò,
ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ÀÎÅÍÆäÀ̽º ±¸¼º¿ä¼Ò ¹×
°ü¸® ¹× ±¸¼º µµ±¸ ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸ ±¸¼º¿ä¼Ò°¡ ¿©ÀüÈ÷ ¼±ÅõǾî
ÀÖ¾î¾ß ÇÕ´Ï´Ù.
- ´ÙÀ½À» ´·¯ ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ.
¼³Ä¡ ÇÁ·Î±×·¥¿¡¼ ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ¸¸µì´Ï´Ù.
- \sqllib\icmweb\macro
- \sqllib\icmweb\html
- \sqllib\icmweb\icons
- \sqllib\icuweb\macro µð·ºÅ丮¿¡¼
À¥ ¼¹öÀÇ \db2www\macro µð·ºÅ丮·Î
¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» º¹»çÇϰųª FTP¸¦ »ç¿ëÇÏ¿© 2ÁøÀ¸·Î
Àü¼ÛÇϽʽÿÀ. °ø¿ë Àб⠾׼¼½º¸¦ Çã¿ëÇϵµ·Ï ÆÄÀÏ »ç¿ë±ÇÇÑÀ»
¼³Á¤ÇϽʽÿÀ.
- \sqllib\icuweb\html µð·ºÅ丮¿¡¼
À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮·Î ¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» º¹»çÇϰųª
FTP¸¦ »ç¿ëÇÏ¿© 2ÁøÀ¸·Î Àü¼ÛÇϽʽÿÀ. °ø¿ë Àб⠾׼¼½º¸¦ Çã¿ëÇϵµ·Ï
ÆÄÀÏ »ç¿ë±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
- \sqllib\icuweb\icons µð·ºÅ丮¿¡¼
À¥ ¼¹öÀÇ ¾ÆÀÌÄÜ µð·ºÅ丮·Î ¸ðµç dg_*.gif ÆÄÀÏÀ» º¹»çÇϰųª FTP¸¦
»ç¿ëÇÏ¿© 2ÁøÀ¸·Î Àü¼ÛÇϽʽÿÀ. °ø¿ë Àб⠾׼¼½º¸¦ Çã¿ëÇϵµ·Ï ÆÄÀÏ
»ç¿ë±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
- dg_config.hti ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ.
ÆÄÀÏ ¹× ¼¹ö À̸§À» º¹»çÇÑ µð·ºÅ丮ÀÇ À̸§À» Ãß°¡ÇϽʽÿÀ. macro_path
º¯¼ö´Â »ç¿ëÀÚ ¾×¼¼½º¸¦ Á¦¾îÇϵµ·Ï À¥ ¼¹ö¿¡ ¼³Á¤µÈ º°¸íÀ¸·Î ¼³Á¤µÉ
¼ö ÀÖ½À´Ï´Ù.
- server_name º¯¼ö¸¦ »ç¿ëÇÏ¿© À¥ ¼¹ö¸¦ ½Äº°ÇϽʽÿÀ.
- image_path º¯¼öÀÇ °ªÀ» À¥ ¼¹ö ±¸¼º ÆÄÀÏ¿¡ Á¤ÀÇµÈ ICONS µð·ºÅ丮¿¡
¸ÊÇÎÇϽʽÿÀ.
- macro_path º¯¼öÀÇ °ªÀ» »ç¿ëÇÏ¿© icm/db2www
°æ·Î¸¦ ÁöÁ¤ÇϽʽÿÀ.
UNIX ¿î¿µ üÁ¦ÀÇ °æ¿ì, dg_config.hti
ÆÄÀÏÀº ´ÙÀ½°ú °°½À´Ï´Ù.
%DEFINE {
server_name="http://server.ibm.com/"
image_path="$(server_name)icons/"
macro_path="$(server_name)icm/db2www/"
help_path="$(server_name)"
%}
Windows NT ¹× OS/2 ¿î¿µ üÁ¦ÀÇ °æ¿ì
dg_config.hti ÆÄÀÏÀº ´ÙÀ½°ú °°½À´Ï´Ù.
%DEFINE {
server_name="http://server.ibm.com/"
image_path="$(server_name)icons/"
macro_path="$(server_name)icm/db2www.exe/"
help_path="$(server_name)"
%}
- ±âÁ¸ À¥ ÆäÀÌÁö¿¡ ¸µÅ©¸¦ Ãß°¡Çϰųª À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ´ëÇÑ
¸µÅ©·Î À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇϽʽÿÀ.
À¥ ÆäÀÌÁö¸¦ ÀÛ¼ºÇÏ·Á¸é
\document_root\icm.html(¿©±â¼
document_root´Â À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮) ÆÄÀÏÀ»
ÆíÁýÇϽʽÿÀ. °ø¿ë Àб⠾׼¼½º¸¦ Çã¿ëÇϵµ·Ï ÆÄÀÏ »ç¿ë±ÇÇÑÀ»
¼³Á¤ÇϽʽÿÀ.
- UNIX ¿î¿µ üÁ¦ÀÇ °æ¿ì ´ÙÀ½°ú °°Àº ÇàÀ» Ãß°¡ÇϽʽÿÀ.
<html><head>
<title>À¥¿ë Information Catalog Manager</title>
</head>
<body bgcolor=white>
<p><a href=/icm/db2www/dg_home.mac/Logon>
À¥¿ë Information Catalog Manager</a>
</body>
</html>
- Windows NT ¹× OS/2 ¿î¿µ üÁ¦ÀÇ °æ¿ì ´ÙÀ½°ú °°Àº ÇàÀ» Ãß°¡ÇϽʽÿÀ.
<html><head>
<title>À¥¿ë Information Catalog Manager</title>
</head>
<body bgcolor=white>
<p><a href=/icm/db2www.exe/dg_home.mac/Logon>
À¥¿ë Information Catalog Manager</a>
</body>
</html>
- À¥ ¼¹ö¿¡¼ °¢ À¥¿ë Information Catalog Manager »ç¿ëÀÚ¿¡ ´ëÇØ ±âº» »ç¿ëÀÚ ÀÎÁõÀ» »ç¿ëÇϽʽÿÀ.
À¥¿ë Information Catalog Manager Ȩ ÆäÀÌÁö¿¡ ¾×¼¼½ºÇÏ¸é »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯´Â ¸Þ½ÃÁö°¡
Ç¥½ÃµË´Ï´Ù. ÇØ´ç °ªÀ» ÀÔ·ÂÇϸé HTTP ȯ°æ º¯¼ö REMOTE_USER°¡
¼³Á¤µË´Ï´Ù. ÀÌ º¯¼ö´Â »ç¿ëÀÚ¿¡°Ô »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ¹¯°í ÁÖ¼®À»
ÀÛ¼ºÇϰí, °»½ÅÇÏ°í »èÁ¦ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù.
ÁÖ¼®ÀÌ ÀÛ¼ºµÉ ¶§ »ç¿ëÀÚ ID°¡ Á¤º¸ īŻ·Î±× Å×ÀÌºí¿¡ ÀúÀåµÇ¹Ç·Î,
»ç¿ëÀÚ ID´Â 8ÀÚ ÀÌÇÏ¿©¾ß ÇÕ´Ï´Ù.
- Net.Data CGI ÇÁ·Î±×·¥ db2www°¡ ÀÖ´Â
µð·ºÅ丮ÀÇ º°¸í icmÀ» ÀÛ¼ºÇϽʽÿÀ.
- º°¸í µð·ºÅ丮 icm¿¡ ´ëÇÑ »ç¿ëÀÚ ID ¹× ¾ÏÈ£ ÀÎÁõÀ» »ç¿ëÇϰí
ÀûÀýÇÑ »ç¿ë±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
ÀÎÁõ »ç¿ë¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â À¥ ¼¹ö ¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
- À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÏ´Â µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ Live Connection °ü¸® ÇÁ·Î±×·¥À»
½ÇÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ dtwcm.cnf¸¦
ÆíÁýÇÏ¿© À¥¿ë Information Catalog Manager¿¡¼ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL
ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
°³ÀÎ¿ë Æ÷Æ® ¹øÈ£ 7100 ¹× °ø¿ë Æ÷Æ® ¹øÈ£ 7110¿¡¼ ½ÃÀÛÇÏ¿© ÃÖ¼ÒÇÑ
ÇÁ·Î¼¼½º, ÃÖ´ë ¼¼ ÇÁ·Î¼¼½º·Î ICMSAMP µ¥ÀÌÅͺ£À̽º¸¦ Ãß°¡ÇÏ·Á¸é
´ÙÀ½°ú °°Àº ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
CLIETTE DTW_SQL:ICMSAMP{
MIN_PROCESS=1
MAX_PROCESS=3
START_PRIVATE_PORT=7100
START_PUBLIC_PORT=7110
EXEC_NAME=./dtwcdb2
DATABASE=ICMSAMP
BINDFILE=NOT_USED
LOGIN=*USE_DEFAULT
PASSWORD=*USE_DEFAULT
}
ÀÌ ºí·ÏÀº 6°³ÀÇ Æ÷Æ®(7100, 7101, 7102, 7110, 7111, 7112)¸¦ ICMSAMP
µ¥ÀÌÅͺ£À̽º¿¡ ÇÒ´çÇÕ´Ï´Ù. ÇØ´ç Æ÷Æ®°¡ »ç¿ë °¡´ÉÇÏ¸ç ´Ù¸¥
ÀÀ¿ëÇÁ·Î±×·¥¿¡¼ »ç¿ëÇÏÁö ¾Ê¾Æ¾ß ÇÕ´Ï´Ù. °¢ CLIETTE DTW_SQL ºí·Ï¿¡
´ëÇØ ´Ù¸¥ Æ÷Æ® ¹øÈ£ ¹üÀ§¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â
Net.Data Administration and Programming Guide¸¦ ÂüÁ¶ÇϽʽÿÀ.
- LOGIN °ªÀ» µ¥ÀÌÅͺ£À̽ºÀÇ »ç¿ëÀÚ ID·Î ¼³Á¤Çϰí PASSWORD °ªÀ» ¾ÏÈ£·Î
¼³Á¤ÇϽʽÿÀ. Áö¿ª µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÒ °æ¿ì *USE_DEFAULT
°ªÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
- SQL È£Ãâ¿¡ Live Connection °ü¸® ÇÁ·Î±×·¥À» »ç¿ëÇϵµ·Ï Net.Data ÃʱâÈ ÆÄÀÏÀ» ¼³Á¤ÇϽʽÿÀ.
À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮¿¡¼ db2www.ini
ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ. ȯ°æ DTW_SQL¹®ÀÌ CLIETTE "DTW_SQL:$(DATABASE)"·Î
³¡³ª¾ß ÇÕ´Ï´Ù.
¿¹:
ENVIRONMENT (DTW_SQL) DTWSQL(IN DATABASE,LOGIN,PASSWORD,
TRANSACTION_SCOPE,SHOWSQL,ALIGN,START_ROW_NUM)
CLIETTE "DTW_SQL:$(DATABASE)"
- Net.Data µð·ºÅ丮ÀÇ dtcmf ½ÇÇà ÆÄÀÏÀ»
»ç¿ëÇÏ¿© Live Connection °ü¸® ÇÁ·Î±×·¥À» ½ÃÀÛÇϽʽÿÀ. À¥¿ë Information Catalog Manager¿¡¼ µ¥ÀÌÅͺ£À̽ºÀÇ µ¥ÀÌÅÍ¿¡
¾×¼¼½ºÇÒ ¼ö ÀÖµµ·Ï Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÇÇàµÇ¾î¾ß ÇÕ´Ï´Ù. Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÃÀ۵Ǹé À¥
¼¹ö¿¡¼ Live Connection °ü¸® ÇÁ·Î±×·¥ âÀ» ÃÖ¼ÒÈÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ Á¤º¸´Â
Net.Data Administration and Programming Guide¸¦ ÂüÁ¶ÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ »ç¿ëÇϱâ Àü¿¡ ¼³Ä¡ ÈÄ »ç¿ëÀÚ Á¤ÀǴܰ踦 µû¸£½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÑ ÈÄ ´ÙÀ½ÀÇ ´Ü°è¸¦ ¿Ï·áÇÏ¿© À¥¿ë Information Catalog Manager¸¦ »ç¿ëÀÚ Á¤ÀÇÇϽʽÿÀ.
- dg_home.hti ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¿¡¼ ¾×¼¼½ºÇÏ·Á´Â °¢ Á¤º¸ īŻ·Î±×¿¡ ´ëÇÑ ¸µÅ©¸¦ Ãß°¡ÇϽʽÿÀ.
¸µÅ©¿¡ ´ëÇØ ´ÙÀ½°ú °°Àº Çü½ÄÀ» »ç¿ëÇϽʽÿÀ.
<LI><A HREF=$(macro_path)dg_frame.mac/frame?DATABASE=xxxx> zzzz </A>
- xxxx
- Á¤º¸ īŻ·Î±× µ¥ÀÌÅͺ£À̽º À̸§(¿¹: ICMSAMP)
- zzzz
- À¥ ÆäÀÌÁö¿¡ Ç¥½ÃµÇ´Â ±â¼úÀûÀÎ ÁÖ¼®(¿¹: CelDial »ùÇà īŻ·Î±×)
Á¤º¸ īŻ·Î±× ¸ñ·Ï ¾Õ ¶Ç´Â µÚ¿¡ ÀÖ´Â dg_home.hti ÆÄÀÏ¿¡ HTML ű׸¦
Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ·± ű׿¡´Â Ãß°¡ÇÏ·Á´Â ¸µÅ©, À̹ÌÁö, ÅØ½ºÆ® ¶Ç´Â
´Ù¸¥ À¯È¿ÇÑ HTML 3.2 űװ¡ Æ÷Ç﵃ ¼ö ÀÖ½À´Ï´Ù.
- Çʼö DB2 Ŭ¶óÀÌ¾ðÆ® ±â´ÉÀ» »ç¿ëÇÏ¿© ¼¹ö ³ëµå ¹× µ¥ÀÌÅͺ£À̽º¸¦
īŻ·Î±×ÈÇϽʽÿÀ. ÀÚ¼¼ÇÑ Á¤º¸´Â ¼³Ä¡ ¹× ±¸¼º º¸Ãæ ¼³¸í¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
DB2 ¸í·ÉÇà 󸮱⿡¼ À¥ ¼¹ö°¡ µ¥ÀÌÅͺ£À̽º·Î ¿¬°áÇÒ ¼ö ÀÖ´ÂÁö È®ÀÎÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ ÅëÇØ Á¤º¸ īŻ·Î±×¿¡ ¾×¼¼½ºÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º °ü¸®
ÇÁ·Î±×·¥ÀÌ µ¥ÀÌÅͺ£À̽º ¼¹ö¿¡¼ ½ÃÀ۵ǰí, Live Connection °ü¸® ÇÁ·Î±×·¥ÀÌ À¥ ¼¹ö¿¡¼
½ÃÀ۵ǰí, À¥ ¼¹ö°¡ ½ÃÀ۵Ǿî¾ß ÇÕ´Ï´Ù.
»ç¿ëÀÚ¿¡°Ô »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÅëÁöÇϰí, À¥¿ë Information Catalog Manager¿¡ ¾×¼¼½ºÇÏ´Â µ¥
»ç¿ëÇÒ ¼ö ÀÖ´Â À¥ ÁÖ¼Ò¸¦ ¾Ë·Á ÁֽʽÿÀ.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]