{"id":290,"date":"2011-05-14T19:56:00","date_gmt":"2011-05-14T10:56:00","guid":{"rendered":"http:\/\/www.typea.info\/blog\/index.php\/2011\/05\/14\/db2_express-c\/"},"modified":"2011-05-14T19:56:00","modified_gmt":"2011-05-14T10:56:00","slug":"db2_express-c","status":"publish","type":"post","link":"https:\/\/www.typea.info\/blog\/index.php\/2011\/05\/14\/db2_express-c\/","title":{"rendered":"DB2 Express-C \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u308b"},"content":{"rendered":"<\/p>\n<p>\u52c9\u5f37\u304c\u3066\u3089\u3001DB2\u3092\u89e6\u308b\u305f\u3081\u306b\u3001Express-C \u3092 CentOS \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u308b\u3002<\/p>\n<p>\u6700\u521d\u306f\u3001<a href=\"http:\/\/dream.jp\/vps\/\">ServersMan@VPS<\/a>\u3000Entry \u30d7\u30e9\u30f3 \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u305f\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u81ea\u4f53\u306f\u6210\u529f\u3059\u308b\u306e\u3060\u304c\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u30e1\u30e2\u30ea\u4e0d\u8db3\u3067\u8d77\u52d5\u3057\u306a\u3044\u3002\u3084\u306f\u308a 256MB \u306e\u30b5\u30fc\u30d0\u30fc\u306bRDBMS\u3092\u5165\u308c\u308b\u306e\u306f\u7121\u7406\u304c\u3042\u308b\u304b\u3002\u304d\u3063\u3068\u4e0a\u4f4d\u5951\u7d04\u306b\u3059\u308c\u3070\u826f\u3044\u306f\u305a\u3060\u304c\u3001\u5b66\u7fd2\u7528\u306b\u306f\u3082\u3063\u305f\u3044\u306a\u3044\u3002<\/p>\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u9014\u4e2d\u304b\u3089\u3001VirtualBox \u4e0a\u306e CentOS\u306b\u5207\u308a\u66ff\u3048\u305f\u3002<\/p>\n<p>DB2 Express-C \u306f\u3001\u4f7f\u7528\u3067\u304d\u308b\u30e1\u30e2\u30ea2G\u3001CPU\u30b3\u30a22\u3064\u3068\u3044\u3046\u5236\u9650\u304c\u3042\u308b\u304c\u3001\u57fa\u672c\u7684\u306b\u30c7\u30fc\u30bf\u30b5\u30a4\u30ba\u3084\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6570\u7b49\u306a\u3069\u306e\u5236\u9650\u306f\u884c\u308f\u306a\u3044\u3001\u518d\u9812\u5e03\u3082\u7533\u8acb\u3059\u308c\u3070\u53ef\u80fd\u3001\u3068\u975e\u5e38\u306b\u9762\u767d\u3044\u30e9\u30a4\u30bb\u30f3\u30b9\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u5834\u9762\u306b\u3088\u3063\u3066\u306f\u3001\u304b\u306a\u308a\u4f7f\u3048\u308b\u306e\u3067\u306f\u306a\u3044\u304b\u3002<\/p>\n<p>Linux \u7528 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30ac\u30a4\u30c9<\/p>\n<p><a href=\"http:\/\/www.ibm.com\/developerworks\/jp\/offers\/db2express-c\/installlin_v95\/\">http:\/\/www.ibm.com\/developerworks\/jp\/offers\/db2express-c\/installlin_v95\/<\/a><\/p>\n<p>\u2605 \u306f\u3001\u5fc5\u8981\u306a\u7b87\u6240\u3001\u2606\u306f\u3001<a href=\"mailto:ServersMan@VPS\">ServersMan@VPS<\/a> \u3067\u306f\u307e\u3063\u305f\u3001\u57fa\u672c\u7684\u306b\u4e0d\u8981\u306a\u7b87\u6240<\/p>\n<h2>\u2605 \u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h2>\n<p><a href=\"http:\/\/www-06.ibm.com\/software\/jp\/data\/db2\/v9\/express-c\/\">http:\/\/www-06.ibm.com\/software\/jp\/data\/db2\/v9\/express-c\/<\/a><\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_01.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_01\" border=\"0\" alt=\"db2_express_c_01\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_01_thumb.jpg\" width=\"347\" height=\"237\" \/><\/a> <\/p>\n<p>\u672c\u4f53:db2exc_974_LNX_x86.tar.gz \u3068\u3001\u30e9\u30f3\u30b2\u30fc\u30b8\u30d1\u30c3\u30af : db2exc_nlpack_974_LNX_x86.tar.gz \u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3002IBM ID \u304c\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306b\u5fc5\u8981\u3002\u7121\u6599\u3067ID\u306f\u53d6\u5f97\u3067\u304d\u308b\u3002(\u81ea\u5206\u306f\u4ee5\u524d\u30e1\u30f3\u30d0\u30fc\u306b\u306a\u3063\u3066\u3044\u305f\u3088\u3046\u3067\u3001\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u305f)<\/p>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u308b\u3082\u3001\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u8db3\u308a\u306a\u3044<\/h3>\n<p><a href=\"mailto:ServersMan@VPS\">ServersMan@VPS<\/a> \u3067\u306f\u3001\u30e9\u30a4\u30d6\u30e9\u30ea\u304c\u8db3\u308a\u306a\u304b\u3063\u305f\u305f\u3081\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3002CentOS\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30e9\u304b\u3089\u3001GUI Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u5834\u5408\u3001\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u5225\u9014\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u5fc5\u8981\u306f\u306a\u304b\u3063\u305f\u3002<\/p>\n<pre class=\"prettyprint linenums\"># tar -xvf db2exc_974_LNX_x86.tar.gz\r\n# cd expc\r\n# .\/db2setup\r\nERROR: \r\n   The required library file libaio.so.1 is not found on the system. \r\n   Check the following web site for the up-to-date system requirements\r\n   of IBM DB2 9.7\r\n   http:\/\/www.ibm.com\/software\/data\/db2\/udb\/sysreqs.html\r\n   http:\/\/www.software.ibm.com\/data\/db2\/linux\/validate  \r\n  Aborting the current installation ...\r\n  Run installation with the option \"-f sysreq\" parameter to force the installation.<\/pre>\n<p><a href=\"http:\/\/www.liferay.com\/ja\/community\/wiki\/-\/wiki\/Main\/DB2+Express-C+9.5+on+CentOS+5.2#section-DB2+Express-C+9.5+on+CentOS+5.2-InstallDB2\">\u30e9\u30a4\u30d6\u30e9\u30ea\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/a>\u3057\u3066\u518d\u5b9f\u884c\u3057\u3066\u307f\u308b\u3002<\/p>\n<pre class=\"prettyprint linenums\"># yum install compat-libstdc++-33\r\n# yum install libaio\r\n# .\/db2setup\r\nDBI1190I  db2setup is preparing the DB2 Setup wizard which will guide\r\n      you through the program setup process. Please wait.\r\n\r\nThe DISPLAY variable is not set properly.  Ensure that the DISPLAY variable is set properly and that permissions are set properly to open windows on the display specified, then rerun the command.<\/pre>\n<p>&nbsp;<\/p>\n<h2>\u2606 VNC\u3092\u5165\u308c\u308b<\/h2>\n<p><a href=\"mailto:ServersMan@VPS\">ServersMan@VPS<\/a> \u3067\u306f\u3001\u5f53\u7136\u3001GUI\u306f\u306a\u3044\u306e\u3067\u3001VNC\u3092\u5165\u308c\u3066\u307f\u308b\u3002VirtualBox\u306b\u306f\u3001GUI Server \u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u3002<\/p>\n<p>\u9014\u4e2d\u3067\u4f5c\u6210\u3059\u308b\u3001\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u8a2d\u5b9a\u30d5\u30a1\u30a4\u30eb\u3092\u5229\u7528\u3059\u308b\u3068\u3001\u30b5\u30a4\u30ec\u30f3\u30c8\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u81ea\u4f53\u306f\u53ef\u80fd\u306a\u3088\u3046\u3060\u3002<\/p>\n<h3>switchdesk\u3057\u3088\u3046\u3068\u3057\u305f\u3089\u3001GNOME \u304c\u306a\u3044\u306e\u3067\u3001\u8a00\u308f\u308c\u305f\u3068\u304a\u308a\u306bGNOME\u3082\u5165\u308c\u308b<\/h3>\n<pre class=\"prettyprint linenums\"># yum install vnc-server.i386\r\n# yum install switchdesk\r\n# switchdesk gnome\r\nRed Hat Linux switchdesk 4.0\r\nCopyright (C) 1999-2004 Red Hat, Inc\r\nRedistributable under the terms of the GNU General Public License\r\nERROR: GNOME is not installed on your machine! to install GNOME, please type\r\nyum groupinstall \"GNOME Desktop Environment\"<\/pre>\n<h3>\u6307\u6458\u901a\u308a GNOME \u3092\u5165\u308c\u308b<\/h3>\n<pre><\/pre>\n<pre class=\"prettyprint linenums\"># yum groupinstall \"GNOME Desktop Environment\"<\/pre>\n<p>\u30c7\u30b9\u30af\u30c8\u30c3\u30d7\u3092 GNOME \u306b\u5909\u66f4\u3059\u308b<\/p>\n<pre class=\"prettyprint linenums\"># switchdesk gnome\r\nRed Hat Linux switchdesk 4.0\r\nCopyright (C) 1999-2004 Red Hat, Inc\r\nRedistributable under the terms of the GNU General Public License\r\nDesktop now set up to run GNOME.<\/pre>\n<p>\u4e00\u65e6\u3001vncserver \u3092\u5b9f\u884c\u5f8c\u3001\u8a2d\u5b9a\u3092\u66f8\u304d\u63db\u3048\u308b<\/p>\n<pre class=\"prettyprint linenums\"># cd \/root\/.vnc\r\n# mv xstartup  xstartup.bak\r\n# ln -s \/root\/.Xclients xstartup<\/pre>\n<p>vncserver \u3092\u5b9f\u884c<\/p>\n<pre class=\"prettyprint linenums\"># vncserver\r\nxauth: (stdin):1:  bad display name \"dti-vps-srv39:1\" in \"add\" command\r\n\r\nNew 'dti-vps-srv39:1 (root)' desktop is dti-vps-srv39:1\r\n\r\nStarting applications specified in \/root\/.vnc\/xstartup\r\nLog file is \/root\/.vnc\/dti-vps-srv39:1.log<\/pre>\n<p><a href=\"mailto:ServersMan@VPS\">ServersMan@VPS<\/a> \u306bVNC\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u63a5\u7d9a\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_02.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_02\" border=\"0\" alt=\"db2_express_c_02\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_02_thumb.jpg\" width=\"572\" height=\"324\" \/><\/a> <\/p>\n<h2>\u2605 DB2 Express-C \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u305f\u30d5\u30a1\u30a4\u30eb\u3092\u89e3\u51cd\u3057\u3001expc \u30d5\u30a9\u30eb\u30c0\u306e\u4e2d\u3067\u3001db2setup \u3092\u5b9f\u884c<\/p>\n<pre class=\"prettyprint linenums\"># tar -xvf db2exc_974_LNX_x86.tar.gz\r\n# cd expc\r\n# .\/db2setup<\/pre>\n<h3>\u5de6\u5074\u30da\u30a4\u30f3\u3067\u3001Install a Product \u3092\u9078\u629e<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_03.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_03\" border=\"0\" alt=\"db2_express_c_03\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_03_thumb.jpg\" width=\"445\" height=\"237\" \/><\/a> <\/p>\n<h3>Install New \u3092\u9078\u629e<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_04.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_04\" border=\"0\" alt=\"db2_express_c_04\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_04_thumb.jpg\" width=\"259\" height=\"174\" \/><\/a> <\/p>\n<h3>DB2\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u524d\u306b\u3001\u6700\u4f4e\u3067\u3082\u4ee5\u4e0b\u306e\u4e8b\u3092\u8a08\u753b\u3057\u3066\u304a\u304f\u5fc5\u8981\u304c\u3042\u308b\u3089\u3057\u3044<\/h3>\n<p>DB2\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306f\u521d\u3081\u3066\u306a\u306e\u3067\u3001\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u9032\u3081\u308b\u3002<\/p>\n<table border=\"1\" cellspacing=\"0\" cellpadding=\"2\" width=\"438\">\n<tbody>\n<tr>\n<td valign=\"top\" width=\"270\">DB2\u7ba1\u7406\u30b5\u30fc\u30d0\u30fc\u306e\u30e6\u30fc\u30b6\u30fc\u540d<\/td>\n<td valign=\"top\" width=\"166\">\u30c7\u30d5\u30a9\u30eb\u30c8\uff1adasadm1<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"270\">DB2\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30fb\u30aa\u30fc\u30ca\u30fc\u30fb\u30e6\u30fc\u30b6\u30fc\u540d<\/td>\n<td valign=\"top\" width=\"166\">\u30c7\u30d5\u30a9\u30eb\u30c8\uff1a<strong>db2inst1<\/strong><\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"270\">fenced\u30e6\u30fc\u30b6\u30fc\u306e\u30e6\u30fc\u30b6\u30fc\u540d<\/td>\n<td valign=\"top\" width=\"166\">\u30c7\u30d5\u30a9\u30eb\u30c8\uff1adb2fenc1<\/td>\n<\/tr>\n<tr>\n<td valign=\"top\" width=\"270\">\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306eTCP\/IP\u30dd\u30fc\u30c8\u756a\u53f7<\/td>\n<td valign=\"top\" width=\"166\"><strong>50000\u756a<\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>&nbsp;<\/p>\n<blockquote>\n<p>\u300cDB2\u306e\u30b5\u30fc\u30d0\u30fc\u30fb\u30d7\u30ed\u30bb\u30b9\u306f\u3001\u4e0a\u8a18\u306e\u300cDB2\u306e\u7ba1\u7406\u30e6\u30fc\u30b6\u30fc\u300d\u3067\u8d77\u52d5\u3055\u308c\u307e\u3059\u3002\u307e\u305f\u3001DB2 \u3067\u306f\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u5916\u90e8\uff08\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\uff09\u304b\u3089\u306e\u63a5\u7d9a\u3092\u53d7\u3051\u4ed8\u3051\u308b\u305f\u3081\u306b\u30011\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u6bce\u306b\u4e00\u3064\u3001\u73fe\u5728\u4f7f\u7528\u3057\u3066\u3044\u306a\u3044\u30dd\u30fc\u30c8\u756a\u53f7\u304c\u5fc5\u8981\u306b\u306a\u308a\u307e\u3059\u3002\u300d<\/p>\n<\/blockquote>\n<p>\u3078\u3047\u3002<\/p>\n<h3>Next<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_05.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_05\" border=\"0\" alt=\"db2_express_c_05\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_05_thumb.jpg\" width=\"358\" height=\"270\" \/><\/a> <\/p>\n<p>\u6b21\u306e\u753b\u9762\u3067\u306f\u3001\u30e9\u30a4\u30bb\u30f3\u30b9\u306b\u540c\u610f\u3057\u3066Next<\/p>\n<h3>Typical (\u6a19\u6e96)- Next<\/h3>\n<p>View Features \u3067\u5c0e\u5165\u3055\u308c\u308b\u30b3\u30f3\u30dd\u30fc\u30cd\u30f3\u30c8\u3092\u78ba\u8a8d\u3067\u304d\u308b\u3002<\/p>\n<blockquote>\n<p>\u300c\u591a\u304f\u306e\u5834\u5408\u3001\u300c\u6a19\u6e96\u300d\u306e\u307e\u307e\u3067\u554f\u984c\u3042\u308a\u307e\u305b\u3093\u3002\u300d<\/p>\n<\/blockquote>\n<p>\u3068\u3044\u3046\u3053\u3068\u306e\u306a\u306e\u3067\u3001\u305d\u306e\u307e\u307e\u3067\u6b21\u3078\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_06.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_06\" border=\"0\" alt=\"db2_express_c_06\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_06_thumb.jpg\" width=\"355\" height=\"302\" \/><\/a> <\/p>\n<\/p>\n<h3>\u5fdc\u7b54\u30d5\u30a1\u30a4\u30eb\uff08\u30ec\u30b9\u30dd\u30f3\u30b9\u30fb\u30d5\u30a1\u30a4\u30eb\uff09\u3092\u4f5c\u6210\u3059\u308b\u304b\u3069\u3046\u304b\u3092\u8a2d\u5b9a<\/h3>\n<blockquote>\n<p>\u300c\u5fdc\u7b54\u30d5\u30a1\u30a4\u30eb\u306f\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u9078\u629e\u3057\u305f\u5185\u5bb9\u3092\u8a18\u9332\u3057\u3066\u304a\u304f\u30d5\u30a1\u30a4\u30eb\u3067\u3001\u540c\u3058\u5185\u5bb9\u3067\u6b21\u56de\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3059\u308b\u969b\u306b\u305d\u306e\u30d5\u30a1\u30a4\u30eb\u3092\u4f7f\u7528\u3059\u308b\u3068\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u4f5c\u696d\u3092\u81ea\u52d5\u5316\u3067\u304d\u308b\u3068\u3044\u3046\u3082\u306e\u3067\u3059\u3002\u300d<\/p>\n<\/blockquote>\n<p>\u306a\u3057\u3067\u3044\u3044\u304b\u306a\u3002\u3068\u308a\u3042\u3048\u305a\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_07.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_07\" border=\"0\" alt=\"db2_express_c_07\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_07_thumb.jpg\" width=\"366\" height=\"190\" \/><\/a> <\/p>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306f\u30c7\u30d5\u30a9\u30eb\u30c8\u306e\u307e\u307e\u3067<\/h3>\n<p>\/opt\/ibm\/db2\/V9.7<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_08.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_08\" border=\"0\" alt=\"db2_express_c_08\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_08_thumb.jpg\" width=\"365\" height=\"218\" \/><\/a> <\/p>\n<h3>DB2\u306e\u7ba1\u7406\u30e6\u30fc\u30b6\u30fc\u306b\u3064\u3044\u3066\u306e\u8a2d\u5b9a<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_09.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_09\" border=\"0\" alt=\"db2_express_c_09\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_09_thumb.jpg\" width=\"363\" height=\"276\" \/><\/a> <\/p>\n<h3>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3059\u308b\u306b\u3057\u3066\u3001\u6b21\u3078<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_10.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_10\" border=\"0\" alt=\"db2_express_c_10\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_10_thumb.jpg\" width=\"356\" height=\"110\" \/><\/a> <\/p>\n<blockquote>\n<p>\u300cDB2\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u3092\u4f5c\u6210\u3059\u308b\u300d\u3092\u9078\u3070\u306a\u3044\u5834\u5408\u3001\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u6271\u3046\u305f\u3081\u306e\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u4f5c\u6210\u30fb\u69cb\u6210\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30fb\u30d7\u30ed\u30bb\u30b9\u306e\u4e2d\u3067\u306f\u884c\u308f\u308c\u305a\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u7d42\u4e86\u5f8c\u306bdb2icrt\u30b3\u30de\u30f3\u30c9\u306a\u3069\u3092\u7528\u3044\u3066\u30de\u30cb\u30e5\u30a2\u30eb\u3067\u5b9f\u65bd\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<h3>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30fb\u30aa\u30fc\u30ca\u30fc\u30fb\u30e6\u30fc\u30b6\u30fc\u306b\u3064\u3044\u3066\u6307\u5b9a<\/h3>\n<p>fenced\u30e6\u30fc\u30b6\u30fc\u306b\u3064\u3044\u3066\u3082\u3001\u540c\u69d8\u306b\u3001\u30d1\u30b9\u30ef\u30fc\u30c9\u3092\u8a2d\u5b9a\u3057\u9032\u3081\u308b\u3002<\/p>\n<p>fenced\u30e6\u30fc\u30b6\u30fc\u3068\u306f\u3001<\/p>\n<blockquote>\n<p>DB2\u306e\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u3001\u30b9\u30c8\u30a2\u30fc\u30c9\u30fb\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30fc\u306a\u3069\u306f\u3001fenced\u30e6\u30fc\u30b6\u30fc\u6a29\u9650\u3067\u5b9f\u884c\u3055\u308c\u307e\u3059\u3002fenced\u30e6\u30fc\u30b6\u30fc\u3092\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u30fb\u30aa\u30fc\u30ca\u30fc\u3068\u5225\u306b\u6307\u5b9a\u3059\u308b\u3053\u3068\u3067\u3001\u30e6\u30fc\u30b6\u30fc\u5b9a\u7fa9\u95a2\u6570\u3001\u30b9\u30c8\u30a2\u30fc\u30c9\u30fb\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3\u30fc\u306b\u554f\u984c\u304c\u3042\u3063\u305f\u969b\u306b\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u672c\u4f53\u3078\u5f71\u97ff\u3092\u53ca\u307c\u3059\u3053\u3068\u3092\u9632\u304e\u307e\u3059\u3002<\/p>\n<\/blockquote>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_11.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_11\" border=\"0\" alt=\"db2_express_c_11\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_11_thumb.jpg\" width=\"361\" height=\"239\" \/><\/a> <\/p>\n<h3>\u8a2d\u5b9a\u5185\u5bb9\u306e\u30b5\u30de\u30ea\u30fc\u304c\u8868\u793a\u3055\u308c\u308b<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_12.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_12\" border=\"0\" alt=\"db2_express_c_12\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_12_thumb.jpg\" width=\"364\" height=\"292\" \/><\/a> <\/p>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u5b9f\u884c\u4e2d<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_13.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_13\" border=\"0\" alt=\"db2_express_c_13\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_13_thumb.jpg\" width=\"329\" height=\"260\" \/><\/a> <\/p>\n<\/p>\n<\/p>\n<\/p>\n<h3>\u30de\u30a4\u30ca\u30fc\u30a8\u30e9\u30fc\u767a\u751f\uff01\uff1f<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_14.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_14\" border=\"0\" alt=\"db2_express_c_14\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_14_thumb.jpg\" width=\"357\" height=\"242\" \/><\/a> <\/p>\n<p>Post-install steps \u3092\u5b9f\u884c\u3057\u308d\u3068\u8a00\u3063\u3066\u3044\u308b\u3088\u3046\u3060\u3002<\/p>\n<p>\/tmp\/db2setup.log \u3092\u898b\u308b\u3068\u3001<\/p>\n<pre class=\"prettyprint linenums\">ERROR: SQL1042C  An unexpected system error occurred.\r\n\r\nERROR: An error occurred while trying to start the \"db2inst1\" instance. The\r\nreturn code is \"4\" and the SQL Message is:   \"PROCESS_ERROR\"\r\n\r\nERROR: An error occurred while configuring the instance \"db2inst1\".\r\n\r\nConfiguring DB2 instances :.......Failure \r\n\r\n\r\nERROR: An error occurred while trying to start the \"db2inst1\" instance. The\r\nreturn code is \"4\" and the SQL Message is:   \"PROCESS_ERROR\"\r\n\r\nERROR: The installation program is unable to add the contact \"db2inst1\". The\r\nreturn value is \"5109\". See the DB2 Information Center for more information\r\nabout adding contacts and configuring health alert notifications.<\/pre>\n<p>\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u8d77\u52d5\u306b\u5931\u6557\u3057\u3066\u3044\u308b\u3088\u3046\u3060\u3002<\/p>\n<p>\u3053\u306e\u5f8c\u3001OS\u81ea\u4f53\u304c\u30e1\u30e2\u30ea\u4e0d\u8db3\u3067\u30a6\u30a3\u30f3\u30c9\u30a6\u304c\u958b\u304b\u306a\u3044\u3001\u30b3\u30de\u30f3\u30c9\u304c\u5b9f\u884c\u3067\u304d\u306a\u3044\u7b49\u306e\u72b6\u6cc1\u3068\u306a\u3063\u305f\u306e\u3067\u3001\u30e1\u30e2\u30ea\u304c\u8db3\u308a\u306a\u3044\u305f\u3081\u3001\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u306e\u8d77\u52d5\u304c\u3067\u304d\u306a\u304b\u3063\u305f\u306e\u3060\u308d\u3046\u3002<\/p>\n<p>\u30e1\u30e2\u30ea\u30922G\u306b\u8a2d\u5b9a\u3057\u305f\u3001VirtualBox\u4e0a\u306bCentOS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001\u3053\u3053\u307e\u3067\u306e\u4f5c\u696d\u3092\u3084\u308a\u76f4\u3057\u305f\u3068\u3053\u308d\u3001\u306f\u6210\u529f\u3002<\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_23.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_23\" border=\"0\" alt=\"db2_express_c_23\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_23_thumb.jpg\" width=\"323\" height=\"217\" \/><\/a>&nbsp;<\/p>\n<h2>\u2605 \u30e9\u30f3\u30b2\u30fc\u30b8\u30d1\u30c3\u30af\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb<\/h2>\n<p>\u4e00\u65e6\u3001db2inst1 \u30e6\u30fc\u30b6\u3067\u30ed\u30b0\u30a4\u30f3\u3057\u76f4\u3057\u3001db2stop \u3092\u884c\u3063\u3066\u304b\u3089\u3001root\u306b\u306a\u3063\u3066\u5b9f\u884c(\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u304c\u52d5\u3044\u3066\u3044\u308b\u3068\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3059\u308b\u3053\u3068\u304c\u3042\u308b\u3068\u306e\u3053\u3068\u306a\u306e\u3067)<\/p>\n<pre class=\"prettyprint linenums\"># tar -xvf db2exc_nlpack_974_LNX_x86.tar.gz\r\n# cd nlpack\/\r\n# sudo .\/db2setup<\/pre>\n<h2>Install a Product<\/h2>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_15.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_15\" border=\"0\" alt=\"db2_express_c_15\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_15_thumb.jpg\" width=\"390\" height=\"248\" \/><\/a> <\/p>\n<h3>Work with Existing \uff5e Laun ch DB2 Setup wizard<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_16.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_16\" border=\"0\" alt=\"db2_express_c_16\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_16_thumb.jpg\" width=\"343\" height=\"231\" \/><\/a> <\/p>\n<\/p>\n<h3>Next \uff5e Next Japanese \u3092\u9078\u629e\u3057\u3066Next<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_17.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_17\" border=\"0\" alt=\"db2_express_c_17\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_17_thumb.jpg\" width=\"356\" height=\"215\" \/><\/a> <\/p>\n<h3>Finish<\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_18.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_18\" border=\"0\" alt=\"db2_express_c_18\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_18_thumb.jpg\" width=\"287\" height=\"234\" \/><\/a><\/p>\n<h3>Setup Complete <\/h3>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_19.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_19\" border=\"0\" alt=\"db2_express_c_19\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_19_thumb.jpg\" width=\"379\" height=\"227\" \/><\/a><\/p>\n<h2>\u2606 JDK\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u8a2d\u5b9a<\/h2>\n<p><a href=\"http:\/\/dream.jp\/vps\/\">ServersMan@VPS<\/a> \u306b\u3066\u30a8\u30e9\u30fc\u306e\u305f\u3081\u5b9f\u65bd\u3057\u305f\u304c\u3001\u901a\u5e38\u306f\u4e0d\u8981\u3068\u601d\u308f\u308c\u308b\u3002<\/p>\n<h3>\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9<\/h3>\n<p><a href=\"http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/jdk-6u25-download-346242.html\">http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/jdk-6u25-download-346242.html<\/a><\/p>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_21.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_21\" border=\"0\" alt=\"db2_express_c_21\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_21_thumb.jpg\" width=\"385\" height=\"109\" \/><\/a> <\/p>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3068\u8a2d\u5b9a<\/h3>\n<p><a href=\"http:\/\/download.oracle.com\/otn-pub\/java\/jdk\/6u25-b06\/jdk-6u25-linux-i586.bin\" name=\"jdk-6u25-linux-i586.bin\">jdk-6u25-linux-i586.bin<\/a><\/p>\n<pre class=\"prettyprint linenums\"># mv jdk-6u25-linux-i586.bin \/opt\/\r\n# cd \/opt\/\r\n# chmod +x jdk-6u25-linux-i586.bin \r\n# .\/jdk-6u25-linux-i586.bin <\/pre>\n<pre class=\"prettyprint linenums\"># vi \/etc\/profile.d\/java.sh\r\nexport JAVA_HOME=\/opt\/jdk1.6.0_25\r\nexport PATH=$JAVA_HOME\/bin:$PATH\r\n# source \/etc\/profile.d\/java.sh \r\n# alternatives --install \/usr\/bin\/java java \/opt\/jdk1.6.0_25\/bin\/java 2\r\n# alternatives --config java\r\n\r\nThere is 1 program that provides 'java'.\r\n\r\n  Selection    Command\r\n-----------------------------------------------\r\n*+ 1           \/opt\/jdk1.6.0_25\/bin\/java\r\n\r\nEnter to keep the current selection[+], or type selection number: <\/pre>\n<p>root\u3067\u3046\u3054\u304b\u3057\u3066\u3044\u305fVNC\u30b5\u30fc\u30d0\u30fc\u3092\u7d42\u4e86\u3055\u305b\u308b<\/p>\n<pre class=\"prettyprint linenums\"># vncserver -kill :1<\/pre>\n<p>\u4e00\u65e6\u30ed\u30b0\u30aa\u30d5\u3057\u3001db2inst1\u30e6\u30fc\u30b6\u306b\u3066\u63a5\u7d9a\u3057\u306a\u304a\u3057VNC\u306e\u8a2d\u5b9a\u3001VNC\u30b5\u30fc\u30d0\u30fc\u306e\u8d77\u52d5<\/p>\n<pre class=\"prettyprint linenums\">$ switchdesk gnome\r\nRed Hat Linux switchdesk 4.0\r\nCopyright (C) 1999-2004 Red Hat, Inc\r\nRedistributable under the terms of the GNU General Public License\r\nDesktop now set up to run GNOME.\r\n$ cd \/home\/db2inst1\/.vnc\r\n$ mv xstartup xstartup.bak\r\n$ ln -s \/home\/db2inst1\/.Xclients xstartup\r\n$ vncserver<\/pre>\n<p><a href=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_20.jpg\"><img loading=\"lazy\" decoding=\"async\" style=\"border-right-width: 0px; display: inline; border-top-width: 0px; border-bottom-width: 0px; border-left-width: 0px\" title=\"db2_express_c_20\" border=\"0\" alt=\"db2_express_c_20\" src=\"https:\/\/www.typea.info\/blog\/wp-content\/uploads\/image\/DB2ExpressC_14EED\/db2_express_c_20_thumb.jpg\" width=\"367\" height=\"189\" \/><\/a><\/p>\n<h2>\u2606 DB2\u30d5\u30a1\u30fc\u30b9\u30c8\u30b9\u30c6\u30c3\u30d7(db2fs)<\/h2>\n<p><a href=\"http:\/\/dream.jp\/vps\/\">ServersMan@VPS<\/a> \u306b\u3066\u3001\u3053\u306e\u30b9\u30c6\u30c3\u30d7\u3092\u884c\u304a\u3046\u3068\u3057\u3066\u30a8\u30e9\u30fc\u3068\u306a\u3063\u305f\u305f\u3081\u3001JDK\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305f\u304c\u3001VirtualBox\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305fCentOS\u3067\u306f\u4e0d\u8981\u3002<\/p>\n<p><a href=\"https:\/\/www-304.ibm.com\/support\/docview.wss?uid=swg21377358\">https:\/\/www-304.ibm.com\/support\/docview.wss?uid=swg21377358<\/a><\/p>\n<pre class=\"prettyprint linenums\">$ db2fs\r\nsh: \/home\/db2v2\/sqllib\/java\/jdk32\/jre\/bin\/java: No such file or directory DB2JAVIT : RC = 127<\/pre>\n<p>DB2\u306e\u8a2d\u5b9a\u5024\u3092\u5909\u66f4<\/p>\n<pre class=\"prettyprint linenums\">$ db2 update dbm cfg using JDK_PATH $JAVA_HOME\r\nDB20000I  The UPDATE DATABASE MANAGER CONFIGURATION command completed \r\nsuccessfully.<\/pre>\n<p>\u78ba\u8a8d<\/p>\n<pre class=\"prettyprint linenums\">$ db2 get dbm cfg | grep \"JDK\"\r\n Java Development Kit installation path       (JDK_PATH) = \/opt\/jdk1.6.0_25<\/pre>\n<p>\u3053\u308c\u3067\u3001\u4e0a\u8a18\u306e\u30a8\u30e9\u30fc\u306f\u89e3\u6d88\u3055\u308c\u308b\u3082\u3001\u30e1\u30e2\u30ea\u4e0d\u8db3\u306e\u30a8\u30e9\u30fc\u306e\u305f\u3081\u3001<a href=\"http:\/\/dream.jp\/vps\/\">ServersMan@VPS<\/a> \u3067\u306e\u7d9a\u884c\u3092\u65ad\u5ff5\u3057\u3001VirtualBox \u306b CentOS\u3092\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u3001\u3053\u3053\u307e\u3067\u306e\u51e6\u7406\u3092\u884c\u3046\u3002<\/p>\n<h2>\u2605&nbsp; \u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306e\u4f5c\u6210<\/h2>\n<p>\u4e0a\u8a18\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30ac\u30a4\u30c9\u3067\u3001db2fs \u3067\u3084\u3063\u3066\u3044\u308b\u306e\u306f\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b\u3060\u3051\u306e\u3088\u3046\u3060\u3002\u305d\u306e\u305f\u3081\u306b\u3001\u30d6\u30e9\u30a6\u30b6\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u304c\u5fc5\u8981\u3068\u3046\u306e\u306f\u9762\u5012\u304f\u3055\u3044\u3002\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306f\u30b3\u30de\u30f3\u30c9\u30e9\u30a4\u30f3\u304b\u3089\u4f5c\u6210\u53ef\u80fd\u306e\u3088\u3046\u3060\u3002<\/p>\n<p><a href=\"http:\/\/public.dhe.ibm.com\/software\/dw\/jp\/data\/sw-library\/db2\/express-c\/wiki\/Getting_started_with_DB2_Express-C_Japanese.pdf\">DB2 Express-C \u5165\u9580 V9,7 \u5bfe\u5fdc<\/a><\/p>\n<p>\u30b3\u30de\u30f3\u30c9\u304b\u3089\u30b5\u30f3\u30d7\u30eb\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f5c\u6210\u3059\u308b<\/p>\n<pre class=\"prettyprint linenums\">$ db2sampl -xml -sql\r\n\r\n  Creating database \"SAMPLE\"...\r\n  Connecting to database \"SAMPLE\"...\r\n  Creating tables and data in schema \"DB2INST1\"...\r\n  Creating tables with XML columns and XML data in schema \"DB2INST1\"...\r\n\r\n  'db2sampl' processing complete.<\/pre>\n<p>\u3053\u3053\u307e\u3067\u3067\u3001\u30b7\u30b9\u30c6\u30e0\u306e\u518d\u8d77\u52d5\u63a8\u5968<\/p>\n<h2>\u2605 \u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u78ba\u8a8d<\/h2>\n<p>\u518d\u8d77\u52d5\u5f8c\u3001DB2\u306e\u72b6\u614b\u3092\u78ba\u8a8d<\/p>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f&nbsp; DB2&nbsp; \u88fd\u54c1\u3001fix&nbsp; pack&nbsp; \u306e\u30ec\u30d9\u30eb\u3001\u304a\u3088\u3073\u305d\u306e\u4ed6\u306e\u8a73\u7d30\u60c5\u5831\u3092\u8868\u793a<\/h3>\n<pre class=\"prettyprint linenums\">$ db2level\r\nDB21085I  Instance \"db2inst1\" uses \"32\" bits and DB2 code release \"SQL09074\" \r\nwith level identifier \"08050107\".\r\nInformational tokens are \"DB2 v9.7.0.4\", \"s110330\", \"IP23242\", and Fix Pack \r\n\"4\".\r\nProduct is installed at \"\/opt\/ibm\/db2\/V9.7\".<\/pre>\n<h3>\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u305f DB2 \u88fd\u54c1\u306b\u56fa\u6709\u306e\u30e9\u30a4\u30bb\u30f3\u30b9\u60c5\u5831\u3092\u3059\u3079\u3066\u30ea\u30b9\u30c8\u30a2\u30c3\u30d7<\/h3>\n<pre class=\"prettyprint linenums\">$ db2licm -l\r\nProduct name:                     \"DB2 Express-C\"\r\nLicense type:                     \"Unwarranted\"\r\nExpiry date:                      \"Permanent\"\r\nProduct identifier:               \"db2expc\"\r\nVersion information:              \"9.7\"\r\nMax number of CPUs:               \"2\"\r\nMax amount of memory (GB):        \"2\"<\/pre>\n<h3>DB2&nbsp; \u30b3\u30d4\u30fc\u306e\u30b3\u30a2\u6a5f\u80fd\u3092\u691c\u8a3c\u3059\u308b\u3053\u3068\u306b\u3088\u3063\u3066\u3001\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u306e\u691c\u8a3c<\/h3>\n<p>db2val \u5fdc\u7b54\u8fd4\u3089\u305a<\/p>\n<h2>\u2605 IBM Data Studio <\/h2>\n<blockquote>\n<p>IBM&nbsp; Data&nbsp; Studio&nbsp; \u306f\u3001\u73fe\u5728\u4f7f\u7528\u304c\u63a8\u5968\u3055\u308c\u306a\u3044\u300c\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30fb\u30bb\u30f3\u30bf\u30fc\u300d\u3084\u300c\u30b3\u30de\u30f3\u30c9\u30fb\u30a8\u30c7\u30a3\u30bf\u30fc\u300d\u306a\u3069\u306e&nbsp; DB2&nbsp; \u30c4\u30fc\u30eb\u306b\u7f6e\u304d\u63db\u308f\u308b\u3082\u306e\u3067\u3059&nbsp; (\u300c\u30b3\u30f3\u30c8\u30ed\u30fc\u30eb\u30fb\u30bb\u30f3\u30bf\u30fc\u300d\u3001\u300c\u30b3\u30de\u30f3\u30c9\u30fb\u30a8\u30c7\u30a3\u30bf\u30fc\u300d\u306f&nbsp; DB2&nbsp; \u306b\u306f\u7d44\u307f\u8fbc\u307e\u308c\u3066\u3044\u308b\u3082\u306e\u306e\u3001\u73fe\u5728\u958b\u767a\u306f\u884c\u308f\u308c\u3066\u3044\u307e\u305b\u3093)\u3002<\/p>\n<\/blockquote>\n<p>\u3068\u306e\u3053\u3068\u306a\u306e\u3067\u3001<a href=\"https:\/\/www.typea.info\/blog\/index.php\/2011\/05\/15\/db2_ibm_data_studio_sql\">\u6b21\u306f IBM Data Studio \u3092\u5229\u7528\u3057\u3066\u4f5c\u6210\u3057\u305f\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a<\/a>\u3057\u3066\u307f\u3088\u3046\u3002<\/p>\n<h2>\u2605 \u307e\u3068\u3081<\/h2>\n<p><a href=\"http:\/\/dream.jp\/vps\/\">ServersMan@VPS<\/a> \u3067\u3001\u305f\u3073\u305f\u3073\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u305f\u3081\u5bfe\u51e6\u3001\u4eca\u5f8c\u306e\u305f\u3081\u306b\u30e1\u30e2\u3092\u6b8b\u3057\u3066\u304a\u304f\u304c\u3001VirtualBox \u4e0a\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u305fCentOS\u3067\u306f\u3001db2val \u306e\u5fdc\u7b54\u304c\u306a\u3044\u3053\u3068\u3092\u9664\u3044\u3066\u3001\u5168\u304f\u554f\u984c\u306a\u304f\u30b9\u30e0\u30fc\u30b9\u306b\u4f5c\u696d\u306f\u5b8c\u4e86\u3057\u305f\u3002<\/p>\n<p><iframe style=\"width: 120px; height: 240px\" marginheight=\"0\" src=\"http:\/\/rcm-jp.amazon.co.jp\/e\/cm?lt1=_blank&amp;bc1=FFFFFF&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=typea09-22&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=ss_til&amp;asins=4798120049\" frameborder=\"0\" marginwidth=\"0\" scrolling=\"no\"><\/iframe><iframe style=\"width: 120px; height: 240px\" marginheight=\"0\" src=\"http:\/\/rcm-jp.amazon.co.jp\/e\/cm?lt1=_blank&amp;bc1=FFFFFF&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=typea09-22&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=ss_til&amp;asins=4774145971\" frameborder=\"0\" marginwidth=\"0\" scrolling=\"no\"><\/iframe><iframe style=\"width: 120px; height: 240px\" marginheight=\"0\" src=\"http:\/\/rcm-jp.amazon.co.jp\/e\/cm?lt1=_blank&amp;bc1=FFFFFF&amp;IS2=1&amp;bg1=FFFFFF&amp;fc1=000000&amp;lc1=0000FF&amp;t=typea09-22&amp;o=9&amp;p=8&amp;l=as4&amp;m=amazon&amp;f=ifr&amp;ref=ss_til&amp;asins=4774120383\" frameborder=\"0\" marginwidth=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u52c9\u5f37\u304c\u3066\u3089\u3001DB2\u3092\u89e6\u308b\u305f\u3081\u306b\u3001Express-C \u3092 CentOS \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3057\u3066\u307f\u308b\u3002 \u6700\u521d\u306f\u3001ServersMan@VPS\u3000Entry \u30d7\u30e9\u30f3 \u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3092\u8a66\u307f\u305f\u3002\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u81ea\u4f53\u306f\u6210\u529f\u3059\u308b\u306e\u3060\u304c\u3001\u30a4\u30f3\u30b9\u30bf [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"sns_share_botton_hide":"","vkExUnit_sns_title":"","_vk_print_noindex":"","sitemap_hide":"","_veu_custom_css":"","veu_display_promotion_alert":"","vkexunit_cta_each_option":"","footnotes":""},"categories":[45,46],"tags":[],"class_list":["post-290","post","type-post","status-publish","format-standard","hentry","category-db2","category-java-ee"],"veu_head_title_object":{"title":"","add_site_title":""},"_links":{"self":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=290"}],"version-history":[{"count":0,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/posts\/290\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.typea.info\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}