{"id":1060,"date":"2009-04-20T09:24:39","date_gmt":"2009-04-20T01:24:39","guid":{"rendered":"http:\/\/www.killtest.com.tw\/?p=1060"},"modified":"2009-04-20T10:16:53","modified_gmt":"2009-04-20T02:16:53","slug":"db2-000-731","status":"publish","type":"post","link":"https:\/\/www.killtest.com.tw\/?p=1060","title":{"rendered":"DB2 000-731\u8003\u53e4\u984c"},"content":{"rendered":"<p>DB2:\u6578\u64da\u5fa9\u5236\u5c31\u662f\u901a\u904e\u5c07\u6e90\u6578\u64da\u5eab\u4e2d\u6307\u5b9a\u7684\u6578\u64da\u5fa9\u5236\u5230<span style=\"color: #000000;\"><a title=\"000-731\" href=\"http:\/\/www.killtest.com.tw\/index.php\/ibm\/000-731\/\" target=\"_blank\">000-731<\/a><\/span>\u76ee\u6a19\u6578\u64da\u5eab\u4e2d\uff0c\u4ee5\u4fdd\u6301\u6e90\u6578\u64da\u5eab\u8207\u76ee\u6a19\u6578\u64da\u5eab\u4e2d\u6307\u5b9a\u6578\u64da\u7684\u540c\u6b65\uff08\u58f9\u81f4\uff09\u3002<\/p>\n<p>\u6211\u5011\u4e3b\u8981\u7528\u5b83\u4f86\u5275\u5efa\u7528\u65bc\u5b58\u5132\u5fa9\u5236\u6a19\u6e96\u7684\u63a7\u5236\u8868\u3002<a title=\"DB2 000-731\" href=\"http:\/\/www.killtest.net\/DB2\/000-731.asp\" target=\"_blank\"><span style=\"color: #ff0000;\">000-731: DB2 9 DBA for Linux,UNIX and Windows<\/span><\/a>\u63a7\u5236\u8868\u6709\u591a\u7a2e\u985e\u578b\uff0c\u7528\u4f86\u5b58\u653e\u8981\u5fa9\u5236\u54ea\u4e9b\u8868\u54ea\u4e9b\u5217\u7b49\u4fe1\u606f\uff0c\u6211\u5011\u5728\u5f8c\u9762\u518d\u4ed4\u7d30\u63a2\u8a0e\u3002\u6211\u5011\u53ef\u4ee5\u4f7f\u7528\u7684\u7ba1\u7406\u754c\u9762\u6709\u5169\u7a2e\uff1a<br \/>\n1.DB2 Control Center\uff08DB2 \u63a7\u5236\u4e2d\u5fc3\uff09 \u53ea\u80fd\u91dd\u5c0dDB2\u670d\u52d9\u5668\u4e4b\u9593\u7684\u6578\u64da\u5fa9\u5236<br \/>\n2.DataJoiner Replication Administration (DJRA) \u53ef\u5305\u542b\u975eIBM\u6578\u64da\u5eab\u7684\u6578\u64da\u5fa9\u5236\uff08\u672c\u6587\u4e0d\u8a73\u7d30\u8a0e\u8ad6\uff09<\/p>\n<p>\u5177\u9ad4\u63a7\u5236\u8868\u985e\u578b\u53ef\u901a\u904e\u67e5\u770b\u6587\u4ef6\u201cSQLLIB\\samples\\repl\\dpcntl.udb\u201d\u4f86\u7372\u5f97\uff0c\u672c\u6587\u6d89\u53ca\u5230\u7684\u63a7\u5236\u8868\u4e3b\u8981\u6709\uff1aASN.IBMSNAP_REGISTER\u3001ASN.IBMSNAP_UOW\u7b49\u3002<\/p>\n<p><strong>\u57fa\u790e\u6982\u5ff5<\/strong><\/p>\n<p>CD\u8868\uff1achange data tables\u66f4\u6539\u6578\u64da\u8868\uff0c\u7528\u65bc\u81e8\u6642\u5b58\u653e\u66f4\u6539\u6578\u64da\u7684\u8868\u3002\u58f9\u822c\u5305\u542b\u6709\u9700\u8981\u6355\u6349\u66f4\u6539\u7684\u5217\u53ca\u58f9\u4e9b\u63a7\u5236\u5217\u3002<\/p>\n<p>\u4f8b\u5982\uff1a\u7528\u6236\u6307\u5b9a\u7684\uff0c\u8981\u6355\u6349\u66f4\u6539\u7684\u5217 CREATE\u00a0 TABLE\u00a0 DEPARTMENT (<\/p>\n<p>DEPTNO \u2026, &lt;&#8211;<\/p>\n<p>DEPTNAME \u2026, &lt;&#8211;<\/p>\n<p>MGRNO \u2026,<\/p>\n<p>ADMRDEPT \u2026,<\/p>\n<p>LOCATION \u2026)<\/p>\n<p>\u6e90\u8868 CREATE\u00a0 TABLE\u00a0 CD20030805296530(<\/p>\n<p>IBMSNAP_UOWID \u2026,<\/p>\n<p>IBMSNAP_INTENTSEQ\u2026,<\/p>\n<p>IBMSNAP_OPERATION \u2026,<\/p>\n<p>DEPTNO\u2026, &lt;&#8211;<\/p>\n<p>DEPTNAME \u2026) &lt;&#8211;<\/p>\n<p>CD\u8868 DB2\u65e5\u8a8c\u985e\u578b\uff1a \u5faa\u74b0\u65e5\u8a8c \u6b78\u6a94\u65e5\u8a8c\uff1a<\/p>\n<p>DB2\u6578\u64da\u5fa9\u5236\u7684\u7d44\u4ef6:DB2 DataPropagator\u7531\u4e09\u90e8\u5206\u7d44\u6210\uff1a\u7ba1\u7406\u754c\u9762\u3001\u66f4\u6539\u6355\u6349\u6a5f\u5236\u3001\u61c9\u7528\u7a0b\u5e8f<\/p>\n<p>\u8a3b\u610f\uff1a\u6b64\u8655\u61c9\u7528\u7a0b\u5e8f\uff08Apply program\uff09\u8207\u6211\u5011\u901a\u5e38\u6240\u8aaa\u7684\u61c9\u7528\u7a0b\u5e8f\u662f\u4e0d\u540c\u7684\u6982\u5ff5\uff0c\u672c\u6587\u4e2d\u5982\u7121\u7279\u6b8a\u8aaa\u660e\uff0c\u201c\u61c9\u7528\u7a0b\u5e8f\u201d\u90fd\u662f\u6307DB2\u6578\u64da\u5fa9\u5236\u7684\u7d44\u4ef6\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DB2:\u6578\u64da\u5fa9\u5236\u5c31\u662f\u901a\u904e\u5c07\u6e90\u6578\u64da\u5eab\u4e2d\u6307\u5b9a\u7684\u6578\u64da\u5fa9\u5236\u5230000-731\u76ee\u6a19\u6578\u64da\u5eab\u4e2d\uff0c\u4ee5\u4fdd\u6301\u6e90\u6578\u64da\u5eab\u8207\u76ee\u6a19\u6578\u64da\u5eab\u4e2d\u6307\u5b9a\u6578\u64da\u7684\u540c\u6b65\uff08\u58f9\u81f4\uff09\u3002 \u6211\u5011\u4e3b\u8981\u7528\u5b83\u4f86\u5275\u5efa\u7528\u65bc\u5b58\u5132\u5fa9\u5236\u6a19\u6e96\u7684\u63a7\u5236\u8868\u3002000-731: DB2 9 DBA for Linux,UNIX and Windows\u63a7\u5236\u8868\u6709\u591a\u7a2e\u985e\u578b\uff0c\u7528\u4f86\u5b58\u653e\u8981\u5fa9\u5236\u54ea\u4e9b\u8868\u54ea\u4e9b\u5217\u7b49\u4fe1\u606f\uff0c\u6211\u5011\u5728\u5f8c\u9762\u518d\u4ed4\u7d30\u63a2\u8a0e\u3002\u6211\u5011\u53ef\u4ee5\u4f7f\u7528\u7684\u7ba1\u7406\u754c\u9762\u6709\u5169\u7a2e\uff1a 1.DB2 Control Center\uff08DB2 \u63a7\u5236\u4e2d\u5fc3\uff09 \u53ea\u80fd\u91dd\u5c0dDB2\u670d\u52d9\u5668\u4e4b\u9593\u7684\u6578\u64da\u5fa9\u5236 2.DataJoiner Replication Administration (DJRA) \u53ef\u5305\u542b\u975eIBM\u6578\u64da\u5eab\u7684\u6578\u64da\u5fa9\u5236\uff08\u672c\u6587\u4e0d\u8a73\u7d30\u8a0e\u8ad6\uff09 \u5177\u9ad4\u63a7\u5236\u8868\u985e\u578b\u53ef\u901a\u904e\u67e5\u770b\u6587\u4ef6\u201cSQLLIB\\samples\\repl\\dpcntl.udb\u201d\u4f86\u7372\u5f97\uff0c\u672c\u6587\u6d89\u53ca\u5230\u7684\u63a7\u5236\u8868\u4e3b\u8981\u6709\uff1aASN.IBMSNAP_REGISTER\u3001ASN.IBMSNAP_UOW\u7b49\u3002 \u57fa\u790e\u6982\u5ff5 CD\u8868\uff1achange data tables\u66f4\u6539\u6578\u64da\u8868\uff0c\u7528\u65bc\u81e8\u6642\u5b58\u653e\u66f4\u6539\u6578\u64da\u7684\u8868\u3002\u58f9\u822c\u5305\u542b\u6709\u9700\u8981\u6355\u6349\u66f4\u6539\u7684\u5217\u53ca\u58f9\u4e9b\u63a7\u5236\u5217\u3002 \u4f8b\u5982\uff1a\u7528\u6236\u6307\u5b9a\u7684\uff0c\u8981\u6355\u6349\u66f4\u6539\u7684\u5217 CREATE\u00a0 TABLE\u00a0 DEPARTMENT ( DEPTNO \u2026, &lt;&#8211; DEPTNAME \u2026, &lt;&#8211; MGRNO \u2026, ADMRDEPT \u2026, LOCATION \u2026) \u6e90\u8868 CREATE\u00a0 TABLE\u00a0 CD20030805296530( IBMSNAP_UOWID \u2026, IBMSNAP_INTENTSEQ\u2026, IBMSNAP_OPERATION \u2026, DEPTNO\u2026, &lt;&#8211; DEPTNAME \u2026) &lt;&#8211; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[333,8],"tags":[332,365,3159],"class_list":["post-1060","post","type-post","status-publish","format-standard","hentry","category-000-731-ibm","category-ibm","tag-000-731","tag-db2","tag-ibm"],"_links":{"self":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1060","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1060"}],"version-history":[{"count":8,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1060\/revisions"}],"predecessor-version":[{"id":1063,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=\/wp\/v2\/posts\/1060\/revisions\/1063"}],"wp:attachment":[{"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1060"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1060"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.killtest.com.tw\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1060"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}