Description of the implementation process of the partition environment in IBM DB2 9 (1)

The following article describes how to install the partition environment of IBM DB2 9 on AIX, we all know that the partition environment of the DB2 database is suitable for statistical and practical analysis applications, such as the Data Warehouse System of a general unit. During the deployment of the data warehouse system, the installation of a partitioned environment is often the first step in project deployment.

In the DB2 Information Center, there are similar installation information, but the information is relatively scattered, requiring installation engineers to have a good understanding of the IBM DB2 product-related website structure.

This is especially not suitable for those who use the partition environment of IBM DB2 9 for the first time. During installation, the installer first needs to find the information and then read the information, therefore, it usually takes a long time. In this article, the installation process is simplified to facilitate quick deployment of the DB2 partition environment.

Disk and memory requirements

Disk requirements

Disk requirements depend on the number of options you have installed. Three options can be installed during the installation process: ESE, CLIENT, and RTCL. Generally, if you have installed all three options, 2 GB space is sufficient. On AIX, the basic DB2 products are installed in the/opt/IBM/DB2/V9.1 directory by default.

Memory Requirements

The DB2 database system requires at least 256 mb ram. For a system that only runs the DB2 and DB2 GUI tools, at least 512 mb ram is required. However, we recommend that you provide 1 gb ram to improve performance. These requirements do not include the memory required by other software running on the system.

Number of machines required

You can install a DB2 partitioned database on one machine, or you can install a partitioned database on multiple machines, this document assumes that you have installed on four servers: ServerA, ServerB, ServerC, and ServerD.

Operating system installation requirements

Table 1. Operating System Environment requirements

AIX operating system

AIX V5.2.0 1) 64-bit AIX kernel is required;

2) TL08 and SP2;

3) Minimum C ++ runtime level is xlC. rte 8.0.0.4 and xlC. AIX50.rte 8.0.0.4

AIX V5.3.0 1) 64-bit AIX kernel is required;

2) TL04 and SP2;

3) Minimum C ++ runtime level is xlC. rte 8.0.0.4 and xlC. AIX50.rte 8.0.0.4

Use the bosboot command to switch to the 64-bit Kernel

To switch to the 64-bit kernel, you must have the root user permission and enter the following command:

Listing 1

 
 

  
  
ln -sf /usr/lib/boot/unix_64 /unix  
  
  
ln -sf /usr/lib/boot/unix_64 /usr/lib/boot/unix  
  
  
bosboot -a  
  
  
shutdown -Fr  
 
 

DB2 version 9 Requirements

DB2 version 9 requires "ibm c ++ runtime environment component for AIX", which contains xlC. rte 8.0.0.4. This can be obtained from the ibm aix Support Web site.

Verify Operating System Environment

Execute oslevel-s

5300-04-02 the output results indicate that TLS 04 and SP2 have been reached.

Verify whether the 64-bit kernel is enabled

Listing 2

 
 

  
  
/usr/sbin/bootinfo -K 
 
 

If the 32-bit kernel is enabled, "32" is returned. If the 64-bit kernel is enabled, "64" is returned ".

Install basic DB2 Products

Transmit the software package ese.tar.gz of DB2 DPF to each machine that needs to run DPF through FTP, and decompress the package using the following command:

Listing 3

Gzip-d ese.tar.gz

Tar-xvf ese.tar

Change the directory to the product directory:

Cd ese/Disk1

Run DB2_install to install the product:

./Db2_install

Enter the ese client when prompted to enter the name of the product to be installed.

The CLIENT contains the software packages required for DB2 application development. Generally, installation is required.

Install the latest DB2 patch