关于accessServer的使用案例（一）_ibm cdc access server chcclp命令-优快云博客

本文链接：https://blog.youkuaiyun.com/qq_41062572/article/details/124451466

这篇博客详细介绍了如何通过命令行工具进行数据库预定的管理。首先展示了关闭预定的步骤，包括设置会话、连接服务器和数据存储器，然后选择并关闭预定。接着，演示了预定的重建过程，涉及到配置可重建、设置变量、添加表映射以及启动镜像。最后，说明了如何打开预定，包括重新连接和启动镜像监控。这些操作对于数据库同步和维护至关重要。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

####################   关闭预定   ######################
$ACCESSSRVER_HOME/bin/chcclp -L zh_CN
# 设置session
Repl >chcclp session set to cdc;
# 设置详细输出
Repl >set verbose;
# 链接服务
Repl > connect server hostname xxx port xxx username xxx password xxx;
# 打开数据存储器链接
Repl >connect datastore name xxx1 context source;
Repl >connect datastore name xxx2 context target;
# 选中预定
Repl >select subscription name xxx_x;
# 关闭预定
Repl >end replication name xxx_x method immediate;
# 断开数据存储器链接
Repl >disconnect datastore name xxx1;
Repl >disconnect datastore name xxx2;
# 断开服务器链接
Repl >disconnect server;

####################   重建预定   ######################
Repl > chcclp session set to cdc;
Repl > set verbose;
# 配置可重建
Repl > set property recreateSubscription yes;
# 设置变量
Repl > set variable name "source_schema" value "PEHAPP";
Repl > set variable name "target_schema" value "PE";
# 打开链接
Repl > connect server hostname 197.0.1.71 port 10101 username jjking password wjjnag;
Repl > connect datastore name DS_PE;
Repl > connect datastore name DS_BRMS;
Repl > select datastore name DS_PE context source;
Repl > select datastore name DS_BRMS context target;
# 操作
Repl > add subscription name PE_BRMS persistency yes;
Repl > lock subscription;
Repl > add table mapping sourceSchema "%source_schema%" sourceTable "T_JRNL_%TIME%" targetSchema "%target_schema%" targetTable "T_JRNL";
Repl > unlock subscription;
# 关闭链接
Repl > disconnect datastore DS_PE;
Repl > disconnect datastore DS_BRMS;
Repl > disconnect server;

###################   打开预定   #######################
Repl > chcclp session set to cdc;
Repl > set verbose;
# 配置可重建
Repl > set property recreateSubscription yes;
# 打开链接
Repl > connect server hostname 197.0.1.71 port 10101 username jjking password wjjnag;
Repl > connect datastore name DS_PE;
Repl > connect datastore name DS_BRMS;
Repl > select datastore name DS_PE context source;
Repl > select datastore name DS_BRMS context target;
# 操作
Repl > select subscription name PE_BRMS;
Repl > start mirroring method continuous;
Repl > monitor replication filter subscription name PE_BRMS;
# 关闭链接
Repl > disconnect datastore DS_PE;
Repl > disconnect datastore DS_BRMS;
Repl > disconnect server;