[DB2 learning document] preliminary installation

Author: gnuhpc
Source: http://www.cnblogs.com/gnuhpc/

1. display the db2setup command in a local language
The db2setup command is used to query the operating system to determine the existing language settings. If db2setup supports language settings on the operating system, this language is used.
If your system uses the same code page as the DB2 interface, but the language environment name is different from the supported language environment name, run the following command to set the Lang environment variable to an appropriate value. You can still see the switched db2setup:
Bourne (SH), KoRn (Ksh), and bash shell:
Lang = <locale>
Export Lang
C shell:
Setenv Lang <locale>
Locale is the language environment supported by the DB2 interface.
2. Change the DB2 interface language (Linux and UNIX)
The interface language of DB2 products is the language that appears in the message, help, and graphical tool interface. When installing the DB2 product, you can choose to install one or more languages. Use the steps outlined in this task if you want to change the interface language to one of the other installed interface languages after installation.
Do not confuse the languages supported by DB2 with those supported by the DB2 interface. The language supported by DB2, that is, the language that data can use, is a language superset supported by the DB2 interface.
To check which public language environments are available on the system, run the $ locale-a command.
To change the DB2 interface language, set the Lang environment variable to the expected language environment.
For Bourne (SH), KoRn (Ksh), and bash shell:
Lang = <locale>
Export Lang
For C shell:
Setenv Lang <locale>
For example, to communicate with the French version of DB2, the "French" language support must be installed and the Lang environment variable must be set to the "French" language environment (for example, fr_fr ).
3. Install the DB2 server (Linux and UNIX)
1. log on to the system as a user with root user permissions.
2. Run the following command to switch to the directory where the DB2 database product CD is installed:
CD/CDROM
CDROM indicates the Installation Point of the DB2 database product CD.
3. If you have downloaded the DB2 database product image, you must decompress the product file.
1. decompress the product file:
Gzip-D product.tar.gz
Here, product is the name of the downloaded database product.
2. decompress the product file:
Tar xvf product.tar
3. Change the directory:
CD./product/disk1
Note: If you have downloaded the Local Language Pack, extract it to the same directory. In this way, a subdirectory (for example,./nlpack/disk1) is created in the same directory, and the installer can automatically find the installation image without prompting
4. Enter the./db2setup command from the directory where the product image is located to start the "DB2 installation" Wizard. For multi-CD installation, use the relative path or absolute path name to issue the db2setup Command outside the installed CD location to ensure that the DB2 database product CD can be retrieved as required
5. the IBM DB2 Installation Boot board will be opened. In this window, you can view the installation prerequisites and release instructions, or install them directly. You may want to view installation prerequisites and release notes for the latest information.
6. Click Install product. The installation product window displays the products that can be installed.
Click "install new product" to start the installation. Follow the prompts in the "DB2 installation" Wizard to complete the installation step by step.
Once the installation is started, you can use the installation panel of the DB2 Installation Wizard to continue the installation and make choices. The installation help can be used to guide you through other steps. To call the installation help, click Help or Press F1. You can click Cancel at any time to end the installation.
By default, DB2 database is installed in one of the following directories:
Aix, HP-UX, and Solaris operating environment
/Opt/IBM/DB2/v9.1
Linux
/Opt/IBM/DB2/v9.1
If you install it on a system that is already in use, _ xx will be added to the installation path of the DB2 database product, where XX is a number, start from 01 and increase with the number of DB2 copies you have installed.
You can also specify the installation path of your DB2 database product.
You can also install the "Local Language Pack" by running the./db2setup command from the directory where the "Local Language Pack" is located after installing the DB2 database product ".
By default, the installation logs db2setup. log and db2setup. Err are located in the/tmp directory. You can specify the location of the log file.
You can run db2setup from the command line to start the installation program.

 

After installing DB2 and successfully creating an instance, you can log on as the instance owner (db2inst1 in this example) and call the db2profile script to set the environment variables. You can use the db2sampl script to create a sample database.

To open the DB2 control center, remember to use the root user to issue xhost + to add access permissions to the X server. Then, log on again as the instance owner and start DB2 Control Center

Now that you have installed DB2 and created a sample database, you can catalog the database on a remote DB2 client. Start DB2 configuration assistant on a remote client and use the search the Network option of the add database using wizard option. Through remote connection, you can find and list the instances and databases created in the virtual machine. The IP address provided for the Host Name field is the IP address of the VM.

 

To sum up the installation method:
InstallDB29 there are four methods for data management software: "DB2 Installation Wizard, db2_install installation script, configuration file-based installation, and manual installation. The following sections describe:

DB2 Installation Wizard

Graphical interface wizard installation in Linux, UNIX, and Windows operating systems is very useful for users who first install DB2 9. The Installation Wizard provides an easy-to-use installation interface, which simplifies operations such as database performance adjustment and optimization tasks after installation. The Installation Wizard can also be used to generate a database instance and describe the installation configuration file. In Unix or Linux environments, the installation wizard must be supported by the X server software.

Db2_install installation script

This script installation method can only be used in a Linux or Unix environment, and Windows does not support script installation. This method provides more fine-grained control over the installation process. However, this method cannot create database users and groups, create database instances, or configure after installation.

Description Configuration File Installation

The configuration file is a text file that contains the steps required for installation and configuration of DB2 9, the DB2 9 installer reads the preset installation values in the description configuration file for installation. You can use the following methods to generate the installation Description configuration file:

1. description file generator can be used in windows.

2. Use the DB2 Installation Wizard to generate

3. Modify the sample file provided in the product package to obtain

This installation method is conducive to the distributed installation of the DB2 client. For example, you can first install a DB2 client and complete the configuration, and then generate a description configuration file, then install and copy similar clients. You can also use the db2cfexp command to output the installation configuration profile of the DB2 client software and server software.

Manual Installation

This installation method is only recommended for use by senior experts. It requires the installer to unpack and extract installation components from more than 970 packages. This method is complex and self-evident and is not recommended for junior users.

Author: gnuhpc
Source: http://www.cnblogs.com/gnuhpc/