¿¬°á¼º º¸Ãæ ¼³¸í¼­

°¡Àå ÀϹÝÀûÀÎ DB2 Connect ¹®Á¦Á¡

ÀÌ Àý¿¡¼­´Â DB2 Connect¸¦ »ç¿ëÇÒ ¶§ ¹ß»ýÇÏ´Â ¿¬°á ¹®Á¦Á¡ÀÇ °¡Àå ÀϹÝÀûÀΠ¡Èĸ¦ ³ª¿­ÇÕ´Ï´Ù. °¢ °æ¿ì¸¶´Ù ´ÙÀ½ Ç׸ñÀÌ Á¦°øµË´Ï´Ù.

ÁÖ:

  1. ±ÇÀåµÇ´Â ¼ÒÇÁÆ®¿þ¾î ¼öÁ¤ ·¹º§¿¡ °üÇÑ °¡Àå ÃֽŠÁ¤º¸¸¦ ¾òÀ¸·Á¸é ÇØ´ç Á¦Ç°ÀÇ ºü¸¥ ½ÃÀÛ ¸Å´º¾ó°ú ÃֽЏ±¸®½º Á¤º¸¸¦ ÂüÁ¶ÇϽʽÿÀ.

  2. APPC Åë½ÅÀÇ Æ¯Á¤ ¸Þ½ÃÁö¿Í ¸®ÅÏ ÄÚµå Á¶ÇÕÀÇ °æ¿ì, SNA °¨Áö Äڵ嵵 Ç¥½ÃµÉ ¼ö ÀÖ½À´Ï´Ù. ÇöÀç´Â ƯÁ¤ ¸Þ½ÃÁö¿Í °ü·ÃµÈ SNA °¨Áö ÄÚµå Á¤º¸¸¦ SNA ¼­ºê½Ã½ºÅÛ¿¡¼­ ¾ò¾î¾ß ÇÕ´Ï´Ù.

    ¶§¶§·Î ½Ã½ºÅÛ ·Î±×¸¦ »ìÆìº½À¸·Î½á SNA °¨Áö Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì¿¡ ÇØ´çÇÏ´ÂÁöÀÇ ¿©ºÎ´Â »ç¿ëµÇ´Â SNA ¼­ºê½Ã½ºÅÛ¿¡ ´Þ·Á ÀÖÀ¸¸ç, ¾î¶² »óȲ¿¡¼­´Â °¨Áö ÄÚµå Á¤º¸¸¦ ¾ò±â À§ÇØ SNA ÃßÀûÀ» ÀÛµ¿½ÃÄÑ ¹®Á¦¸¦ ´Ù½Ã ¸¸µé¾î¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.

  3. °ÔÀÌÆ®¿þÀ̶ó´Â ¿ë¾î´Â DB2 Connect Enterprise Edition°ú °ü·ÃµË´Ï´Ù.

SQL0965 ¶Ç´Â SQL0969

¡ÈÄ

¸Þ½ÃÁö SQL0965¿Í SQL0969´Â AS/400¿ë DB2 Universal Database, OS/390¿ë DB2 Universal Database, MVS/ESA¿ë DB2 ¹× VM & VSE¿ë DB2¿¡¼­ ¼­·Î ´Ù¸¥ ¸®ÅÏ ÄÚµå ¹øÈ£·Î Á¦½ÃµÉ ¼ö ÀÖ½À´Ï´Ù.

µÑ Áß¿¡¼­ ÇϳªÀÇ ¸Þ½ÃÁö°¡ Ç¥½ÃµÉ ¶§ ±× ¸Þ½ÃÁö¸¦ Á¦½ÃÇÑ µ¥ÀÌÅͺ£À̽º ¼­¹ö Á¦Ç°À» ¾Ë¾Æ³»·Á¸é ¹®¼­¿¡¼­ ¿ø·¡ SQL Äڵ带 ã¾Æº¸¾Æ¾ß ÇÕ´Ï´Ù.

¼Ö·ç¼Ç

È£½ºÆ® µ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ ¼ö½ÅµÇ´Â SQL ÄÚµå´Â º¯È¯ÇÒ ¼ö ¾ø½À´Ï´Ù. ¿À·ù Äڵ带 ±âÃÊ·Î ¹®Á¦¸¦ Á¤Á¤ÇÑ ´ÙÀ½ ½ÇÆÐ ¸í·ÉÀ» ´Ù½Ã ½ÇÇàÇϽʽÿÀ.

CONNECTÁßÀÇ SQL1338

¡ÈÄ/¿øÀÎ

±âÈ£ ¸ñÀûÁö À̸§ÀÌ Á¤ÀǵÇÁö ¾Ê¾Ò°Å³ª Á¦´ë·Î Á¤ÀǵÇÁö ¾Ê¾Ò½À´Ï´Ù.

