{"id":3135,"date":"2020-04-16T18:48:13","date_gmt":"2020-04-16T09:48:13","guid":{"rendered":"https:\/\/lab4ict.com\/system\/?p=3135"},"modified":"2023-06-17T07:40:56","modified_gmt":"2023-06-16T22:40:56","slug":"db2%ef%bc%88v11-5%ef%bc%89%e3%81%a7%e8%a4%87%e6%95%b0%e3%81%ae%e3%82%a4%e3%83%b3%e3%82%b9%e3%82%bf%e3%83%b3%e3%82%b9%e3%82%92%e8%b5%b7%e5%8b%95%e3%81%99%e3%82%8b%ef%bc%81","status":"publish","type":"post","link":"https:\/\/lab4ict.com\/system\/archives\/3135","title":{"rendered":"Db2\uff08V11.5\uff09\u3067\u8907\u6570\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8d77\u52d5\u3059\u308b\uff01"},"content":{"rendered":"<p>Db2\u306b\u304a\u3044\u3066\u3001\u8907\u6570\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8d77\u52d5\u3059\u308b\u65b9\u6cd5\u3092\u307e\u3068\u3081\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<h2>\u4f7f\u7528\u74b0\u5883<\/h2>\n<ul>\n<li>CentOS 8.1 (Server with GUI)<\/li>\n<li>Db2 V11.5<\/li>\n<\/ul>\n<h2>\u6700\u521d\u306b\u6c7a\u3081\u308b\u3053\u3068<\/h2>\n<p>\u8907\u6570\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u7acb\u3061\u4e0a\u3052\u308b\u305f\u3081\u306b\u306f\u3001\u65b0\u898f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u7528\u306e\u30e6\u30fc\u30b6ID\u3001\u30b0\u30eb\u30fc\u30d7\u3068\u30dd\u30fc\u30c8\u756a\u53f7\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u3042\u3089\u304b\u3058\u3081\u6c7a\u3081\u3066\u304a\u304d\u307e\u3057\u3087\u3046\u3002\u6700\u521d\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30dd\u30fc\u30c8\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4ee5\u4e0b\u306e\u3068\u304a\u308a\u3067\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ grep -i db2inst  \/etc\/services\r\nDB2_db2inst1\t60000\/tcp\r\nDB2_db2inst1_1\t60001\/tcp\r\nDB2_db2inst1_2\t60002\/tcp\r\nDB2_db2inst1_3\t60003\/tcp\r\nDB2_db2inst1_4\t60004\/tcp\r\nDB2_db2inst1_END\t60005\/tcp\r\ndb2c_db2inst1\t50000\/tcp\r\n<\/pre>\n<h2>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210\u60c5\u5831<\/h2>\n<p>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210\u306b\u5fc5\u8981\u306a\u60c5\u5831\u3092\u307e\u3068\u3081\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<table>\n<tr>\n<th>No<\/th>\n<th>Name<\/th>\n<th>Value<\/th>\n<th>Comments<\/th>\n<\/tr>\n<tr>\n<td>01<\/td>\n<td>db2iadm2: Group ID<\/td>\n<td>2011<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>02<\/td>\n<td>db2fsdm2: Group ID<\/td>\n<td>2012<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>03<\/td>\n<td>db2inst2: User ID<\/td>\n<td>2011<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>04<\/td>\n<td>db2fenc2: User ID<\/td>\n<td>2012<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>05<\/td>\n<td>Port Number<\/td>\n<td>50010<\/td>\n<td><\/td>\n<\/tr>\n<\/table>\n<h2>Db2\u7528\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210<\/h2>\n<p>root\u30e6\u30fc\u30b6\u3067\u3001Db2\u7528\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30e6\u30fc\u30b6ID\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7ID\u306f\u3001\u4f5c\u6210\u6e08\u307f\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u3068\u91cd\u306a\u3089\u306a\u3044\u3088\u3046\u306b\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1,2,3,4,5,6,7]; title: ; notranslate\" title=\"\">\r\n# su -\r\n# groupadd -g 2011 db2iadm2\r\n# groupadd -g 2012 db2fsdm2\r\n# useradd -u 2011 -g db2iadm2 -m -d \/home\/db2inst2 db2inst2\r\n# useradd -u 2012 -g db2fsdm2 -m -d \/home\/db2fenc2 db2fenc2\r\n# passwd db2inst2\r\n# passwd db2fenc2\r\n<\/pre>\n<h2>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210<\/h2>\n<p>Db2\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002\u30dd\u30fc\u30c8\u756a\u53f7\u306f\u3001\u6700\u521d\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e50000\u304b\u3089\u5c11\u3057\u96e2\u3057\u3066\u300150010\u3068\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# \/opt\/ibm\/db2\/V11.5\/instance\/db2icrt -p 50010 -s ese -u db2fenc2 db2inst2\r\n<\/pre>\n<h2>Db2\u306e\u8d77\u52d5\u3068\u505c\u6b62<\/h2>\n<p>Db2\u306e\u8d77\u52d5\u3068\u505c\u6b62\u304c\u3067\u304d\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1,2,3]; title: ; notranslate\" title=\"\">\r\n# su - db2inst2\r\n$ db2start\r\n$ db2stop\r\n<\/pre>\n<h2>Db2\u3067\u4f7f\u7528\u3059\u308b\u30dd\u30fc\u30c8\u756a\u53f7\u306e\u78ba\u8a8d<\/h2>\n<p>Db2\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3067\u4f7f\u7528\u3059\u308b\u30dd\u30fc\u30c8\u756a\u53f7\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ grep -i db2inst  \/etc\/services\r\nDB2_db2inst1\t60000\/tcp\r\nDB2_db2inst1_1\t60001\/tcp\r\nDB2_db2inst1_2\t60002\/tcp\r\nDB2_db2inst1_3\t60003\/tcp\r\nDB2_db2inst1_4\t60004\/tcp\r\nDB2_db2inst1_END\t60005\/tcp\r\ndb2c_db2inst1\t50000\/tcp\r\nDB2_db2inst2\t60006\/tcp\r\nDB2_db2inst2_1\t60007\/tcp\r\nDB2_db2inst2_2\t60008\/tcp\r\nDB2_db2inst2_3\t60009\/tcp\r\nDB2_db2inst2_4\t60010\/tcp\r\nDB2_db2inst2_END\t60011\/tcp\r\ndb2c_db2inst2\t50010\/tcp\r\n<\/pre>\n<h2>\u304a\u308f\u308a\u306b<\/h2>\n<p>\u8907\u6570\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u3044\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u8d77\u52d5\u3068\u505c\u6b62\u304c\u884c\u3048\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3057\u305f\u3002\u3053\u306e\u5f8c\u306f\u3001\u6700\u521d\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3068\u540c\u69d8\u306b\u3001DB\u306e\u4f5c\u6210\u7b49\u3092\u884c\u3063\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<h2>\u53c2\u8003\u60c5\u5831<\/h2>\n<ul>\n<li><a href=\"https:\/\/www.ibm.com\/docs\/en\/db2\" target=\"_blank\" rel=\"noopener\">IBM Db2 documentation<\/a><\/li>\n<\/ul>\n<h2>\u95a2\u9023\u8a18\u4e8b<\/h2>\n<div class=\"sc_getpost\"><a class=\"clearfix\" href=\"https:\/\/lab4ict.com\/system\/archives\/4286\" ><div class=\"sc_getpost_thumb post-box-thumbnail__wrap\"><img decoding=\"async\" src=\"data:image\/gif;base64,R0lGODdhAQABAPAAAN3d3QAAACwAAAAAAQABAAACAkQBADs=\" width=\"150\" height=\"150\" alt=\"\u3010\u8a18\u4e8b\u4e00\u89a7\u3011Db2\u3092\u4f7f\u3044\u3053\u306a\u3059\uff01\" loading=\"lazy\" data-src=\"https:\/\/lab4ict.com\/system\/wp-content\/uploads\/2022\/12\/eyecatch_db2_02-150x150.png\" class=\"lazyload\"><\/div><div class=\"title\">\u3010\u8a18\u4e8b\u4e00\u89a7\u3011Db2\u3092\u4f7f\u3044\u3053\u306a\u3059\uff01<\/div><div class=\"substr\">Db2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304b\u3089\u6d3b\u7528\u306b\u95a2\u3059\u308b\u8a18\u4e8b\u306e\u4e00\u89a7\u3092\u63b2\u8f09\u3057\u307e\u3059\u3002...<\/div><\/a><\/div>\n<h2>Db2\u66f8\u7c4d\uff08Amazon\uff09<\/h2>\n<h3>\u5373\u6226\u529b\u306eDB2\u7ba1\u7406\u8853\u3000\uff5e\u4ed5\u7d44\u307f\u304b\u3089\u308f\u304b\u308b\u52b9\u7387\u7684\u7ba1\u7406\u306e\u30ce\u30a6\u30cf\u30a6<\/h3>\n<p><iframe style=\"width: 120px; height: 240px;\" sandbox=\"allow-popups allow-scripts allow-modals allow-forms allow-same-origin\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&amp;bc1=000000&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=infotecr-22&amp;language=ja_JP&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=as_ss_li_til&amp;asins=B07FC6JDJF&amp;linkId=78a998dac5b175577ad0fd2f81956839\"><\/iframe><\/p>\n<h3>DB2 10 \u30a8\u30d0\u30ea\u30e5\u30a8\u30fc\u30b7\u30e7\u30f3\u30fb\u30ac\u30a4\u30c9\u30d6\u30c3\u30af<\/h3>\n<p><iframe style=\"width: 120px; height: 240px;\" sandbox=\"allow-popups allow-scripts allow-modals allow-forms allow-same-origin\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\" frameborder=\"0\" src=\"\/\/rcm-fe.amazon-adsystem.com\/e\/cm?lt1=_blank&amp;bc1=000000&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=infotecr-22&amp;language=ja_JP&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=as_ss_li_til&amp;asins=479813189X&amp;linkId=f11cfb121245f63214f653b5812fa0cb\"><\/iframe><\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Db2\u306b\u304a\u3044\u3066\u3001\u8907\u6570\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u8d77\u52d5\u3059\u308b\u65b9\u6cd5\u3092\u307e\u3068\u3081\u307e\u3059\u3002<\/p>\n","protected":false},"author":1,"featured_media":6945,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[106],"tags":[480,520,519],"class_list":["post-3135","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db2","tag-db2","tag-520","tag-519"],"_links":{"self":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/3135","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/comments?post=3135"}],"version-history":[{"count":1,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/3135\/revisions"}],"predecessor-version":[{"id":10353,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/3135\/revisions\/10353"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media\/6945"}],"wp:attachment":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/media?parent=3135"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/categories?post=3135"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/tags?post=3135"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}