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:
GUI installer available on Linux (requires X window server) and Windows operating systems. It can be used to create instances and response files.
Automated install using the response file to avoid user interaction during install and to ensure the same install options are used for multiple installs.
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.
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
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:
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.
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: selecting DB2 features to install
Setup wizard: setting DB2 copy name
Setup wizard: specifying the location of DB2 Information Center
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: 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
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: enabling operating system security for DB2 objects
Installation using response file
On the Windows platform, enter following command:
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:
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:
Considerations for DB2 Express-C
The following constraints are present in DB2 Express-C:
IBM DB2 Related Interview Questions
|IBM Websphere Interview Questions||IBM-REXX Interview Questions|
|IBM Cognos Interview Questions||IBM DB2 Interview Questions|
|J2EE Interview Questions||COBOL Interview Questions|
|IBM-JCL Interview Questions||DB2 Using SQL Interview Questions|
|IBM WAS Administration Interview Questions||IBM WebSphere Administration Interview Questions|
|Database Administration Interview Questions||DB2 SQL Programming Interview Questions|
|Mainframe DB2 Interview Questions|
IBM DB2 Related Practice Tests
|IBM Websphere Practice Tests||IBM Cognos Practice Tests|
|IBM DB2 Practice Tests||J2EE Practice Tests|
|COBOL Practice Tests||IBM-JCL Practice Tests|
|DB2 Using SQL Practice Tests||IBM WAS Administration Practice Tests|
|Database Administration Practice Tests||DB2 SQL Programming Practice Tests|
Ibm Db2 Tutorial
Db2 Application Development Overview
Application Development With Db2 Purexml
Application Development With Php
Application Development With C/c++
Application Development With Java
Application Development With .net
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.