Warehouse Manager ¼³Ä¡ ¾È³»¼
ÀÌ Àå¿¡¼´Â Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò, Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò, Á¤º¸ īŻ·Î±× »ç¿ëÀÚ ±¸¼º¿ä¼Ò ¹×
À¥¿ë Information Catalog Manager¿¡ ´ëÇÑ ¼³Ä¡ ÇÁ·Î¼¼½º¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.
»ç¿ëÀÚÀÇ °ü¸®ÀÚ°¡ Á¤º¸ īŻ·Î±×¸¦ ÀÛ¼ºÇϰųª ±âÁ¸ÀÇ Á¤º¸ īŻ·Î±×¸¦ ÀÌÁÖÇϱâ À§ÇØ
»ç¿ëÇÒ Windows NT ¿öÅ©½ºÅ×À̼ǿ¡ Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò°¡ Æ÷ÇÔµÈ Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦
¼³Ä¡ÇØ¾ß ÇÕ´Ï´Ù. ±× ´ÙÀ½, Windows 32ºñÆ® ¿î¿µ üÁ¦(Windows NT, Windows 95, Windows 98 ¶Ç´Â Windows 2000)°¡
¼öÇà ÁßÀÎ Ãß°¡ ¿öÅ©½ºÅ×À̼ǿ¡¼ Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÒ °ÍÀÎÁö ¶Ç´Â Á¤º¸ īŻ·Î±× »ç¿ëÀÚ
±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÒ °ÍÀÎÁö ¼±ÅÃÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¿öÅ©½ºÅ×À̼ÇÀº »ç¿ëÀÚÀÇ DB2 Universal Database°¡
À§Ä¡ÇÑ ¿öÅ©½ºÅ×À̼ǿ¡ ¿¬°áµÇ¾î¾ß ÇÕ´Ï´Ù.
(Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¿Í º°µµ·Î) Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò³ª Á¤º¸ īŻ·Î±× »ç¿ëÀÚ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÑ ÈÄ,
¼¹ö ³ëµå ¹× ¿ø°Ý Á¤º¸ īŻ·Î±×¸¦ µî·ÏÇØ¾ß ÇÕ´Ï´Ù. Information Catalog Manager »ç¿ëÀÚ ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
DB2 Universal Database ¹× Net.Data¸¦ Áö¿øÇÏ´Â ¿î¿µ üÁ¦·ÎºÎÅÍ, À¥¿ë Information Catalog Manager¸¦ »ç¿ëÇÏ¿© Á¤º¸ īŻ·Î±×¿¡
ÀÖ´Â ¸ÞŸµ¥ÀÌÅÍ¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÏ´Â ¿öÅ©½ºÅ×À̼ǿ¡´Â
Net.Data Live Connection Manager ¹× Net.Data Perl LE(Language Environment)µµ ¼³Ä¡µÇ¾î¾ß ÇÕ´Ï´Ù.
Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¿¡´Â Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò ¹× Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼°¡ Æ÷ÇԵ˴ϴÙ.
»ç¿ëÀÚÀÇ DB2 Universal Database¿¡ ´ëÇÑ ¿¬°á¼ºÀÌ ÀÖ´Â Windows NT ¶Ç´Â Windows 2000 ¿öÅ©½ºÅ×À̼ǿ¡
Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.
Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÏ·Á¸é,
- Warehouse Manager CD-ROMÀ» CD-ROM µå¶óÀ̺꿡 ³ÖÀ¸½Ê½Ã¿À. ·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼, DB2 Warehouse Manager ¼±ÅöõÀÌ ¼±ÅõǾú´ÂÁö
È®ÀÎÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦
´©¸£°í ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦
Á¦¿ÜÇÑ ¸ðµç ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
- ´ÙÀ½À» ´·¯ ¼³Ä¡ ÇÁ·Î±×·¥À» °è¼ÓÇϽʽÿÀ.
¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ¿Ï·áµË´Ï´Ù.
- AS/400 ¶Ç´Â OS/390¿¡¼ Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÒ °æ¿ì,
createic.bak ¹× flgnmwcr.bak ÆÄÀÏÀ» ã¾Æ¼ À̸§À» °¢°¢ createic.exe ¹× flgnmwcr.exe·Î ¹Ù²Ù½Ê½Ã¿À.
- Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇϽʽÿÀ. Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼ ¼öÇà¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ±¸¼º¿ä¼Ò¸¦ »ç¿ëÇÏ·Á¸é ¿ì¼± Á¤º¸ īŻ·Î±×¸¦ ÀÛ¼ºÇϰųª ±âÁ¸ÀÇ Á¤º¸ īŻ·Î±×¸¦
ÀÌÁÖ½ÃÄÑ¾ß ÇÕ´Ï´Ù. Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼´Â ´ÙÀ½°ú °°Àº ±â´ÉÀ» ¼öÇàÇÕ´Ï´Ù.
Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇÏ·Á¸é,
- DB2 Universal Database¿¡¼ µ¥ÀÌÅͺ£À̽º¸¦ ÀÛ¼ºÇϰųª, Á¤º¸ īŻ·Î±×°¡ Æ÷ÇÔµÈ
±âÁ¸ÀÇ µ¥ÀÌÅͺ£À̽º¸¦ ãÀ¸½Ê½Ã¿À.
- ½ÃÀÛ --> ÇÁ·Î±×·¥ --> IBM DB2 -->
Information Catalog Manager --> Á¤º¸ īŻ·Î±× Ãʱâȸ¦ ´©¸£½Ê½Ã¿À. Á¤º¸
īŻ·Î±× ÃʱâÈ Ã¢ÀÌ ¿¸³´Ï´Ù.
- Á¤º¸ īŻ·Î±× À¯ÇüÀ» ¼±ÅÃÇÑ ÈÄ È®ÀÎÀ» ´©¸£½Ê½Ã¿À.
Windows NT¿ë DB2 UDB¿¡¼ īŻ·Î±× Á¤ÀÇ Ã¢ÀÌ ¿¸³´Ï´Ù.
- ÇÊ¿äÇÑ Á¤º¸¸¦ ÀÔ·ÂÇϰí Á¤ÀǸ¦ ´©¸£½Ê½Ã¿À.
Á¤º¸ īŻ·Î±×¿¡ ¿¬°á âÀÌ ¿¸³´Ï´Ù.
- »ç¿ëÀÚ°¡ ÁöÁ¤ÇÑ Á¤º¸ īŻ·Î±×¿¡ ´ëÇÑ »ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÀÔ·ÂÇϰí
¿¬°áÀ» ´©¸£½Ê½Ã¿À.
Windows 32ºñÆ® ¿î¿µ üÁ¦(Windows NT, Windows 95, Windows 98 ¶Ç´Â Windows 2000)¿¡¼(Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¿Í º°µµ·Î) Á¤º¸ īŻ·Î±× °ü¸®ÀÚ
±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÏ·Á¸é,
- DB2 Universal Database CD-ROMÀ» CD-ROM µå¶óÀ̺꿡 ³ÖÀ¸½Ê½Ã¿À. ·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼, DB2 Enterprise Edition ¼¹ö
¼±Åöõ(¶Ç´Â ÇØ´çµÇ´Â °æ¿ì, DB2 Enterprise - Extended Edition ¼¹ö
¼±Åöõ) ¶Ç´Â DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦
´©¸£°í ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¿¡ ´ëÇÑ ¼±ÅöõÀ» ¼±ÅÃÇϰí ÇÏÀ§ ±¸¼º¿ä¼Ò¸¦
¼±ÅÃÇϽʽÿÀ.
- ÇÏÀ§ ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ Á¤º¸ īŻ·Î±× °ü¸®ÀÚ ÇÏÀ§
±¸¼º¿ä¼Ò¿¡ ´ëÇÑ ¼±ÅöõÀ» ¼±ÅÃÇϽʽÿÀ.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà âÀ¸·Î µ¹¾Æ°¡·Á¸é °è¼ÓÀ»
´©¸£°í ´ÙÀ½À» ´·¯ ¼³Ä¡ ÇÁ·Î±×·¥À» °è¼ÓÇϽʽÿÀ.
- ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ¿Ï·áµÇ¸é Warehouse Manager CD-ROM¿¡¼ Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò¸¦
¼³Ä¡ÇÑ ÈÄ(¾ÆÁ÷ ¼öÇàÇÏÁö ¾ÊÀº °æ¿ì) Á¤º¸ īŻ·Î±× ÃʱâÈ À¯Æ¿¸®Æ¼¸¦ ¼öÇàÇϽʽÿÀ.
Information Catalog Manager µµ±¸ ±¸¼º¿ä¼Ò ¼³Ä¡¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
Windows 32ºñÆ® ¿î¿µ üÁ¦(Windows NT, Windows 95, Windows 98 ¶Ç´Â Windows 2000)¿¡ Á¤º¸ īŻ·Î±× »ç¿ëÀÚ ±¸¼º¿ä¼Ò¸¦ ¼³Ä¡ÇÏ·Á¸é,
- DB2 Universal Database CD-ROMÀ» CD-ROM µå¶óÀ̺꿡 ³ÖÀ¸½Ê½Ã¿À. ·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼ DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇϰí, DB2 Enterprise Edition
¼±Åöõ(¶Ç´Â ÇØ´çµÇ´Â °æ¿ì, DB2 Enterprise - Extended Edition ¼±Åöõ)À»
Áö¿î ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦
´©¸£°í ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¸¦ Á¦¿ÜÇÑ ¸ðµç ¼±ÅöõÀ» Áö¿ì°í ÇÏÀ§ ±¸¼º¿ä¼Ò¸¦
´©¸£½Ê½Ã¿À.
- ÇÏÀ§ ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ Á¤º¸ īŻ·Î±× »ç¿ëÀÚ ÇÏÀ§ ±¸¼º¿ä¼Ò¿¡ ´ëÇÑ
¼±ÅöõÀ» ¼±ÅÃÇϽʽÿÀ.
- °è¼ÓÀ» ´·¯ ¼³Ä¡ ÇÁ·Î±×·¥À» °è¼ÓÇϽʽÿÀ.
- ¼³Ä¡ ÇÁ·Î±×·¥ÀÌ ¿Ï·áµÇ¸é ¼¹ö ³ëµå¿Í ¿ø°Ý Á¤º¸ īŻ·Î±×¸¦
µî·ÏÇϽʽÿÀ. Information Catalog Manager »ç¿ëÀÚ ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
DB2 Universal Database ¹× Net.Data¸¦ Áö¿øÇÏ´Â ¿î¿µ üÁ¦¿¡ À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ
¿î¿µ üÁ¦´Â Net.Data Live Connection Manager ¹× Perl LEµµ Áö¿øÇØ¾ß ÇÕ´Ï´Ù. ÀÌ ¿î¿µ üÁ¦¿¡´Â
Windows NT, OS/2, AIX, DYNIX/PTX ¹× Solaris°¡ Æ÷ÇԵ˴ϴÙ.
ÇÁ·Î±×·¥ ½ÃÀÛÀ» À§ÇÑ MIME À¯Çü ¼³Á¤¿¡ ´ëÇØ¼´Â Information Catalog Manager Administration Guide¸¦
ÂüÁ¶ÇϽʽÿÀ.
»ç¿ëÀÚ´Â À¥ ¼¹ö¿¡¼ ÀÎÁõÀ» »ç¿ëÇÒ ¼ö ÀÖ¾î¾ß ÇÕ´Ï´Ù. ÀÎÁõÀ» »ç¿ëÇÑ ÈÄ °¢ »ç¿ëÀÚ´Â
»ç¿ëÀÚ ID ¹× ¾ÏÈ£¸¦ ÀÔ·ÂÇÏ¿© À¥¿ë Information Catalog Manager¿¡ ¾×¼¼½ºÇØ¾ß ÇÕ´Ï´Ù. Net.Data Live Connection Manager´Â
µ¥ÀÌÅͺ£À̽º ¿¬°áÀ» °ü¸®ÇϹǷÎ, »ç¿ëÀÚ´Â µ¥ÀÌÅͺ£À̽º »ç¿ëÀÚ ID¿Í ¾ÏÈ£¸¦
¸ô¶óµµ µË´Ï´Ù.
Á¤º¸ īŻ·Î±×¿¡¼ÀÇ Á¤º¸ ¹Î°¨µµ¿¡ µû¶ó »ç¿ëÀÚ´Â À¥ ¼¹ö¿¡ ´ëÇÑ ÀûÀýÇÑ ·¹º§ÀÇ º¸¾ÈÀ»
±¸ÇöÇØ¾ß ÇÕ´Ï´Ù. À¥ ¼¹öÀÇ ÀÎÁõ ±â´ÉÀ» ³Ñ¾î¼´Â Ãß°¡ º¸¾ÈÀ» À§Çؼ, ¾ÏÈ£È
¹× ۰¡ ÀÖ´Â º¸¾È ÆÐŰÁö¸¦ ¼³Ä¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. °í±Þ À¥ ¼¹ö
º¸¾È¿¡ ´ëÇØ¼´Â IBM
SecureWay(R)(Websphere °è¿)
¹®¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡Çϱâ Àü¿¡,
- IBM HTTP À¥ ¼¹ö°¡ ¼³Ä¡µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
- À¥ ¼¹ö Æ÷Æ® ¹øÈ£¸¦ È®ÀÎÇϽʽÿÀ. À¥ ¼¹ö¿¡ 80(±âº»°ª)ÀÌ ¾Æ´Ñ Æ÷Æ®°¡ ÀÖ´Â
°æ¿ì, µµ¸ÞÀÎ À̸§À» ±¸¼ºÇÒ ¶§ À¥ ÁÖ¼Ò¿¡ Àִ ȣ½ºÆ® À̸§¿¡ Æ÷Æ® ¹øÈ£¸¦
Ãß°¡ÇϽʽÿÀ(¿¹: http://hostname:portnumber/).
- Net.Data ½ÇÇà ÆÄÀÏÀÌ Æ÷ÇԵǵµ·Ï À¥ ¼¹ö¿¡ icmÀ̶ó´Â µð·ºÅ丮¸¦
ÀÛ¼ºÇϽʽÿÀ(¿¹: \IBM HTTP Server\icm). ÀÌ
µð·ºÅ丮¸¦ Net.Data cgi-bin µð·ºÅ丮·Î ÁöÁ¤ÇϽʽÿÀ.
ÀÌ µð·ºÅ丮¿¡
db2www.exe ½ÇÇà ÆÄÀÏÀ» µÎ½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡ÇÏ·Á¸é,
- À¥¿ë Information Catalog Manager¸¦ »ç¿ëÀÚÀÇ À¥ ¼¹ö¿¡ ¼³Ä¡ÇÏ·Á¸é,
- DB2 Universal Database CD-ROMÀ» À¥ ¼¹ö ¿öÅ©½ºÅ×À̼ÇÀÇ CD-ROM µå¶óÀ̺꿡 ³ÖÀ¸½Ê½Ã¿À.
·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼ DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦
´©¸£°í ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¸¦ Á¦¿ÜÇÑ ¸ðµç ±¸¼º¿ä¼Ò¿¡ ´ëÇÑ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
- ÇÏÀ§ ±¸¼º¿ä¼Ò¸¦ ´©¸£½Ê½Ã¿À.
- ÇÏÀ§ ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, À¥¿ë Information Catalog Manager¿¡ ´ëÇÑ
¼±ÅöõÀÌ ¼±ÅÃµÇ°í ´Ù¸¥ ¸ðµç ¼±ÅöõÀÌ Áö¿öÁ³´ÂÁö È®ÀÎÇϽʽÿÀ.
- °è¼ÓÀ» Ŭ¸¯ÇϽʽÿÀ.
- ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, Åë½Å ÇÁ·ÎÅäÄÝ ±¸¼º¿ä¼Ò,
ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ÀÎÅÍÆäÀ̽º ±¸¼º¿ä¼Ò,
°ü¸® ¹× ±¸¼º µµ±¸ ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸ ±¸¼º¿ä¼Ò°¡ ¼±ÅÃµÈ »óÅÂÀÎÁö
È®ÀÎÇϽʽÿÀ.
- ´ÙÀ½À» ´·¯ ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ. ¼³Ä¡ ÇÁ·Î±×·¥Àº ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù.
- program files\sqllib\icmweb\macro
- program files\sqllib\icmweb\html
- program files\sqllib\icmweb\icons
- ¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» program
files\sqllib\icmweb\macro µð·ºÅ丮¿¡¼ Net.Data ¸ÅÅ©·Î µð·ºÅ丮(ÀϹÝÀûÀ¸·Î
\db2www\macro)·Î º¹»çÇϽʽÿÀ.
- ¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» program files\sqllib\icmweb\html¿¡¼ À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮(ÀϹÝÀûÀ¸·Î
\IBM HTTP Server\htdocs)·Î º¹»çÇϽʽÿÀ.
- ¸ðµç dg*.gif ÆÄÀÏÀ» program files\sqllib\icmweb\icons µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ À̹ÌÁö µð·ºÅ丮(ÀϹÝÀûÀ¸·Î \IBM HTTP Server\icons)·Î º¹»çÇϽʽÿÀ. ÀÌ µð·ºÅ丮´Â
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´Â 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>
- .htaccess¶ó´Â ÆÄÀÏÀ» AuthName, AuthType,
AuthUserFile°ú ÇÔ²² \IBM HTTP Server\icm µð·ºÅ丮¿¡
ÀÛ¼ºÇÏ°í ´ÙÀ½°ú °°ÀÌ ¼³Á¤µÈ ¸í·É¹®À» ¿ä±¸ÇϽʽÿÀ.
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 Manager¸¦ ¼öÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ \db2www\connect\dtwcm.cnf¸¦
ÆíÁýÇϰí, À¥¿ë Information Catalog Manager°¡ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL ºí·ÏÀ»
Ãß°¡ÇϽʽÿÀ.
ÃÖ¼ÒÇÑ ÇϳªÀÇ ÇÁ·Î¼¼½º¸¦ °¡Áø µ¥ÀÌÅͺ£À̽º ICMSAMP¸¦ Ãß°¡ÇÏ·Á¸é, °³ÀÎ¿ë Æ÷Æ® ¹øÈ£´Â
7100ºÎÅÍ ½ÃÀÛÇÏ°í °ø¿ë Æ÷Æ® ¹øÈ£´Â 7110ºÎÅÍ ½ÃÀÛÇÏ´Â ÃÖ´ë ¼¼ °¡Áö ÇÁ·Î¼¼½º°¡ ´ÙÀ½
ºí·ÏÀ» Ãß°¡ÇÕ´Ï´Ù.
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 Manager¸¦ »ç¿ëÇϵµ·Ï 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 Manager¸¦ ½ÃÀÛÇϽʽÿÀ. À¥¿ë Information Catalog Manager°¡ µ¥ÀÌÅͺ£À̽º¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖÀ¸·Á¸é Live Connection Manager°¡ ¼öÇà ÁßÀ̾î¾ß ÇÕ´Ï´Ù.
Live Connection Manager°¡
½ÃÀÛµÈ ÈÄ À¥ ¼¹öÀÇ Live Connection Manager âÀ» ÃÖ¼ÒȽÃų ¼ö ÀÖ½À´Ï´Ù. Net.Data Administration and Programming Guide¿¡¼
ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
À¥¿ë Information Catalog Manager¸¦ »ç¿ëÇϱâ Àü¿¡ ¼³Ä¡ ÈÄ »ç¿ëÀÚ Á¤ÀÇÀÇ ´Ü°è¸¦ µû¸£½Ê½Ã¿À.
À¥¿ë Information Catalog Manager¸¦ ¼³Ä¡Çϱâ Àü¿¡,
- IBM HTTP À¥ ¼¹ö°¡ ¼³Ä¡µÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
- À¥ ¼¹ö Æ÷Æ® ¹øÈ£¸¦ È®ÀÎÇϽʽÿÀ. À¥ ¼¹ö¿¡ 80(±âº»°ª)ÀÌ ¾Æ´Ñ Æ÷Æ®°¡ ÀÖ´Â
°æ¿ì, µµ¸ÞÀÎ À̸§À» ±¸¼ºÇÒ ¶§ À¥ ÁÖ¼Ò¿¡ Àִ ȣ½ºÆ® À̸§¿¡ Æ÷Æ® ¹øÈ£¸¦
Ãß°¡ÇϽʽÿÀ(¿¹: http://hostname:portnumber/).
- Net.Data ½ÇÇà ÆÄÀÏÀÌ Æ÷ÇԵǵµ·Ï À¥ ¼¹ö¿¡ icmÀ̶ó´Â
µð·ºÅ丮¸¦ ÀÛ¼ºÇϽʽÿÀ(¿¹:
/usr/lpp/HTTPServer/share/icm/). ÀÌ µð·ºÅ丮¸¦ Net.Data cgi-bin µð·ºÅ丮·Î ÁöÁ¤ÇϽʽÿÀ.
½ÇÇà ÆÄÀÏ db2www(ÀϹÝÀûÀ¸·Î
/usr/lpp/internet/server_root/cgi-bin µð·ºÅ丮¿¡
ÀÖÀ½)¸¦ ÀÌ µð·ºÅ丮¿¡ µÎ½Ê½Ã¿À.
- db2www.ini ÆÄÀÏ(ÀϹÝÀûÀ¸·Î
/usr/lpp/internet/server_root/pub/
µð·ºÅ丮¿¡ ÀÖÀ½)À» ¹®¼ ·çÆ® µð·ºÅ丮(ÀϹÝÀûÀ¸·Î
/usr/lpp/HTTPServer/share/htdocs)·Î
º¹»çÇϽʽÿÀ. 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 ¼³Ä¡ âÀÌ
¿¸³´Ï´Ù.
- ¼³Ä¡ »ç¿ë±ÇÀÌ ÀÖ´Â Á¦Ç°À» ¼±ÅÃÇϽʽÿÀ. Tab ۸¦ ´·¯ °Á¶Ç¥½ÃµÈ ¿É¼ÇÀ»
º¯°æÇϽʽÿÀ. ¿É¼ÇÀ» ¼±ÅÃÇϰųª ¼±Åà Ãë¼ÒÇÏ·Á¸é Enter¸¦ ´©¸£½Ê½Ã¿À.
¿É¼ÇÀ» ¼±ÅÃÇϸé, º°Ç¥°¡ ±× ¿·¿¡ Ç¥½ÃµË´Ï´Ù.
¼³Ä¡ÇÏ·Á´Â DB2 Á¦Ç°ÀÇ ¼±ÅÃÀû ±¸¼º¿ä¼Ò¸¦ ¼±ÅÃÇϰųª ¼±Åà Ãë¼ÒÇÏ·Á¸é,
»ç¿ëÀÚ Á¤ÀÇ ¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ.
¾ðÁ¦µç ÀÌÀü âÀ¸·Î µ¹¾Æ°¡·Á¸é Ãë¼Ò
¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ.
- DB2 Á¦Ç°°ú ±× ±¸¼º¿ä¼ÒÀÇ ¼±ÅÃÀ» ¸¶ÃÆÀ¸¸é, OK¸¦ ¼±ÅÃÇÏ¿© ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ.
DB2 Á¦Ç° ¶Ç´Â ±¸¼º¿ä¼ÒÀÇ ¼³Ä¡ µ¿¾È¿¡ ÇÊ¿äÇÑ Á¤º¸³ª Áö¿øÀ» ¾òÀ¸·Á¸é
µµ¿ò¸» ¿É¼ÇÀ» ¼±ÅÃÇϽʽÿÀ.
¼³Ä¡ ÇÁ·Î±×·¥Àº ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù.
- program files\sqllib\icmweb\macro
- program files\sqllib\icmweb\html
- program files\sqllib\icmweb\icons
- ¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ program
files\sqllib\icmweb\macro µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ Net.Data ¸ÅÅ©·Î
µð·ºÅ丮(ÀϹÝÀûÀ¸·Î /usr/lpp/internet/db2www/macro)·Î
º¹»çÇϽʽÿÀ. ÀÌ ÆÄÀÏ¿¡ ´ëÇÑ »ç¿ë±ÇÇÑÀ» °ø¿ë Àбâ·Î ¼³Á¤ÇÏ·Á¸é
chmod ugo+r *¸¦ ÀÔ·ÂÇϽʽÿÀ.
- ¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ program
files\sqllib\icmweb\html µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ ¹®¼ ·çÆ®
µð·ºÅ丮(ÀϹÝÀûÀ¸·Î /usr/lpp/HTTPServer/share/htdocs)·Î
º¹»çÇϽʽÿÀ. ÀÌ ÆÄÀÏ¿¡ ´ëÇÑ »ç¿ë±ÇÇÑÀ» °ø¿ë Àбâ·Î ¼³Á¤ÇÏ·Á¸é
chmod ugo+r *¸¦ ÀÔ·ÂÇϽʽÿÀ.
- ¸ðµç dg*.gif ÆÄÀÏÀ» Windows NT ¿öÅ©½ºÅ×À̼ÇÀÇ program
files\sqllib\icmweb\icons µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ À̹ÌÁö µð·ºÅ丮(ÀϹÝÀûÀ¸·Î
/usr/lpp/HTTPServer/share/icons)·Î º¹»çÇϽʽÿÀ. ÀÌ µð·ºÅ丮´Â
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´Â 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>
- .htaccess¶ó´Â ÆÄÀÏÀ» AuthName, AuthType, AuthUserFile°ú ÇÔ²²
/usr/lpp/HTTPServer/share/icm µð·ºÅ丮¿¡ ÀÛ¼ºÇÏ°í ´ÙÀ½°ú
°°ÀÌ ¼³Á¤µÈ ¸í·É¹®À» ¿ä±¸ÇϽʽÿÀ.
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 Manager¸¦ ¼öÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ /usr/lpp/internet/db2www/db2/dtwcm.cnf¸¦
ÆíÁýÇϰí, À¥¿ë Information Catalog Manager°¡ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
ÃÖ¼ÒÇÑ ÇϳªÀÇ ÇÁ·Î¼¼½º¸¦ °¡Áø µ¥ÀÌÅͺ£À̽º ICMSAMP¸¦ Ãß°¡ÇÏ·Á¸é, °³ÀÎ¿ë Æ÷Æ® ¹øÈ£´Â
7100ºÎÅÍ ½ÃÀÛÇÏ°í °ø¿ë Æ÷Æ® ¹øÈ£´Â 7110ºÎÅÍ ½ÃÀÛÇÏ´Â ÃÖ´ë ¼¼ °¡Áö ÇÁ·Î¼¼½º°¡ ´ÙÀ½
ºí·Ï¿¡ Ãß°¡µË´Ï´Ù.
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 Manager¸¦ »ç¿ëÇϵµ·Ï 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 Manager¸¦ ½ÃÀÛÇϽʽÿÀ. À¥¿ë Information Catalog Manager°¡ µ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ µ¥ÀÌÅÍ¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖµµ·Ï
Live Connection Manager°¡ ¼öÇà ÁßÀ̾î¾ß ÇÕ´Ï´Ù. Live Connection Manager°¡
½ÃÀÛµÈ ÈÄ À¥ ¼¹öÀÇ Live Connection Manager âÀ» ÃÖ¼ÒȽÃų ¼ö ÀÖ½À´Ï´Ù. Net.Data Administration and Programming Guide¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
- ÁÖ:
- Live Connection Manager´Â db2www.ini ÆÄÀÏ¿¡ ÁöÁ¤µÈ DB2 ÀνºÅϽº·Î
½ÃÀÛÇØ¾ß ÇÕ´Ï´Ù. DB2 ȯ°æÀº dtwcm ½ÇÇà ÆÄÀÏÀ» ¼öÇàÇϱâ Àü¿¡
¼³Á¤ÇØ¾ß ÇÕ´Ï´Ù.
- ·Î±×¾Æ¿ôÇϽʽÿÀ.
À¥¿ë 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¸¦ ¼³Ä¡ÇÏ·Á¸é,
- À¥¿ë Information Catalog Manager ÆÄÀÏÀ» »ç¿ëÀÚÀÇ À¥ ¼¹ö³ª Windows NT ¿öÅ©½ºÅ×À̼ǿ¡ ¼³Ä¡ÇϽʽÿÀ.
- DB2 Universal Database CD-ROMÀ» À¥ ¼¹ö ¿öÅ©½ºÅ×À̼ÇÀÇ CD-ROM µå¶óÀ̺꿡 ³ÖÀ¸½Ê½Ã¿À.
·±Ä¡ÆÐµå°¡ ¿¸³´Ï´Ù.
- ·±Ä¡ÆÐµå¿¡¼ ¼³Ä¡¸¦ ´©¸£½Ê½Ã¿À.
- Á¦Ç° ¼±Åà â¿¡¼ DB2 Administration Client
¼±ÅöõÀ» ¼±ÅÃÇÑ ÈÄ ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- ¼³Ä¡ À¯Çü ¼±Åà â¿¡¼ »ç¿ëÀÚ ¼³Ä¡¸¦
´©¸£°í ´ÙÀ½À» ´©¸£½Ê½Ã¿À.
- DB2 ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼ µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸
±¸¼º¿ä¼Ò¸¦ Á¦¿ÜÇÑ ¸ðµç ±¸¼º¿ä¼Ò¿¡ ´ëÇÑ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
- ÇÏÀ§ ±¸¼º¿ä¼Ò¸¦ ´©¸£½Ê½Ã¿À.
- ÇÏÀ§ ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, À¥¿ë Information Catalog Manager¿¡ ´ëÇÑ
¼±ÅöõÀÌ ¼±ÅÃµÇ°í ´Ù¸¥ ¸ðµç ¼±ÅöõÀÌ Áö¿öÁ³´ÂÁö È®ÀÎÇϽʽÿÀ.
- °è¼ÓÀ» Ŭ¸¯ÇϽʽÿÀ.
- ±¸¼º¿ä¼Ò ¼±Åà â¿¡¼, Åë½Å ÇÁ·ÎÅäÄÝ ±¸¼º¿ä¼Ò,
ÀÀ¿ëÇÁ·Î±×·¥ °³¹ß ÀÎÅÍÆäÀ̽º ±¸¼º¿ä¼Ò,
°ü¸® ¹× ±¸¼º µµ±¸ ±¸¼º¿ä¼ÒÀÇ ¼±ÅöõÀ» Áö¿ì½Ê½Ã¿À.
µ¥ÀÌÅÍ ¿þ¾îÇϿ콺 µµ±¸ ±¸¼º¿ä¼Ò°¡ ¼±ÅÃµÈ »óÅÂÀÎÁö
È®ÀÎÇϽʽÿÀ.
- ´ÙÀ½À» ´·¯ ¼³Ä¡¸¦ °è¼ÓÇϽʽÿÀ. ¼³Ä¡ ÇÁ·Î±×·¥Àº ´ÙÀ½ µð·ºÅ丮¿¡ ÆÄÀÏÀ» ÀÛ¼ºÇÕ´Ï´Ù.
- program files\sqllib\icmweb\macro
- program files\sqllib\icmweb\html
- program files\sqllib\icmweb\icons
- ¸ðµç *.mac ¹× *.hti ÆÄÀÏÀ» program files\sqllib\icuweb\macro
µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ \db2www\macro µð·ºÅ丮·Î º¹»çÇϰųª,
FTP¸¦ »ç¿ëÇÏ¿© 2ÁøÀ¸·Î Àü¼ÛÇϽʽÿÀ. °ø¿ë Àбâ
¾×¼¼½º¸¦ Çã¿ëÇÏ´Â ÆÄÀÏ »ç¿ë ±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
- ¸ðµç *.htm ¹× *.gif ÆÄÀÏÀ» program files\sqllib\icuweb\html
µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ ¹®¼ ·çÆ® µð·ºÅ丮·Î º¹»çÇϰųª, FTP¸¦ »ç¿ëÇÏ¿©
2ÁøÀ¸·Î Àü¼ÛÇϽʽÿÀ. °ø¿ë Àбâ
¾×¼¼½º¸¦ Çã¿ëÇÏ´Â ÆÄÀÏ »ç¿ë ±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
- ¸ðµç dg_*.gif ÆÄÀÏÀ» program
files\sqllib\icuweb\icons µð·ºÅ丮¿¡¼ À¥ ¼¹öÀÇ ¾ÆÀÌÄÜ µð·ºÅ丮·Î
º¹»çÇϰųª, FTP¸¦ »ç¿ëÇÏ¿© 2ÁøÀ¸·Î Àü¼ÛÇϽʽÿÀ. °ø¿ë Àбâ
¾×¼¼½º¸¦ Çã¿ëÇÏ´Â ÆÄÀÏ »ç¿ë ±ÇÇÑÀ» ¼³Á¤ÇϽʽÿÀ.
- dg_config.hti ÆÄÀÏÀ» ÆíÁýÇϽʽÿÀ. ÆÄÀÏ ¹× ¼¹ö À̸§À»
º¹»çÇÑ µð·ºÅ丮 À̸§À» Ãß°¡ÇϽʽÿÀ. macro_path º¯¼ö´Â »ç¿ëÀÚ ¾×¼¼½º¸¦ Á¦¾îÇϱâ À§ÇØ
»ç¿ëÀÚ À¥ ¼¹ö¿¡ ¼³Á¤µÈ º°¸í¿¡ ¼³Á¤µÉ ¼ö ÀÖ½À´Ï´Ù.
- server_name º¯¼ö¸¦ »ç¿ëÇÏ¿© »ç¿ëÀÚÀÇ À¥ ¼¹ö¸¦ ½Äº°ÇϽʽÿÀ.
- image_path º¯¼ö¿¡ ´ëÇÑ °ªÀ» À¥ ¼¹ö ±¸¼º ÆÄÀÏ¿¡ Á¤ÀÇµÈ ICONS µð·ºÅ丮¿¡ ¸ÊÇϽʽÿÀ.
- macro_path º¯¼ö °ªÀ» »ç¿ëÇÏ¿© icm/db2www °æ·Î¸¦
ÁöÁ¤ÇϽʽÿÀ.
UNIX(R) ¿î¿µ üÁ¦¿¡¼,
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 Manager¸¦ ¼öÇàÇϵµ·Ï Net.Data¸¦ ¼³Á¤ÇϽʽÿÀ.
- Net.Data ÆÄÀÏ dtwcm.cnf¸¦ ÆíÁýÇϰí
À¥¿ë Information Catalog Manager°¡ »ç¿ëÇÒ °¢ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ CLIETTE DTW_SQL ºí·ÏÀ» Ãß°¡ÇϽʽÿÀ.
ÃÖ¼ÒÇÑ ÇϳªÀÇ ÇÁ·Î¼¼½º¸¦ °¡Áø µ¥ÀÌÅͺ£À̽º ICMSAMP¸¦ Ãß°¡ÇÏ·Á¸é, °³ÀÎ¿ë Æ÷Æ® ¹øÈ£
7100ºÎÅÍ ½ÃÀÛÇÏ°í °ø¿ë Æ÷Æ® ¹øÈ£ 7110ºÎÅÍ ½ÃÀÛÇÏ´Â ÃÖ´ë ¼¼ °¡Áö ÇÁ·Î¼¼½º°¡ ´ÙÀ½
ºí·ÏÀ» Ãß°¡ÇÕ´Ï´Ù.
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 Manager¸¦ »ç¿ëÇϵµ·Ï 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 Manager¸¦ ½ÃÀÛÇϽʽÿÀ. Live Connection Manager´Â À¥¿ë Information Catalog Manager°¡
µ¥ÀÌÅͺ£À̽º¿¡¼ µ¥ÀÌÅÍ¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖµµ·Ï ¼öÇà ÁßÀ̾î¾ß ÇÕ´Ï´Ù. Live Connection Manager°¡
½ÃÀÛµÈ ÈÄ À¥ ¼¹öÀÇ Live Connection Manager âÀ» ÃÖ¼ÒȽÃų ¼ö ÀÖ½À´Ï´Ù.
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 Manager°¡ À¥ ¼¹ö¿¡¼ ½ÃÀ۵Ǹç, À¥ ¼¹ö°¡ ½ÃÀ۵ǴÂÁö
È®ÀÎÇϽʽÿÀ.
»ç¿ëÀÚ¿¡°Ô »ç¿ëÀÚ ID¿Í ¾ÏÈ£¸¦ ¾Ë·Á ÁÖ°í, À¥¿ë Information Catalog Manager¿¡ ¾×¼¼½ºÇϴµ¥ »ç¿ëÇÒ ¼ö ÀÖ´Â À¥ ÁÖ¼Ò¸¦
¾Ë¸®½Ê½Ã¿À.
Á¤º¸ īŻ·Î±× °ü¸®ÀÚ´Â ¼³Ä¡ ¼º°ø ¿©ºÎ¸¦ È®ÀÎÇÒ ¼ö ÀÖµµ·Ï »ùÇà ÇÁ·Î±×·¥À» Á¦°øÇÕ´Ï´Ù. ÇÁ·Î±×·¥Àº Á¤º¸ īŻ·Î±× °ü¸®ÀÚ¿¡
Æ÷ÇÔµÈ »ùÇà µ¥ÀÌÅ͸¦ ¼³Ä¡ÇÕ´Ï´Ù. ÀÌ »ùÇà µ¥ÀÌÅÍ´Â Information Catalog Manager »ç¿ëÀÚ ¾È³»¼ÀÇ ½Ã³ª¸®¿À¿¡¼
»ç¿ëµË´Ï´Ù.
Information Catalog Manager Administration Guide¿¡¼´Â »ùÇà Á¤º¸ īŻ·Î±× ÀÛ¼º ¹æ¹ý¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.
[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö ]