{"id":251,"date":"2022-01-14T13:29:54","date_gmt":"2022-01-14T12:29:54","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/2022\/01\/14\/setting-up-ibm-db2-on-linux\/"},"modified":"2022-04-06T08:26:40","modified_gmt":"2022-04-06T06:26:40","slug":"setting-up-ibm-db2-on-linux","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/","title":{"rendered":"Setting up IBM Db2 on Linux"},"content":{"rendered":"

My last contact with IBM Db2<\/a> was more than 10 years ago, and that only on the SQL\/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with. And now we have a request for supporting someone with performance issues on Db2, and requests are showing up from people who want to migrate to PostgreSQL. First thing to do? Install the product so you have something to play with and this is the topic of this post.<\/p>\n

<\/p>\n

There is a free version of Db2 with some restrictions you can download here<\/a>. The database size restriction of 100MB seems a bit too low, but as I am planning to use this as a playground I don’t care right now. The requirements for the installation are documented here<\/a>. I had expected a list of packages to install on the operating system but this listed on another page, which is here<\/a>. I’ll be doing this with SLES 15<\/a> just because I like to switch between distributions from time to time. You can also use Red Hat, CentOS or Ubuntu as listed in the documentation linked above. When you want to install Db2 you have the choice between “root” and “non-root” installations and I’ll go for the “non-root”<\/a> version here.<\/p>\n

My SLES 15 is a minimal installation and for SLES that really means minimal, you don’ event have sudo or vi. In addition, because I’ll use the graphical installer, you need an X environment, and of course an operating system user and group:<\/p>\n

\nsles15db2:~ $ zypper in xorg-x11-xauth sudo vi\nsles15db2:~ $ groupadd db2\nsles15db2:~ $ useradd -g db2 -m db2\nsles15db2:~ $ passwd db2\nsles15db2:~ $ cat \/etc\/sudoers | grep db2\ndb2 ALL=(ALL) NOPASSWD: ALL\n<\/pre>\n
Once that is ready create a new SSH connection with X11 forwarding enabled, extract the downloaded file:<\/p>\n
\ndwe@ltdwe:~$ ssh -X db2@192.168.100.178\n(db2@192.168.100.178) Password: \n\/usr\/bin\/xauth:  file \/home\/db2\/.Xauthority does not exist\ndb2@sles15db2:~> tar axf v11.5.6_linuxx64_server_dec.tar.gz \ndb2@sles15db2:~> ls -l\ntotal 2034628\ndrwxr-xr-x 2 db2 db2          6 Mar  3  2021 bin\ndrwxr-xr-x 3 db2 db2        206 Jun 11  2021 server_dec\n-rw-r--r-- 1 db2 db2 2083458415 Jan 14 10:05 v11.5.6_linuxx64_server_dec.tar.gz\ndb2@sles15db2:~\/server_dec> ls -l\ntotal 84\ndrwxr-xr-x 6 db2 db2   134 Jun 11  2021 db2\n-r--r--r-- 1 db2 db2  4987 Jun 11  2021 db2checkCOL_readme.txt\n-r--r--r-- 1 db2 db2 16808 Jun 11  2021 db2checkCOL.tar.gz\n-r-xr-xr-x 1 db2 db2  5254 Jun 11  2021 db2ckupgrade\n-r-xr-xr-x 1 db2 db2  5207 Jun 11  2021 db2_deinstall\n-r-xr-xr-x 1 db2 db2  5077 Jun 11  2021 db2_install\n-r-xr-xr-x 1 db2 db2  5041 Jun 11  2021 db2ls\n-r-xr-xr-x 1 db2 db2  5059 Jun 11  2021 db2prereqcheck\n-r-xr-xr-x 1 db2 db2  5059 Jun 11  2021 db2setup\n-r-xr-xr-x 1 db2 db2  5095 Jun 11  2021 installFixPack\n<\/pre>\n
Without installing any additional packages let’s try to start the installation:<\/p>\n
\ndb2@sles15db2:~\/server_dec> .\/db2setup \nERROR: \n   The 'strings' utility that is used to detect prerequisite libraries\n   is not present on this system.  Please use your package or software\n   manager to install the GNU Binary Utilities\nRequirement not matched for DB2 database \"Server\" . Version: \"11.5.6.0\". \n\nSummary of prerequisites that are not met on the current system: \n\n   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: \"\/lib\/libpam.so*\". \n\n\nDBT3609E  The db2prereqcheck utility could not find the library file libnuma.so.1. \n\n\n  Aborting the current installation ...\n  Run installation with the option \"-f sysreq\" parameter to force the installation.\n<\/pre>\n
Obviously a few packages are missing:<\/p>\n
\ndb2@sles15db2:~\/server_dec> sudo zypper in binutils libnuma1\n<\/pre>\n
Next try:<\/p>\n
\ndb2@sles15db2:~\/server_dec> .\/db2setup \nRequirement not matched for DB2 database \"Server\" . Version: \"11.5.6.0\". \n\nSummary of prerequisites that are not met on the current system: \n\n   DBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: \"\/lib\/libpam.so*\". \n\n\nDBT3609E  The db2prereqcheck utility could not find the library file libnuma.so.1. \n\n\nDBT3514W  The db2prereqcheck utility failed to find the following 32-bit library file: \"libstdc++.so.6\". \n\n\n  Aborting the current installation ...\n  Run installation with the option \"-f sysreq\" parameter to force the installation.\n<\/pre>\n
Two more packages to install:<\/p>\n
\ndb2@sles15db2:~\/server_dec> sudo zypper in libstdc++6-32bit pam-32bit\n<\/pre>\n
And finally the installer is starting up:<\/p>\n
\ndb2@sles15db2:~\/server_dec> .\/db2setup \nDBI1190I  db2setup is preparing the DB2 Setup wizard which will guide\n      you through the program setup process. Please wait.\n\n\nDBI1160I  Non-root install is being performed.\n<\/pre>\n
\"\"<\/a><\/p>\n
The installation is straight forwards as you can just go through the screens and select\/de-select what you like or don’t like:
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a>
\n\"\"<\/a><\/p>\n
In the following screen there is some important information you should write down somewhere, such as the port and profiles which will give you the correct environment:
\n\"\"<\/a>
\nFinally the installer wants to open a browser for displaying the “Db2 first steps”:
\n\"\"<\/a>
\nYou either skip this or install a browser and then continue:
\n\"\"<\/a>
\n\"\"<\/a><\/p>\n
That’s it for the installation. All in all, quite easy to do and for re-doing this you can use the response file which was generated by the installer.<\/p>\n
The installer already started the instance and you can see that in the process list:<\/p>\n
\ndb2@sles15db2:~\/server_dec> ps -ef | grep db2\nroot      9829  1032  0 09:57 ?        00:00:00 sshd: db2 [priv]\ndb2       9834     1  0 09:57 ?        00:00:00 \/usr\/lib\/systemd\/systemd --user\ndb2       9835  9834  0 09:57 ?        00:00:00 (sd-pam)\ndb2       9842  9829  0 09:57 ?        00:00:08 sshd: db2@pts\/0\ndb2       9843  9842  0 09:57 pts\/0    00:00:00 -bash\ndb2      26473     1  0 12:02 pts\/0    00:00:00 db2wdog 0 [db2]\ndb2      26475 26473  0 12:02 pts\/0    00:00:00 db2sysc 0\ndb2      26480 26473  0 12:02 pts\/0    00:00:00 db2ckpwd 0\ndb2      26481 26473  0 12:02 pts\/0    00:00:00 db2ckpwd 0\ndb2      26482 26473  0 12:02 pts\/0    00:00:00 db2ckpwd 0\ndb2      26484 26473  0 12:02 pts\/0    00:00:00 db2vend (PD Vendor Process - 1) 0\ndb2      26488 26473  0 12:02 pts\/0    00:00:00 db2acd  ,0,0,0,1,0,0,00000000,0,0,0000000000000000,0000000000000000,00000000,00000000,00000000,00000000,00000000,00000000,0000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,00000000,000000002d85b000,0000000000000000,0000000000000000,1,0,0,,,,,a89e68,14,1e014,2,0,1,0000000000041fc0,0x240000000,0x240000000,1600000,7,2,10\ndb2      29070  9834  0 12:06 ?        00:00:00 \/usr\/bin\/dbus-daemon --session --address=systemd: --nofork --nopidfile --systemd-activation --syslog-only\ndb2      29072  9834  0 12:06 ?        00:00:00 \/usr\/lib\/gvfs\/gvfsd\ndb2      29077  9834  0 12:06 ?        00:00:00 \/usr\/lib\/gvfs\/gvfsd-fuse \/run\/user\/1000\/gvfs -f\ndb2      29106  9834  0 12:06 ?        00:00:00 \/usr\/lib\/at-spi2\/at-spi-bus-launcher\ndb2      29356  9843 99 12:07 pts\/0    00:00:00 ps -ef\ndb2      29357  9843  0 12:07 pts\/0    00:00:00 grep --color=auto db2\n<\/pre>\n
For connecting to the instance you need to source the profile and then start the “db2” utility:<\/p>\n
\ndb2@sles15db2:~> . sqllib\/db2profile \ndb2@sles15db2:~> db2\n(c) Copyright IBM Corporation 1993,2007\nCommand Line Processor for DB2 Client 11.5.6.0\n\nYou can issue database manager commands and SQL statements from the command \nprompt. For example:\n    db2 => connect to sample\n    db2 => bind sample.bnd\n\nFor general help, type: ?.\nFor command help, type: ? command, where command can be\nthe first few keywords of a database manager command. For example:\n ? CATALOG DATABASE for help on the CATALOG DATABASE command\n ? CATALOG          for help on all of the CATALOG commands.\n\nTo exit db2 interactive mode, type QUIT at the command prompt. Outside \ninteractive mode, all commands must be prefixed with 'db2'.\nTo list the current command option settings, type LIST COMMAND OPTIONS.\n\nFor more detailed help, refer to the Online Reference Manual.\n\ndb2 =>\n<\/pre>\n
Create a database, connect to it, and create a dummy table:<\/p>\n
\ndb2 => create database db1\nDB20000I  The CREATE DATABASE command completed successfully.\n\nb2 => connect to db1\n\n   Database Connection Information\n\n Database server        = DB2\/LINUXX8664 11.5.6.0\n SQL authorization ID   = DB2\n Local database alias   = DB1\n\ndb2 => create table t1 ( a int )\nDB20000I  The SQL command completed successfully.\ndb2 => select * from t1\n\nA          \n-----------\n\n  0 record(s) selected.\n<\/pre>\n
Ready to start playing. Last, but not least: If you reboot the machine, the instance will not come up automatically. To start it:<\/p>\n
\ndb2@sles15db2:~> . sqllib\/db2profile \ndb2@sles15db2:~> db2start\n01\/14\/2022 12:29:12     0   0   SQL1063N  DB2START processing was successful.\nSQL1063N  DB2START processing was successful.\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL\/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with. And […]<\/p>\n","protected":false},"author":29,"featured_media":39,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229],"tags":[56,57],"type_dbi":[],"class_list":["post-251","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","tag-db2","tag-ibm"],"acf":[],"yoast_head":"\nSetting up IBM Db2 on Linux - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Setting up IBM Db2 on Linux\" \/>\n<meta property=\"og:description\" content=\"My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL\/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with. And […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2022-01-14T12:29:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-06T06:26:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"482\" \/>\n\t<meta property=\"og:image:height\" content=\"586\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Daniel Westermann\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@westermanndanie\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Westermann\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\"},\"author\":{\"name\":\"Daniel Westermann\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"headline\":\"Setting up IBM Db2 on Linux\",\"datePublished\":\"2022-01-14T12:29:54+00:00\",\"dateModified\":\"2022-04-06T06:26:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\"},\"wordCount\":505,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png\",\"keywords\":[\"DB2\",\"IBM\"],\"articleSection\":[\"Database Administration & Monitoring\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\",\"name\":\"Setting up IBM Db2 on Linux - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png\",\"datePublished\":\"2022-01-14T12:29:54+00:00\",\"dateModified\":\"2022-04-06T06:26:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png\",\"width\":482,\"height\":586},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Setting up IBM Db2 on Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66\",\"name\":\"Daniel Westermann\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g\",\"caption\":\"Daniel Westermann\"},\"description\":\"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.\",\"sameAs\":[\"https:\/\/x.com\/westermanndanie\"],\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Setting up IBM Db2 on Linux - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/","og_locale":"en_US","og_type":"article","og_title":"Setting up IBM Db2 on Linux","og_description":"My last contact with IBM Db2 was more than 10 years ago, and that only on the SQL\/application level. I’ve never done an installation of Db2 as most of our customers either don’t use it, or we don’t know about it, or these databases are managed by other teams than those we work with. And […]","og_url":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/","og_site_name":"dbi Blog","article_published_time":"2022-01-14T12:29:54+00:00","article_modified_time":"2022-04-06T06:26:40+00:00","og_image":[{"width":482,"height":586,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png","type":"image\/png"}],"author":"Daniel Westermann","twitter_card":"summary_large_image","twitter_creator":"@westermanndanie","twitter_misc":{"Written by":"Daniel Westermann","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/"},"author":{"name":"Daniel Westermann","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"headline":"Setting up IBM Db2 on Linux","datePublished":"2022-01-14T12:29:54+00:00","dateModified":"2022-04-06T06:26:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/"},"wordCount":505,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png","keywords":["DB2","IBM"],"articleSection":["Database Administration & Monitoring"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/","url":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/","name":"Setting up IBM Db2 on Linux - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png","datePublished":"2022-01-14T12:29:54+00:00","dateModified":"2022-04-06T06:26:40+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/01\/db2_1.png","width":482,"height":586},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/setting-up-ibm-db2-on-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Setting up IBM Db2 on Linux"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d08e9bd996a89bd75c0286cbabf3c66","name":"Daniel Westermann","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/31350ceeecb1dd8986339a29bf040d4cd3cd087d410deccd8f55234466d6c317?s=96&d=mm&r=g","caption":"Daniel Westermann"},"description":"Daniel Westermann is Principal Consultant and Technology Leader Open Infrastructure at dbi services. He has more than 15 years of experience in management, engineering and optimization of databases and infrastructures, especially on Oracle and PostgreSQL. Since the beginning of his career, he has specialized in Oracle Technologies and is Oracle Certified Professional 12c and Oracle Certified Expert RAC\/GridInfra. Over time, Daniel has become increasingly interested in open source technologies, becoming \u201cTechnology Leader Open Infrastructure\u201d and PostgreSQL expert. \u00a0Based on community or EnterpriseDB tools, he develops and installs complex high available solutions with PostgreSQL. He is also a certified PostgreSQL Plus 9.0 Professional and a Postgres Advanced Server 9.4 Professional. He is a regular speaker at PostgreSQL conferences in Switzerland and Europe. Today Daniel is also supporting our customers on AWS services such as AWS RDS, database migrations into the cloud, EC2 and automated infrastructure management with AWS SSM (System Manager). He is a certified AWS Solutions Architect Professional. Prior to dbi services, Daniel was Management System Engineer at LC SYSTEMS-Engineering AG in Basel. Before that, he worked as Oracle Developper &\u00a0Project Manager at Delta Energy Solutions AG in Basel (today Powel AG). Daniel holds a diploma in Business Informatics (DHBW, Germany). His branch-related experience mainly covers the pharma industry, the financial sector, energy, lottery and telecommunications.","sameAs":["https:\/\/x.com\/westermanndanie"],"url":"https:\/\/www.dbi-services.com\/blog\/author\/daniel-westermann\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/251","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=251"}],"version-history":[{"count":7,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/251\/revisions"}],"predecessor-version":[{"id":17021,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/251\/revisions\/17021"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/39"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=251"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=251"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=251"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=251"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}