¿¹¸¦ µé¾î, APPC ³ëµå°¡ »ç¿ëµÇ°í DB2 ³ëµå µð·ºÅ丮¿¡¼­ ÁöÁ¤µÈ ±âÈ£ ¸ñÀûÁö À̸§ÀÌ Áö¿ª APPC Åë½Å ¼­ºê½Ã½ºÅÛ ±¸¼º¿¡ ÀÖ´Â CPI-C Ç׸ñ°ú ÀÏÄ¡ÇÏÁö ¾ÊÀ» ¶§ ÀÌ ¿À·ù°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.

¶Ç ´Ù¸¥ ¿øÀÎÀ¸·Î´Â ¸Ó½Å¿¡ µÑ ÀÌ»óÀÇ SNA ½ºÅÃÀÌ ¼³Ä¡µÈ °ÍÀÏ ¼ö ÀÖ½À´Ï´Ù. »ç¿ëÇÏ·Á°í ÇÏ´Â ½ºÅÃÀÌ ¸ÕÀú ÂüÁ¶µÇ´ÂÁö È®ÀÎÇÏ·Á¸é PATH¿Í LIBPATH¸¦ È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.

¼Ö·ç¼Ç

  1. DB2 ³ëµå µð·ºÅ丮 Ç׸ñ¿¡¼­ ÁöÁ¤µÈ CPICÂÊ Á¤º¸ ÇÁ·ÎÆÄÀÏ À̸§ÀÌ SNA ±¸¼º°ú ÀÏÄ¡ÇÏ´ÂÁö È®ÀÎÇϽʽÿÀ(ÀÌ ÇÁ·ÎÆÄÀÏ À̸§Àº ´ë¼Ò¹®ÀÚ¸¦ ±¸ºÐÇÕ´Ï´Ù).
  2. »ç¿ëÇÏ·Á´Â SNA ½ºÅÃÀ» ¸ÕÀú ÂüÁ¶ÇÏ´ÂÁö È®ÀÎÇÏ·Á¸é PATH¿Í LIBPATH¸¦ È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.

CONNECTÁßÀÇ SQL1403N

¡ÈÄ

SQL1403N Á¦°øµÈ »ç¿ëÀÚ À̸§ ¶Ç´Â ¾ÏÈ£°¡ Ʋ¸³´Ï´Ù.

¼Ö·ç¼Ç

  1. »ç¿ëÀÚ°¡ DB2 Connect ¿öÅ©½ºÅ×À̼ǿ¡¼­ ÀÎÁõÀ» ¹ÞÀ» ¼ö ¾ø½À´Ï´Ù. »ç¿ëÀÚ°¡ DB2 Connect ¿öÅ©½ºÅ×À̼ǿ¡¼­ ÀÎÁõÀ» ¹Þ±â·Î µÇ¾î ÀÖ´ÂÁö¸¦ ¾Ë¾Æº¸½Ê½Ã¿À.

    ÀÎÁõÀ» ¹Þ±â·Î µÇ¾î ÀÖÀ¸¸é, ÇÊ¿äÇÑ °æ¿ì CONNECT¹®¿¡ ¿Ã¹Ù¸¥ ¾ÏÈ£¸¦ Á¦°øÇÏ¿´´ÂÁö È®ÀÎÇϽʽÿÀ.

    ÀÎÁõÀ» ¹Þ±â·Î µÇ¾î ÀÖÁö ¾ÊÀ¸¸é, ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 Ç׸ñÀÌ AUTHENTICATION SERVER¸¦ »ç¿ëÇÏ¿© ¿Ã¹Ù¸£Áö ¾Ê°Ô īŻ·Î±×È­µÇ¾î ÀÖ½À´Ï´Ù. AUTHENTICATIONÀÌ ¸í½ÃÀûÀ¸·Î ÁöÁ¤µÇÁö ¾ÊÀ¸¸é À̰ÍÀÌ ±âº»°ªÀÔ´Ï´Ù. ÀÌ °æ¿ì¿¡´Â AUTHENTICATION DCS³ª CLIENT¸¦ »ç¿ëÇÏ¿© Ç׸ñÀ» ´Ù½Ã īŻ·Î±×È­ÇϽʽÿÀ.

  2. ¾ÏÈ£¸¦ ¸ñÇ¥ ¼­¹ö µ¥ÀÌÅͺ£À̽º·Î º¸³¾ ¼ö ¾ø½À´Ï´Ù. ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 Ç׸ñÀÌ AUTHENTICATION DCS¸¦ »ç¿ëÇÏ¿© īŻ·Î±×È­µÇ¾î ÀÖÀ¸¸é, DB2 Client¿¡¼­ ¸ñÇ¥ ¼­¹ö µ¥ÀÌÅͺ£À̽º·Î ¾ÏÈ£¸¦ Àü¼ÛÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, AIX¿Í °°Àº ƯÁ¤ Ç÷§Æû¿¡¼­´Â CONNECT¹®¿¡ ¾ÏÈ£¸¦ Á¦°øÇÏ´Â °æ¿ì¿¡¸¸ ¾ÏÈ£¸¦ ¾òÀ» ¼ö ÀÖ½À´Ï´Ù.

