Db2 Express C Db2 Install On Linux

1. Db2 Express C Db2 Install On Linux 10

DB2 Express-C is a fully functional and very powerful database offering from IBM, that can be used for free. Currently it’s limited to two cores and 4GB RAM, that’s enough to be used in small-medium applications.DB2 plays well with LXC, and I had no problem using it for years in a hosted server environment.It’s been a while since my last post in this subject. I’ve been running DB2 9.7 in a Debian based LXC container without a glitch for about 5 years. After a distribution upgrade of the Ubuntu host, the 9.7 gave up and I was left with the dilemma of either staying on an old and insecure core distribution, or upgrading the entire stack.Installing the DB2 Express-C 10.5 is a breeze when compared to previous versions.

A couple of simple commands and you’re done. Upgrading from a previous version is almost as simple. Still it does take some preparation, and I advise anyone trying to do it to exercise caution. PreparationIn this article I assume you already have a single database instance you want to upgrade. The database is installed using the standard locations and users.My host installation is done in a fresh amd64 LXC install from the Ubuntu template. The DB I’m upgrading from has been copied from it’s original 32bit container to the corresponding locations (/opt/ibm/db2, /home/dbsinst1, /home/dasusr1) in the fresh host.

The users, groups, services are added to the corresponding /etc files, the /opt/ibm/db2 folders and the /var/lib/db2 folders are copied.Before copying make sure the original container is shut down properly! InstallationDownload the installer for your architecture from IBM. Extract the files to /opt/ibm/db2 folder in your target machine.Add prerequisites for the latest version that DB2 installer complains about./db2prereqcheck -lRequirement not matched for DB2 database 'Server'. Version: '10.5.0.4'.Summary of prerequisites that are not met on the current system:DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: '/lib/i386-linux-gnu/libpam.so.' .DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: 'libstdc.so.6'.Requirement not matched for DB2 database 'Server' with pureScale feature.

Version: '10.5.0.4'.Summary of prerequisites that are not met on the current system:DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: '/lib/i386-linux-gnu/libpam.so.' .DBT3514W The db2prereqcheck utility failed to find the following 32-bit library file: 'libstdc.so.6'.Start adding the missing requirements. DB2 still requires 32 bit libs for running. Apt-get install binutils libaio1 dpkg -add-architecture i386 apt-get update apt-get install libpam0g:i386 libstdc6:i386Start DB2 installation./db2installDBI1324W Support of the db2install command is deprecated. For more information, see the DB2 Information Center.Default directory for installation of products - /opt/ibm/db2/V10.5.Install into default directory (/opt/ibm/db2/V10.5)? yes/noyesDB2 installation is being initialized.Total number of tasks to be performed: 36Total estimated time for all tasks to be performed: 1370 second(s).Task #38 startDescription: Updating global profile registryEstimated time 3 second(s)Task #38 endThe execution completed successfully.For more information see the DB2 installation log at'/tmp/db2install.log.14621'.You can now remove the installation folder if you want to. MigrationAdd the libs to run 32 bit DB2 9.7 apt-get install libaio1:i386Check to see if the upgrade can be completed on the databases # su - db2inst1$ db2start$ /opt/ibm/db2/expc/db2ckupgrade -e -l /tmp/upgradev10.5.logDBT5508I The db2ckupgrade utility completed successfully.

The database or databases can be upgraded.$ cat /tmp/upgradev10.5.logVersion of DB2CKUPGRADE being run: VERSION '10.5'Database: 'MYDB'DBT5537I The db2ckupgrade utility has completed processing for database 'MYDB'.DBT5508I The db2ckupgrade utility completed successfully. The database or databases can be upgraded.$ db2 force application allDB20000I The FORCE APPLICATION command completed successfully.DB21024I This command is asynchronous and may not be effective immediately. $ db2 terminateDB20000I The TERMINATE command completed successfully. $ db2stopSQL1064N DB2STOP processing was successful.

Refine your search by using the following advanced search options. CriteriaUsageQuestions with keyword1 or keyword2keyword1 keyword2Questions with a mandatory word, e.g.

Db2 Express C Db2 Install On Linux 10

Keyword2keyword1 +keyword2Questions excluding a word, e.g. Keyword2keyword1 -keyword2Questions with keyword(s) and a specific tagkeyword1 tag1Questions with keyword(s) and either of two or more specific tagskeyword1 tag1 tag2To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +tag1.