What are the projects required to install IBM DB2 for AIX?

The following article describes the actual installation process of IBM DB2 for AIX. I saw the actual installation process of IBM DB2 for AIX on the relevant website two days ago, the following is a detailed description of the main content of the article.

AIX is installed on the IBM RS6000 operating system, and the HP9000 is the same

1. Register as a user with Super User Permissions (root)

2. Insert the software CD labeled "DB2 General Database Enterprise Edition" into the drive

3. Enter the following command to create a directory for IBM DB2 for AIX to install the CD-ROM:

# Mkdir-p/cdrom where cdrom represents the CD-ROM installation directory.

Enter the following command to assign the CD-ROM File System:

# Smitty storage

4. Select a File System

5. Select Add/change/display/delete file system

6. Select the CDROM File System

7. Select Add CDROM File System

8. In the pop-up window, enter the following items as the installation point:

/Cdrom

9. Install the CD-ROM file system by entering the following command: smit mountf

10. Enter a value in the file system name field. For example, the name may be/dev/cd0.

11. Enter a value in the installation directory Field. For example, this value may be/cdrom.

12. Set the read-only system to Yes.

13. Click OK.

14. cd/cdrom

15. Enter the./db2setup command to start the DB2 installation program. The Install DB2 V6 window opens.

16. Press the Tab key to change the highlighted options. Press Enter to select or cancel the selected options.

1) install the following three products on the server:

Note: To display the components of the DB2 product to be installed, select Custom. To return to the previous window at any time, select cancel.

DB2 Administration Client

Choose to customize and install this product,

DB2 UDB enterprise edition

Choose to customize and install this product,

DB2 Software Developer Kit

If you are developing at the same time, you need to customize IBM DB2 for AIX to install this product.

2) select only the Chinese language ZH_CN for "DB2 product information" and "DB2 Product Database.

17. After you confirm in Step 16, you will start to install the database program. During installation, you also need to confirm the following issues:

1) whether to create a DB2 management account. Generally, choose to create:

Create db2 Management User db2as by default using the default UID, Group Id, install home path), in terms of language support,

Select only the Chinese language ZH_CN.

2) whether to create a DB2 instance. Generally, choose to create a DB2 instance:

Create db2 Management User db2inst1 by default: db2iadm1 use the default UID, Group Id, install home path ),

In terms of language support, only the Chinese language ZH_CN is supported.

Create db2 user db2fenc1 by default: use the default UID, Group Id, and home installation path for db2fenc1 ),

In terms of language support, only the Chinese language ZH_CN is supported.

Whether to create a sample database. In order to check whether the database is correctly installed, we generally choose to create a sample database)

Whether to select the DB2 instance process to automatically perform initialization when the operating system starts

If you want to install and use it on an independent server, you can select autostart, but do not select autostart in the dual-host shared environment of aix + hacmp + db2.

Autostart: the startup of the DB2 instance process, which is controlled by hacmp.

18. Installation result:

After the database program is installed, the DB2 software program is installed in the/usr/lpp directory,

DB2DIR =/usr/lpp/DB2_06_01

Note: If the instance creation and management account are not specified during the installation process, you can use the command to create the instance (db2icrt) after the installation is complete ).

To create or add a new instance, "Management Server", or other DB2 Products and Components, run the following command:

/Usr/lpp/DB2_06_01/install/DB2setup

19. Verify Installation

If you do not select to create a sample database during installation, you can run the db2sampl command to create a SAMPLE database,

Verify the installation by using the command line processor to connect to the database:

1) register with the system as a user with SYSADM permissions. For example, db2inst1

2) enter the DB2sampl command to create the SAMPLE database.

3) when creating a SAMPLE database, use the database alias SAMPLE to automatically catalog it.

4) enter the DB2start command to start the database management program.

5) enter the following command to connect to the SAMPLE database, retrieve the list of all employees working in department 20, and reset the database connection:

 
 

  
  
DB2 connect to sample   
  
  
DB2 "select * from staff where dept = 20"   
  
  
DB2 connect reset  
 
 

Note: after verification and installation, you can remove the SAMPLE database to release disk space. Enter the DB2 drop database sample command

To unload the SAMPLE database.

If you have not installed the DB2 tool for IBM DB2 for AIX, you can create a SAMPLE database and use the command line processor

To verify the installation, as shown below:

Step 1.

Register with the system as a user with SYSADM permissions.

Step 2.

Enter the db2sampl command to create the SAMPLE database.

When you create a SAMPLE database, use the database alias SAMPLE to automatically catalog it.

Step 3.

Enter the db2start command to start the database management program.

Step 4.

Run the following command to connect to the SAMPLE database:

 
 

  
  
db2 connect to sample   
  
  
db2 "select * from staff where dept = 20"   
  
  
db2 connect reset  
 
 

If the preceding commands are correctly executed, the installation of IBM DB2 for AIX on the DB2 UDB database server is successful.