SQL5043N

¡ÈÄ

Çϳª ÀÌ»óÀÇ Åë½Å ÇÁ·ÎÅäÄÝ Áö¿øÀÌ ¼º°øÀûÀ¸·Î ½ÃÀÛµÇÁö ¾Ê¾Ò½À´Ï´Ù. ±×·¯³ª ÄÚ¾î µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±â´ÉÀº ¼º°øÀûÀ¸·Î ½ÃÀ۵Ǿú½À´Ï´Ù.

TCP/IP ÇÁ·ÎÅäÄÝÀÌ DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ ½ÃÀÛµÇÁö ¾Ê¾ÒÀ» °ÍÀÔ´Ï´Ù. ÀÌÀü¿¡´Â Ŭ¶óÀÌ¾ðÆ® ¿¬°á¿¡ ¼º°øÇßÀ» °ÍÀÔ´Ï´Ù.

diaglevel = 4À̸é db2diag.log¿¡ ´ÙÀ½°ú °°Àº À¯»çÇÑ Ç׸ñÀÌ µé¾î ÀÖÀ» °ÍÀÔ´Ï´Ù.

1997-05-30-14.09.55.321092   Instance:svtdbm5   Node:000
PID:10296(db2tcpcm)   Appid:none
common_communication  sqlcctcpconnmgr_child   Probe:46
DIA3205E Socket address "30090" configured in the TCP/IP
services file and
required by the TCP/IP server support is being used by another
process.

¼Ö·ç¼Ç

ÀÌ °æ°í´Â ¿ø°Ý Ŭ¶óÀÌ¾ðÆ®¿¡ ´ëÇØ °ÔÀÌÆ®¿þÀÌ·Î ÀÛ¿ëÇÏ´Â DB2 Connect¿¡¼­ Çϳª ÀÌ»óÀÇ Å¬¶óÀÌ¾ðÆ® Åë½Å ÇÁ·ÎÅäÄÝÀ» ó¸®Çϴµ¥ ¹®Á¦°¡ ÀÖÀ½À» ¾Ë¸®´Â ¡ÈÄÀÔ´Ï´Ù. ÀÌ ÇÁ·ÎÅäÄÝÀº TCP/IP ¹× APPC µîÀÌ µÉ ¼ö ÀÖÀ¸¸ç, ´ë°³ ¸Þ½ÃÁö´Â DB2 Connect¿¡ Á¤ÀÇµÈ Åë½Å ÇÁ·ÎÅäÄÝ Áß Çϳª°¡ Á¦´ë·Î ±¸¼ºµÇÁö ¾Ê¾ÒÀ½À» ³ªÅ¸³À´Ï´Ù.

DB2COMM ÇÁ·ÎÆÄÀÏ º¯¼ö°¡ Á¤ÀǵÇÁö ¾Ê¾Ò°Å³ª Á¦´ë·Î Á¤ÀǵÇÁö ¾ÊÀº °ÍÀÌ ÈçÇÑ ¿øÀÎÀÏ ¼ö ÀÖ½À´Ï´Ù. ÀϹÝÀûÀ¸·Î DB2COMM º¯¼ö¿Í µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º¿¡ Á¤ÀÇµÈ À̸§(¿¹: svcename, nname ¶Ç´Â tpname)°£ÀÇ ºÒÀÏÄ¡°¡ ¹®Á¦ÀÔ´Ï´Ù.

ÇϳªÀÇ °¡´ÉÇÑ ½Ã³ª¸®¿À´Â ÀÌÀü¿¡´Â ¿¬°áÀÌ ¼º°øÀûÀ̾ú´Ù°¡ ±¸¼ºÀÌ ¾Æ¹« °Íµµ º¯°æµÇÁö ¾ÊÀº »óÅ¿¡¼­ SQL5043 ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³­ °ÍÀÔ´Ï´Ù. À̰ÍÀº ¿ø°Ý ½Ã½ºÅÛÀÌ ¾î¶² ÀÌÀ¯·Î ÀÎÇØ ¿¬°áÀ» ºñÁ¤»óÀûÀ¸·Î Á¾·áÇÒ ¶§, TCP/IP ÇÁ·ÎÅäÄÝÀ» »ç¿ëÇÏ¸é ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¿À·ù°¡ ¹ß»ýµÉ ¶§ Ŭ¶óÀÌ¾ðÆ®¿¡´Â ¿©ÀüÈ÷ ¿¬°áÀÌ Á¸ÀçÇÏ´Â °ÍÀ¸·Î ³ªÅ¸³¯ ¼ö ÀÖÀ¸¸ç, ¾Æ·¡ÀÇ ¸í·ÉÀ» ½ÇÇàÇÔÀ¸·Î½á ´õ ÀÌ»óÀÇ °³ÀÔ ¾øÀÌ ¿¬°áÀ» º¹¿øÇÏ´Â °ÍÀÌ °¡´ÉÇØÁú ¼ö ÀÖ½À´Ï´Ù.

