密码文件的创建
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
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
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/725820/viewspace-1873449/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/725820/viewspace-1873449/