使用 DBCAT 迁移 DB2 LUW 表结构到 OceanBase 数据库

$sudo yum -y install java-1.8.0-openjdk.x86_64

$which java
/usr/local/java/jdk1.8.0_261/bin/java

echo 'export JAVA_HOME=/usr/local/java/jdk1.8.0_261/' >> ~/.bash_profile
. ~/.bash_profile

tar zxvf dbcat-1.8.0-SNAPSHOT.tar.gz
cd dbcat-1.8.0-SNAPSHOT/
chmod +x bin/dbcat

$tree -L 3 --filelimit 30
.
├── bin
│   ├── dbcat
│   ├── dbcat.bat
│   └── dbcat-debug
├── conf
│   ├── dbcat.properties
│   └── logback.xml
├── docs
│   ├── README.docx
│   ├── README.md
│   └── README.txt
├── LEGAL.md
├── lib [45 entries exceeds filelimit, not opening dir]
├── LICENSE
├── meta
│   └── README
└── NOTICE

5 directories, 12 files

bin/dbcat convert -H<host> -P<port> -u<user> -p<******>  -D<database> --schema <schema> --from <from> --to <to> --all

bin/dbcat convert -H xxx.xxx.xxx.xxx -P 50001 -udb2inst2 -p****** --schema TESTDB -DTESTDB --table bmsql_customer --from db2luw115 --to obmysql32x --all

$tree ~/output/dbcat-20xx-xx-xx-164533/
/home/qing.meiq/output/dbcat-20xx-xx-xx-164533/
├── tpccdb
│   └── TABLE-schema.sql
└── tpccdb-conversion.html

1 directory, 2 files

obclient [test]> source TABLE-schema.sql
Query OK, 0 rows affected (0.044 sec)

db2 => describe table  bmsql_customer

                                Data type                     Column
Column name                     schema    Data type name      Length     Scale Nulls
------------------------------- --------- ------------------- ---------- ----- ------
C_W_ID                          SYSIBM    BIGINT                       8     0 No
C_D_ID                          SYSIBM    BIGINT                       8     0 No
C_ID                            SYSIBM    BIGINT                       8     0 No
C_DISCOUNT                      SYSIBM    DECIMAL                      4     4 Yes
C_CREDIT                        SYSIBM    CHARACTER                    2     0 Yes
C_LAST                          SYSIBM    VARCHAR                     16     0 Yes
C_FIRST                         SYSIBM    VARCHAR                     16     0 Yes
C_CREDIT_LIM                    SYSIBM    DECIMAL                     12     2 Yes
C_BALANCE                       SYSIBM    DECIMAL                     12     2 Yes
C_YTD_PAYMENT                   SYSIBM    DECIMAL                     12     2 Yes
C_PAYMENT_CNT                   SYSIBM    INTEGER                      4     0 Yes
C_DELIVERY_CNT                  SYSIBM    INTEGER                      4     0 Yes
C_STREET_1                      SYSIBM    VARCHAR                     20     0 Yes
C_STREET_2                      SYSIBM    VARCHAR                     20     0 Yes
C_CITY                          SYSIBM    VARCHAR                     20     0 Yes
C_STATE                         SYSIBM    CHARACTER                    2     0 Yes
C_ZIP                           SYSIBM    CHARACTER                    9     0 Yes
C_PHONE                         SYSIBM    CHARACTER                   16     0 Yes
C_SINCE                         SYSIBM    TIMESTAMP                   10     6 Yes
C_MIDDLE                        SYSIBM    CHARACTER                    2     0 Yes
C_DATA                          SYSIBM    VARCHAR                    500     0 Yes

  21 record(s) selected.

obclient [test]> desc bmsql_customer;
+----------------+---------------+------+-----+---------+-------+
| Field          | Type          | Null | Key | Default | Extra |
+----------------+---------------+------+-----+---------+-------+
| c_w_id         | bigint(20)    | NO   | PRI | NULL    |       |
| c_d_id         | bigint(20)    | NO   | PRI | NULL    |       |
| c_id           | bigint(20)    | NO   | PRI | NULL    |       |
| c_discount     | decimal(4,4)  | YES  |     | NULL    |       |
| c_credit       | char(2)       | YES  |     | NULL    |       |
| c_last         | varchar(16)   | YES  |     | NULL    |       |
| c_first        | varchar(16)   | YES  |     | NULL    |       |
| c_credit_lim   | decimal(12,2) | YES  |     | NULL    |       |
| c_balance      | decimal(12,2) | YES  |     | NULL    |       |
| c_ytd_payment  | decimal(12,2) | YES  |     | NULL    |       |
| c_payment_cnt  | int(11)       | YES  |     | NULL    |       |
| c_delivery_cnt | int(11)       | YES  |     | NULL    |       |
| c_street_1     | varchar(20)   | YES  |     | NULL    |       |
| c_street_2     | varchar(20)   | YES  |     | NULL    |       |
| c_city         | varchar(20)   | YES  |     | NULL    |       |
| c_state        | char(2)       | YES  |     | NULL    |       |
| c_zip          | char(9)       | YES  |     | NULL    |       |
| c_phone        | char(16)      | YES  |     | NULL    |       |
| c_since        | timestamp     | YES  |     | NULL    |       |
| c_middle       | char(2)       | YES  |     | NULL    |       |
| c_data         | varchar(500)  | YES  |     | NULL    |       |
+----------------+---------------+------+-----+---------+-------+
21 rows in set (0.007 sec)