当前位置：网站首页>IBM Q复制ALTER ADD COLUMN

IBM Q复制ALTER ADD COLUMN

2022-08-04 11:23:00 【51CTO】

1.在源端和目标端都同时更改表结构

       
       [[email protected] scripts]$ db2 "describe  table t1"
       
                                Data type                     Column
       
Column name                     schema    Data type name      Length     Scale Nulls
       
------------------------------- --------- ------------------- ---------- ----- ------
       
ID                              SYSIBM    INTEGER                      4     0 Yes   
       
NAME                            SYSIBM    VARCHAR                     10     0 Yes   
       
  2 record(s) selected.
       
[[email protected] scripts]$ db2 "ALTER TABLE DB2INST1.T1 ADD  COLUMN SEX VARCHAR(10)"
       
DB20000I  The SQL command completed successfully.
       
[[email protected] scripts]$ db2 "describe  table t1"
       
                                Data type                     Column
       
Column name                     schema    Data type name      Length     Scale Nulls
       
------------------------------- --------- ------------------- ---------- ----- ------
       
ID                              SYSIBM    INTEGER                      4     0 Yes   
       
NAME                            SYSIBM    VARCHAR                     10     0 Yes   
       
SEX                             SYSIBM    VARCHAR                     10     0 Yes   
       
  3 record(s) selected.
       
[[email protected] ~]$ db2 "ALTER TABLE DB2INST1.T1 ADD  COLUMN SEX VARCHAR(10)"
       
DB20000I  The SQL command completed successfully.
       
[[email protected] ~]$ db2 "describe  table t1"
       
                                Data type                     Column
       
Column name                     schema    Data type name      Length     Scale Nulls
       
------------------------------- --------- ------------------- ---------- ----- ------
       
ID                              SYSIBM    INTEGER                      4     0 Yes   
       
NAME                            SYSIBM    VARCHAR                     10     0 Yes   
       
SEX                             SYSIBM    VARCHAR                     10     0 Yes   
       
  3 record(s) selected.
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.

2.Asnclp命令行中操作alter add column

       
       [[email protected] ~]$ asnclp 
       
ASNCLP SESSION SET TO Q REPLICATION
       
SET SERVER CAPTURE TO DBALIAS DB110 ID db2inst1 PASSWORD "wwwwww"
       
SET SERVER TARGET  TO DBALIAS DB111 ID db2inst1 PASSWORD "wwwwww"
       
SET RUN SCRIPT NOW STOP ON SQL ERROR ON
       
ALTER ADD COLUMN USING SIGNAL (SEX) QSUB SUB0001 USING REPQMAP SAMPLE_ASN_TO_TARGETDB_ASN
      
1.
2.
3.
4.
5.
6.

3.在源端插入数据

       
       [[email protected] ~]$ db2 "insert into t1 values (333,'b','Man')"
       
DB20000I  The SQL command completed successfully.
      
1.
2.

4.目标端查看数据

       
       [[email protected] ~]$ db2 "select * from t1"
       
ID          NAME       SEX       
       
----------- ---------- ----------
       
          1 a          -         
       
          1 a          -         
       
        222 b          -         
       
        333 b          Man       
       
  4 record(s) selected.
      
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.

5.总结(针对已有运行中的QSUB，表增加字段的变更)
不需要停止capture/apply守护进程；
不需要停止该表映射的预订服务；
规划步骤如下：
源表/目标表直接增加字段
asnclp命令，执行alter add column操作即可

QREP

原网站

版权声明
本文为[51CTO]所创，转载请带上原文链接，感谢
https://blog.51cto.com/u_15735145/5543089

当前位置：网站首页>IBM Q复制ALTER ADD COLUMN

IBM Q复制ALTER ADD COLUMN

边栏推荐

猜你喜欢

随机推荐