|DB2 Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛÀº Ưº°ÇÑ À¯ÇüÀÇ ºÐ»ê µ¥ÀÌÅͺ£À̽º °ü¸® ½Ã½ºÅÛ(DBMS)ÀÔ´Ï´Ù. |Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛÀ» »ç¿ëÇϸé DBMS¿¡ ÀÖ´Â µ¥ÀÌÅ͸¦ Äõ¸®ÇÏ°í °Ë»öÇÒ ¼ö ÀÖ½À´Ï´Ù. |´ÜÀÏ SQL¹®Àº ´ÙÁß DBMS ¶Ç´Â °³º°ÀûÀÎ µ¥ÀÌÅͺ£À̽º¸¦ ÂüÁ¶ÇÒ ¼ö ÀÖ½À´Ï´Ù. |¿¹¸¦ µé¾î, DB2 Universal Database Å×À̺í, Oracle Å×ÀÌºí ¹× Sybase ºä¿¡ ÀÖ´Â |µ¥ÀÌÅ͸¦ Á¶ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
|DB2 Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛÀº Çϳª ÀÌ»óÀÇ µ¥ÀÌÅÍ ¼Ò½º ¹× DB2 ÀνºÅϽº(Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º·Î »ç¿ëÇÒ |µ¥ÀÌÅͺ£À̽º)°¡ ÀÖ´Â ¼¹ö·Î ±¸¼ºµË´Ï´Ù. |Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º¿¡´Â µ¥ÀÌÅÍ ¼Ò½º ¹× ±× Ư¼ºÀ» ½Äº°ÇÏ´Â Ä«Å»·Î±× Ç׸ñÀÌ ÀÖ½À´Ï´Ù. |µ¥ÀÌÅÍ ¼Ò½º´Â DBMS ¹× µ¥ÀÌÅÍ·Î ±¸¼ºµË´Ï´Ù. |Áö¿øµÇ´Â µ¥ÀÌÅÍ ¼Ò½º´Â ´ÙÀ½°ú °°½À´Ï´Ù. |
|DB2 Universal Database Æä´õ·¹ÀÌƼµå ¼¹ö´Â ·¦ÆÛ¶ó´Â ÇÁ·ÎÅäÄÝÀ» |»ç¿ëÇؼ µ¥ÀÌÅÍ ¼Ò½º¿¡¼ µ¥ÀÌÅ͸¦ °Ë»öÇÏ°í µ¥ÀÌÅÍ ¼Ò½º¿Í Åë½ÅÇÕ´Ï´Ù. |»ç¿ëÇÏ´Â ·¦ÆÛ´Â DB2 ÀνºÅϽº°¡ ½ÇÇàµÇ´Â ¿î¿µ üÁ¦¿¡ µû¶ó ´Ù¸¨´Ï´Ù. |º°¸íÀº µ¥ÀÌÅÍ ¼Ò½º¿¡ À§Ä¡ÇÑ ºä¿Í Å×À̺íÀ» ½Äº°ÇÏ´Â µ¥ »ç¿ëµË´Ï´Ù. |ÀÀ¿ëÇÁ·Î±×·¥Àº ´Ù¸¥ DB2 µ¥ÀÌÅͺ£À̽º¿Í ¸¶Âù°¡Áö·Î Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º¿¡ ¿¬°áÇÒ ¼ö ÀÖÀ¸¸ç, |Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º¿¡ Å×À̺íÀ̳ª ºä°¡ ÀÖ´Â °Íó·³ º°¸íÀ» »ç¿ëÇÏ¿© µ¥ÀÌÅÍ ¼Ò½º¸¦ Äõ¸®ÇÒ ¼ö ÀÖ½À´Ï´Ù.
|Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛÀÌ ¼³Á¤µÇ¸é ¸¶Ä¡ µ¥ÀÌÅÍ°¡ ´ÜÀÏ ·ÎÄà µ¥ÀÌÅͺ£À̽º¿¡ ÀÖ´Â °Íó·³ |µ¥ÀÌÅÍ ¼Ò½º Á¤º¸¿¡ ¾×¼¼½ºÇÒ ¼ö ÀÖ½À´Ï´Ù. |»ç¿ëÀÚ ¹× ÀÀ¿ëÇÁ·Î±×·¥Àº Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º¿¡ Äõ¸®¸¦ º¸³»¸é, |ÀÌ µ¥ÀÌÅͺ£À̽º°¡ µ¥ÀÌÅÍ ¼Ò½º¿¡¼ µ¥ÀÌÅ͸¦ °Ë»öÇÕ´Ï´Ù.
|DB2 Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛÀÌ ÀÛµ¿µÇ´Â µ¥´Â Á¦ÇÑ»çÇ×ÀÌ ÀÖ½À´Ï´Ù. |ºÐ»ê ¿äû(DR)Àº DB2 ¹öÀü 7ÀÇ Àбâ Àü¿ë Á¶ÀÛÀ¸·Î¸¸ Á¦Çѵ˴ϴÙ. ¶ÇÇÑ º°¸í¿¡ ´ëÇÑ |À¯Æ¿¸®Æ¼ Á¶ÀÛ(LOAD, REORG, REORGCHK, IMPORT, RUNSTATS µî)À» ½ÇÇàÇÒ ¼ö ¾ø½À´Ï´Ù. |±×·¯³ª DDL ¹× DML ¸í·É¹®À» µ¥ÀÌÅÍ ¼Ò½º¿Í ¿¬°üµÈ SQL Dialect¸¦ »ç¿ëÇÏ¿© |Á÷Á¢ DBMS·Î Á¦ÃâÇÏ´Â Åë°ú ±â´ÉÀ» »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.
|¹öÀü 7.2ÀÇ »õ ·¦ÆÛ(¿¹: AIX, HP ¹× Solaris ¿î¿µ ȯ°æÀÇ |Informix; Linux, HP ¹× Solaris ¿î¿µ ȯ°æÀÇ Oracle; |AIX ¹× Solaris ¿î¿µ ȯ°æÀÇ Sybase; AIX ¹× NTÀÇ Microsoft SQL Server)´Â |ÀÌ FixPak¿¡¼ »ç¿ë ºÒ°¡´ÉÇϹǷΠDB2 Relational |Connect ¹öÀü 7.2¸¦ ±¸ÀÔÇØ¾ß ÇÕ´Ï´Ù.
|ÀÌ ¼½¼Ç¿¡´Â Æä´õ·¹ÀÌƼµå ½Ã½ºÅÛ ¼¹ö·Î »ç¿ëÇÒ ¼¹ö¿¡ DB2 Relational Connect¸¦ |¼³Ä¡ÇÏ´Â °úÁ¤ÀÌ ³ª¿Í ÀÖ½À´Ï´Ù. |Relational Connect´Â Oracle, Sybase, Microsoft SQL Server ¹× Informix µ¥ÀÌÅÍ ¼Ò½º¿¡ |¾×¼¼½ºÇÏ´Â µ¥ ÇÊ¿äÇÕ´Ï´Ù. DB2 Relational Connect¸¦ »ç¿ëÇϸé DB2 Universal Database °è¿ ±¸¼º¿ø¿¡ |¾×¼¼½ºÇÏÁö ¾Ê¾Æµµ µË´Ï´Ù.
|DB2 Relational Connect ¼³Ä¡ Àü¿¡, |
|
|
|x:\setup /i language
|¿©±â¼, |
|¼³Ä¡ ·±Ä¡Æе尡 ¿¸³´Ï´Ù.
|¼³Ä¡°¡ ³¡³ª¸é DB2 Relational Connect°¡ ´Ù¸¥ DB2 Á¦Ç°°ú ÇÔ²² µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù. |¿¹¸¦ µé¾î, Oracle NET8 Ŭ¶óÀ̾ðÆ® ¼ÒÇÁÆ®¿þ¾î(net8.dll)¿¡ ´ëÇÑ ·¦ÆÛ ¶óÀ̺귯¸®´Â |c:\Program Files\SQLLIB\bin µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù. |
|UNIX Æä´õ·¹ÀÌƼµå ¼¹ö¿¡ DB2 Relational Connect¸¦ ¼³Ä¡ÇÏ·Á¸é, db2setup À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇϽʽÿÀ.
|ÁÖ: db2setup À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇÒ ¶§ ³ªÅ¸³ª´Â ȸéÀº |Æä´õ·¹ÀÌƼµå ¼¹ö¿¡ ¼³Ä¡µÈ °Í¿¡ µû¶ó ´Ù¸¨´Ï´Ù. |¿©±â¼´Â Relational Connect¸¦ ¼³Ä¡ÇÏÁö ¾ÊÀº »óȲÀ» °¡Á¤ÇÕ´Ï´Ù. |
|¼³Ä¡°¡ ³¡³ª¸é DB2 Relational Connect°¡ ´Ù¸¥ DB2 Á¦Ç°°ú ÇÔ²² µð·ºÅ丮¿¡ ¼³Ä¡µË´Ï´Ù. |
|CREATE NICKNAME ¸í·É¹®ÀÇ nickname ¸Å°³º¯¼ö´Â 2ºÎºÐ(½ºÅ°¸¶¿Í º°¸í)À¸·Î ±¸¼ºµÈ |À̸§ÀÔ´Ï´Ù. º°¸íÀ» ÀÛ¼ºÇÒ ¶§ ½ºÅ°¸¶¸¦ »ý·«ÇÑ °æ¿ì, |º°¸í ½ºÅ°¸¶´Â º°¸íÀ» ÀÛ¼ºÇÏ´Â »ç¿ëÀÚÀÇ AuthID°¡ µË´Ï´Ù. |º°¸íÀÌ ÀÛ¼ºµÇ°í ³ª¸é, º°¸í¿¡ ´ëÇÑ Á¤º¸°¡ |Ä«Å»·Î±× ºä SYSCAT.TABLES, SYSCAT.TABOPTIONS, |SYSCAT.COLUMNS, SYSCAT.COLOPTIONS ¹× SYSCAT.INDEXES¿¡ ÀúÀåµË´Ï´Ù.
|Æä´õ·¹ÀÌƼµå µ¥ÀÌÅͺ£À̽º ¹é¾÷À» ´Ù¸¥ Æä´õ·¹ÀÌƼµå ¼¹ö·Î ¸®½ºÅä¾îÇÒ °æ¿ì, |µ¥ÀÌÅͺ£À̽º À̹ÌÁö¿¡´Â DB2 °è¿ µ¥ÀÌÅÍ ¼Ò½º¿¡ ¾×¼¼½ºÇÏ´Â µ¥ ÇÊ¿äÇÑ |»õ µ¥ÀÌÅͺ£À̽º ¹× ³ëµå µð·ºÅ丮 Á¤º¸°¡ µé¾î ÀÖÁö ¾Ê½À´Ï´Ù. |¸®½ºÅä¾î¸¦ ¼öÇàÇÒ ¶§´Â ÀÌ Á¤º¸¸¦ Ä«Å»·Î±×ÇØ¾ß ÇÕ´Ï´Ù.