DB2 Express-C - IBM DB2

DB2 Express-C is a version of DB2 Universal Database Express Edition (DB2 Express) for the community, which is completely free to download, develop, deploy, test, run, embed and redistribute. It provides the same core data server features and development interfaces as well as system limits as DB2 Express in a smaller package. DB2 Express-C is available for Linux and Windows running 32-bit or 64-bit hardware with up to 2 CPUs and 4 GBs of memory.

DB2 Express-C can be seamlessly upgraded to DB2 Express, Workgroup, and Enterprise Server Edition without database or application modification. In a Linux system, you can use uname a to determine the current kernel level and rpm -qa | grep glibc for the glibc version. There are a number of common and alternate methods for installing DB2:

  • DB2 Setup Wizard

    GUI installer available on Linux (requires X window server) and Windows operating systems. It can be used to create instances and response files.

  • Response file install

    Automated install using the response file to avoid user interaction during install and to ensure the same install options are used for multiple installs.

  • db2_install script

    It is only available on Linux and installs all components for the DB2 product with English interface support. Additional language support can be selected using –L parameter. It allows more control over the setup process and less over the installation process. No user and group creation or configuration will occur.

  • Third-party deployment tools

    Installation method for Windows. Used for mass client deployment using Windows Active Directory®, Windows System Management Server, or Tivoli. Table 1-2 summarizes DB2 installation methods.

DB2 installation methods

DB2 installation methods

Installation steps using DB2 Setup Wizard
DB2 Setup Wizard is the most common method of installing DB2. It provides a graphical user interface to step you through the DB2 installation process:

  1. Execute setup.exe, which displays the welcome window.

    The welcome window has several choices which include: Installation Prerequisites, Release Notes, Migration Information, Install a Product, and Exit. Upon choosing Install a Product, two installation options are presented. One is for DB2 Express-C, which installs the database server component and another is for DB2 Client, which only consists of DB2 client component.

    Choose DB2 Express-C install, which starts the Setup Wizard. It will take few moments for the Next button to become available. Click Next once it becomes available.

  2. Accept the terms in the license agreement to continue.
  3. Several installation types are presented: Typical, Compact, and Custom. Choose Custom to include all application development features.
  4. Now you are offered Installation options regarding response file creation. Installation can proceed with or without response file generation or you can specify the response file for future installations.
  5. The response file path can be changed from the specified default. For this scenario, specify installation with response file.

    Setup wizard: specifying response file option

    Setup wizard: specifying response file option

  6. The Select features to install window is displayed . All Application development tools should be chosen by default. You can change the default installation path on this window. For this walkthrough, we choose the default.
  7. Setup wizard: selecting DB2 features to install

    Setup wizard: selecting DB2 features to install

  8. Select a language to install.
  9. Set the DB2 copy name window is next . This is used to identify a location where DB2 products are installed on the computer.
  10. Setup wizard: setting DB2 copy name

    Setup wizard: setting DB2 copy name

  11. Specify the location of the DB2 Information Center. Choices are IBM Web site or On intranet server. We accept the default of the external IBM Web site.
  12. Setup wizard: specifying the location of DB2 Information Center

    Setup wizard: specifying the location of DB2 Information Center

  13. Next, set the user information for DB2 Administrator server (DAS). This user ID is used to start DB2 Administration server, which responds to various DB2 administration tools and Configuration Assistant (CA).
  14. In this section of the wizard, you can also specify the option to use the same user ID for other services.

    Setup wizard: setting DAS user information

    Setup wizard: setting DAS user information

  15. The Configure DB2 instance window allows creation of DB2 instances. In Windows, by default, a DB2 instance called DB2 will be created.
  16. Setup wizard: configuring DB2 instances

    Setup wizard: configuring DB2 instances

    The Configure button provides the option to set or alter the service name and listener port number associated with the given instance.

    Setup wizard: DB2 instance configuration window

    Setup wizard: DB2 instance configuration window

  17. The next step involves preparing the DB2 tools catalog. The Tools catalog will be required for DB2 Task Center and Scheduler.
  18. This step gives you the option to create the tools catalog in a new or an existing database.

    Setup wizard: preparing the DB2 tools catalog

    Setup wizard: preparing the DB2 tools catalog

  19. The Set up notifications window provides you the option to set up DB2 send notifications automatically to the SMTP server when a database needs attention. For our walkthrough, we uncheck this option.
  20. Enable operating system security for DB2 objects window provides you the option to enable operating system security, which is chosen by default. With this security option, only users who belong to DB2 users group (DB2USERS) and DB2 administrator group (DBADMINS) can access DB2 objects.
  21. Setup wizard: enabling operating system security for DB2 objects

    Setup wizard: enabling operating system security for DB2 objects

  22. Finally, DB2 Setup wizard starts copying the files and creates the response file.
  23. After the successful installation of DB2 Express-C, you can create the sample database.

Installation using response file
On the Windows platform, enter following command:

setup -u my.rsp

On the Linux platform, use the following command:

db2setup -r <responsefile_directory>/<response_file>

Installation using db2_install script
On a Linux system, log in as a user with root authority. If DB2 Express-C has been downloaded from the previously mentioned URl, it needs to be decompressed and untarred prior to installation:

  1. Decompress the product file:
  2. gzip -d db2exc_91_LNX_x86.tar.gz
  3. Untar the product file:
  4. tar -xvf db2exc_91_LNX_x86.tar
  5. Change directory into the product directory where db2_install can be found and enter the following command:
  6. ./db2_install

Sample database creation
There are several options for creating the sample database. You can create the sample database with just the tables in V8 sample SQL database objects, XML database objects, or both.

The graphical option prompts you for the creation of the database once installation is complete and provides graphical options for creating a sample database.
The command line option involves the db2sampl command. Key options are:

  • -sql: Create SQL database objects and data
  • -xml: Create XML database objects and data
  • -v8: Create the SAMPLE database from DB2 UDB V8

Considerations for DB2 Express-C
The following constraints are present in DB2 Express-C:

  • Maximum processors: 2
  • Maximum addressable memory: 4 GB
  • Database Partitioning Feature: N/A
  • Connection Concentrator: N/A
  • DB2 Geodetic Extender: N/A
  • Query Patroller: N/A
  • Net Search Extender: N/A
  • Exclude options such as HADR, DB2 Connect support, and Warehouse Manager tools

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

IBM DB2 Topics