¾Æ¸¶ °ÔÀÌÆ®¿þÀÌ¿¡ ¿¬°áÇÑ Å¬¶óÀÌ¾ðÆ® Áß Çϳª´Â ¿©ÀüÈ÷ TCP/IP Æ÷Æ®¿¡ ÇÚµéÀ» °¡Áö°í ÀÖÀ» °ÍÀÔ´Ï´Ù. °ÔÀÌÆ®¿þÀÌ¿¡ ¿¬°áµÈ °¢ Ŭ¶óÀÌ¾ðÆ® ¸Ó½Å¿¡´Â ´ÙÀ½°ú °°Àº ÇÚµéÀÌ ÀÖ½À´Ï´Ù.

  1. db2 terminate
  2. db2stop

SQL30020

¡ÈÄ

SQL30020N ÈÄ¼Ó ¸í·É°ú SQL¹®ÀÇ ¼º°øÀûÀÎ ½ÇÇà¿¡ ¿µÇâÀ» ÁÙ ºÐ»ê ÇÁ·ÎÅäÄÝ ¿À·ù ¶§¹®¿¡ ½ÇÇàµÇÁö ¸øÇÏ¿´½À´Ï´Ù.

¼Ö·ç¼Ç

ÀÌ ¿À·ù°¡ ¹ß»ýÇÏ¸é ¼­ºñ½º¸¦ ¹Þ¾Æ¾ß ÇÕ´Ï´Ù.

db2dump µð·ºÅ丮¿¡¼­ ffdc dump(pid.000)°¡ ÀÖ´ÂÁö Á¡°ËÇÕ´Ï´Ù. ±×·± ÈÄ, db2fdump¸¦ »ç¿ëÇÏ¿© ÀÌ ´ýÇÁ ÆÄÀÏÀ» Çü½ÄÈ­ÇÏ°í °á°ú ÆÄÀÏ¿¡¼­ "ERROR"¸¦ »ìÆìº¾´Ï´Ù. MVS ABEND°¡ ¿©±â¿¡ ³ª¿­µÇ¾î ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì¿¡´Â MVS ÄܼÖÀ» È®ÀÎÇÏ¿© ÀÚ¼¼ÇÑ Á¤º¸¸¦ ¾Ë¾Æº¸°í MVS ¸Þ½ÃÁö¿Í ÄÚµå ¸Å´º¾óÀÇ DB2 ºÎºÐ¿¡¼­ ÀÌ»ó Á¾·á Äڵ带 »ìÆìº¾´Ï´Ù.

SQL30060

¡ÈÄ

SQL30060N "<±ÇÇÑ ºÎ¿© ID>"¿¡°Ô Á¶ÀÛ <operation>À» ¼öÇàÇÒ ¼ö Àִ Ư±ÇÀÌ ¾ø½À´Ï´Ù.

¼Ö·ç¼Ç

MVS¿ë DB2³ª OS/390¿ë DB2¿¡ ¿¬°áÇÒ ¶§, Åë½Å µ¥ÀÌÅͺ£À̽º(CDB) Å×À̺íÀÌ Á¦´ë·Î °»½ÅµÇÁö ¾Ê¾Ò½À´Ï´Ù. ´ÙÀ½ ¼³¸í¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.

SQL30061

¡ÈÄ

À߸øµÈ È£½ºÆ®³ª AS/400 µ¥ÀÌÅͺ£À̽º ¼­¹ö¿¡ ¿¬°áÇϰí ÀÖ½À´Ï´Ù. ¸ñÇ¥ µ¥ÀÌÅͺ£À̽º¸¦ ãÀ» ¼ö ¾ø½À´Ï´Ù.

¼Ö·ç¼Ç

À߸øµÈ ¼­¹ö µ¥ÀÌÅͺ£À̽º À̸§ÀÌ DCS µð·ºÅ丮 Ç׸ñ¿¡ ÁöÁ¤µÇ¾úÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¿À·ù°¡ ¹ß»ýÇϸé SQLCODE -30061ÀÌ ÀÀ¿ëÇÁ·Î±×·¥¿¡ ¸®Åϵ˴ϴÙ.

