DB2 SQL复制知识点

密码文件的创建
asnpwd INIT ENCRYPT PASSWORD using "C:\mq\dprop\asnpwd.aut"
asnpwd ADD ALIAS SOURCE ID suserid PASSWORD suserpwd using "C:\mq\dprop\asnpwd.aut"
asnpwd ADD ALIAS TARGET ID tuserid PASSWORD tuserpwd using "C:\mq\dprop\asnpwd.aut"
asnpwd LIST using "C:\mq\dprop\asnpwd.aut"

capture和apply启停
start capture
set db2codepage=1208
asncap CAPTURE_SERVER=GSDB CAPTURE_SCHEMA=ASN CAPTURE_PATH=C:\mq\dprop\cap startmode=COLD
Start Apply
asnapply CONTROL_SERVER=SAMPLE APPLY_QUAL=aq00 APPLY_PATH=C:\mq\dprop\app
Stop Capture
asnccmd CAPTURE_SERVER=GSDB CAPTURE_SCHEMA=ASN STOP
Stop Apply
asnacmd CONTROL_SERVER=SAMPLE APPLY_QUAL=aq00 STOP

比较两个数据库同一个表的数据
asntdiff db=SAMPLE where="target_table = 'CTMTCAP' and apply_qual = 'AQ00' and set_name = 'SET00'"
让Target表的数据和Source表的数据一致
asntrep DB=SAMPLE SCHEMA=ASN where="target_table = 'CTMTCAP' and apply_qual = 'AQ00' and set_name = 'SET00'"
查看复制状态
asnacmd apply_qual=AQ00 control_server=SAMPLE status



请使用浏览器的分享功能分享到微信等