IBM Q复制ALTER ADD COLUMN

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

[db2inst1@node01 scripts]$ db2 "describe table t1" Data type ColumnColumn 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 ColumnColumn 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 ColumnColumn 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

[db2inst1@node01 ~]$ asnclp ASNCLP SESSION SET TO Q REPLICATIONSET SERVER CAPTURE TO DBALIAS DB110 ID db2inst1 PASSWORD "SERVER TARGET TO DBALIAS DB111 ID db2inst1 PASSWORD "RUN SCRIPT NOW STOP ON SQL ERROR ONALTER ADD COLUMN USING SIGNAL (SEX) QSUB SUB0001 USING REPQMAP SAMPLE_ASN_TO_TARGETDB_ASN

3.在源端插入数据

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

4.目标端查看数据

[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操作即可

QREP

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。