IBM Q复制ALTER ADD COLUMN-CSDN博客

本文链接：https://blog.csdn.net/hbhe0316/article/details/122701277

1.在源端和目标端都同时更改表结构 https://www.cndba.cn/hbhe0316/article/4867

https://www.cndba.cn/hbhe0316/article/4867

[db2inst1@node01 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.

[db2inst1@node01 scripts]$ db2 "ALTER TABLE DB2INST1.T1 ADD  COLUMN SEX VARCHAR(10)"
DB20000I  The SQL command completed successfully.
[db2inst1@node01 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.

[db2inst1@node02 ~]$ db2 "ALTER TABLE DB2INST1.T1 ADD  COLUMN SEX VARCHAR(10)"
DB20000I  The SQL command completed successfully.
[db2inst1@node02 ~]$ 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.

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

https://www.cndba.cn/hbhe0316/article/4867

[db2inst1@node01 ~]$ 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

3.在源端插入数据https://www.cndba.cn/hbhe0316/article/4867

[db2inst1@node01 ~]$ db2 "insert into t1 values (333,'b','Man')"
DB20000I  The SQL command completed successfully.

4.目标端查看数据https://www.cndba.cn/hbhe0316/article/4867https://www.cndba.cn/hbhe0316/article/4867https://www.cndba.cn/hbhe0316/article/4867https://www.cndba.cn/hbhe0316/article/4867

[db2inst1@node02 ~]$ db2 "select * from t1"

ID          NAME       SEX       
----------- ---------- ----------
          1 a          -         
          1 a          -         
        222 b          -         
        333 b          Man       

  4 record(s) selected.

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

https://www.cndba.cn/hbhe0316/article/4867

QREP