ÀÌ Àý¿¡¼´Â DB2 Connect¸¦ »ç¿ëÇÒ ¶§ ¹ß»ýÇÏ´Â ¿¬°á ¹®Á¦Á¡ÀÇ °¡Àå ÀϹÝÀûÀΠ¡Èĸ¦ ³ª¿ÇÕ´Ï´Ù. °¢ °æ¿ì¸¶´Ù ´ÙÀ½ Ç׸ñÀÌ Á¦°øµË´Ï´Ù.
ÁÖ:
¶§¶§·Î ½Ã½ºÅÛ ·Î±×¸¦ »ìÆìº½À¸·Î½á SNA °¨Áö Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì¿¡ ÇØ´çÇÏ´ÂÁöÀÇ ¿©ºÎ´Â »ç¿ëµÇ´Â SNA ¼ºê½Ã½ºÅÛ¿¡ ´Þ·Á ÀÖÀ¸¸ç, ¾î¶² »óȲ¿¡¼´Â °¨Áö ÄÚµå Á¤º¸¸¦ ¾ò±â À§ÇØ SNA ÃßÀûÀ» ÀÛµ¿½ÃÄÑ ¹®Á¦¸¦ ´Ù½Ã ¸¸µé¾î¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.
¸Þ½ÃÁö SQL0965¿Í SQL0969´Â AS/400¿ë DB2 Universal Database, OS/390¿ë DB2 Universal Database, MVS/ESA¿ë DB2 ¹× VM & VSE¿ë DB2¿¡¼ ¼·Î ´Ù¸¥ ¸®ÅÏ ÄÚµå ¹øÈ£·Î Á¦½ÃµÉ ¼ö ÀÖ½À´Ï´Ù.
µÑ Áß¿¡¼ ÇϳªÀÇ ¸Þ½ÃÁö°¡ Ç¥½ÃµÉ ¶§ ±× ¸Þ½ÃÁö¸¦ Á¦½ÃÇÑ µ¥ÀÌÅͺ£À̽º ¼¹ö Á¦Ç°À» ¾Ë¾Æ³»·Á¸é ¹®¼¿¡¼ ¿ø·¡ SQL Äڵ带 ã¾Æº¸¾Æ¾ß ÇÕ´Ï´Ù.
È£½ºÆ® µ¥ÀÌÅͺ£À̽º·ÎºÎÅÍ ¼ö½ÅµÇ´Â SQL ÄÚµå´Â º¯È¯ÇÒ ¼ö ¾ø½À´Ï´Ù. ¿À·ù Äڵ带 ±âÃÊ·Î ¹®Á¦¸¦ Á¤Á¤ÇÑ ´ÙÀ½ ½ÇÆÐ ¸í·ÉÀ» ´Ù½Ã ½ÇÇàÇϽʽÿÀ.
±âÈ£ ¸ñÀûÁö À̸§ÀÌ Á¤ÀǵÇÁö ¾Ê¾Ò°Å³ª Á¦´ë·Î Á¤ÀǵÇÁö ¾Ê¾Ò½À´Ï´Ù.
¿¹¸¦ µé¾î, APPC ³ëµå°¡ »ç¿ëµÇ°í DB2 ³ëµå µð·ºÅ丮¿¡¼ ÁöÁ¤µÈ ±âÈ£ ¸ñÀûÁö À̸§ÀÌ Áö¿ª APPC Åë½Å ¼ºê½Ã½ºÅÛ ±¸¼º¿¡ ÀÖ´Â CPI-C Ç׸ñ°ú ÀÏÄ¡ÇÏÁö ¾ÊÀ» ¶§ ÀÌ ¿À·ù°¡ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.
¶Ç ´Ù¸¥ ¿øÀÎÀ¸·Î´Â ¸Ó½Å¿¡ µÑ ÀÌ»óÀÇ SNA ½ºÅÃÀÌ ¼³Ä¡µÈ °ÍÀÏ ¼ö ÀÖ½À´Ï´Ù. »ç¿ëÇÏ·Á°í ÇÏ´Â ½ºÅÃÀÌ ¸ÕÀú ÂüÁ¶µÇ´ÂÁö È®ÀÎÇÏ·Á¸é PATH¿Í LIBPATH¸¦ È®ÀÎÇØ¾ß ÇÕ´Ï´Ù.
SQL1403N Á¦°øµÈ »ç¿ëÀÚ À̸§ ¶Ç´Â ¾ÏÈ£°¡ Ʋ¸³´Ï´Ù.
ÀÎÁõÀ» ¹Þ±â·Î µÇ¾î ÀÖÀ¸¸é, ÇÊ¿äÇÑ °æ¿ì CONNECT¹®¿¡ ¿Ã¹Ù¸¥ ¾ÏÈ£¸¦ Á¦°øÇÏ¿´´ÂÁö È®ÀÎÇϽʽÿÀ.
ÀÎÁõÀ» ¹Þ±â·Î µÇ¾î ÀÖÁö ¾ÊÀ¸¸é, ½Ã½ºÅÛ µ¥ÀÌÅͺ£À̽º µð·ºÅ丮 Ç׸ñÀÌ AUTHENTICATION SERVER¸¦ »ç¿ëÇÏ¿© ¿Ã¹Ù¸£Áö ¾Ê°Ô īŻ·Î±×ȵǾî ÀÖ½À´Ï´Ù. AUTHENTICATIONÀÌ ¸í½ÃÀûÀ¸·Î ÁöÁ¤µÇÁö ¾ÊÀ¸¸é À̰ÍÀÌ ±âº»°ªÀÔ´Ï´Ù. ÀÌ °æ¿ì¿¡´Â AUTHENTICATION DCS³ª CLIENT¸¦ »ç¿ëÇÏ¿© Ç׸ñÀ» ´Ù½Ã īŻ·Î±×ÈÇϽʽÿÀ.
Çϳª ÀÌ»óÀÇ Åë½Å ÇÁ·ÎÅäÄÝ Áö¿øÀÌ ¼º°øÀûÀ¸·Î ½ÃÀÛµÇÁö ¾Ê¾Ò½À´Ï´Ù. ±×·¯³ª ÄÚ¾î µ¥ÀÌÅͺ£À̽º °ü¸® ÇÁ·Î±×·¥ ±â´ÉÀº ¼º°øÀûÀ¸·Î ½ÃÀ۵Ǿú½À´Ï´Ù.
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 Æ÷Æ®¿¡ ÇÚµéÀ» °¡Áö°í ÀÖÀ» °ÍÀÔ´Ï´Ù. °ÔÀÌÆ®¿þÀÌ¿¡ ¿¬°áµÈ °¢ Ŭ¶óÀÌ¾ðÆ® ¸Ó½Å¿¡´Â ´ÙÀ½°ú °°Àº ÇÚµéÀÌ ÀÖ½À´Ï´Ù.
SQL30020N ÈÄ¼Ó ¸í·É°ú SQL¹®ÀÇ ¼º°øÀûÀÎ ½ÇÇà¿¡ ¿µÇâÀ» ÁÙ ºÐ»ê ÇÁ·ÎÅäÄÝ ¿À·ù ¶§¹®¿¡ ½ÇÇàµÇÁö ¸øÇÏ¿´½À´Ï´Ù.
ÀÌ ¿À·ù°¡ ¹ß»ýÇÏ¸é ¼ºñ½º¸¦ ¹Þ¾Æ¾ß ÇÕ´Ï´Ù.
db2dump µð·ºÅ丮¿¡¼ ffdc dump(pid.000)°¡ ÀÖ´ÂÁö Á¡°ËÇÕ´Ï´Ù. ±×·± ÈÄ, db2fdump¸¦ »ç¿ëÇÏ¿© ÀÌ ´ýÇÁ ÆÄÀÏÀ» Çü½ÄÈÇÏ°í °á°ú ÆÄÀÏ¿¡¼ "ERROR"¸¦ »ìÆìº¾´Ï´Ù. MVS ABEND°¡ ¿©±â¿¡ ³ª¿µÇ¾î ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ °æ¿ì¿¡´Â MVS ÄܼÖÀ» È®ÀÎÇÏ¿© ÀÚ¼¼ÇÑ Á¤º¸¸¦ ¾Ë¾Æº¸°í MVS ¸Þ½ÃÁö¿Í ÄÚµå ¸Å´º¾óÀÇ DB2 ºÎºÐ¿¡¼ ÀÌ»ó Á¾·á Äڵ带 »ìÆìº¾´Ï´Ù.
SQL30060N "<±ÇÇÑ ºÎ¿© ID>"¿¡°Ô Á¶ÀÛ <operation>À» ¼öÇàÇÒ ¼ö Àִ Ư±ÇÀÌ ¾ø½À´Ï´Ù.
MVS¿ë DB2³ª OS/390¿ë DB2¿¡ ¿¬°áÇÒ ¶§, Åë½Å µ¥ÀÌÅͺ£À̽º(CDB) Å×À̺íÀÌ Á¦´ë·Î °»½ÅµÇÁö ¾Ê¾Ò½À´Ï´Ù. ´ÙÀ½ ¼³¸í¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
À߸øµÈ È£½ºÆ®³ª 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>
¸Þ½ÃÁö SQL30073Àº ¸®ÅÏ ÄÚµå 119C¿Í ÇÔ²² ¹ßÇàµË´Ï´Ù. ÀÌ ¿À·ù´Â ¸ñÇ¥ ¼¹ö µ¥ÀÌÅͺ£À̽º°¡ DB2 Ŭ¶óÀÌ¾ðÆ®¿¡ »ç¿ëµÈ ÄÚµå ÆäÀÌÁö¸¦ Áö¿øÇÏÁö ¾ÊÀ» ¶§ ¹ß»ýÇÕ´Ï´Ù(DB2 Connect¸¦ °æÀ¯ÇÔ). ÄÚµå ÆäÀÌÁö´Â DB2 Ŭ¶óÀÌ¾ðÆ®°¡ ¼öÇàµÇ´Â ¿î¿µ ȯ°æÀÇ ±¸¼º¿¡¼ °¡Á®¿Â °ÍÀÔ´Ï´Ù.
°ü¸® ¾È³»¼¿¡¼ ÀÚ¼¼ÇÑ ³»¿ëÀ» ÂüÁ¶ÇϽʽÿÀ.
ÀÌ ¹®Á¦´Â Á¾Á¾ ¸ñÇ¥ ¼¹ö µ¥ÀÌÅͺ£À̽º ½Ã½ºÅÛ¿¡ ¼öÁ¤ ÆÐÄ¡¸¦ ¼³Ä¡ÇÏ¿© ÇØ°áÇÒ ¼ö ÀÖ½À´Ï´Ù. ÇØ´ç ¼ºñ½º ºÎ¼¿¡ ¿¬¶ôÇÏ¿© ÀÌ Â¡ÈÄ¿¡ ´ëÇØ ±Ç°íÇÏ´Â ¼öÁ¤ ÆÐÄ¡¸¦ ¾ò¾î ¼³Ä¡ÇϽʽÿÀ.
ÀϽÃÀûÀÎ ÇØ°áÃ¥À¸·Î »ç¿ëÀÚ´Â DB2CODEPAGE ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇÏ¿© ±âº» ÄÚµå ÆäÀÌÁö¸¦ °ãÃľµ ¼ö ÀÖ½À´Ï´Ù. ·ÎÄÉÀÏÀ» È®ÀÎÇϰųª DB2CODEPAGE=850À¸·Î ¼³Á¤ÇϽʽÿÀ.
UNIX Ç÷§ÆûÀÇ »ç¿ëÀÚ´Â LANG ȯ°æ º¯¼ö¸¦ ´Ù¸¥ °ªÀ¸·Î ¼³Á¤ÇÏ¿© ´Ù¸¥ ÄÚµå ÆäÀÌÁö·Î ÀüȯÇÒ ¼ö ÀÖ½À´Ï´Ù.
¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁö¿Í 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À» ¼ö¹ÝÇÑ SQL30081N°ú sna °¨Áö ÄÚµå 0877002C
Ʋ¸° ³×Æ®¿öÅ© À̸§ÀÌ ÁöÁ¤µÇ¾ú½À´Ï´Ù.
¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå ffff0003
Ʋ¸° MAC ÁÖ¼Ò°¡ ÁöÁ¤µÇ¾ú°Å³ª SNA ¸µÅ©°¡ »ç¿ëÁßÀÌ ¾Æ´Õ´Ï´Ù.
¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå 10030021
LU À¯ÇüÀÌ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù.
¸®ÅÏ ÄÚµå 1À» ¼ö¹ÝÇÑ SQL30081N°ú SNA °¨Áö ÄÚµå 084B6031
DSNZPARM(MVS¿ë DB2³ª OS/390 È£½ºÆ®¿ë DB2¿¡¼)ÀÇ MAXDBAT°¡ 0À¸·Î ¼³Á¤µÇ¾ú½À´Ï´Ù.
´ÙÀ½Àº ´Ù¸¥ Á¦¾ÈÀÔ´Ï´Ù.
¸Þ½ÃÁö SQL30081NÀÌ ¸®ÅÏ ÄÚµå 2 ¹× SNA °¨Áö ÄÚµå 08120022¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.
NCP(¸µÅ©ÀÇ È£½ºÆ® ÂÊ)¿¡¼ NUMILU ¸Å°³º¯¼ö°¡ ±âº»°ª(0)À¸·Î ¼³Á¤µÇ¾úÀ» ¼ö ÀÖ½À´Ï´Ù. À̸¦ È®ÀÎÇϽʽÿÀ. º¯°æ »çÇ×À» Àû¿ëÇÑ ÈÄ Àç½ÃµµÇϱâ Àü¿¡ ÇÊ¿äÇÑ °æ¿ì NCP Á¤ÀǸ¦ ¼öÁ¤ÇϽʽÿÀ.
¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁöÀÔ´Ï´Ù(ÀÌ °æ¿ì¿¡´Â 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 ºü¸¥ ½ÃÀÛ ¸Å´º¾óÀ» ÂüÁ¶ÇϽʽÿÀ.
¡ÈÄ´Â ´ÙÀ½ ¸Þ½ÃÁöÀÔ´Ï´Ù(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
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 ¼ºê½Ã½ºÅÛÀÌ ½ÃÀ۵ǴÂÁö È®ÀÎÇϽʽÿÀ.
¸Þ½ÃÁö SQL30081NÀÌ ¸®ÅÏ ÄÚµå 27 ¹× SNA °¨Áö ÄÚµå 800Axxxx¿Í ÇÔ²² Ç¥½ÃµË´Ï´Ù.
VTAM PIU(Path Information Unit)°¡ ³Ê¹« Å®´Ï´Ù.
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 °ÔÀÌÆ®¿þÀÌ¿¡¼ È£½ºÆ®·Î ¿¬°áÇÒ ¶§µµ ¹ß»ýÇÒ ¼ö ÀÖ½À´Ï´Ù.
db2 update dbm cfg using diaglevel 4DB2¸¦ Á¤ÁöÇÏ¿´´Ù°¡ Àç½ÃÀÛÇÑ ÈÄ 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.
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 ÇÁ·ÎÅäÄÝÀ» Àç½ÃÀÛÇϱ⸸ ÇÏ¸é ¹®Á¦°¡ Á¤Á¤µË´Ï´Ù. ¶§·Î´Â Àüü ¸Ó½ÅÀ» Àç½ÃÀÛÇØ¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù.