× Welcome to the Centrify Community! Looking for Express & Smart Card Help? Click Here

Installing DB2 Express-C on Linux and configuring the Centrify DB2 plugin

Installing DB2 Express-C on Linux and configuring the Centrify DB2 plugin

By Centrify Contributor I ‎10-21-2016 09:09 AM

The Centrify Community has some great resources when it comes to IBM DB2 integration with Active Directory using Centrify.  But, have you ever wanted to quickly set up DB2 in a test environment to play with these integrations? By following this article, you can!

  

I had long shied away from testing the Centrify DB2 plugin because it seemed mysterious and complex.  Once I dove into it, I found it was much easier than expected.  In only a few hours, I had a DB2 test instance up and running, easily integrated with Active Directory thanks to Centrify.

 

Why integrate DB2 with Active Directory Using Centrify?  Robertson has a great write-up here: Overcoming IBM DB2 Identity and Access Challenges with Centrify and AD.

 

My AD users could authenticate to the DB2 system from the command line or remotely using IBM Data Studio.  Security Groups were enumerated from AD, and SSO "just worked".  Best of all, I could quickly demonstrate meeting security requirements by enabling DB2's encryption of usernames, passwords and optionally all data going to the server.

 

Here is my experience installing IBM DB2 Express-C on CentOS 7.2.

 

Prerequisites: 

 

Validate prerequsites.  The following command produced a list of errors for 32-bit libraries that I ignored, since I was running on a 64-bit system.

./db2prereqcheck

 

There were a few errors I had to resolve manually.  First, resolve dependency issues on CentOS:

yum install libaio
yum install compat-libstdc++-33

 

Next, since my CentOS test VM was a "minimal" install, it did not include X-Windows.  To keep going with my DB2 installation quickly, I chose to install X Windows instead of trying to figure out how to install DB2 on the command line only:

yum groupinstall “Desktop” “X Window System” “Fonts” “Desktop Platform”

 

 Now that the pre-reqs are satisified, I was able to launch the DB2 installer:

./db2setup
  • The GUI launches.
  • Select "New Install".
  • Choose "DB2 Express C", then click "Next".

 

Picture1.png

  • I chose "Typical" and clicked "Next".

 

Picture2.png

  • Set a password for the instance owner, db2inst1, and click "Next".
  • Do the same for Fenced User 
  • Lastly, click "Finish" after the Response File and Summary

 

Picture3.png

 

Next, let's create a sample database for testing purposes.  

su - db2inst1 
cd /opt/ibm/db2/V11.1_01/bin/db2sampl
./db2sampl

Picture4.png

 

This creates the sample database.  We can test by connecting to it:

 

db2 connect to sample

Picture5.png

 

To return some results, you can use the following query: 

db2 ‘select * from dept’

From here, you can follow Robertson's guide to install the Centrify DB2 user, group and GSSAPI plugins.  

 

Part 2 of this blog has been published!  See it here: Testing and Troubleshooting the Centrify DB2 plugin.

 

Showing results for 
Search instead for 
Do you mean 
Labels

Community Control Panel