DB2 ³ëµå, µ¥ÀÌÅͺ£À̽º ¹× DCS µð·ºÅ丮 Ç׸ñÀ» Á¡°ËÇØ º¸½Ê½Ã¿À. DCS µð·ºÅ丮 Ç׸ñÀÇ ¸ñÇ¥ µ¥ÀÌÅͺ£À̽º À̸§ Çʵ尡 Ç÷§Æû¿¡ ÀÖ´Â µ¥ÀÌÅͺ£À̽º À̸§°ú ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù. ¿¹¸¦ µé¾î, OS/390¿ë DB2 Universal Database µ¥ÀÌÅͺ£À̽ºÀÇ °æ¿ì, »ç¿ëµÉ À̸§ÀÌ BSDS(Boot Strap Data Set) "LOCATION=locname" Çʵ忡 »ç¿ëµÈ À̸§°ú °°¾Æ¾ß Çϴµ¥, ÀÌ Çʵ忡 »ç¿ëµÈ À̸§Àº DDF(Distributed Data Facility)°¡ ½ÃÀÛµÉ ¶§ DSNL004I ¸Þ½ÃÁö(LOCATION=À§Ä¡)¿¡µµ Á¦°øµË´Ï´Ù.

DB2 Connect ºü¸¥ ½ÃÀÛ ¸Å´º¾ó¿¡ DB2 īŻ·Î±× °»½Å ¹æ¹ýÀ» º¸¿©ÁÖ´Â ¿¹°¡ µé¾î ÀÖ½À´Ï´Ù. SNA ±¸¼ºÀ» ¼³¸íÇÑ °¢ Àå¿¡¼­ "DB2 µð·ºÅ丮 °»½Å" ÀýÀ» ÂüÁ¶Çϰųª "DB2 ConnectÀÇ È£½ºÆ® ¹× AS/400 µ¥ÀÌÅͺ£À̽º ±¸¼º" Àå°ú "TCP/IP ¿¬°á ±¸¼º" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ.

APPC ¶Ç´Â APPN ³ëµå¿¡ ´ëÇÑ ¿Ã¹Ù¸¥ ¸í·ÉÀº ´ÙÀ½°ú °°½À´Ï´Ù.

   db2 catalog appc node <node_name> remote <sym_dest_name> security program
   db2 catalog dcs database <local_name> as <real_db_name>
   db2 catalog database <local_name> as <alias> at node <node_name>
                authentication dcs

TCP/IP ³ëµå¿¡ ´ëÇÑ ¿Ã¹Ù¸¥ ¸í·ÉÀº ´ÙÀ½°ú °°½À´Ï´Ù.

   db2 catalog tcpip node <node_name> remote <host_name_or_address>
                server <port_no_or_service_name>
   db2 catalog dcs database <local_name> as <real_db_name>
   db2 catalog database <local_name> as <alias> at node <node_name>
                authentication dcs

±×·± ÈÄ, µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÏ·Á¸é ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.

   db2 connect to <alias> user <user_name> using <password>

CONNECT½Ã ¸®ÅÏ ÄÚµå 119C¸¦ ¼ö¹ÝÇÑ SQL30073

¡ÈÄ

¸Þ½ÃÁö SQL30073Àº ¸®ÅÏ ÄÚµå 119C¿Í ÇÔ²² ¹ßÇàµË´Ï´Ù. ÀÌ ¿À·ù´Â ¸ñÇ¥ ¼­¹ö µ¥ÀÌÅͺ£À̽º°¡ DB2 Ŭ¶óÀÌ¾ðÆ®¿¡ »ç¿ëµÈ ÄÚµå ÆäÀÌÁö¸¦ Áö¿øÇÏÁö ¾ÊÀ» ¶§ ¹ß»ýÇÕ´Ï´Ù(DB2 Connect¸¦ °æÀ¯ÇÔ). ÄÚµå ÆäÀÌÁö´Â DB2 Ŭ¶óÀÌ¾ðÆ®°¡ ¼öÇàµÇ´Â ¿î¿µ ȯ°æÀÇ ±¸¼º¿¡¼­ °¡Á®¿Â °ÍÀÔ´Ï´Ù.

°ü¸® ¾È³»¼­¿¡¼­ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.

¼Ö·ç¼Ç

ÀÌ ¹®Á¦´Â Á¾Á¾ ¸ñÇ¥ ¼­¹ö µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ¿¡ ¼öÁ¤ ÆÐÄ¡¸¦ ¼³Ä¡ÇÏ¿© ÇØ°áÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇØ´ç ¼­ºñ½º ºÎ¼­¿¡ ¿¬¶ôÇÏ¿© ÀÌ Â¡ÈÄ¿¡ ´ëÇØ ±Ç°íÇÏ´Â ¼öÁ¤ ÆÐÄ¡¸¦ ¾ò¾î ¼³Ä¡ÇϽʽÿÀ.

