{"id":2198,"date":"2021-04-07T19:36:56","date_gmt":"2021-04-07T11:36:56","guid":{"rendered":"http:\/\/123.57.164.21\/?p=2198"},"modified":"2021-04-07T19:39:18","modified_gmt":"2021-04-07T11:39:18","slug":"ibm-cloud-db2-clpplus","status":"publish","type":"post","link":"https:\/\/92it.top\/?p=2198","title":{"rendered":"IBM Cloud DB2 CLPPlus"},"content":{"rendered":"\n<p>DB2\u81ea\u5e26\u7684CLP\u5f88\u4e0d\u597d\u7528\uff0c\u548cOracle\u7684SQL plus\u76f8\u6bd4\uff0c\u5c24\u5176\u662f\u683c\u5f0f\u5316\u663e\u793a\u65b9\u9762\u505a\u7684\u4e0d\u591f\u597d\u3002DB2\u4e3a\u4e86\u63d0\u9ad8Oracle\u7684\u517c\u5bb9\u5ea6\uff0c\u57289.7\u63a8\u51fa\u4e86\u548cSQLPLUS\u975e\u5e38\u76f8\u4f3c\u7684CLPPLUS\u3002<\/p>\n\n\n\n<h5 class=\"wp-block-heading\">1.\u5982\u4f55\u4e0b\u8f7d\u5b89\u88c5CLPPLUS\u5462\uff1f<\/h5>\n\n\n\n<ul><li>\u767b\u5f55IBM Cloud DB2\u7684\u63a7\u5236\u53f0\uff0c\u70b9\u51fb\u7ba1\u7406&#8211;&gt;\u8fde\u63a5&#8211;&gt;Mac&#8211;&gt;\u9a71\u52a8\u7a0b\u5e8f\u5217\u8868<\/li><\/ul>\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\/2021\/04\/image-13-1024x679.png\" alt=\"\" class=\"wp-image-2204\" width=\"703\" height=\"465\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-1024x679.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-300x199.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-1536x1019.png 1536w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-230x153.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-350x232.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13-480x318.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-13.png 1902w\" sizes=\"(max-width: 703px) 100vw, 703px\" \/><\/figure><\/div>\n\n\n\n<ul><li>\u4e0b\u8f7d\u597d\u4e86\u4ee5\u540e\uff0c\u70b9\u51fbinstallDSDriver.sh\u5b89\u88c5\u3002<\/li><\/ul>\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\/2021\/04\/image-14.png\" alt=\"\" class=\"wp-image-2205\" width=\"475\" height=\"335\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-14.png 752w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-14-300x211.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-14-230x162.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-14-350x247.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-14-480x338.png 480w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">2.\u5b89\u88c5\u597d\u4ee5\u540e\uff0c\u5728Mac\u7684Application\u4e2d\uff0c\u80fd\u770b\u5230\u5b89\u88c5\u597d\u7684CLPPlus \u548c dsdriver<\/h5>\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\/2021\/04\/image-15.png\" alt=\"\" class=\"wp-image-2206\" width=\"330\" height=\"433\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-15.png 632w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-15-228x300.png 228w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-15-230x302.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-15-350x460.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-15-480x630.png 480w\" sizes=\"(max-width: 330px) 100vw, 330px\" \/><\/figure><\/div>\n\n\n\n<h5 class=\"wp-block-heading\">3.\u9700\u8981\u914d\u7f6e\u73af\u5883\u53d8\u91cf\uff0c\u5426\u5219\u4e0d\u4f1a\u8bc6\u522bdb2cli\u4e4b\u7c7b\u7684\u547d\u4ee4<\/h5>\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\/2021\/04\/image-16-1024x93.png\" alt=\"\" class=\"wp-image-2210\" width=\"692\" height=\"63\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-1024x93.png 1024w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-300x27.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-768x70.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-830x75.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-230x21.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-350x32.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16-480x43.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-16.png 1038w\" sizes=\"(max-width: 692px) 100vw, 692px\" \/><\/figure><\/div>\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=\"\">\u5728Mac\u7684\u547d\u4ee4\u7ec8\u7aef\u4e0a\uff0c\u6267\u884c\u4e0b\u9762\u7684\u547d\u4ee4\uff1a\nexport PATH=$PATH:\/Applications\/dsdriver\/bin\/ \nexport DB2CLIINIPATH=\/Applications\/dsdriver\/cfg\/\nexport DB2DSDRIVER_CFG_PATH=\/Applications\/dsdriver\/cfg\/<\/pre>\n\n\n\n<p>PS\uff1a\u5728Terminal\u4e0b\u7528export PS1=XXX&nbsp; &nbsp;\u4fee\u6539\u5b8c\u540e\uff0c\u672c\u6b21\u751f\u6548\uff0c\u4f46\u662f\u91cd\u65b0\u542f\u52a8Teminal\u540e\u53c8\u6062\u590d\u5230\u9ed8\u8ba4\u683c\u5f0f\u3002<\/p>\n\n\n\n<ul><li>~\u4e0b\u9762\u672c\u6765\u6ca1\u6709 .bash_profile\uff0c\u8981\u7528touch .bash_profile\u624b\u52a8\u521b\u5efa\u3002<\/li><li>open -e .bash_profile \u6253\u5f00\u6587\u4ef6\u52a0\u5165export PS1=XXX \u8fd9\u884c\uff0c\u4fdd\u5b58\u5e76\u5173\u95ed\u6587\u4ef6\u3002<\/li><li>source .bash_profile \u4f7f\u66f4\u65b0\u751f\u6548\u3002<\/li><\/ul>\n\n\n\n<h5 class=\"wp-block-heading\">4.CLPPlus\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u4e3b\u8981\u9760\u914d\u7f6ecfg\u4e0b\u9762\u7684\u7684db2dsdriver.cfg\u6587\u4ef6\u3002<\/h5>\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\/2021\/04\/image-17.png\" alt=\"\" class=\"wp-image-2212\" width=\"332\" height=\"423\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-17.png 672w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-17-236x300.png 236w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-17-230x293.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-17-350x446.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-17-480x611.png 480w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/figure><\/div>\n\n\n\n<ul><li>db2dsdriver.cfg\u6587\u4ef6\u7684\u914d\u7f6e\u65b9\u6cd5\uff0c\u53ef\u4ee5\u7528\u547d\u4ee4\u751f\u6210\uff0c\u5177\u4f53\u7684\u547d\u4ee4\uff0c\u53ef\u4ee5\u4eceIBM Cloud DB2\u7684\u63a7\u5236\u53f0\uff0c\u70b9\u51fb\u7ba1\u7406&#8211;&gt;\u8fde\u63a5&#8211;&gt;Mac&#8211;&gt;\u8fde\u63a5\u770b\u5230\u3002\u6267\u884cdb2cli writecfg\u76f8\u5173\u7684\u547d\u4ee4\u540e\uff0c\u5c31\u4f1a\u5728db2dsdriver.cfg\u6587\u4ef6\u4e2d\u751f\u6210\u76f8\u5173\u7684\u914d\u7f6e\u4fe1\u606f\u3002<\/li><\/ul>\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\/2021\/04\/image-18-996x1024.png\" alt=\"\" class=\"wp-image-2213\" width=\"555\" height=\"570\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-996x1024.png 996w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-292x300.png 292w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-768x790.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-830x854.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-230x237.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-350x360.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18-480x494.png 480w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-18.png 1122w\" sizes=\"(max-width: 555px) 100vw, 555px\" \/><\/figure><\/div>\n\n\n\n<ul><li>\u4f46\u662f\u6211\u8fd9\u91cc\u8fd9\u4e2a\u547d\u4ee4\u603b\u62a5\u9519\uff0c\u6240\u4ee5\u6211\u662f\u624b\u52a8\u4fee\u6539\u7684\/Applications\/dsdriver\/cfg\/db2dsdriver.cfg\u6587\u4ef6\u3002<\/li><\/ul>\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=\"\">&lt;configuration>\n  &lt;dsncollection>\n   \/\/ dsn\u7684alias\u522b\u540d\u975e\u5e38\u91cd\u8981\uff0c\u8fd9\u91cc\u9762\u6211\u4eec\u8d77\u4e86\u4e2a\u522b\u540ddashdb\n   &lt;dsn alias=\"dashdb\" name=\"xxxx\" host=\"xxxxxxx.databases.appdomain.cloud\" port=\"32657\"> \n   &lt;\/dsn>\n  &lt;\/dsncollection>\n  &lt;databases>\n   &lt;database name=\"xxxx\" host=\"xxxxxxx.databases.appdomain.cloud\" port=\"32657\">\n   &lt;\/database> \n  &lt;\/databases>\n  &lt;parameters>\n     &lt;parameter name=\"SecurityTransportMode\" value=\"SSL\"\/>\n  &lt;\/parameters>\n&lt;\/configuration><\/pre>\n\n\n\n<h5 class=\"wp-block-heading\">5.\u4e0a\u9762\u90fd\u914d\u7f6e\u597d\u4ee5\u540e\uff0c\u901a\u8fc7clpplus -nw \u6570\u636e\u5e93userID@\u522b\u540d  \u547d\u4ee4\uff0c\u6309\u6307\u793a\u8f93\u5165\u5bc6\u7801\uff0c\u901a\u8fc7\u9a8c\u8bc1\u4ee5\u540e\uff0c\u5c31\u8fde\u63a5\u5230\u6570\u636e\u5e93\u4e86\u3002<\/h5>\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\/2021\/04\/image-19.png\" alt=\"\" class=\"wp-image-2218\" width=\"601\" height=\"334\" srcset=\"https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19.png 866w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-300x167.png 300w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-768x427.png 768w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-830x462.png 830w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-230x128.png 230w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-350x195.png 350w, https:\/\/92it.top\/wp-content\/uploads\/2021\/04\/image-19-480x267.png 480w\" sizes=\"(max-width: 601px) 100vw, 601px\" \/><\/figure><\/div>\n\n\n\n<p>\u4e00\u4e9b\u53c2\u8003\u7f51\u7ad9<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">https:\/\/www.ibm.com\/docs\/en\/db2woc?topic=integration-connecting-clpplus\nhttps:\/\/www.ibm.com\/support\/knowledgecenter\/SSCJDQ\/com.ibm.swg.im.dashdb.clpplus.doc\/doc\/c0053823.html\nhttps:\/\/www.ibm.com\/docs\/en\/db2woc?topic=database-connecting-db2\nhttps:\/\/www.ibm.com\/support\/knowledgecenter\/SSCJDQ\/com.ibm.swg.im.dashdb.clpplus.doc\/doc\/clpplus_local.html\nhttps:\/\/www.ibm.com\/docs\/en\/db2-warehouse?topic=warehouse-getting-container-images<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>DB2\u81ea\u5e26\u7684CLP\u5f88\u4e0d\u597d\u7528\uff0c\u548cOracle\u7684SQL plus\u76f8\u6bd4\uff0c\u5c24\u5176\u662f\u683c\u5f0f\u5316\u663e\u793a\u65b9\u9762\u505a\u7684\u4e0d\u591f\u597d\u3002DB2\u4e3a\u4e86\u63d0 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/2198"}],"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=2198"}],"version-history":[{"count":12,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/2198\/revisions"}],"predecessor-version":[{"id":2221,"href":"https:\/\/92it.top\/index.php?rest_route=\/wp\/v2\/posts\/2198\/revisions\/2221"}],"wp:attachment":[{"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2198"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2198"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/92it.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2198"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}