IBM* DB2* Connect ¸±¸®½º Á¤º¸ ¸ñÂ÷ IBM DB2 Connect ¸±¸®½º Á¤º¸ ¹öÀü * RELEASE.TXT¿¡¼­ Á¤º¸ °ËÅä * DB2¿¡¼­ÀÇ SNA SPMÀÌ Windows ºÎÆ® ÈÄ ½ÃÀÛ ½ÇÆÐ * ÅëÇÕ SNA Áö¿øÀÌ ´õ ÀÌ»ó Windows¿ë DB2 Connect Personal Edition 7.1°ú ÇÔ²² Á¦°øµÇÁö ¾ÊÀ½ * Solaris ¹öÀü 2.6¿¡ Ãß°¡ °æ·Î ÇÊ¿ä * Å͹̳Π¼­¹ö ÀÀ¿ëÇÁ·Î±×·¥ * JDBC/ODBC/CLI Á¤Àû ÇÁ·ÎÆÄÀϸµ Á¦ÇÑ * OS/390¿ë DB2(R) APAR ¼öÁ¤ ÀüÁ¦Á¶°Ç o Kerberos ¹× »ç¿ëÀÚ ID ¾Ïȣȭ * µî·Ï»óÇ¥ IBM DB2 Connect ¸±¸®½º Á¤º¸ ¹öÀü (c)Copyright International Business Machines Corporation 1996, 2000. All rights reserved. ÀÌ ÆÄÀÏÀº DB2 ¸Å´º¾óÀÌ ÀμâµÉ ¶§ »ç¿ë ºÒ°¡´ÉÇß´ø, ´ÙÀ½ Á¦Ç°µé¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù. * IBM DB2 Connect Personal Edition, ¹öÀü 7.1 * IBM DB2 Connect Enterprise Edition, ¹öÀü 7.1 RELEASE.TXT¶ó´Â À̸§À¸·Î ¼³Ä¡µÈ °¢ ¼³Ä¡ Á¤º¸ ÆÄÀÏÀº ´ÙÀ½ Á¦Ç°¿¡ ´ëÇÑ Á¤º¸¸¦ Á¦°øÇÕ´Ï´Ù. * IBM DB2 Universal Database Satellite Edition, ¹öÀü 7.1 * IBM DB2 Universal Database Personal Edition, ¹öÀü 7.1 * IBM DB2 Universal Database Workgroup Edition, ¹öÀü 7.1 * IBM DB2 Universal Database Enterprise Edition, ¹öÀü 7.1 * AIX¿ë IBM DB2 Data Links Manager, ¹öÀü 7.1 * Windows NT¿ë IBM DB2 Data Links Manager, ¹öÀü 7.1 * AIX¿ë IBM DB2 Universal Database Enterprise - Extended Edition, ¹öÀü 7.1 * Windows NT¿ë IBM DB2 Universal Database Enterprise - Extended Edition, ¹öÀü 7.1 * Solaris ¿î¿µ üÁ¦¿ë IBM DB2 Universal Database Enterprise - Extended Edition, ¹öÀü 7.1 * AIX¿ë IBM DB2 Query Patroller, ¹öÀü 7.1 * Solaris ¿î¿µ üÁ¦¿ë IBM DB2 Query Patroller, ¹öÀü 7.1 * IBM DB2 Personal Developer's Edition, ¹öÀü 7.1 * IBM DB2 Universal Developer's Edition, ¹öÀü 7.1 Á¦¾î ¼¾ÅÍ¿¡ ´ëÇÑ ¹®Á¦Á¡ ÇØ°á ¹× ±âŸ Á¤º¸´Â sqllib/cc/prime/readme.htmÀ» ÂüÁ¶ÇϽʽÿÀ. »õ·Î¿î ±â´É ¼­ÀûÀº ¹öÀü 7.1¿ë ±âº» DB2 °³¼±µÈ ±â´É°ú ÀÌ·¯ÇÑ »õ·Ó°í °³¼±µÈ ±â´É¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ¼³¸íÀ» Á¦°øÇÕ´Ï´Ù. RELEASE.TXT¿¡¼­ Á¤º¸ °ËÅä RELEASE.TXT´Â DB2 Universal Database¿¡ °üÇÑ ÃֽŠÁ¤º¸¸¦ Á¦°øÇÕ´Ï´Ù. ÀÌ Á¤º¸´Â ÁÖ·Î DB2 Connect¿¡ °üÇÑ °ÍÀÔ´Ï´Ù. DB2¿¡¼­ÀÇ SNA SPMÀÌ Windows ºÎÆ® ÈÄ ½ÃÀÛ ½ÇÆÐ Microsoft SNA Server ¹öÀü 4 SP3 ÀÌÈÄ ¹öÀüÀ» »ç¿ë ÁßÀ̶ó¸é, DB2¿¡¼­ÀÇ SNA SPMÀÌ ÀçºÎÆ® ÈÄ ÀûÀýÈ÷ ½ÃÀ۵Ǿú´ÂÁö¸¦ °ËÁõÇϽʽÿÀ. ´ÙÀ½°ú À¯»çÇ× Ç׸ñ¿¡ ´ëÇØ \sqllib\\db2diag.log ÆÄÀÏÀ» Á¡°ËÇϽʽÿÀ. 2000-04-20-13.18.19.958000 Instance:DB2 Node:000 PID:291(db2syscs.exe) TID:316 Appid:none common_communication sqlccspmconnmgr_APPC_init Probe:19 SPM0453C Microsoft SNA Server°¡ ½ÃÀÛµÇÁö ¾Ê¾ÒÀ¸¹Ç·Î µ¿±â ÁöÁ¡ °ü¸® ÇÁ·Î±×·¥ÀÌ ½ÃÀÛÇÏÁö ¾Ê¾Ò½À´Ï´Ù. 2000-04-20-13.18.23.033000 Instance:DB2 Node:000 PID:291(db2syscs.exe) TID:302 Appid:none common_communication sqlccsna_start_listen Probe:14 DIA3001E "SNA SPM" ÇÁ·ÎÅäÄÝ Áö¿øÀÌ Á¤»óÀûÀ¸·Î ½ÃÀÛµÇÁö ¾Ê¾Ò½À´Ï´Ù. 2000-04-20-13.18.23.603000 Instance:DB2 Node:000 PID:291(db2syscs.exe) TID:316 Appid:none common_communication sqlccspmconnmgr_listener Probe:6 DIA3103E APPC ÇÁ·ÎÅäÄÝ Áö¿ø¿¡ ¿À·ù°¡ ¹ß»ýÇß½À´Ï´Ù. APPC ¸í·É¾î "APPC(DISPLAY 1 BYTE)". 1Â÷ rc´Â "F004"À̸ç 2Â÷ rc´Â "00000000"ÀÔ´Ï´Ù. db2diag.log¿¡ ÇØ´ç Ç׸ñÀÌ ÀÖ°í, ½Ã°£ ¼ÒÀÎÀÌ ÃÖ±Ù ÀçºÎÆ® ½Ã°£°ú ÀÏÄ¡ÇÑ´Ù¸é ´ÙÀ½À» ¼öÇàÇϽʽÿÀ. 1. db2stopÀ» ¹ßÇàÇϽʽÿÀ. 2. SnaServer ¼­ºñ½º°¡ ½ÃÀÛµÇÁö ¾Ê¾Ò´Ù¸é À̸¦ ½ÃÀÛÇϽʽÿÀ. 3. db2start¸¦ ¹ßÇàÇϽʽÿÀ. db2diag.log ÆÄÀÏÀ» ´Ù½Ã Á¡°ËÇÏ¿© Ç׸ñÀÌ ´õ ÀÌ»ó Ãß°¡µÇÁö ¾Ê¾Ò´ÂÁö¸¦ °ËÁõÇϽʽÿÀ. ÅëÇÕ SNA Áö¿øÀÌ ´õ ÀÌ»ó Windows¿ë DB2 Connect Personal Edition 7.1°ú ÇÔ²² Á¦°øµÇÁö ¾ÊÀ½ Windows¿ë DB2 Connect Personal Edition V7.1Àº ´õ ÀÌ»ó ÅëÇÕ SNA ½ºÅÃÀ» Á¦°øÇÏÁö ¾Ê½À´Ï´Ù. DB2 Connect V7.1 ¹®¼­¿¡ Æ÷ÇÔµÈ ÅëÇÕ SNA ½ºÅà Á¤º¸´Â À߸øµÈ °ÍÀÔ´Ï´Ù. SNA ¿¬°á¼ºÀÌ ÇÊ¿äÇÏ´Ù¸é, Áö¿øµÇ´Â SNA Á¦Ç°ÀÌ ¼³Ä¡µÇ¾î ÀÖ¾î¾ß¸¸ ÇÕ´Ï´Ù. Áö¿øµÇ´Â SNA Á¦Ç°Àº DB2 Connect Personal Edition ºü¸¥ ½ÃÀÛ V7.1ÀÇ ¼ÒÇÁÆ®¿þ¾î ¿ä±¸»çÇ× ¹× Çϵå¿þ¾î ¿ä±¸»çÇ× ¾Æ·¡¿¡ ÀÖ´Â ¼³Ä¡ °èȹ Àå¿¡ ³ª¿­µÇ¾î ÀÖ½À´Ï´Ù(Å×À̺í 1 ÂüÁ¶). ¼³Ä¡µÈ SNA ½ºÅðú ÇÔ²² DB2 Connect Personal Edition¿¡¼­ ÀÌÁÖ ÁßÀ̶ó¸é, SNA ¿¬°á¼ºÀº °è¼Ó ÀÛµ¿ÇÒ °ÍÀÔ´Ï´Ù. ±×·¯³ª, ÀÌ´Â Áö¿øµÇÁö ¾Ê´Â ±¸¼ºÀ̹ǷÎ, Áö¿øµÇ´Â SNA ½ºÅà Áß Çϳª¸¦ ¼³Ä¡ÇϽʽÿÀ. Solaris ¹öÀü 2.6¿¡ Ãß°¡ °æ·Î ÇÊ¿ä Solaris** ¹öÀü 2.6¿ë DB2 Connect ¹öÀü 7.1¿¡´Â 106285-02 ÀÌ»óÀÇ ÆÐÄ¡¿Í UNIX¿ë DB2 Connect ºü¸¥ ½ÃÀÛ** ¼­Àû¿¡ ³ª¿­µÈ ÆÐÄ¡°¡ ÇÊ¿äÇÕ´Ï´Ù. Å͹̳Π¼­¹ö ÀÀ¿ëÇÁ·Î±×·¥ Windows** 2000ÀÌ Å͹̳Π¼­¹ö¸¦ ÀÀ¿ëÇÁ·Î±×·¥À¸·Î¼­ »ç¿ë ÁßÀ̶ó¸é, DB2 Connect¸¦ ¼³Ä¡ÇÒ ¶§ Å͹̳Π¼­¹ö°¡ ¼³Ä¡ ¸ðµå¿¡ ÀÖ¾î¾ß¸¸ ÇÕ´Ï´Ù. DB2 Connect ¼³Ä¡ ½Ã, Å͹̳Π¼­¹ö¸¦ ¼³Ä¡ ¸ðµå·Î ¼³Á¤ÇÏ´Â °¡Àå ½¬¿î ¹æ¹ýÀº Á¦¾îÆÇÀÇ ÇÁ·Î±×·¥ Ãß°¡/Á¦°Å¸¦ »ç¿ëÇÏ´Â °ÍÀÔ´Ï´Ù. ÀÌ·¸°Ô Çϸé Å͹̳Π¼­¹ö´Â ÀÚµ¿À¸·Î ¼³Ä¡ ¸ðµå·Î ÀüȯµË´Ï´Ù. JDBC/ODBC/CLI Á¤Àû ÇÁ·ÎÆÄÀϸµ Á¦ÇÑ JDBC/ODBC/CLI Á¤Àû ÇÁ·ÎÆÄÀϸµÀÌ ÇöÀç Á÷Á¢Àû ÀÀ¿ëÇÁ·Î±×·¥À» ¸ñǥȭÇß½À´Ï´Ù. ÀÌ´Â ¸¹Àº ±â´ÉÀû ±¸¼º¿ä¼Ò ¹× ½ÇÇà µ¿¾ÈÀÇ º¹ÀâÇÑ ÇÁ·Î±×·¥ ·ÎÁ÷À» °¡Áø º¹ÀâÇÑ ÀÀ¿ëÇÁ·Î±×·¥À» ÀǹÌÇÏ´Â °ÍÀÌ ¾Æ´Õ´Ï´Ù. SQL¹®ÀÌ ÇÁ·ÎÆÄÀϸµ ¼¼¼Ç¿¡ ĸÃĵǵµ·Ï Á¤»óÀûÀ¸·Î ½ÇÇàµÇ¾ú½À´Ï´Ù. ±¸¹® ÀÏÄ¡ ¼¼¼Ç¿¡¼­ ÀÏÄ¡ÇÏÁö ¾Ê´Â µ¿Àû ±¸¹®Àº µ¿Àû JDBC/ODBC/CLI È£Ãâ·Î¼­ ½ÇÇàÀ» °è¼ÓÇÕ´Ï´Ù. SQL¹®Àº ±¸¹® ÀÏÄ¡¿¡ À¯È¿ÇÑ È帰¡ µÇµµ·Ï ĸÃÄµÇ°í ¹ÙÀεåµÈ SQL¹®°ú ±ÛÀÚ ÇÑÀÚ ÇÑÀÚ°¡ ÀÏÄ¡ÇØ¾ß ÇÕ´Ï´Ù. °ø¹éµµ Àǹ̸¦ °®½À´Ï´Ù. ¿¹¸¦ µé¾î, "COL = 1"Àº "COL=1"°ú ´Ù¸£°Ô Àνĵ˴ϴÙ. ±ÛÀÚ°¡ Á¤È®È÷ ÀÏÄ¡Çϵµ·Ï ÇÏ·Á¸é, ¹®ÀÚ ´ë½Å ¸Å°³º¯¼ö Ç¥½Ã¹®ÀÚ¸¦ »ç¿ëÇϽʽÿÀ. »çÀü ¹Ù¿îµå Á¤Àû SQL¹®À» °¡Áø ÀÀ¿ëÇÁ·Î±×·¥À» ¼öÇàÇÒ ¶§, µ¿Àû ±¸ºÐ ÀÛµ¿À» Á¦¾îÇÏ´Â µ¿Àû ·¹Áö½ºÅÍ´Â Á¤ÀûÀ¸·Î º¯È¯µÈ ±¸¹®¿¡ ¿µÇâÀ» ¹ÌÄ¡Áö ¾Ê½À´Ï´Ù. ÀÀ¿ëÇÁ·Î±×·¥ÀÌ ºÎ¼Ó ¼øÂ÷ DML¹®¿¡ ÂüÁ¶µÈ ¿ÀºêÁ§Æ®¿¡ ´ëÇÑ DDL¹®À» ¹ßÇàÇÏ´Â °æ¿ì, ÇØ´ç ±¸¹® ¸ðµÎ°¡ ĸÃÄ ÆÄÀÏ¿¡ µé¾î ÀÖ½À´Ï´Ù. JDBC/ODBC/CLI Á¤Àû ÇÁ·ÎÆÄÀϸµ ¹ÙÀÎµå µµ±¸´Â À̵éÀ» ¹ÙÀεåÇÕ´Ï´Ù. ¹ÙÀÎµå ½Ãµµ´Â VALIDATE(RUN) ¹ÙÀÎµå ¿É¼ÇÀ» Áö¿øÇÏ´Â DBMSÀ» °¡Áø °æ¿ì¿¡´Â ¼º°øÀûÀ̾úÀ¸³ª, À̸¦ Áö¿øÇÏÁö ¾Ê´Â °æ¿ì¿¡´Â ½ÇÆÐÇß½À´Ï´Ù. ÀÌ·² ¶§´Â, ÀÀ¿ëÇÁ·Î±×·¥ÀÌ Á¤Àû ÇÁ·ÎÆÄÀϸµÀ» »ç¿ëÇÒ ¼ö ¾ø½À´Ï´Ù. µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ´Â ÀÀ¿ëÇÁ·Î±×·¥º° ¿ä±¸»çÇ׿¡ µû¶ó SQL¹®À» Ãß°¡, º¯°æ, Á¦°ÅÇϱâ À§ÇØ Ä¸ÃÄ ÆÄÀÏÀ» ÆíÁýÇÒ ¼ö ÀÖ½À´Ï´Ù. OS/390¿ë DB2(R) APAR ¼öÁ¤ ÀüÁ¦Á¶°Ç * APAR PQ34536: OS/390¿ë DB2¿ë PTF UQ40226 ¹öÀü 6 * APAR PQ35121: OS/390¿ë DB2¿ë PTF UQ41788 ¹öÀü 5 * APAR PQ35121: OS/390¿ë DB2¿ë PTF UQ41789 ¹öÀü 6 Kerberos ¹× »ç¿ëÀÚ ID ¾Ïȣȭ * APAR PQ36732: OS/390¿ë DB2¿ë PTF UQ41942 ¹öÀü 6 * APAR PQ36732: OS/390¿ë DB2¿ë PTF UQ41941 ¹öÀü 5 µî·Ï»óÇ¥ * ´ÙÀ½ Ç׸ñÀº ¹Ì±¹ ¹× ´Ù¸¥ ³ª¶ó¿¡¼­ IBMÀÇ »óÇ¥ ¹× µî·Ï»óÇ¥ÀÔ´Ï´Ù. * DB2 * DB2 Connect * IBM * OS/390 ** Microsoft, Windows, ¹× Windows NT´Â Microsoft CorporationÀÇ »óÇ¥ ¹× µî·Ï»óÇ¥ÀÔ´Ï´Ù. ** Sun, Java, ¹× Solaris´Â ¹Ì±¹ ¹× ´Ù¸¥ ³ª¶ó¿¡¼­ Sun Microsystems, Inc.ÀÇ »óÇ¥ ¹× µî·Ï»óÇ¥ÀÔ´Ï´Ù. ** UNIX´Â ¹Ì±¹ ¹× ´Ù¸¥ ³ª¶ó¿¡¼­ The Open GroupÀÇ µî·Ï»óÇ¥ÀÔ´Ï´Ù. ** ±âŸ ȸ»ç, Á¦Ç° ¹× ¼­ºñ½º À̸§Àº ±âŸ ´Ù¸¥ ȸ»çÀÇ »óÇ¥À̰ųª ¼­ºñ½º Ç¥½ÃÀÔ´Ï´Ù.