Install and configure ICDC for DB2 in Linux

Install and configure ICDC

 

 

 

I. Environment

OS: linux_final_5.5 (64bit)

DB: DB2 v9.7fp4_linuxx64_server.tar

ICDC: cdc_6.5.20.db2 _ linux.zip

Access Server: cdc_6.5.20.accs_svr_lnx_x86.zip

Manangementconsole: cdc_6.5.20.mgmt_console_wdws.zip

Network: Lan source IP address 192.168.128.100 image IP address 192.168.128.101

Ii. Purpose

Allows you to copy database data from the source to the image.

Iii. Implementation on the image end 1 Database preparation a) install DB2

There are no special requirements. Follow the normal installation steps. I use Silent Installation.

#./Db2setup-r/root/db2aese. RSP

You can view the installation information in two files under/tmp.

Db2setup. Log db2setup. Err

B) Create a database

Create a database

# Su-db2inst1

$ Create dB mydb using codeset utf-8territory CN pagesize 8 K

 

C) database Optimization

Create a user temporary buffer pool

$ DB2 create bufferpool user_tempdata_bpsize automatic pagesize 8192

Create user data buffer pool

$ DB2 create bufferpool userdata_bp sizeautomatic pagesize 8192

Create user temporary tablespace

$ DB2 create user temporary tablespaceuser_temp_tspace pagesize 8192 bufferpool user_tempdata_bp

Change the default data table space and use a separate buffer pool.

$ DB2 alter tablespace userspace1 bufferpooluserdata_bp

Increase the number of transaction log files

$ DB2 connect to mydb

$ DB2 update dB CFG for mydb usinglogprimary 50

$ DB2 update dB CFG for mydb using logsecond30

Increase the transaction log file size

$ DB2 update dB CFG for mydb using logfilsiz100

Database starts with the operating system (optional)

$ Db2iauto-on db2inst1

 

2. Install ICDC agent

Decompress the file

$ Unzip cdc_6.5.20.db2 _ linux.zip

Go to File Execution

$./Setup-cdc-linux-power-db2luw.bin

If the file cannot be executed, you can change the permission.

$ Chmod + x setup-cdc-linux-power-db2luw.bin

 

 

Installation information:

Installation path:/home/db2inst1/ICDC/

Start the configuration tool? Yes

Input Instance name: db2target

Port: 10901

Enable Automatic Discovery port: Disable

Allocate Disk Quota for instance: 1

Memory size: 1024

Bit version: 64

DB2 instance: db2inst1

DB2 name: mydb

Whether to configure advanced parameters: N

Username: db2inst1

Password :*******

Metadata tables: db2inst1 [U1]

Refresh loader path:/home/db2inst1/ICDC/

Overwrite the metadata? Y

S is the instance started now? Y

 

Start an ICDC instance

$ CD/home/db2inst1/ICDC/bin

$ Nohup./dmts64-I db2target &

Disable an ICDC instance

$./Dmshutdown-I db2target or

$./Dmterminate. Sh

 

3. Install Access Server

Decompress the file

$ Unzip cdc_6.5.1_accs_svr_lnx_x86.zip

Enter the file directory for execution

$./Cdcaccess-6.5.1503.5-linux-x86-setup.bin

If you do not have the execution permission

$ Chmod + x cdcaccess-6.5.1503.5-linux-x86-setup.bin

 

 

Installation information:

Port: 10101

Installation path:/home/db2inst1/icdcacc

 

 

Start accessserver

$/Home/db2inst1/icdcacc/bin/dmaccessserver &

Disable accessserver

# Pkill accessserver

Add Admin user to accessserver

$ CD/home/db2inst1/icdcacc/bin/

$./Dmcreateuser admin db212345 adminsysadmin True False true

Iv. Source implementation 1. Database preparation

Enable archiving logs

# Su-db2inst1

$ Mkdir/u01/dbdata/backup

$ DB2 update dB CFG for mydb2 using logretainon

$ DB2 update dB CFG for mydb2 usinglogarchmeth1 Disk:/disk01/dbdata/backup

$ DB2 force application all

Back up database

$ DB2 backup database mydb2 to/disk01/dbdata/backup

2. Install ICDC agent

Decompress the file

$ Unzip cdc_6.5.20.db2 _ linux.zip

Go to File Execution

$./Setup-cdc-linux-power-db2luw.bin

If the file cannot be executed, you can change the permission.

$ Chmod + x setup-cdc-linux-power-db2luw.bin

 

 

Installation information:

Installation path:/home/db2inst1/ICDC/

Start the configuration tool? Yes

Input Instance name: db2source

Port: 10901

Enable Automatic Discovery port: Disable

Allocate Disk Quota for instance: 1

Memory size: 1024

Bit version: 64

DB2 instance: db2inst1

DB2 name: mydb2

Whether to configure advanced parameters: N

Username: db2inst1

Password :*******

Metadata tables: db2inst1

Refresh loader path:/home/db2inst1/ICDC/

Overwrite the metadata? Y

S is the instance started now? Y

 

Start an ICDC instance

$ CD/home/db2inst1/ICDC/bin

$ Nohup./dmts64-I db2sourcet &

Disable an ICDC instance

$./Dmshutdown-I db2source or

$./Dmterminate. Sh

 

5. Install the management console and configure ICDC Data Synchronization

Install software as usual.

The login user name is the user name set when the access server is installed

The IP address of the image where the access server is located

The port is the port entered when the access server is installed.

Configuration

1. Create a storage

Access Manager = Data Storage window right-click = new storage

2. Allocate users to Data Storage

Right-click New Data Storage = and select assign user

3. Configure the replication project

Configuration = in the reservation box, right-click to create a reservation

4. Add Table ing

Right-click the reservation point and select = TABLE ing (one-to-one) = select the target table = image mode = start the process

 

 

Suggestion: Close the connection to the database before closing the manage console.

 

[U1] Note: if the "metadataschema:" list does not contain db2inst1, run the DB2 create schema db2inst1 command. Edit the created instance and run/home/db2inst1/ICDC/bin/dmconfigurets.