{"id":234,"date":"2009-04-25T18:11:40","date_gmt":"2009-04-25T12:11:40","guid":{"rendered":"http:\/\/techsatwork.com\/blog\/?p=234"},"modified":"2016-01-07T11:31:13","modified_gmt":"2016-01-07T05:31:13","slug":"db2-on-ubuntu","status":"publish","type":"post","link":"https:\/\/techsatwork.com\/?p=234","title":{"rendered":"DB2 on Ubuntu"},"content":{"rendered":"

Have you heard about Ubuntu ? \u00c2\u00a0Its one of the most popular open source linux distribution available. Lot of people associate\u00c2\u00a0\u00c2\u00a0open source with unstable and unreliable software, but ironically its not. \u00c2\u00a0Majority of the open source software are pretty good and come with good user group support. \u00c2\u00a0One such distribution is Ubuntu.<\/p>\n

\"ubuntulogo\"<\/a><\/p>\n

Ubuntu does have an option for commercial support from Canonical. \u00c2\u00a0Today Ubuntu comes with three different flavors…yeah just three unlike certain other operating systems that comes with half a dozen editions.<\/p>\n

I have been using the desktop edition for a while and its been very stable. \u00c2\u00a0I used to have the server edition which hosted my personal mail server, but one fine morning the motherboard decided to fry a chipset. They also have a laptop\/netbook edition, I am told its pretty good as well although I haven’t tried. \u00c2\u00a0 Ubuntu just released 9.04. \u00c2\u00a0 The latest version is pretty sweet and boots fast. \u00c2\u00a0If you are running Ubuntu 8.10, then there is a straight upgrade path<\/a>, otherwise you have install \u00c2\u00a0Ubuntu 9.04 . \u00c2\u00a0<\/p>\n

\"Download<\/p>\n

One of the operating systems IBM DB2 V9.5 supports is Ubuntu 32 bit and 64 bit. \u00c2\u00a0Here is how to install DB2 on Ubuntu. \u00c2\u00a0Once you download Ubuntu<\/a> and DB2<\/a>\u00c2\u00a0<\/p>\n

Install Ubuntu<\/a> and make sure you update all the patches.<\/p>\n

Unzip and untar the DB2 install file<\/p>\n

Ensure you satisfies all the\u00c2\u00a0prerequisites\u00c2\u00a0for DB2<\/p>\n

Run db2setup and follow the instructions on GUI screen. The install options are pretty easy and if you are new to DB2, you can choose the typical install option. If its the first time I recommend selecting the create instance option.<\/p>\n

sudo .\/db2setup<\/span><\/em><\/p>\n

While running db2setup, if you encounter the following error message :
\nERROR:<\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0The required library file libstdc++.so.5 is not found on the system.<\/span><\/span><\/em>
\n<\/span> <\/span>ERROR:<\/span><\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0The required library file libaio.so.1 is not found on the system.<\/span><\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0Check the following web site for the up-to-date system requirements<\/span><\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0of IBM DB2 9.5<\/span><\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0http:\/\/www.ibm.com\/software\/data\/db2\/udb\/sysreqs.html<\/span><\/span><\/em>
\n<\/span> <\/span>\u00c2\u00a0http:\/\/www.software.ibm.com\/data\/db2\/linux\/validate<\/span><\/span><\/em>
\n<\/span> <\/span>\/home\/rpillai\/Desktop\/exp\/db2\/linux\/install\/..\/bin\/db2usrinf:<\/span><\/span><\/em>
\n<\/span> <\/span>error while loading shared libraries: libstdc++.so.5:<\/span><\/span><\/em>
\n<\/span> <\/span>cannot open shared object file: No such file or directory<\/span><\/span><\/em>
\n<\/span> <\/span>[: 609: 0: unexpected operator<\/span><\/span><\/em>
\n<\/span> <\/span>\/home\/rpillai\/Desktop\/exp\/db2\/linux\/install\/..\/bin\/db2langdir:<\/span><\/span><\/em>
\n<\/span> <\/span>error while loading shared libraries: libstdc++.so.5:<\/span><\/span><\/em>
\n<\/span> <\/span>cannot open shared object file: No such file or directory<\/span><\/span><\/em>
\n<\/span> <\/span>\/home\/rpillai\/Desktop\/exp\/db2\/linux\/install\/..\/bin\/db2langdir:<\/span><\/span><\/em>
\n<\/span> <\/span>error while loading shared libraries: libstdc++.so.5:<\/span><\/span><\/em>
\n<\/span> <\/span>cannot open shared object file: No such file or directory<\/span><\/span><\/em>
\n<\/span> <\/span>DBI1055E The message file db2install.cat cannot be found.<\/span><\/span><\/em>
\n<\/span> <\/span>Explanation: \u00c2\u00a0The message file required by this<\/span><\/span><\/em>
\n<\/span> <\/span>script is missing from the system; it may have been<\/span><\/span><\/em>
\n<\/span> <\/span>deleted or the database products may have been loaded<\/span><\/span><\/em>
\n<\/span> <\/span>incorrectly.<\/span><\/span><\/em>
\n<\/span> <\/span>User Response: \u00c2\u00a0Verify that the product option containing<\/span><\/span><\/em>
\n<\/span> <\/span>the message file is installed correctly. \u00c2\u00a0If there are<\/span><\/span><\/em>
\n<\/span> <\/span>verification errors; reinstall the product option.<\/span><\/span><\/em><\/p>\n

You can solve the above issue by \u00c2\u00a0running the following command
\nsudo apt-get install libstdc++5<\/span><\/em>
\nsudo apt-get install libaio-dev<\/span><\/em>
\nsudo .\/db2setup<\/span><\/em><\/p>\n

Once you install finishes, sudo to instance and check whether you can connect to sample database. You can list the available databases by typing<\/p>\n

db2 list db directory<\/em> \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 << \u00c2\u00a0list databases<\/p>\n

db2 connect to sample<\/em> \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0<< connect to the sample database\u00c2\u00a0<\/p>\n

db2 list tables for all schema<\/em> \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0<< list all tables in the database<\/p>\n

You can stop and start db2 with the following commands :<\/p>\n

db2start \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0<< \u00c2\u00a0starts db2<\/p>\n

db2stop \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 \u00c2\u00a0 << stops db2<\/p>\n","protected":false},"excerpt":{"rendered":"

Have you heard about Ubuntu ? \u00c2\u00a0Its one of the most popular open source linux distribution available. Lot of people associate\u00c2\u00a0\u00c2\u00a0open source with unstable and unreliable software, but ironically its not. \u00c2\u00a0Majority of the open source software are pretty good and come with good user group support. \u00c2\u00a0One such distribution is Ubuntu. Ubuntu does have […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","site-transparent-header":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[53,3,142],"tags":[943,149,146,151,152,148,150,147,945,145,143,144],"class_list":["post-234","post","type-post","status-publish","format-standard","hentry","category-applications","category-db2","category-linux","tag-db2","tag-db2langdir","tag-db2setup","tag-db2start","tag-db2stop","tag-db2usrinf","tag-libaioso1","tag-libstdcso5","tag-linux","tag-open-source","tag-ubuntu","tag-ubuntu-904"],"_links":{"self":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/234","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=234"}],"version-history":[{"count":26,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/234\/revisions"}],"predecessor-version":[{"id":1547,"href":"https:\/\/techsatwork.com\/index.php?rest_route=\/wp\/v2\/posts\/234\/revisions\/1547"}],"wp:attachment":[{"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=234"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=234"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techsatwork.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=234"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}