The root user does not have automatic access to DB2 server resources, and arguably shouldn't. The user you should be logged in as to start working with DB2 is the instance owner (this is a different user than the DAS owner). If you're not sure which user owns the DB2 instance, or if an instance exists yet, use the db2ilist command to show a list of all instances installed on the local server. As the db2 instance owner you can run db2start, db2stop, and db2sampl to start working with a database right away. Eventually you will want to create other users who will interact with DB2 with fewer permissions than the instance owner has.
This edition applies to IBM® DB2® Express-C Version 9.1 for Linux®. Install DB2 Express-C & create SAMPLE database. 6 Getting Started with DB2 Express-C.
As soon as you have a database up and running, you can use GRANT statements to allow other users to connect to the database, work with tables, and execute routines (user-defined functions and stored procedures).
The Centrify Community has some great resources when it comes to. 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.
Db2 Express C Installation
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:.
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:. CentOS 7.2 virtual machine.
DB2 Express-C installation file obtained from 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'.
I chose 'Typical' and clicked 'Next'. 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 Next, let's create a sample database for testing purposes. Su - db2inst1 cd /opt/ibm/db2/V11.101/bin/db2sampl./db2sampl This creates the sample database. We can test by connecting to it: db2 connect to sample To return some results, you can use the following query: db2 ‘select. from dept’ From here, you can follow Robertson's guide to. Part 2 of this blog has been published!