DMHS数据对比工具安装

DMHS数据对比工具安装

环境说明：
源端 数据库端口 数据库安装路径 数据存放路径
192.168.65.185 5236 /dm8/ /dm8/data
目的端：
192.168.65.187 5236 /dm8/ /dm8/data

DMHS 安装目录
/home/dmdba/dmhs

1.安装ODBC
1.源端主库安装ODBC
–1.LINUX环境中配置ODBC,要安装gcc包。

rpm -aq|grep gcc 
tar -zxvf unixODBC-2.3.0.tar.gz 
cd unixODBC-2.3.0 

–2.配置ODBC(root)

./configure --enable-gui=no

–3.编译ODBC

make 
make install 

–4.查看ODBC版本

odbc_config --version 

–5.查看ODBC配置文件路径

odbc_config --odbcini 
odbcinst -j 

–6.配置ODBC.INI

[dm8]
Desription = DM ODBC DSND
Driver = DM8 ODBC DRIVER
SERVER = localhost
UID = SYSDBA
PWD = SYSDBA
TCP_PORT = 5236 

–7.配置odbcinst.ini

[DM8 ODBC DRIVER]
Description = ODBC DRIVER FOR DM8
DRIVER = /dm8/bin/libdodbc.so
Setup = /lib/libdmOdbcSetup.so
threading = 0 

–8.测试ODBC

su - dmdba 
isql dm8
添加环境变量：
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
[dmdba@CentOS7-01 ~]$ source .bash_profile

2.配置数据对比工具
源端AGENT配置agent.xml
cd /home/dmdba/dmhs/bin/

<?xml version="1.0" encoding="utf-8"?>
<agent>
      <port>5347</port>
        <lang>ch</lang>
        <max_session>50</max_session>
        <mode>0</mode>
        <lock_nowait>1</lock_nowait>
        <pwd_encipher>0</pwd_encipher>
        <dyn_wait_time>100</dyn_wait_time>
<database>
           <server>192.168.65.185</server>
           <uid>SYSDBA</uid>
           <psw>SYSDBA</psw>
           <port>5236</port>
           <type>DM8</type>
           <char_code>PG_GB18030</char_code>
</database>
</agent>

目的端AGENT配置agent.xml
cd /home/dmdba/dmhs/bin
vim agent.xml

<?xml version="1.0" encoding="utf-8"?>

<agent>
        <port>5347</port>
      <lang>ch</lang>
        <max_session>50</max_session>
        <mode>0</mode>
        <lock_nowait>1</lock_nowait>
        <pwd_encipher>0</pwd_encipher>
        <dyn_wait_time>100</dyn_wait_time>
<database>
           <server>192.168.65.187</server>
           <uid>SYSDBA</uid>
           <psw>SYSDBA</psw>
           <port>5236</port>
           <type>DM8</type>
           <char_code>PG_GB18030</char_code>
</database>
</agent>

配置源端veri对比文件:
[dmdba@localhost bin]$ cat veri.xml

<?xml version="1.0" encoding="utf-8"?>
<veri>
        <lang>ch</lang> <!-- language: en or ch -->
       <max_thr>40</max_thr>
        <max_obj_thr>1</max_obj_thr>
        <retry_times>0</retry_times>
        <gen_html>0</gen_html>
        <max_out_sync>100000</max_out_sync>
        <pwd_encipher>0</pwd_encipher>
        <col_opt>0</col_opt>
        <log_mode>0</log_mode>
        <sort_buf_size>1024</sort_buf_size>
        <report_mode>0</report_mode>
        <dmhs> <!-- dmhs_server for destination -->
                <server_name>192.168.65.187</server_name>
                <port>5345</port>
                <site_id>3</site_id>  
        </dmhs>
        <src>
                <agent_server>192.168.65.185</agent_server>
                <port>5347</port>
                <db_type>DM8</db_type>
                <odbc_str>
                        <db_server>192.168.65.185</db_server>
                        <db_user>SYSDBA</db_user>
                        <db_pwd>SYSDBA</db_pwd>
                </odbc_str>
        </src>
        <dest>
               <agent_server>192.168.65.187</agent_server>
               <port>5347</port>
               <db_type>DM8</db_type>
               <odbc_str>
                       </dest>
</veri>

源端作业配置：
[dmdba@localhost bin]$ cat j1.xml

<?xml version="1.0" encoding="GB2312" ?>
<job>
        <name>j1</name>
        <table_list>
          <table_info>
           <table_name>SYSDBA.TEST2==SYSDBA.TEST2</table_name>
         <col_map_flag>0</col_map_flag>
         <tab_cmp_flag>0</tab_cmp_flag>
        <row_partition_src>
                <![CDATA[ "C1"  < 1000]]>
        </row_partition_src>
        <row_partition_dest>
                <![CDATA[ "C1"  < 1000]]>
        </row_partition_dest>
                  <key_list> 
                        <col>C1==C1</col>
                  </key_list>
                  <col_list>
                        <col>C1==C1</col>
                        <col>C2==C2</col>
                  </col_list>
          </table_info>
    </table_list>
</job>

检查依赖:
[dmdba@localhost bin]$ ldd dmhs_veri
[dmdba@localhost bin]$ ls -l /usr/local/lib/libodbc.so.2 #没有这个包的话做个软连接
[dmdba@localhost bin]$ln -s /usr/local/lib/libodbc.so /usr/local/lib/libodbc.so.2

启动源端agent：

[dmdba@localhost bin]$ ./dmhs_veri_agent_dm8

启动目的端agent:

[dmdba@localhost bin]$ ./dmhs_veri_agent_dm8

启动源端的对比文件：

[dmdba@CentOS7-01 bin]$ ./dmhs_veri "TABLE=(SYSDBA.TEST2==SYSDBA.TEST2)" mode=normal

对比文件生成在bin目录下report目录