1.0 ¼Ò°³
2.0 ¾Ë·ÁÁø ¹®Á¦Á¡
2.1 À¥ °³¹ß ȯ°æ
2.2 WebSphere Application Server µð¹ö±ë
2.3 JavaScript µð¹ö°Å
2.4 SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å
2.5 Å×½ºÆ® ¹× Àü°³ µµ±¸(¼¹ö µµ±¸)
2.6 JDT µð¹ö°Å
2.7 ÀÚ±¹¾î Á¦ÇÑ»çÇ×
2.8 SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å(Linux)
2.9 SQLJ µð¹ö°Å
WebSphere StudioÀÇ µð¹ö°Å¿¡¼´Â À¥ ÀÀ¿ëÇÁ·Î±×·¥, ¼¹öÃø JavaScript, Java, SQLJ, SQL ÀúÀå ÇÁ·Î½ÃÀú ¹× ÄÄÆÄÀÏµÈ ¾ð¾î µð¹ö±×¿¡ ÇÊ¿äÇÑ µµ±¸¸¦ Á¦°øÇÕ´Ï´Ù. ÀÌ Readme ÆÄÀÏÀº WebSphere Studio µð¹ö°Å¿Í ¿¬°üµÈ Á¦ÇÑ»çÇ×°ú ¾Ë·ÁÁø ¹®Á¦Á¡¿¡ ´ëÇØ ¼³¸íÇÕ´Ï´Ù.
JSP µð¹ö±ë:
- JSP ÆÄÀÏÀº WebSphere Application Server¿¡¼ Å×½ºÆ®ÇÒ ¶§ µð¹ö±×µÉ ¼ö ÀÖ½À´Ï´Ù. Tomcat ¼¹ö¿¡¼ Å×½ºÆ®ÇÒ °æ¿ì, µð¹ö°Å´Â JSP Áß´ÜÁ¡¿¡¼ ÁßÁöÇÏÁö ¾Ê½À´Ï´Ù.
- Áß´ÜÁ¡À» JSP ÆÄÀÏÀÇ ´ÙÀ½ ű׿¡¼ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- ¾ç½ÄÀÇ JSP scriptlet: <% %>
- ¾ç½ÄÀÇ JSP Ç¥Çö½Ä: <%= %>
- ¾ç½ÄÀÇ JSP ¼±¾ð: <%! %>
- jsp:useBean, jsp:getProperty ¹× jsp:setProperty ű×
- »ç¿ëÀÚ Á¤ÀÇ Å±×
- Áß´ÜÁ¡À» ´ÙÀ½ ÅÂ±× ¼¼Æ®¿¡ ´ëÇØ ¼³Á¤ÇÒ ¼ö ¾ø½À´Ï´Ù.
- HTML ÄÚµå
- JSP Áö½Ã¹®
- ±âŸ ¸ðµç Ç¥ÁØ JSP ű×(jsp:include, jsp:forward µî)
- ÀÌÀü ¹öÀüÀÇ WebSphere Studio¿¡¼ ÇöÀç ¹öÀüÀ¸·Î ÀÛ¾÷°ø°£À» ÀÌÁÖÇÒ °æ¿ì, JSP Áß´ÜÁ¡À» »èÁ¦ÇÏ°í ´Ù½Ã ÀÛ¼ºÇØ¾ß ÇÕ´Ï´Ù.
- ´Ü°èº° µð¹ö±× ¸ðµå´Â EJB Ȩ ¸Þ¼Òµå¿¡ ´ëÇØ ½ÇÆÐÇÕ´Ï´Ù: WebSphere Application Server µð¹ö±× ¾î´ðÅ͸¦ »ç¿ëÇÏ¿© µð¹ö±× ¼¼¼ÇÀ» ½ÇÇàÇÒ °æ¿ì, ´Ü°èº° µð¹ö±× ¸ðµå´Â EJB Ȩ ¸Þ¼Òµå¿¡ ´ëÇØ ÁßÁöÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ ¸Þ¼Òµå¸¦ µð¹ö±×ÇÏ·Á¸é Áß´ÜÁ¡À» »ç¿ëÇϽʽÿÀ.
- Java¿¡¼ Javascript·ÎÀÇ step returnÀº Áö¿øµÇÁö ¾Ê½À´Ï´Ù: Java¿¡¼ Javascript ÄÚµå·Î ´Ù½Ã ¸®ÅÏÇÏ·Á¸é Áß´ÜÁ¡À» »ç¿ëÇϽʽÿÀ.
- JSP µð¹ö±ë:
- ´Ü°èº° µð¹ö±×´Â ½ÇÇà °¡´É Äڵ尡 ¾ø´Â JSP¿¡ ´ëÇØ ÀÛµ¿ÇÏÁö ¾Ê½À´Ï´Ù.
- µð¹ö±× ¼¼¼ÇÀ» ½ÇÇàÇϱâ À§ÇØ WebSphere Application Server µð¹ö±× ¾î´ðÅ͸¦ »ç¿ëÇÏ´Â °æ¿ì, JSP º¯¼ö ¹× Ç¥Çö½ÄÀ» °Ë»çÇϰųª Ç¥½ÃÇÒ ¼ö ¾ø½À´Ï´Ù.
- Çà±îÁö ½ÇÇàÀº JSP¿¡¼ Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
- JSP Áß´ÜÁ¡À» ¼³Á¤ÇÏ¸é ¼Óµµ°¡ ´À¸± ¼ö ÀÖ½À´Ï´Ù. JSP Áß´ÜÁ¡ÀÌ ¸¹ÀÌ ÀÖ´Ù¸é, µð¹ö°Å¸¦ ÃʱâÈÇϴµ¥ ½Ã°£ÀÌ ´õ ÇÊ¿äÇÕ´Ï´Ù.
- JSP ¼±¾ð ºí·ÏÀÇ Á¤Àû º¯¼ö¿¡ ¼³Á¤µÈ Áß´ÜÁ¡ÀÌ ÀÛµ¿ÇÏÁö ¾Ê°Ô µÇ¸ç ´Ù¸¥ Áß´ÜÁ¡ ¹®Á¦°¡ ¹ß»ýÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
- È÷Æ® °è¼ö, Á¶°Ç, ¼±ÅÃµÈ ½º·¹µå ¹× VM ÀϽÃÁß´Ü Á¤Ã¥°ú °°Àº Áß´ÜÁ¡ Ư¼ºÀº JSP Áß´ÜÁ¡¿¡ Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
- µð¹ö°Å ÆíÁý±â¿¡¼ Java Áß´ÜÁ¡À» ¼³Á¤ÇÏÁö ¸¶½Ê½Ã¿À: Java Áß´ÜÁ¡Àº Java ÆíÁý±â¿¡¼ ¼³Á¤µÇ¾î¾ß ÇÏ°í µð¹ö°Å ÆíÁý±â¿¡¼ ¼³Á¤Çؼ´Â ¾ÈµË´Ï´Ù.
- ¼Ò½º ÆÄÀÏ º¯°æ µð¹ö±× º¸±â ÆË¾÷ ¸Þ´º »ç¿ëÇϱâ: ½ºÅà ÇÁ·¹ÀÓ¿¡¼ ¼Ò½º ÆÄÀÏ º¯°æ ÆË¾÷ ¸Þ´º Ç׸ñÀ» »ç¿ëÇÏ¿© Ç¥½ÃµÈ ¼Ò½º ÆÄÀÏÀ» º¯°æÇÏ·Á´Â °æ¿ì, »õ ÆÄÀÏÀ» ÆíÁý±â¿¡¼ ¿ ¼ö ¾ø½À´Ï´Ù. À̸¦ ÇØ°áÇÏ·Á¸é ´Ù¸¥ ½ºÅà ÇÁ·¹ÀÓÀ» ´©¸¥ ÈÄ ¿ø·¡ ½ºÅà ÇÁ·¹ÀÓÀ» ´Ù½Ã ´©¸£½Ê½Ã¿À. ±×·± ´ÙÀ½, ÆíÁý±â¿¡¼ »õ ÆÄÀÏÀ» ¿¾î¾ß ÇÕ´Ï´Ù.
- µð¹ö±× ÄܼÖ: µð¹ö±× Äֿܼ¡¼ À¯ÇüÀ» ¿ ¼ö ÀÖ´Â ÇÏÀÌÆÛ¸µÅ©°¡ ÀÛµ¿ÇÏÁö ¾Ê½À´Ï´Ù.
- ÇÖ½º¿Ò ÈÄ ½ºÅà ÇÁ·¹ÀÓ ·¹À̺í: ÇÖ Äڵ带 ¹Ù²Ù¸é ÀϺΠ½ºÅà ÇÁ·¹ÀÓÀÇ ·¹À̺íÀÌ ´ÙÀ½°ú °°ÀÌ Ç¥½ÃµË´Ï´Ù.
<unknown receiving type>(<unknown declaring type>).<unknown method name>(<unknown arguments>) line: not available <unknown line number>´Ù¸¥ Perspective·Î ÀüȯÇÏ¿© ¿Ã¹Ù¸¥ ·¹À̺íÀ» °¡Á®¿Â ÈÄ ´Ù½Ã µð¹ö±× Perspective·Î ÀüȯÇÒ ¼ö ÀÖ½À´Ï´Ù.
- JavaScript ¿ÀºêÁ§Æ®´Â »ý¼ºÀÚ°¡ ¿Ï·áµÇ¾î¾ß °Ë»ç¿¡ »ç¿ë °¡´ÉÇÕ´Ï´Ù: »ý¼ºÀÚÀÇ ½ÇÇàÀ» ÅëÇØ ÁøÇàÇÒ ¼ö ÀÖÁö¸¸, ±¸¼ºÀÌ ¿Ï·áµÉ ¶§±îÁö ±¸¼ºµÇ°í ÀÖ´Â ¿ÀºêÁ§Æ®¸¦ Á¶»çÇÒ ¼ö ¾ø½À´Ï´Ù.(»ý¼ºÀÚ¸¦ Á¾·áÇß½À´Ï´Ù.)
- °Ç³Ê¶Ù±â ¹× ¸Ç À§ ½ºÅà ÇÁ·¹ÀÓ ¾Æ·¡ÀÇ ½ºÅà ÇÁ·¹ÀÓ: ¸Ç À§ ½ºÅà ÇÁ·¹ÀÓÀÌ ¾Æ´Ñ ½ºÅà ÇÁ·¹ÀÓÀÇ step over¿Í step returnÀº JavaScript¿¡¼ Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
- JSP include: JSP includeÀÇ JavaScript µð¹ö±ëÀº Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
- Àç±Í ÇÔ¼ö¿¡¼ ½ºÅ×ÇÎ: Àç±Í JavaScript ÇÔ¼ö¸¦ µð¹ö±ëÇÏ¿© Àç±Í ÇÔ¼ö¿¡¼ ½ºÅ×ÇÎÇÒ °æ¿ì, ½ÇÇà ·¹º§ÀÇ ¸Ç À§·Î ¸®Åϵ˴ϴÙ.
- ±â·Ï±â³ª inputStream º¯¼ö°¡ ÀÖ´Â ¿ÀºêÁ§Æ®¸¦ ÆîÄ¡Áö ¸¶½Ê½Ã¿À: JavaScript ¿ÀºêÁ§Æ® °Ë»ç ½Ã, º¯¼ö ±â·Ï±â³ª inputStreamÀÌ ÀÖ´Â ¿ÀºêÁ§Æ®¸¦ ÆîÄ¡Áö ¾Êµµ·Ï »ç¿ëÀÚ¿¡°Ô °æ°íÇÕ´Ï´Ù. À̰ÍÀÌ µð¹ö°ÅÀÇ ¹ÝÀÀÀ» ´À¸®°Ô ÇÒ ¼ö ÀÖ½À´Ï´Ù.
- Å×½ºÆ® ȯ°æ: WebSphere V5 Å×½ºÆ® ȯ°æÀ» »ç¿ëÇÒ °æ¿ì, JavaScript µð¹ö±×°¡ ÀÛµ¿ÇÏÁö ¾Ê½À´Ï´Ù. ÀÌ ¹®Á¦Á¡Àº APAR #PQ73036¿¡¼ ¼öÁ¤µÇ¾ú½À´Ï´Ù.
- µ¥ÀÌÅÍ Á¤ÀÇ ºäÀÇ µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿À°Å³ª »èÁ¦Çϸé Áß´ÜÁ¡ÀÇ ¼³Á¤À» ÀÒÀ» ¼ö ÀÖ½À´Ï´Ù: µ¥ÀÌÅÍ Á¤ÀÇ ºäÀÇ Æú´õ·Î µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿À±â Àü¿¡ SQL ÀúÀå ÇÁ·Î½ÃÀú¸¦ µð¹ö±×ÇÏ°í µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿À¸é, ÀÛ¼ºÇÑ ¸ðµç Çà Áß´ÜÁ¡À» ÀÒ°Ô µË´Ï´Ù. µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿À°í ³ª¸é, µð¹ö°Å´Â ¼Ò½º¸¦ º¸±â À§ÇØ ±× Æú´õ¸¦ »ç¿ëÇÕ´Ï´Ù. °¡Á®¿Â µ¥ÀÌÅͺ£À̽º Á¤º¸¸¦ »èÁ¦Çϸé, ´ÙÀ½¿¡ SQL ÀúÀå ÇÁ·Î½ÃÀú¸¦ µð¹ö±×ÇÏ·Á°í ÇÒ ¶§ Áß´ÜÁ¡ Á¤º¸¸¦ ¶ÇÇÑ ÀÒ°Ô µË´Ï´Ù. ÀÌ´Â µ¥ÀÌÅͺ£À̽º¸¦ óÀ½ °¡Á®¿ÔÀ» ¶§ ÀÒ¾î¹ö¸° Áß´ÜÁ¡À» º¹¿øÇÏÁö ¾Ê½À´Ï´Ù.
ÀÌ ¹®Á¦¸¦ ÇÇÇϱâ À§ÇØ ÀúÀå ÇÁ·Î½ÃÀú¸¦ µð¹ö±×Çϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º¸¦ °¡Á®¿Ã °ÍÀ» ±ÇÀåÇÕ´Ï´Ù.
- Java ÀúÀå ÇÁ·Î½ÃÀúÀÇ µð¹ö±ëÀº Áö¿øµÇÁö ¾Ê½À´Ï´Ù: ÆíÁý±â¿¡¼ »ç¿ëÀÚ´Â Java ÀúÀå ÇÁ·Î½ÃÀúÀÇ ¼Ò½º Äڵ忡 Áß´ÜÁ¡À» Ãß°¡ÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇÏÁö¸¸ Java ÀúÀå ÇÁ·Î½ÃÀúÀÇ µð¹ö±ëÀÌ ¾ÆÁ÷ Áö¿øµÇÁö ¾ÊÀ¸¹Ç·Î ÀÌ Áß´ÜÁ¡Àº ¹«½ÃµË´Ï´Ù.
- ÀúÀå ÇÁ·Î½ÃÀú À̸§ ±¸ºÐ: SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å´Â ½ºÅ°¸¶ ¶Ç´Â ÇÁ·Î½ÃÀú À̸§À» ±¸ºÐÇÏ¿© ÀúÀå ÇÁ·Î½ÃÀú¿¡ ´ëÇÑ Á¦ÇÑµÈ Áö¿øÀ» Á¦°øÇÕ´Ï´Ù. ÀÌ·¯ÇÑ ÇÁ·Î½ÃÀú´Â µ¥ÀÌÅÍ Á¤ÀÇ º¸±âÀÇ ÄÁÅØ½ºÆ® ¸Þ´º°¡ ¾Æ´Ñ ±¸¼º ½ÇÇà ´ëÈ »óÀÚ¿¡¼ ½ÇÇàÇØ¾ß ÇÕ´Ï´Ù.
- Ȱ¼ºÈ SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å ¼¼¼ÇÀ» µ¿½Ã¿¡ Çϳª ÀÌ»ó ¿ ¼ö ÀÖµµ·Ï Áö¿øÇÕ´Ï´Ù: ÀÌ Á¦Ç°ÀÇ ¹öÀü 5.0¿¡¼´Â Ȱ¼ºÈ SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å ¼¼¼ÇÀ» ÇÑ ¹ø¿¡ Çϳª ÀÌ»ó ¿ ¼ö ¾ø½À´Ï´Ù. ÀÌ Á¦ÇÑ»çÇ×Àº ÇØ´ç Á¦Ç°ÀÇ ¹öÀü 5.0.1 À̻󿡼 ´õ ÀÌ»ó Àû¿ëµÇÁö ¾Ê½À´Ï´Ù.
- FOR BIT DATA Àμö¸¦ °¡Áø ÀúÀå ÇÁ·Î½ÃÀú: FOR BIT DATA ¼Ó¼ºÀ» °¡Áø Àμö°¡ ÀÖ´Â ÀúÀå ÇÁ·Î½ÃÀú´Â WebSphere Studio SQL ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å·Î´Â µð¹ö±×µÇÁö ¾È½À´Ï´Ù.
- ÀÌÀü »ç¿ë °¡´ÉÇÑ Á¦Ç°¿¡¼ ÀÛ¼ºµÈ ½ÇÇà ±¸¼ºÀº ÇöÀç Á¦Ç°¿¡¼ ÀÎ½ÄµÉ ¼ö ¾ø½À´Ï´Ù: ÀÌ Á¦Ç°ÀÇ ÀÌÀü »ç¿ë °¡´ÉÇÑ ¹öÀüÀ» ¼³Ä¡Çß°í ÀúÀå ÇÁ·Î½ÃÀú µð¹ö°Å ½ÇÇà ±¸¼ºÀ» ÀÛ¼ºÇß´Ù¸é, ÀÌ Á¦Ç°ÀÇ ÇöÀç ¹öÀü°ú ÇÔ²² »ç¿ëµÉ °æ¿ì ½ÇÇà ±¸¼º ¼³Á¤ÀÌ ÀνĵÇÁö ¾Ê½À´Ï´Ù. ÀÌÀü »ç¿ë °¡´ÉÇÑ ¹öÀü¿¡¼ ÀúÀåµÈ ½ÇÇà ±¸¼º ¼³Á¤Àº Á¦Ç°ÀÇ ÇöÀç ¹öÀü¿¡¼ ¿·ÈÀ» ¶§ ±âº»°ªÀ¸·Î ´Ù½Ã µÇµ¹¸± ¼ö ÀÖ½À´Ï´Ù.
µð¹ö±× ¸ðµå¿¡¼ ¼¹ö ½ÇÇàÀ» ÇÒ °æ¿ì ´ÙÀ½À» °í·ÁÇϽʽÿÀ.
- ¼¹ö´Â µð¹ö±× ÀÌ¿ÜÀÇ ¸ðµå¿¡¼ ½ÇÇàµÉ ¶§º¸´Ù ´À¸®°Ô ½ÇÇàµË´Ï´Ù.
- WebSphere Application Server´Â JSP ÆäÀÌÁö¸¦ ÄÄÆÄÀÏÇÏ´Â µ¥ ¸Å¿ì ¿À·£ ½Ã°£ÀÌ °É¸³´Ï´Ù.
Java °³¹ß µµ±¸¿¡¼ ¾Ë·ÁÁø ¹®Á¦Á¡ ¹× Á¦ÇÑ»çÇ׿¡ ´ëÇÑ Á¤º¸´Â Java °³¹ß µµ±¸(JDT) ¸±¸®½º Á¤º¸¿Í Workbench(IDE) ¸±¸®½º Á¤º¸¿¡¼ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ Á¤º¸´Â ÀÌ Á¦Ç°°ú ÇÔ²² ¼³Ä¡µÈ ±âº» Á¦Ç° readme¿¡¼ ¿¬°áµÇ¾î ÀÖ½À´Ï´Ù.
- ¾ç¹æÇâ(BiDi) Á¦ÇÑ»çÇ×: ¿ø½Ã ÄÚµå ÆäÀÌÁö°¡ ¾Æ´Ñ ±âŸ ÄÚµå ÆäÀÌÁö¿¡¼ ÀÎÄÚµåµÈ JSP¸¦ µð¹ö±ëÇÒ °æ¿ì, µð¹ö°Å ÆíÁý±â¸¦ »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù.
- ÄÄÆÄÀÏµÈ ¾ð¾î µð¹ö°Å:
- 1¹ÙÀÌÆ®(SBCS) ½Ã½ºÅÛ¿¡¼ ÄÄÆÄÀÏµÈ ¾ð¾î µð¹ö°Å´Â 0x7F¸¦ ÃʰúÇÑ ¹®ÀÚ¸¦ Æ÷ÇÔÇÑ ÇÁ·Î±×·¥ ¸Å°³º¯¼öÀÇ Àü´Þ ¶Ç´Â ÇÁ·Î±×·¥ À̸§À» Áö¿øÇÏÁö ¾Ê½À´Ï´Ù.
- µð¹ö±× ´ë»ó À̸§ ¹× µð¹ö±× ´ë»ó Àμö¿¡¼ NL ¹®ÀÚÀÇ »ç¿ëÀº Áö¿øµÇÁö ¾Ê½À´Ï´Ù.
·ÎÄà µ¥ÀÌÅͺ£À̽º¿¡¼ SQL ÀúÀå ÇÁ·Î½ÃÀú¸¦ µð¹ö°ÅÇÒ °æ¿ì, ¿À·ù ¹øÈ£ SQL1224NÀ» ¼ö½ÅÇÒ ¼ö ÀÖ½À´Ï´Ù.
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL1224N ¿äû¿¡ ´ëÀÀÇϱâ À§ÇØ µ¥ÀÌÅͺ£À̽º ¿¡ÀÌÀüÆ®¸¦ ½ÃÀÛÇÒ ¼ö ¾ø¾ú°Å³ª, µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ Á¾·á ¶Ç´Â °Á¦ ½ÇÇà ¸í·É¿¡ µû¶ó µ¥ÀÌÅͺ£À̽º ¿¡ÀÌÀüÆ®¸¦ Á¾·áÇß½À´Ï´Ù. SQLSTATE=55032
ÀÌ´Â Linux Ä¿³ÎÀÇ ¹®Á¦ ¶§¹®ÀÔ´Ï´Ù(Linux Ä¿³Î Bugzilla ¹ö±× #351). ´ÙÀ½ Áö½Ã»çÇ×Àº CLI(Call Level Interface) ´ë½Å DB2ÀÇ TCPIP ¿¬°á ¸Þ¼Òµå¸¦ »ç¿ëÇÏ´Â(·çÇÁ¹éÀ¸·Î¼) ÇØ°á ¹æ¹ýÀÔ´Ï´Ù. ÀÌ ÇÁ·Î½ÃÀú¸¦ ÅëÇØ µð¹ö°Å´Â Àü°ú µ¿ÀÏÇÑ µ¥ÀÌÅͺ£À̽º º°¸íÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
- ¿ø°Ý DB2 Ŭ¶óÀÌ¾ðÆ®¿ë Æ÷Æ®°¡ ¼³Á¤µÇÁö ¾Ê¾ÒÀ» °æ¿ì, /etc/services¿¡¼ TCP/IP Æ÷Æ®¸¦ »ý¼ºÇϽʽÿÀ(¿¹: db2cdb2inst1 50000/tcp # DB2 connection service port). ±âÁ¸ ¿ø°Ý DB2 Ŭ¶óÀÌ¾ðÆ®¿ë Æ÷Æ®¸¦ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
¾Æ·¡ÀÇ ´Ü°è 2~7±îÁö ¼öÇàÇÏ·Á¸é DB2 ÀνºÅϽº ¼ÒÀ¯Àڷμ ·Î±×ÀÎÇØ¾ß ÇÕ´Ï´Ù.
- TCP/IP Åë½Å ÇÁ·ÎÅäÄÝ¿¡ ´ëÇÑ ¿¬°á °ü¸®ÀÚ¸¦ ½ÃÀÛÇÏ·Á¸é µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¸¦ ±¸¼ºÇϽʽÿÀ. ÀÌ ÀÛ¾÷ÀÌ ÀÌ¹Ì ¼öÇàµÇ¾ú´ÂÁö ¿©ºÎ°¡ ºÒÈ®½ÇÇÑ °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2set db2commÃâ·Â¿¡ Ű¿öµå tcpip°¡ ¾ø´Â °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© tcpip°¡ Æ÷ÇԵǵµ·Ï db2comm ·¹Áö½ºÆ®¸® º¯¼ö¸¦ °»½ÅÇØ¾ß ÇÕ´Ï ´Ù.
db2set db2comm=<existing protocol names>,tcpipdb2comm ·¹Áö½ºÆ®¸® º¯¼ö´Â µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ°¡ ½ÃÀÛµÉ ¶§ ¾î¶² ÇÁ·ÎÅäÄÝ ¿¬°á °ü¸®ÀÚ¸¦ »ç¿ëÇÒ °ÍÀÎÁö °áÁ¤ÇÕ´Ï´Ù. ½°Ç¥·Î Ű¿öµå¸¦ ºÐ¸®ÇÏ¿© ´ÙÁß Åë½Å ÇÁ·ÎÅäÄÝ¿¡ ´ëÇØ ÀÌ º¯¼ö¸¦ ¼³Á¤ÇÒ ¼ö ÀÖ½À´Ï´Ù(¿¹: db2set db2comm=tcpip,appc).
db2comm ·¹Áö½ºÆ®¸® ¸Å°³º¯¼ö¿¡ ÀÇÇØ ÁöÁ¤µÈ ÇÁ·ÎÅäÄÝ¿¡ ´ëÇØ ¿¬°á °ü¸®ÀÚ¸¦ ½ÃÀÛÇϱâ À§Çؼ´Â db2start ¸í·ÉÀ» ´Ù½Ã ¹ßÇàÇØ¾ß ÇÕ´Ï´Ù. ¾Æ·¡ ´Ü°è 7¿¡¼ DB2¸¦ ´Ù½Ã ½ÃÀÛÇÒ °ÍÀ̹ǷÎ, Áö±Ý ÇÏÁö ¾Ê¾Æµµ µË´Ï´Ù.
.- /etc/services(´Ü°è 1)¿¡ Á¤ÀÇµÈ ¿¬°á ¼ºñ½º À̸§À¸·Î SVCENAME µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±¸¼º ¸Å°³º¯¼ö¸¦ °»½ÅÇϽʽÿÀ.
ÇöÀç SVCENAME ¼³Á¤À» Á¡°ËÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 get dbm cfg | grep -i svcenameSVCENAME ¼³Á¤À» °»½ÅÇØ¾ß ÇÒ °æ¿ì, ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 update dbm cfg using svcename <connection service name>¿©±â¼ <connection service name>Àº ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇϸç, /etc/services¿¡ ÀÖ´Â ¼ºñ½º Æ÷Æ® À̸§°ú ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù(¿¹:db2 update dbm cfg using svcename db2cdb2inst1).
µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ±¸¼º °»½ÅÀº ´ÙÀ½ db2start ¸í·ÉÀÌ ¹ßÇàµÉ ¶§±îÁö È¿°ú¸¦ °®Áö ¾Ê½À´Ï´Ù. ÀÌ ÀÛ¾÷Àº ¾Æ·¡ ´Ü°è 7¿¡¼ ÇÕ´Ï´Ù.
- ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇÏ¿© ·çÇÁ¹é ³ëµå¸¦ īŻ·Î±×ÇϽʽÿÀ.
db2 catalog tcpip node <nodename> remote 127.0.0.1 server <connection service name>¿©±â¼ <nodename>Àº īŻ·Î±×µÉ ³ëµåÀÇ ·ÎÄà º°¸íÀÔ´Ï´Ù. À̰ÍÀº ¿öÅ©½ºÅ×ÀÌ¼Ç »óÀÇ ÀÓÀÇÀû À̸§À¸·Î, ³ëµå ½Äº°¿¡ »ç¿ëµË´Ï´Ù(¿¹: db2 catalog tcpip node mynode remote 127.0.0.1 server db2cdb2inst1).
īŻ·Î±× ¸í·ÉÀÌ Á¦´ë·Î ÀÛµ¿ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.
db2 list node directoryÀÌ ¸í·ÉÀÇ »ùÇà Ãâ·ÂÀº ´ÙÀ½°ú °°½À´Ï´Ù(ÆíÀÇ»ó, ºó ÁÙÀº Á¦°ÅµÇ¾ú½À´Ï´Ù).
³ëµå µð·ºÅ丮
µð·ºÅ丮ÀÇ Ç׸ñ ¼ö = 1
³ëµå 1 Ç׸ñ:
³ëµå À̸§ = MYNODE
ÁÖ¼® =
ÇÁ·ÎÅäÄÝ = TCPIP
È£½ºÆ® À̸§ = 127.0.0.1
¼ºñ½º À̸§ = db2cdb2inst1- µ¥ÀÌÅͺ£À̽º¸¦ ´ÙÀ½°ú °°ÀÌ Ä«Å»·Î±×ÇϽʽÿÀ. °¢ ¸í·ÉÀÇ È¿°ú¸¦ ÃßÀûÇÏ·Á¸é, ¾Æ·¡ ÁÖ¾îÁø ¸í·ÉÀ» ÂüÁ¶ÇÏ¿© »ùÇà Ãâ·ÂÀ» »ý¼ºÇϽʽÿÀ.
- db2 catalog db <database name> as <database alias>
- db2 uncatalog db <database name>
- db2 catalog db <database alias as <database name> at node <nodename>
¿¹:
db2 catalog db WAS as WASLOOP
db2 uncatalog db WAS
db2 catalog db WASLOOP as WAS at node MYNODEÂü°í:
- µ¥ÀÌÅͺ£À̽º º°¸íÀº ¿øÇÏ´Â ´ë·Î ÁöÁ¤ÇÒ ¼ö ÀÖÁö¸¸, µ¥ÀÌÅͺ£À̽º À̸§°ú µ¿ÀÏÇØ¼´Â ¾ÈµË´Ï´Ù.
- µ¥ÀÌÅͺ£À̽º°¡ Á¦´ë·Î īŻ·Î±×µÇÁö ¾ÊÀ¸¸é ¿À·ù º¯È£ SQL1334NÀ» ¼ö½ÅÇÏ°Ô µË´Ï´Ù.
- ÀúÀå ÇÁ·Î½ÃÀú¸¦ µð¹ö±×ÇϰíÀÚ ÇÏ´Â ¸ðµç µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ ´Ü°è 5a~5c¸¦ ¹Ýº¹ÇØ¾ß ÇÕ´Ï´Ù.
´Ü°è 5a~5c¿¡ ´ëÇÑ »ùÇà Ãâ·Â
´Ü°è 5a Àü¿¡ WAS ·ÎÄà µ¥ÀÌÅͺ£À̽º°¡ ÀÌ¹Ì ÀÛ¼ºµÇ¾ú½À´Ï´Ù. ¸í·É db2 list db directoryÀÇ Ãâ·ÂÀº ´ÙÀ½°ú °°½À´Ï´Ù.
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮
µð·ºÅ丮ÀÇ Ç׸ñ ¼ö = 1
µ¥ÀÌÅͺ£À̽º 1 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WAS
µ¥ÀÌÅͺ£À̽º À̸§ = WAS
·ÎÄà µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/ctsui
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = °£Á¢
īŻ·Î±× ³ëµå ¹øÈ£ = 0´Ü°è 5a ÀÌÈÄ¿¡ db2 list db directoryÀÇ Ãâ·ÂÀº ´ÙÀ½°ú °°½À´Ï´Ù.
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮
µð·ºÅ丮ÀÇ Ç׸ñ ¼ö = 2
µ¥ÀÌÅͺ£À̽º 1 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WAS
µ¥ÀÌÅͺ£À̽º À̸§ = WAS
·ÎÄà µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/ctsui
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = °£Á¢
īŻ·Î±× ³ëµå ¹øÈ£ = 0
µ¥ÀÌÅͺ£À̽º 2 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WASLOOP
µ¥ÀÌÅͺ£À̽º À̸§ = WAS
·ÎÄà µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/ctsui
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = °£Á¢
īŻ·Î±× ³ëµå ¹øÈ£ = 0´Ü°è 5b ÀÌÈÄ¿¡ db2 list db directoryÀÇ Ãâ·ÂÀº ´ÙÀ½°ú °°½À´Ï´Ù.
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮
µð·ºÅ丮ÀÇ Ç׸ñ ¼ö = 1
µ¥ÀÌÅͺ£À̽º 1 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WASLOOP
µ¥ÀÌÅͺ£À̽º À̸§ = WAS
·ÎÄà µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/ctsui
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = °£Á¢
īŻ·Î±× ³ëµå ¹øÈ£ = 0´Ü°è 5c ÀÌÈÄ¿¡ db2 list db directoryÀÇ Ãâ·ÂÀº ´ÙÀ½°ú °°½À´Ï´Ù.
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮
µð·ºÅ丮ÀÇ Ç׸ñ ¼ö = 2
µ¥ÀÌÅͺ£À̽º 1 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WAS
µ¥ÀÌÅͺ£À̽º À̸§ = WASLOOP
³ëµå À̸§ = MYNODE
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = ¿ø°Ý
īŻ·Î±× ³ëµå ¹øÈ£ = -1
µ¥ÀÌÅͺ£À̽º 2 Ç׸ñ:
µ¥ÀÌÅͺ£À̽º º°¸í = WASLOOP
µ¥ÀÌÅͺ£À̽º À̸§ = WAS
·ÎÄà µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 = /home/ctsui
µ¥ÀÌÅͺ£À̽º ¸±¸®½º ·¹º§ = 9.00
ÁÖ¼® =
µð·ºÅ丮 ÀÔ·Â À¯Çü = °£Á¢
īŻ·Î±× ³ëµå ¹øÈ£ = 0
catalog db ¸í·ÉÀÌ Á¦´ë·Î ÀÛµ¿ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½ µÎ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ(¾Æ·¡ »ùÇà Ãâ·ÂÀ» ÂüÁ¶ÇϽʽÿÀ).
db2 connect to wasloop
db2 connect to was¿©±â¼, db2 connect to wasloop´Â ¿¬°á Á¤º¸¸¦ ÀμâÇϰí db2 connect to was´Â SQL1403NÀ» Á¦½ÃÇØ¾ß ÇÕ´Ï´Ù.
db2 connect to wasloopÀÇ »ùÇÃ Ãâ·Â:
µ¥ÀÌÅͺ£À̽º ¿¬°á Á¤º¸
½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮µ¥ÀÌÅͺ£À̽º ¼¹ö = DB2/6000 6.1.0
SQL 񀀥 ID = CTSUI
·ÎÄà µ¥ÀÌÅͺ£À̽º º°¸í = WASLOOPdb2 connect to wasÀÇ »ùÇà Ãâ·Â:
SQL1403N Á¦°øµÈ »ç¿ëÀÚ À̸§ ¹×/¶Ç´Â ¾ÏÈ£°¡ ¿Ã¹Ù¸£Áö ¾Ê½À´Ï´Ù. SQLSTATE=08004- ÀÎÁõ ¸ÞÄ¿´ÏÁòÀ» Ŭ¶óÀÌ¾ðÆ® ÀÎÁõÀ¸·Î °»½ÅÇϽʽÿÀ. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϽʽÿÀ.
db2 update dbm cfg using authentication client
¸í·ÉÀÌ Á¦´ë·Î ÀÛµ¿ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© »õ ¼³Á¤À» Ç¥½ÃÇϽʽÿÀ.
db2 get dbm cfg
»ùÇÃ Ãâ·Â:
....
µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ÀÎÁõ (AUTHENTICATION) = CLIENT
....- µð·ºÅ丮 ij½Ã¸¦ »õ·Î °íÄ¡·Á¸é DB2¸¦ ´Ù½Ã ½ÃÀÛÇϽʽÿÀ. ¿¹¸¦ µé¸é, ´ÙÀ½°ú °°½À´Ï´Ù.
db2stop
db2start- WASÀÇ °æ¿ì, admin.config ÆÄÀÏÀ» °»½ÅÇÒ Çʿ䰡 ¾ø½À´Ï´Ù. Websphere ÀÀ¿ëÇÁ·Î±×·¥ÀÇ °æ¿ì, ±âÁ¸ µ¥ÀÌÅͼҽº ±¸¼ºÀ» º¯°æÇÒ Çʿ䰡 ¾ø½À´Ï´Ù.
- µ¥ÀÌÅͺ£À̽º¸¦ »èÁ¦ÇÏ·Á¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
- db2 attach to <nodename> user <userid> using <password>
- db2 drop db <database name>
¿¹: db2 attach to MYNODE user myid using mypasswd
db2 drop db WAS
J9 JVMÀ» µð¹ö±×ÇÏ¸é¼ ÇÖ½º¿ÒÀ» ½ÇÇàÇÒ ¶§ È£Ãâ ½ºÅÿ¡ SQLJ ¸Þ¼Òµå°¡ »ç¿ëµÇ¾úÀ¸¸é, ½ºÅÿ¡ ¾µ¸ð¾ø´Â ¸Þ¼Òµå°¡ ÀÖÀ½ ´ëÈ »óÀÚ°¡ ³ªÅ¸³³´Ï´Ù. ÇÖ½º¿ÒÀ» SQLJ Ŭ·¡½º¿¡ ½ÇÇàÇÏ¸é ±× Å¬·¡½º´Â JVM¿¡ ´Ù½Ã ·ÎµåµÇÁö¸¸, ´ÙÀ½¿¡ ±× Ŭ·¡½º¿¡ ÀÖ´Â ¸Þ¼Òµå°¡ È£ÃâµÉ ¶§±îÁö »õ Äڵ尡 ½ÇÇàµÇÁö ¾Ê½À´Ï´Ù.
SQLJ Ŭ·¡½º¸¦ ÇÖ½º¿ÒÇϸé, ÇöÀç µð¹ö±× ¼¼¼ÇÀÌ ÁøÇàµÇ´Â µ¿¾È ÀÌ Å¬·¡½º¿¡ ´ëÇØ SWLJ Áß´ÜÁ¡ÀÌ ÀÛµ¿µÇÁö ¾Ê½À´Ï´Ù.
(C) Copyright IBM Corporation 2000, 2003. All Rights Reserved.