{"id":2073,"date":"2019-12-16T06:51:46","date_gmt":"2019-12-15T21:51:46","guid":{"rendered":"https:\/\/lab4ict.com\/system\/?p=2073"},"modified":"2023-06-14T23:11:18","modified_gmt":"2023-06-14T14:11:18","slug":"rhel-8%e3%81%abdb2%ef%bc%88v11-5%ef%bc%89%e3%82%92%e3%82%a4%e3%83%b3%e3%82%b9%e3%83%88%e3%83%bc%e3%83%ab%e3%81%99%e3%82%8b%ef%bc%81","status":"publish","type":"post","link":"https:\/\/lab4ict.com\/system\/archives\/2073","title":{"rendered":"Db2\uff08V11.5\uff09\u3092CentOS 8\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\uff01"},"content":{"rendered":"<p>CentOS 8\u306bDB2\uff08V11.5\uff09\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u307e\u3059\u3002<br \/>\n<!--more--><\/p>\n<h2>\u4f7f\u7528\u74b0\u5883<\/h2>\n<ul>\n<li>CentOS 8 (Server with GUI)<\/li>\n<li>Db2 V11.5<\/li>\n<\/ul>\n<h2>Db2 V11.5\u306e\u30c0\u30f3\u30ed\u30fc\u30c9<\/h2>\n<p>IBM\u306e\u30db\u30fc\u30e0\u30da\u30fc\u30b8\u304b\u3089\u3001IBM ID\u3092\u4f7f\u7528\u3057\u3066\u3001Db2 V11.5 Linux (AMD64\uff09\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u307e\u3059\u3002<\/p>\n<h2>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u60c5\u5831<\/h2>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306b\u5fc5\u8981\u306a\u60c5\u5831\u3092\u307e\u3068\u3081\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<table>\n<tbody>\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>Install User<\/td>\n<td>root<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>02<\/td>\n<td>FILE<\/td>\n<td>\/opt\/ibm\/db2\/V11.5<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>03<\/td>\n<td>INSTALL_TYPE<\/td>\n<td>TYPICAL<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>04<\/td>\n<td>LANG<\/td>\n<td>JP<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>05<\/td>\n<td>db2iadm1: Group ID<\/td>\n<td>2001<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>06<\/td>\n<td>db2fsdm1: Group ID<\/td>\n<td>2002<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>07<\/td>\n<td>db2inst1: User ID<\/td>\n<td>2001<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>08<\/td>\n<td>db2fenc1: User ID<\/td>\n<td>2002<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>09<\/td>\n<td>Port Number<\/td>\n<td>50000<\/td>\n<td>Default<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>root\u30e6\u30fc\u30b6\u306b\u30b9\u30a4\u30c3\u30c1<\/h2>\n<p>\u975eroot\u30e6\u30fc\u30b6\u3067\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u5236\u9650\u3082\u591a\u3044\u306e\u3067\u3001root\u30e6\u30fc\u30b6\u306b\u30b9\u30a4\u30c3\u30c1\u3057\u3066\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n$ sudo su -\r\n<\/pre>\n<h2>Db2\u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u5c55\u958b<\/h2>\n<p>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u914d\u7f6e\uff08\u4f8b\uff1a\/root\/Downloads\uff09\u3057\u3066\u3001\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305fDb2\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u5c55\u958b\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# cd \/root\/Downloads\r\n# gunzip -c v11.5_linuxx64_dec.tar.gz  | tar -xvf-\r\n<\/pre>\n<h2>\u30b5\u30a4\u30ec\u30f3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u7528\u306e\u5fdc\u7b54\u30d5\u30a1\u30a4\u30eb\u306e\u4f5c\u6210<\/h2>\n<p>\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u306e\u3067\u3001\u5c55\u958b\u3057\u305fDb2\u306e\u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u308a\u3001\u30b5\u30a4\u30ec\u30f3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u7528\u306e\u5fdc\u7b54\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1,2]; title: ; notranslate\" title=\"\">\r\n# cd \/root\/Downloads\/server_dec\r\n# vi db2server.rsp\r\nPROD          = DB2_SERVER_EDITION\r\nFILE          = \/opt\/ibm\/db2\/V11.5\r\nLIC_AGREEMENT = ACCEPT\r\nINSTALL_TYPE  = TYPICAL\r\nLANG          = JP\r\n<\/pre>\n<h2>Db2\u306e\u30b5\u30a4\u30ec\u30f3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u4f5c\u6210\u3057\u305f\u30b5\u30a4\u30ec\u30f3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u7528\u306e\u5fdc\u7b54\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u7528\u3057\u3066\u3001Db2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# .\/db2setup -r db2server.rsp\r\nRequirement not matched for DB2 database &quot;Server&quot; . Version: &quot;11.5.0.0&quot;. \r\n\r\nSummary of prerequisites that are not met on the current system: \r\n\r\n   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: &quot;\/lib\/libpam.so*&quot;. \r\n\r\n\r\nDBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: &quot;libstdc++.so.6&quot;. \r\n\r\n\r\nDBI1191I  db2setup is installing and configuring DB2 according to the\r\n      response file provided. Please wait.\r\n\r\n\r\nThe execution completed with warnings.\r\n\r\nFor more information see the DB2 installation log at &quot;\/tmp\/db2setup.log&quot;.\r\n<\/pre>\n<h2>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u72b6\u6cc1\u306e\u78ba\u8a8d<\/h2>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u5b8c\u4e86\u3057\u305f\u3089\u3001db2ls\u30b3\u30de\u30f3\u30c9\u3067\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u72b6\u6cc1\u306e\u78ba\u8a8d\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# db2ls\r\n\r\nInstall Path                       Level   Fix Pack   Special Install Number   Install Date                  Installer UID \r\n---------------------------------------------------------------------------------------------------------------------\r\n\/opt\/ibm\/db2\/V11.5               11.5.0.0        0                            Sun Dec 15 11:28:39 2019 EST             0 \r\n<\/pre>\n<h2>CentOS 8\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u306e\u78ba\u8a8d<\/h2>\n<p>Db2\u7528\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u4f5c\u6210\u306e\u305f\u3081\u3001AWS EC2\u306eRHEL 8\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1,5]; title: ; notranslate\" title=\"\">\r\n# cat \/etc\/passwd\r\nroot:x:0:0:root:\/root:\/bin\/bash\r\n...\r\nusradmin:x:1000:1000:usradmin:\/home\/sysadm001:\/bin\/bash\r\n# cat \/etc\/group\r\nroot:x:0:\r\n...\r\nusradmin:x:1000:\r\n<\/pre>\n<h2>Db2\u7528\u306e\u30e6\u30fc\u30b6\u304a\u3088\u3073\u30b0\u30eb\u30fc\u30d7\u306e\u4f5c\u6210<\/h2>\n<p>Db2\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\u30c7\u30d5\u30a9\u30eb\u30c8\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,8,9]; title: ; notranslate\" title=\"\">\r\n# groupadd -g 2001 db2iadm1\r\n# groupadd -g 2002 db2fsdm1\r\n# useradd -u 2001 -g db2iadm1 -m -d \/home\/db2inst1 db2inst1 \r\n# useradd -u 2002 -g db2fsdm1 -m -d \/home\/db2fenc1 db2fenc1 \r\n# passwd db2inst1\r\n# passwd db2fenc1\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<\/p>\n<pre class=\"brush: plain; highlight: [1]; title: ; notranslate\" title=\"\">\r\n# \/opt\/ibm\/db2\/V11.5\/instance\/db2icrt -s ese -u db2fenc1 db2inst1\r\n<\/pre>\n<h2>Db2\u306e\u8d77\u52d5\u3068\u505c\u6b62<\/h2>\n<p>Db2\u306e\u8d77\u52d5\u3068\u505c\u6b62\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: plain; highlight: [1,2,5]; title: ; notranslate\" title=\"\">\r\n# su - db2inst1\r\n$ db2start\r\n12\/15\/2019 11:47:12     0   0   SQL1063N  DB2START processing was successful.\r\nSQL1063N  DB2START processing was successful.\r\n$ db2stop\r\n12\/15\/2019 11:47:23     0   0   SQL1064N  DB2STOP processing was successful.\r\nSQL1064N  DB2STOP processing was successful.\r\n<\/pre>\n<h2>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e0a\u306e\u6ce8\u610f\u70b9<\/h2>\n<p>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4e0a\u306e\u6ce8\u610f\u70b9\u3092\u6574\u7406\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<ul>\n<li>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u524d\u306b\u3001\/etc\/hosts\u30d5\u30a1\u30a4\u30eb\u304c\u6b63\u3057\u304f\u8a2d\u5b9a\u3055\u308c\u3066\u3044\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\uff08hostname\u306e\u30a8\u30f3\u30c8\u30ea\u304c\u6b63\u3057\u304f\u5b58\u5728\u3059\u308b\u3053\u3068\uff09<\/li>\n<\/ul>\n<h2>\u304a\u308f\u308a\u306b<\/h2>\n<p>CentOS 8\u306bDb2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u884c\u3044\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u307e\u3067\u884c\u3044\u307e\u3057\u305f\u3002\u4ee5\u964d\u306f\u3001DB\u306e\u4f5c\u6210\u304b\u3089\u958b\u59cb\u3059\u308b\u3053\u3068\u304c\u3067\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>CentOS 8\u306bDB2\uff08V11.5\uff09\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\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":[482,480,52],"class_list":["post-2073","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-db2","tag-centos-8","tag-db2","tag-52"],"_links":{"self":[{"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/2073","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=2073"}],"version-history":[{"count":1,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/2073\/revisions"}],"predecessor-version":[{"id":10345,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/posts\/2073\/revisions\/10345"}],"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=2073"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/categories?post=2073"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/lab4ict.com\/system\/wp-json\/wp\/v2\/tags?post=2073"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}