ÀϽÃÀûÀÎ ÇØ°áÃ¥À¸·Î »ç¿ëÀÚ´Â DB2CODEPAGE ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇÏ¿© ±âº» ÄÚµå ÆäÀÌÁö¸¦ °ãÃľµ ¼ö ÀÖ½À´Ï´Ù. ·ÎÄÉÀÏÀ» È®ÀÎÇϰųª DB2CODEPAGE=850À¸·Î ¼³Á¤ÇϽʽÿÀ.

UNIX Ç÷§ÆûÀÇ »ç¿ëÀÚ´Â LANG ȯ°æ º¯¼ö¸¦ ´Ù¸¥ °ªÀ¸·Î ¼³Á¤ÇÏ¿© ´Ù¸¥ ÄÚµå ÆäÀÌÁö·Î ÀüȯÇÒ ¼ö ÀÖ½À´Ï´Ù.

¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁö¿Í SNA °¨Áö ÄÚµåÀÔ´Ï´Ù.

  db2 connect to <database name> user <userid>
  Enter password for <userid>:
  SQL30081N  A communication error has been detected.
  Communication protocol
  being used: "APPC".  Communication API being used: "CPI-C".
  Location where
  the error was detected: "".  Communication function detecting
  the error:
  "cmallc".  Protocol specific error code(s): "1", "*",
  "0x10030021".
  SQLSTATE=08001

¼Ö·ç¼Ç

ÀÌ »ùÇÿ¡¼­ °¨Áö ÄÚµå´Â 10030021ÀÔ´Ï´Ù.

ÀÌ ¿À·ù ¸Þ½ÃÁö¿¡ °ü·ÃµÈ °¡Àå ÀϹÝÀûÀÎ °¨Áö ÄÚµå¿Í °¢ °æ¿ì¿¡ Á¦¾ÈµÇ´Â ¼Ö·ç¼ÇÀº ´ÙÀ½°ú °°½À´Ï´Ù.

  1. ¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú sna °¨Áö ÄÚµå 0877002C
    

    Ʋ¸° ³×Æ®¿öÅ© À̸§ÀÌ ÁöÁ¤µÇ¾ú½À´Ï´Ù.

  2. ¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå ffff0003
    

    Ʋ¸° MAC ÁÖ¼Ò°¡ ÁöÁ¤µÇ¾ú°Å³ª SNA ¸µÅ©°¡ »ç¿ëÁßÀÌ ¾Æ´Õ´Ï´Ù.

  3. ¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå 10030021
    

    LU À¯ÇüÀÌ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.

  4. ¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå 084B6031
    

    DSNZPARM(MVS¿ë DB2³ª OS/390 È£½ºÆ®¿ë DB2¿¡¼­)ÀÇ MAXDBAT°¡ 0À¸·Î ¼³Á¤µÇ¾ú½À´Ï´Ù.

´ÙÀ½Àº ´Ù¸¥ Á¦¾ÈÀÔ´Ï´Ù.

  1. Áö¿ª LU ÇÁ·ÎÆÄÀÏÀ» ÀÛ¼ºÇÒ ¶§ LU¸¦ ±âº» LU·Î Á¤ÀÇÇϽʽÿÀ. ¿¹¸¦ µé¾î, CM/2ÀÇ SNA ±â´É ¸ñ·Ï ÆÐ³Î¿¡¼­ ´ÙÀ½ Áß Çϳª¸¦ ¼öÇàÇϽʽÿÀ.
  2. DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ SNA°¡ ½ÃÀ۵ǴÂÁö Á¡°ËÇϽʽÿÀ.
  3. MVS¿ë DB2³ª OS/390¿ë DB2¸¦ »ç¿ëÁßÀÎ °æ¿ì, DDF(Distributed Data Facility) ÁÖ¼Ò °ø°£ÀÌ ½ÃÀ۵ǴÂÁö¿Í ÇØ´ç DB2°¡ ¼öÇàÁßÀÎÁö È®ÀÎÇϽʽÿÀ.

¸®ÅÏ ÄÚµå 2¸¦ ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

¸Þ½ÃÁö SQL30081NÀÌ ¸®ÅÏ ÄÚµå 2 ¹× SNA °¨Áö ÄÚµå 08120022¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.

¼Ö·ç¼Ç

