Migrate DB2 database from Windows XP to AIX and reinstall the database

This article mainly describes how to migrate a DB2 database from Windows XP to AIX and how to reinstall the database, in actual operations, if you encounter the re-installation of the database during the migration of the DB2 database from Windows XP to AIX, but you do not know how to solve it correctly, so the following articles must be good teachers and friends for you.

Install Database

1. Log On As the root user and create gjyw as the instance user through smitty user to enter the directory where the installation file of the DB2 database is located.

2. Grant all permissions to all files in the installation file directory chomd 777 *

3. If you use. db2_setup for installation, you must log on with the root user.

Run vi. profile

The following is a reference clip:

 
 

  
  
".profile" 6 lines, 103 characters   
  
  
alias l='ls -l'   
  
  
set -o vi   
  
  
DISPLAY=192.168.250.110:0.0   
  
  
export DISPLAY   
  
  
PATH=$PATH:/nmon/nmon   
  
  
export PATH  
 
 

Change the preceding IP address to the remote client IP address.

4. Use another installation file in the directory (same as step 1). During the installation process, change instance db2inst1 to gjyw (the name of the instance to be used );

5. Stop the service after the installation is complete;

Su-gjyw (instance user)

Db2 database stop instance, if not, db2stop force stop

Exit to the root layer

Su-dasusr1 (db2 administrator)

Db2admin stop DAS

6. Upgrade DB2 8.2

Switch to the update package directory

 
 

  
  
./installFixPak –y 
 
 

7. Switch to the root user

The following is a reference clip:

 
 

  
  
cd /usr/opt/db2_08_01/instance   
  
  
chmod +x db2iupdt   
  
  
chmod +x dasupdt  
 
 

Grant executable permissions to these two files

The following is a reference clip:

 
 

  
  
./db2iupdt gjyw   
  
  
./dasupdt dasusr1  
 
 

The above content is an introduction to the complete process of migrating DB2 databases from Windows XP to AIX. I hope you will get some benefits.