Á¦ 10 Àå¿¡¼ ´ÙÀ½ ´Ü¶ôÀÌ °»½ÅµÇ¾ú½À´Ï´Ù.
|OS/390¿ë DB2 DataPropagator ¹öÀü 7(V7)À» ¼öÇàÇÏ·Á¸é |OS/390¿ë DB2 ¹öÀü 5, OS/390¿ë DB2 ¹öÀü 6 ¶Ç´Â OS/390¿ë DB2 ¹öÀü 7ÀÌ ÀÖ¾î¾ß ÇÕ´Ï´Ù.
|OS/390¿ë DB2 DataPropagator V7Àº À¯´ÏÄÚµå ¹× ASCII ÄÚµåÈ Ã¼°è¸¦ Áö¿øÇÕ´Ï´Ù. |»õ·Î¿î ÄÚµåÈ Ã¼°è¸¦ »ç¿ëÇÏ·Á¸é OS/390¿ë DB2 V7ÀÌ ÇÊ¿äÇϸç |DB2 DataPropagator ¼Ò½º, ¸ñÇ¥ ¹× Á¦¾î Å×À̺íÀ» ´ÙÀ½ ¼½¼Ç¿¡¼ ¼³¸íÇÏ´Â °Íó·³ |¼öµ¿À¸·Î ÀÛ¼ºÇϰųª º¯È¯ÇØ¾ß ÇÕ´Ï´Ù. |±×·¯³ª ±âÁ¸ º¹Á¦ ȯ°æ¿¡¼´Â ÄÚµåÈ Ã¼°è¸¦ ¼öÁ¤ÇÏÁö ¾Ê¾Æµµ OS/390¿ë DB2 DataPropagator V7·Î |ÀÛ¾÷ÇÒ ¼ö ÀÖ½À´Ï´Ù.
|¼Ò½º, CD ¹× ¸ñÇ¥ Å×ÀÌºí¿¡¼ °°Àº ÄÚµåÈ Ã¼°è¸¦ »ç¿ëÇÏ´Â °æ¿ì, |º¹Á¦ ȯ°æ¿¡¼ µ¥ÀÌÅÍ º¯È¯ÀÇ Çʿ伺À» ÃÖ¼ÒÈÇÒ ¼ö ÀÖ½À´Ï´Ù. |Å×ÀÌºí¿¡ ´ëÇÑ ÄÚµåÈ Ã¼°è¸¦ ¼±ÅÃÇÒ ¶§ ´ÜÀÏ CCSID ±ÔÄ¢À» µû¸£½Ê½Ã¿À. |Å×ÀÌºí ½ºÆäÀ̽ºÀÇ ¹®ÀÚ µ¥ÀÌÅ͸¦ ASCII, À¯´ÏÄÚµå ¶Ç´Â EBCDICÀ¸·Î ÄÚµåÈÇÒ ¼ö ÀÖ½À´Ï´Ù. |Å×ÀÌºí ½ºÆäÀ̽ºÀÇ ¸ðµç Å×À̺íÀº µ¿ÀÏÇÑ ÄÚµåÈ Ã¼°è¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù. |SQL¹®ÀÇ ¸ðµç Å×À̺í ÄÚµåÈ Ã¼°è´Â µ¿ÀÏÇØ¾ß ÇÕ´Ï´Ù. |¶ÇÇÑ ºä ¹× Á¶Àο¡¼ »ç¿ëÇÏ´Â ¸ðµç Å×À̺íÀº µ¿ÀÏÇÑ ÄÚµåÈ Ã¼°è¸¦ »ç¿ëÇØ¾ß ÇÕ´Ï´Ù.
|´ÜÀÏ CCSID ±ÔÄ¢À» µû¸£Áö ¾ÊÀ¸¸é DB2¿¡¼ À§¹ÝÀ» ¹ß°ßÇÏ¿© ¹ÙÀε峪 ½ÇÇà ½Ã¿¡ |SQLCODE -873À» ¸®ÅÏÇÕ´Ï´Ù. ASCII ¶Ç´Â À¯´ÏÄڵ带 ¾î¶² Å×ÀÌºí¿¡ »ç¿ëÇØ¾ß ÇÏ´ÂÁö´Â |Ŭ¶óÀ̾ðÆ®/¼¹ö ±¸¼º¿¡ µû¶ó ´Þ¶óÁý´Ï´Ù. |ƯÈ÷ Å×ÀÌºí¿¡ ´ëÇÑ ÄÚµåÈ Ã¼°è¸¦ ¼±ÅÃÇÒ ¶§ ÀÌ ±ÔÄ¢À» µû¸£½Ê½Ã¿À. |
|Å×ÀÌºí¿¡ ´ëÇØ ÀûÀýÇÑ ÄÚµåÈ Ã¼°è¸¦ ÁöÁ¤ÇÏ·Á¸é Å×À̺íÀ» »ý¼ºÇÒ ¶§ »ç¿ëÇÑ |SQLÀ» ¼öÁ¤ÇÕ´Ï´Ù. |
|Reorg ¹× ·Îµå À¯Æ¿¸®Æ¼¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ Á¤º¸´Â OS/390¿ë DB2 Universal Database |À¯Æ¿¸®Æ¼ ¾È³»¼ ¹× ÂüÁ¶¼¸¦ ÂüÁ¶ÇϽʽÿÀ.
|DPCNTL.MVS´Â OS/390¿ë DB2ÀÇ |sqllib\samples\replÀ» Æ÷ÇÔÇÏ°í ÀÖÀ¸¸ç Á¦¾î Å×À̺íÀ» ÀÛ¼ºÇÏ´Â |¸î °³ÀÇ CREATE TABLE¹®ÀÌ µé¾î ÀÖ½À´Ï´Ù. |ASCII ¶Ç´Â À¯´ÏÄڵ尡 ÇÊ¿äÇÑ Å×À̺í(¿¹: ASN.IBMSNAP_REGISTER ¹× ASN.IBMSNAP_PRUNCNTL)ÀÇ °æ¿ì, |´ÙÀ½ ¿¹¿Í °°ÀÌ CCSID ASCII ¶Ç´Â CCSID UNICODE Å°¿öµå¸¦ Ãß°¡ÇϽʽÿÀ.
|CREATE TABLE ASN.IBMSNAP_PRUNCNTL ( | TARGET_SERVER CHAR( 18) NOT NULL, | TARGET_OWNER CHAR( 18) NOT NULL, | TARGET_TABLE CHAR( 18) NOT NULL, | SYNCHTIME TIMESTAMP, | SYNCHPOINT CHAR( 10) FOR BIT DATA, | SOURCE_OWNER CHAR( 18) NOT NULL, | SOURCE_TABLE CHAR( 18) NOT NULL, | SOURCE_VIEW_QUAL SMALLINT NOT NULL, | APPLY_QUAL CHAR( 18) NOT NULL, | SET_NAME CHAR( 18) NOT NULL, | CNTL_SERVER CHAR( 18) NOT NULL, | TARGET_STRUCTURE SMALLINT NOT NULL, | CNTL_ALIAS CHAR( 8) | ) CCSID UNICODE | DATA CAPTURE CHANGES | IN TSSNAP02;
|±âÁ¸ Á¦¾î Å×ÀÌºí ¹× CD Å×À̺íÀ» ¼öÁ¤ÇÏ·Á¸é |Reorg ¹× ·Îµå À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇϽʽÿÀ.
|CREATE TABLE user1.cdtable1 ( | employee_name varchar, | employee_age decimal | ) CCSID UNICODE;
|OS/390¿ë DB2 UDB SQL ÂüÁ¶¼¿¡´Â CCSID¿¡ ´ëÇÑ |ÀÚ¼¼ÇÑ ³»¿ëÀÌ ÀÖ½À´Ï´Ù. |