{"id":17,"date":"2007-04-05T01:00:12","date_gmt":"2007-04-04T16:00:12","guid":{"rendered":"http:\/\/192.168.24.51\/topics\/?p=17"},"modified":"2007-04-05T01:00:12","modified_gmt":"2007-04-04T16:00:12","slug":"db2-%e3%83%a6%e3%83%bc%e3%82%b6%e3%83%87%e3%83%bc%e3%82%bf%e3%81%ae%e6%a0%bc%e7%b4%8d%e5%a0%b4%e6%89%80%e3%81%ae%e7%a7%bb%e5%8b%95","status":"publish","type":"post","link":"https:\/\/chidipy.jpn.com\/topics\/?p=17","title":{"rendered":"DB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\u306e\u79fb\u52d5"},"content":{"rendered":"<p>DB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\u306e\u79fb\u52d5<br \/>\nDB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\uff08\u30b3\u30f3\u30c6\u30ca\uff09\u306e\u79fb\u52d5\u3059\u308b\u65b9\u6cd5\u3002<br \/>\nDB2\u306e\u30ea\u30c0\u30a4\u30ec\u30af\u30c8\u30ea\u30b9\u30c8\u30a2(RESTORE \u30b3\u30de\u30f3\u30c9)\u6a5f\u80fd\u3092\u5229\u7528\u3059\u308b<br \/>\n\uff11\uff0e\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9\u30fb\u30b3\u30f3\u30c6\u30ca\u60c5\u5831\u53d6\u5f97<br \/>\n\u3000\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9\u540d\u3068\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9ID\u306e\u78ba\u8a8d<\/p>\n<blockquote><p>$ db2 &#8220;LIST TABLESPACES&#8221;<\/p><\/blockquote>\n<p>\u3000\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9ID\u3054\u3068\u306b\u73fe\u5728\u306e\u30b3\u30f3\u30c6\u30ca\u30d1\u30b9\u306e\u78ba\u8a8d<\/p>\n<blockquote><p>$ db2 &#8220;LIST TABLESPACE CONTAINERS FOR <em>&lt;\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9ID&gt;<\/em>&#8220;<\/p><\/blockquote>\n<p>\uff12\uff0e\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u53d6\u5f97<\/p>\n<blockquote><p>$ db2 &#8220;BACKUP DATABASE <em>&lt;DB\u540d&gt; \uff5e\uff08\u4ee5\u4e0b\u7701\u7565\uff09<\/em>&#8220;<\/p><\/blockquote>\n<p>\uff13\uff0e\u30ea\u30c0\u30a4\u30ec\u30af\u30c8\u30aa\u30d7\u30b7\u30e7\u30f3\u3092\u4f7f\u7528\u3057\u3066\u3001\u30ea\u30b9\u30c8\u30a2\u3092\u5b9f\u884c\u3002<br \/>\n\u3000\u203b\u30ea\u30b9\u30c8\u30a2\u306f\u30da\u30f3\u30c7\u30a3\u30f3\u30b0\u72b6\u614b\u306b\u306a\u308b<\/p>\n<blockquote><p>$ db2 &#8220;RESTORE DATABASE &lt;DB\u540d&gt; FROM <em>&lt;\u30d0\u30c3\u30af\u30a2\u30c3\u30d7\u30a4\u30e1\u30fc\u30b8\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u30d1\u30b9&gt;<\/em> TAKEN AT <em>&lt;\u4f7f\u7528\u30c7\u30fc\u30bf\u306e\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7(YYYYMMDDhhmmss)&gt;<\/em> <strong>REDIRECT<\/strong>&#8220;<\/p><\/blockquote>\n<p>\uff14\uff0e\u30ea\u30b9\u30c8\u30a2\u3059\u308b\u30c7\u30fc\u30bf\u683c\u7d0d\u5834\u6240\uff08\u30b3\u30f3\u30c6\u30ca\u30d1\u30b9\uff09\u306e\u5909\u66f4<\/p>\n<blockquote><p>$ db2 &#8220;SET TABLESPACE CONTAINERS FOR <em>&lt;\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9ID&gt;<\/em> USING (path \u2018<em>&lt;\u65b0\u3057\u3044\u30b3\u30f3\u30c6\u30ca\u306e\u30d1\u30b9&gt;<\/em>&#8216;)&#8221;<\/p><\/blockquote>\n<p>\uff15\uff0e\u30ea\u30b9\u30c8\u30a2\u3092\u518d\u958b\u3059\u308b<\/p>\n<blockquote><p>$ db2 &#8220;RESTORE DATABASE <em>&lt;DB\u540d&gt;<\/em> <strong>CONTINUE<\/strong>&#8220;<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>DB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\u306e\u79fb\u52d5 DB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\uff08\u30b3\u30f3\u30c6\u30ca\uff09\u306e\u79fb\u52d5\u3059\u308b\u65b9\u6cd5\u3002 DB2\u306e\u30ea\u30c0\u30a4\u30ec\u30af\u30c8\u30ea\u30b9\u30c8\u30a2(RESTORE \u30b3\u30de\u30f3\u30c9)\u6a5f\u80fd\u3092\u5229\u7528\u3059\u308b \uff11\uff0e\u30c6\u30fc\u30d6\u30eb\u30b9\u30da\u30fc\u30b9\u30fb\u30b3\u30f3\u30c6\u30ca\u60c5\u5831\u53d6\u5f97 \u3000\u30c6\u30fc\u30d6\u30eb &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/chidipy.jpn.com\/topics\/?p=17\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;DB2 \u30e6\u30fc\u30b6\u30c7\u30fc\u30bf\u306e\u683c\u7d0d\u5834\u6240\u306e\u79fb\u52d5&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[12,2],"tags":[],"_links":{"self":[{"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=\/wp\/v2\/posts\/17"}],"collection":[{"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=17"}],"version-history":[{"count":0,"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=\/wp\/v2\/posts\/17\/revisions"}],"wp:attachment":[{"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/chidipy.jpn.com\/topics\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}