NCP(¸µÅ©ÀÇ È£½ºÆ® ÂÊ)¿¡¼­ NUMILU ¸Å°³º¯¼ö°¡ ±âº»°ª(0)À¸·Î ¼³Á¤µÇ¾úÀ» ¼ö ÀÖ½À´Ï´Ù. À̸¦ È®ÀÎÇϽʽÿÀ. º¯°æ »çÇ×À» Àû¿ëÇÑ ÈÄ Àç½ÃµµÇϱâ Àü¿¡ ÇÊ¿äÇÑ °æ¿ì NCP Á¤ÀǸ¦ ¼öÁ¤ÇϽʽÿÀ.

¸®ÅÏ ÄÚµå 9¸¦ ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁöÀÔ´Ï´Ù(ÀÌ °æ¿ì¿¡´Â SNA °¨Áö Äڵ尡 ÇÊ¿ä¾ø½À´Ï´Ù).

   db2 connect to <database> user <userid>
   SQL30081N  A communication error has been detected.
   Communication protocol
   being used: "APPC".  Communication API being used: "CPI-C".
   Location where
   the error was detected: "".  Communication function detecting
   the error:
   "cmsend".  Protocol specific error code(s): "9", "*",
   "0x10086021".
   SQLSTATE=08001

¼Ö·ç¼Ç

Æ®·£Àè¼Ç ÇÁ·Î±×·¥ À̸§(TPNAME)ÀÌ DB2 Connect ½Ã½ºÅÛ¿¡¼­ ¿Ã¹Ù¸£°Ô Á¤ÀǵÇÁö ¾ÊÀº °ÍÀÌ ¹®Á¦ÀÔ´Ï´Ù. ¿¹¸¦ µé¾î, SNA ±¸¼ºÀ» °»½ÅÇßÁö¸¸ DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ ¾ÆÁ÷ È®ÀÎÇÏÁö´Â ¾Ê¾ÒÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÚ¼¼ÇÑ »çÇ×Àº OS/2 ¹× Windows¿ë DB2 Connect Enterprise Edition ºü¸¥ ½ÃÀÛÀ̳ª DB2 Connect Personal Edition ºü¸¥ ½ÃÀÛ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.

¸®ÅÏ ÄÚµå 10À» ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁöÀÔ´Ï´Ù(SNA °¨Áö Äڵ尡 ÇÊ¿ä¾ø½À´Ï´Ù).

   SQL30081N  A communication error has been detected.
   Communication protocol
   being used: "APPC".  Communication API being used: "CPI-C".
   Location where
   the error was detected: "".  Communication function detecting
   the error:
   "cmrcv".  Protocol specific error code(s): "10", "*", "*".
   SQLSTATE=08001

¼Ö·ç¼Ç

DB2°¡ ¿Ã¹Ù¸£°Ô ¼³Ä¡µÇ¾ú´ÂÁö °¨ÁöÇϽʽÿÀ.

OS/2¿ë DB2 Connect °ÔÀÌÆ®¿þÀ̸¦ »ç¿ëÇϰí ÀÖÀ¸¸é ´ÙÀ½°ú °°Àº ¸Þ½ÃÁö¸¦ º¼ ¼ö ÀÖ½À´Ï´Ù.

   Protocol specific error code(s): "10", "*", "0x084C0000".
   SQLSTATE=08001

¿¹¸¦ µé¾î, ÀÌ °æ¿ì CM/2¿¡¼­´Â TP À̸§ÀÌ ´ÙÀ½°ú °°ÀÌ Á¤ÀǵǾî¾ß ÇÕ´Ï´Ù.

   Transaction program name        = 'tpname'    (user defined)
   OS/2 program path and file name = notused

±×·± ÈÄ, CM/2 ±¸¼º È­¸éÀº ´ÙÀ½°ú °°¾Æ¾ß ÇÕ´Ï´Ù.

   Presentation type - background
   Operation type - Queued, operator preloaded

¸®ÅÏ ÄÚµå 20À» ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

   SQL30081N  A communication error has been detected.
   Communication protocol
   being used: "APPC".  Communication API being used: "CPI-C".
   Location where
   the error was detected: "".  Communication function detecting
   the error:
   "xcstp".  Protocol specific error code(s): "20", "*", "*".
   SQLSTATE=08001

¼Ö·ç¼Ç

DB2 Connect ½Ã½ºÅÛ¿¡¼­ SNA ¼­ºê½Ã½ºÅÛÀÌ ½ÃÀ۵ǴÂÁö È®ÀÎÇϽʽÿÀ.

¸®ÅÏ ÄÚµå 27À» ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

¸Þ½ÃÁö SQL30081NÀÌ ¸®ÅÏ ÄÚµå 27 ¹× SNA °¨Áö ÄÚµå 800Axxxx¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.

¼Ö·ç¼Ç

VTAM PIU(Path Information Unit)°¡ ³Ê¹« Å®´Ï´Ù.

