How can I confirm the partition environment for installing IBM DB2 9? (1)

Today, we will mainly describe how to install the partition environment of IBM DB2 9 on AIX, in practice, the partition environment of the DB2 database is mainly suitable for statistics and analysis operations and practical applications. For example, the data warehouse system of a general unit is deployed in 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.

Installation engineers are required to have a good understanding of the website structure related to IBM DB2 products, especially those who are not suitable for the first time using the DB2 partition environment. 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. There are three options to install IBM DB2 9, which are ESE, CLIENT, and RTCL. Generally, 2 GB space is sufficient if you install all three options. 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.

Requirements for installing the IBM DB2 9 Operating System

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 IBM DB2 9 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

After installing basic DB2 products for the first time, we recommend that you install the latest DB2 patch, which is helpful for the future stability of the system and because it is installed before the instance is created, therefore, you do not need to execute db2iupdt to update the instance. The latest DB2 patch can be obtained from the following URL:

Http://www-1.ibm.com/support/docview.wss? Rs = 71 & uid = swg21254867