Informatica PowerExchange 9.5.1 for DB2 UDB 安装和使用手册

Informatica PowerExchange 9.5.1 for DB2 UDB 安装和使用手册

Informatica PowerExchange 9.5.1 for DB2

安装和使用手册

2014-01-23

杨晓东 QQ: 734471791

Informatica PowerExchange 9.5.1 for DB2 UDB 安装和使用手册

目录

致读者 ....................................................................................................................................................................... 4 本手册涉及的软件和配置说明 ............................................................................................................................... 5 DB2 Server安装和配置 ........................................................................................................................................... 6

DB2环境要求 ................................................................................................................................................... 6 检测是DB2是否已经打开归档 ...................................................................................................................... 6

未打开的状态 ........................................................................................................................................... 7 打开的状态 ............................................................................................................................................... 8 设置DB2为归档模式(2种方式) .................................................................................................................... 8

命令行 ....................................................................................................................................................... 8 图形化 ....................................................................................................................................................... 9 创建Capture Catalog表 ................................................................................................................................. 18 初始化Capture Catalog表 ............................................................................................................................. 19 创建CDCDEMO源表 ................................................................................................................................... 19 启动CDCDEMO源表的CDC Change(2种方式) ....................................................................................... 20

命令行 ..................................................................................................................................................... 20 图形化 ..................................................................................................................................................... 20

PWX Server安装配置 ............................................................................................................................................ 21

安装PWX Listener ......................................................................................................................................... 21 配置dbmover.cfg文件 ................................................................................................................................... 21 启动PWX Listener ......................................................................................................................................... 22 测试PWX连通性 ............................................................................................................................................. 22 PWX Client端安装配置 ......................................................................................................................................... 23

安装PWX Client 和配置Dbmover.cfg文件 ............................................................................................... 23 配置Dbmover.cfg .......................................................................................................................................... 23 测试PWX连通性 ............................................................................................................................................. 23 PWX Navigator中注册CDC表 ............................................................................................................................ 24 PWX/PWC CDC RT模式任务设置 ....................................................................................................................... 29

导入源表结构 ................................................................................................................................................. 29 创建Mapping .................................................................................................................................................. 30 创建PWX DB2LUW CDC Real Time类型的Application 连接 ................................................................. 31 创建Workflow，并配置Session属性 .......................................................................................................... 32 执行Workflow，并验证CDC数据的同步结果 .......................................................................................... 33 PWX/PWC CDC Continuous RT模式任务设置 ................................................................................................... 34

Mapping设计 .................................................................................................................................................. 34 配置dbmover.cfg 文件 .................................................................................................................................. 34 配置pwxccl.cfg 文件 .................................. …… 此处隐藏：8350字，全部文档内容请下载后查看。喜欢就下载吧 ……