{"id":91,"date":"2018-07-12T09:56:01","date_gmt":"2018-07-12T01:56:01","guid":{"rendered":"http:\/\/lst.wting.me\/?p=91"},"modified":"2019-07-20T19:23:43","modified_gmt":"2019-07-20T11:23:43","slug":"db2%e8%bf%81%e5%ba%93","status":"publish","type":"post","link":"https:\/\/lst.wting.top\/?p=91","title":{"rendered":"DB2\u8fc1\u5e93"},"content":{"rendered":"<p>\u5220\u9664\u539f\u5df2\u7ecf\u635f\u574f\u7684DB<br \/>\ndb2 drop db CPONLDB<br \/>\n\u65b0\u5efa\u6570\u636e\u5e93<br \/>\ndb2 create db CPONLDB on \/CPONL using codeset GBK territory CN pagesize 32768;<br \/>\n\u67e5\u770b\u662f\u5426\u5efa\u6210<br \/>\ndb2 list db directory<br \/>\n\u65b0\u5efaschema<br \/>\ncreate schema XXX<br \/>\n\u4ece42\u5e93\u5bfc\u51fa\u539f\u6765\u7684\u6570\u636e<br \/>\ndb2look -d CPONLDB -z CP_ONLAP -e -c -o a.sql<br \/>\n-d\u8868\u793a\u5e93\u540d\uff0c-z\u8868\u793aschema\uff0c-o\u540e\u63a5\u4e00\u4e2aa.sql\u8868\u793a\u5bfc\u6210a.sql\u8fd9\u4e2a\u6587\u4ef6<\/p>\n<p>\u5bfc\u51fa\u7684SQL\u6587\u4ef6\u9700\u8981\u8fdb\u884c\u5904\u7406\uff0c\u56e0\u4e3a\u5bfc\u51fa\u7684SQL\u4f1a\u5bf9Sequence\u548c\u7d22\u5f15\u8fdb\u884c\u8bbe\u7f6e\uff0c\u6bd4\u5982\u628asequence\u8bbe\u7f6e\u6210\u8d77\u59cb\u4e8e1000\uff0c\u6240\u4ee5\u8fd9\u4e9b\u8bed\u53e5\u8981\u5220\u9664\u3002<br \/>\n\u53ef\u4ee5\u7528notepad\u548c\u6b63\u5219\u8868\u8fbe\u5f0f\u6765\u5b8c\u6210\uff0c\u6b63\u5219\u8868\u8fbe\u975e\u8d2a\u5a6a\u6a21\u5f0f\u5339\u914d\u6240\u6709\u5b57\u7b26\uff1a([\\s\\S]*?)<\/p>\n<p>\u7136\u540e\u5728\u65b0\u5e93\u521b\u5efa\u8868<br \/>\ndb2 -txf a.sql<\/p>\n<p>\u7ed9ap\u7528\u6237\u8d4b\u6743<br \/>\ndb2 &#8221; grant usage on sequence CP_ONLAP.SEQ_SJCZ_EBPPTRANS to cp_onlap &#8221;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u5220\u9664\u539f\u5df2\u7ecf\u635f\u574f\u7684DB db2 drop db CPONLDB \u65b0\u5efa\u6570\u636e\u5e93 db2 create db CPON [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/posts\/91"}],"collection":[{"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lst.wting.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=91"}],"version-history":[{"count":1,"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":92,"href":"https:\/\/lst.wting.top\/index.php?rest_route=\/wp\/v2\/posts\/91\/revisions\/92"}],"wp:attachment":[{"href":"https:\/\/lst.wting.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lst.wting.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lst.wting.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}