{"id":6159,"date":"2022-07-05T10:15:01","date_gmt":"2022-07-05T02:15:01","guid":{"rendered":"http:\/\/123.57.164.21\/?p=6159"},"modified":"2022-07-07T17:16:56","modified_gmt":"2022-07-07T09:16:56","slug":"db2-%e6%8c%87%e5%ae%9a%e5%ad%97%e7%ac%a6%e7%bc%96%e7%a0%81","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=6159","title":{"rendered":"DB2 \u6307\u5b9a\u5b57\u7b26\u7f16\u7801"},"content":{"rendered":"\n<p>\u5f53\u6211\u4eec\u5728DB2\u521b\u5efadatabase\u65f6\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u6307\u5b9a\u5b57\u7b26\u96c6\u7f16\u7801\u3002database\u5b57\u7b26\u96c6:\u5fc5\u987b\u5728\u5efa\u5e93\u65f6\u6307\u5b9a<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">\/\/ \u5982\u679c\u8981\u521b\u5efa\u7684\u6570\u636e\u5e93\u5df2\u7ecf\u5b58\u5728\uff0c\u53ef\u4ee5\u7528\u547d\u4ee4\u5220\u9664\ndb2 DROP DATABASE testdb\n\n\/\/ \u5982\u679c\u5220\u9664\u6570\u636e\u5e93\u65f6\uff0c\u63d0\u793a\u6570\u636e\u5e93\u88ab\u522b\u7684Process\u5360\u7528\uff0c\u53ef\u4ee5\u6267\u884c\u4e0b\u9762\u7684\u547d\u4ee4\ndb2 list applications \u67e5\u770b\u5f53\u524d\u6570\u636e\u5e93\u8fde\u63a5\u7684\u8fdb\u7a0b\ndb2 force applications all \u5f3a\u5236\u4e2d\u65ad\u8fd9\u4e9b\u8fde\u63a5\u8fde\u63a5\ndb2 DROP DATABASE testdb \u91cd\u65b0Drop\u6570\u636e\u5e93\n\n\/\/  --\u533a\u57df\u4e3a\u65e5\u672c\uff08JP\uff09\u7684IBM-943\u6570\u636e\u5e93\ndb2 create database testdb using codeset IBM-943 TERRITORY JP<\/pre>\n\n\n\n<p>\u521b\u5efa\u6210\u529f\u540e\uff0c\u7136\u540e\u6211\u4eec\u53ef\u4ee5\u8fde\u63a5\u5230\u6570\u636e\u5e93\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">db2 connect to testdb<\/pre>\n\n\n\n<p>\u8fde\u63a5\u6570\u636e\u5e93\u6210\u529f\u4ee5\u540e\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u67e5\u770b\u6570\u636e\u5e93\u5b57\u7b26\u96c6<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">db2 get db cfg<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-1024x914.png\" alt=\"\" class=\"wp-image-6162\" width=\"500\" height=\"445\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-1024x914.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-300x268.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-830x741.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-230x205.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7-350x313.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-7.png 1064w\" sizes=\"(max-width: 500px) 100vw, 500px\" \/><\/figure><\/div>\n\n\n\n<p>\u6211\u4eec\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u67e5\u770b\u5728\u5f53\u524d\u5b57\u7b26\u96c6\u4e0b\uff0c\u4e00\u4e2a\u6c49\u5b57\u5360\u7528\u6570\u636e\u5e93\u51e0\u4e2a\u957f\u5ea6\u3002\u53ef\u4ee5\u770b\u5230\u5728IBM-943\u4e0b\uff0c\u4e00\u4e2a\u5168\u89d2\u6c49\u5b57\u53602\u4e2a\u957f\u5ea6\uff0c\u534a\u89d2\u82f1\u6570\u5b57\u53601\u4e2a\u957f\u5ea6\u3002<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">SELECT Length('\u738b') FROM sysibm.sysdummy1<\/pre>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8.png\" alt=\"\" class=\"wp-image-6163\" width=\"462\" height=\"261\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8.png 782w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8-300x170.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8-768x434.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8-230x130.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8-350x198.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-8-480x271.png 480w\" sizes=\"(max-width: 462px) 100vw, 462px\" \/><\/figure><\/div>\n\n\n\n<p>\u5173\u4e8e\u5b57\u7b26\u96c6\u548c\u533a\u57df\u7684\u8bf4\u660e\uff0c\u53ef\u4ee5\u53c2\u8003DB2\u5b98\u65b9\u7684\u6587\u6863\u3002<\/p>\n\n\n\n<p><a href=\"https:\/\/www.ibm.com\/docs\/en\/db2\/11.5?topic=support-supported-territory-codes-code-pages\">https:\/\/www.ibm.com\/docs\/en\/db2\/11.5?topic=support-supported-territory-codes-code-pages<\/a><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/123.57.164.21\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-1024x961.png\" alt=\"\" class=\"wp-image-6168\" width=\"517\" height=\"485\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-1024x961.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-300x282.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-768x721.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-830x779.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-230x216.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-350x329.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9-480x451.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2022\/07\/\u56fe\u7247-9.png 1470w\" sizes=\"(max-width: 517px) 100vw, 517px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u5f53\u6211\u4eec\u5728DB2\u521b\u5efadatabase\u65f6\uff0c\u53ef\u4ee5\u7528\u4e0b\u9762\u7684\u547d\u4ee4\u6307\u5b9a\u5b57\u7b26\u96c6\u7f16\u7801\u3002database\u5b57\u7b26\u96c6:\u5fc5\u987b\u5728\u5efa\u5e93\u65f6\u6307\u5b9a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6159"}],"collection":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6159"}],"version-history":[{"count":9,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6159\/revisions"}],"predecessor-version":[{"id":6334,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/6159\/revisions\/6334"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}