¸®ÅÏ ÄÚµå 79¸¦ ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

   SQL30081N  A communication error has been detected.
   Communication protocol
   being used: "TCP/IP".  Communication API being used: "SOCKETS".
   Location
   where the error was detected: "".  Communication function
   detecting the error:
   "connect".  Protocol specific error code(s): "79", "*", "*".
   SQLSTATE=08001

¼Ö·ç¼Ç

ÀÌ ¿À·ù´Â ¿ø°Ý Ŭ¶óÀÌ¾ðÆ®°¡ DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡ ¿¬°áÇÒ ¼ö ¾ø´Â °æ¿ì¿¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù. DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ È£½ºÆ®·Î ¿¬°áÇÒ ¶§µµ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.

  1. DB2COMM ÇÁ·ÎÆÄÀÏ º¯¼ö°¡ DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ ¿Ã¹Ù¸£Áö ¾Ê°Ô ¼³Á¤µÇ¾úÀ» ¼ö ÀÖ½À´Ï´Ù. À̸¦ È®ÀÎÇϽʽÿÀ. ¿¹¸¦ µé¾î, AIX»ó¿¡¼­ DB2 Extended Enterprise EditionÀ» ¼öÇàÇÒ °æ¿ì, db2set db2comm=tcpip ¸í·ÉÀÌ sqllib/db2profile¿¡ ³ªÅ¸³ª¾ß ÇÕ´Ï´Ù.
  2. DB2 Ŭ¶óÀÌ¾ðÆ®¿Í DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ TCP/IP ¼­ºñ½º À̸§°ú Æ÷Æ® ¹øÈ£ ½ºÆå°£ ¶Ç´Â Æ÷Æ® ¹øÈ£ ½ºÆåµé°£¿¡ ºÒÀÏÄ¡°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. µÎ ¸Ó½ÅÀÇ TCP/IP services ÆÄÀÏ¿¡ ÀÖ´Â Ç׸ñÀ» È®ÀÎÇϽʽÿÀ.
  3. DB2 Connect °ÔÀÌÆ®¿þÀÌ¿¡¼­ DB2°¡ ½ÃÀ۵ǴÂÁö Á¡°ËÇϽʽÿÀ. ´ÙÀ½ ¸í·ÉÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±¸¼º diaglevelÀ» 4·Î ¼³Á¤ÇϽʽÿÀ.

       db2 update dbm cfg using diaglevel 4
    
    DB2¸¦ Á¤ÁöÇÏ¿´´Ù°¡ Àç½ÃÀÛÇÑ ÈÄ db2diag.log ÆÄÀÏÀ» »ìÆìº¸°í DB2 TCP/IP Åë½ÅÀÌ ½ÃÀ۵Ǿú´ÂÁö Á¡°ËÇϽʽÿÀ. ´ÙÀ½°ú À¯»çÇÑ Ãâ·ÂÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
       1998-02-03-12.41.04.861119   Instance:svtdbm2   Node:00
       PID:86496(db2sysc)   Appid:none
       common_communication  sqlcctcp_start_listen   Probe:80
       DIA3000I "TCPIP" protocol support was successfully started.
    

ÇÁ·ÎÅäÄÝ Æ¯Á¤ ¿À·ù ÄÚµå 10032¸¦ ¼ö¹ÝÇÑ SQL30081N

¡ÈÄ

   SQL30081N  A communication error has been detected.
   Communication protocol
   being used: "TCP/IP".  Communication API being used: "SOCKETS".
   Location
   where the error was detected: "9.21.85.159".  Communication
   function detecting
   the error: "send".  Protocol specific error code(s): "10032",
   "*", "*".
   SQLSTATE=08001

¼Ö·ç¼Ç

ÀÌ ¿À·ù ¸Þ½ÃÁö´Â TCP/IP Åë½ÅÀÌ ÀÌ¹Ì ½ÇÆÐÇÑ ¸Ó½ÅÀ¸·ÎºÎÅÍ ¿¬°áÀ» ²÷À¸·Á ÇÒ ¶§ ³ªÅ¸³¯ ¼ö ÀÖ½À´Ï´Ù. TCP/IP ¼­ºê½Ã½ºÅÛÀÇ ¹®Á¦¸¦ Á¤Á¤ÇϽʽÿÀ.

´ëºÎºÐÀÇ ¸Ó½Å¿¡¼­ TCP/IP ÇÁ·ÎÅäÄÝÀ» Àç½ÃÀÛÇϱ⸸ ÇÏ¸é ¹®Á¦°¡ Á¤Á¤µË´Ï´Ù. ¶§·Î´Â Àüü ¸Ó½ÅÀ» Àç½ÃÀÛÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.


[ ÆäÀÌÁöÀÇ ¸Ç À§ | ÀÌÀü ÆäÀÌÁö | ´ÙÀ½ ÆäÀÌÁö | ¸ñÂ÷ | »öÀÎ ]