IBM's Universal Database

Getting DB2 up and running on Linux.
Enabling the DB2 Graphical Tools

You must have the prerequisite Java Runtime Environment (JRE) level to use the DB2 Administration Tools. For more information, refer to the Control Center README, which can be found in the INSTHOME/sqllib/cc/prime directory, where INSTHOME is the home directory of the user created for the instance during the installation (for example, /home/db2inst1/sqllib/cc/prime). Let me save you some time and take you through the quickest way I found to get the graphical tools running on your workstation. Perform the following steps:

  • Log on to your workstation as a user with root authority

  • In order to run the graphical tools, you need to be running at least Java 1.1.7 v3 or later. A JRE is available from the Blackdown web site at www.blackdown.org/java-linux/mirrors.html. For this example, I visited the mirror site at: ftp://metalab.unc.edu/pub/linux/devel/lang/java/blackdown.org/JDK-1.1.7/i386/glibc/v3/, downloaded the jre_1.1.7-v3-glibc-x86-native.tar.gz file and placed it in the /tmp directory. For all the latest information on supported JREs and browsers, go to http://www.software.ibm.com/data/db2/.

  • Note that you must download the native threads version of the JRE that you want to use. The DB2 Control Center does not support green threads.

  • Once you have downloaded an appropriate JRE, unpack the file by entering the following command:

  • tar xvfz jre_1.1.7-v3-glibc-x86-native.tar.gz

  • Log on to your workstation as the db2inst1 user.

  • Update your PATH so that your workstation knows the location of the JRE's binary files just installed. Assuming you are following along the example, for Bash or Bourne shells enter this command: export PATH=/tmp/jre117_v3/bin:$PATH; for C shell enter: setenv PATH /tmp/jre117_v7/bin:${PATH}, where /tmp/jre117_v7/bin is the path to the downloaded JRE binary files.

  • Start the JDBC Applet Server by entering the following command: db2jstrt 6790.

  • Start a graphical administration tool. For this example, let's start the Control Center using the command db2cc 6790.

  • The Control Center Sign On window opens. Enter a valid DB2 user that has SYSADM authority on the instance with which you intend to work. For our example, enter the db2inst user ID and the corresponding password. For more information, refer to the “Administration Guide”.

Now, you have completed all the steps necessary to configure your workstation for the DB2 graphical tools.

If you followed the steps and considerations that I have outlined in this article, you should have a running copy of DB2 on your Linux workstation, a sample database, a running Control Center and a smile on your face!

Paul Zikopoulos (paulz_ibm@yahoo.com) is a senior member of the DB2 information and development team, specializing in DB2 installation and configuration issues. He has more than five years experience with the DB2 Universal Database, and has written magazine articles and books about DB2. Paul is an IBM Certified Advanced Technical Expert (DRDA and Cluster/EEE) and an IBM Certified Solutions Expert with DB2 Universal Database.

______________________

Webinar
One Click, Universal Protection: Implementing Centralized Security Policies on Linux Systems

As Linux continues to play an ever increasing role in corporate data centers and institutions, ensuring the integrity and protection of these systems must be a priority. With 60% of the world's websites and an increasing share of organization's mission-critical workloads running on Linux, failing to stop malware and other advanced threats on Linux can increasingly impact an organization's reputation and bottom line.

Learn More

Sponsored by Bit9

Webinar
Linux Backup and Recovery Webinar

Most companies incorporate backup procedures for critical data, which can be restored quickly if a loss occurs. However, fewer companies are prepared for catastrophic system failures, in which they lose all data, the entire operating system, applications, settings, patches and more, reducing their system(s) to “bare metal.” After all, before data can be restored to a system, there must be a system to restore it to.

In this one hour webinar, learn how to enhance your existing backup strategies for better disaster recovery preparedness using Storix System Backup Administrator (SBAdmin), a highly flexible bare-metal recovery solution for UNIX and Linux systems.

Learn More

Sponsored by Storix