Á¦ 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¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀÌ ÀÖ½À´Ï´Ù.