kettle数据迁移从DB2到mysql

kettle数据迁移从DB2到mysql

kettle-​​11:48:51 - Carte - Installing timer to purge stale objects after 1440 minutes.2020/07/12 11:57:57 - Spoon - 正在开始任务...2020/07/12 11:57:57 - test1111 - 开始执行任务2020/07/12 11:57:57 - test1111 - 开始项[创建表 [T1]]2020/07/12 11:57:57 - test1111 - 开始项[复制数据到 [T1]]2020/07/12 11:57:58 - 复制数据到 [T1] - Running transformation using the Kettle execution engine2020/07/12 11:57:58 - 复制到_sorcet1_到_target - 为了转换解除补丁开始 [复制到_sorcet1_到_target]2020/07/12 11:57:58 - 写到 [T1].0 - Connected to database [target] (commit=100)2020/07/12 11:58:31 - 从 [T1].0 - linenr 500002020/07/12 11:58:38 - 写到 [T1].0 - linenr 500002020/07/12 11:59:08 - 从 [T1].0 - linenr 1000002020/07/12 11:59:18 - 写到 [T1].0 - linenr 1000002020/07/12 11:59:45 - 从 [T1].0 - linenr 1500002020/07/12 11:59:52 - 写到 [T1].0 - linenr 1500002020/07/12 12:00:22 - 从 [T1].0 - linenr 2000002020/07/12 12:00:29 - 写到 [T1].0 - linenr 2000002020/07/12 12:01:04 - 从 [T1].0 - linenr 2500002020/07/12 12:01:12 - 写到 [T1].0 - linenr 2500002020/07/12 12:01:47 - 从 [T1].0 - linenr 3000002020/07/12 12:01:57 - 写到 [T1].0 - linenr 3000002020/07/12 12:02:43 - 从 [T1].0 - linenr 3500002020/07/12 12:02:55 - 写到 [T1].0 - linenr 3500002020/07/12 12:03:30 - 从 [T1].0 - linenr 4000002020/07/12 12:03:42 - 写到 [T1].0 - linenr 4000002020/07/12 12:04:18 - 从 [T1].0 - linenr 4500002020/07/12 12:04:26 - 写到 [T1].0 - linenr 4500002020/07/12 12:05:05 - 从 [T1].0 - linenr 5000002020/07/12 12:05:11 - 写到 [T1].0 - linenr 5000002020/07/12 12:05:47 - 从 [T1].0 - linenr 5500002020/07/12 12:05:55 - 写到 [T1].0 - linenr 5500002020/07/12 12:06:29 - 从 [T1].0 - linenr 6000002020/07/12 12:06:37 - 写到 [T1].0 - linenr 6000002020/07/12 12:07:15 - 从 [T1].0 - linenr 6500002020/07/12 12:07:24 - 写到 [T1].0 - linenr 6500002020/07/12 12:07:56 - 从 [T1].0 - linenr 7000002020/07/12 12:08:04 - 写到 [T1].0 - linenr 7000002020/07/12 12:08:39 - 从 [T1].0 - linenr 7500002020/07/12 12:08:49 - 写到 [T1].0 - linenr 7500002020/07/12 12:09:27 - 从 [T1].0 - linenr 8000002020/07/12 12:09:34 - 写到 [T1].0 - linenr 8000002020/07/12 12:10:10 - 从 [T1].0 - linenr 8500002020/07/12 12:10:22 - 写到 [T1].0 - linenr 8500002020/07/12 12:10:54 - 从 [T1].0 - linenr 9000002020/07/12 12:11:04 - 写到 [T1].0 - linenr 9000002020/07/12 12:11:36 - 从 [T1].0 - linenr 9500002020/07/12 12:11:46 - 写到 [T1].0 - linenr 9500002020/07/12 12:12:18 - 从 [T1].0 - linenr 10000002020/07/12 12:12:26 - 写到 [T1].0 - linenr 10000002020/07/12 12:13:05 - 从 [T1].0 - linenr 10500002020/07/12 12:13:11 - 写到 [T1].0 - linenr 10500002020/07/12 12:13:56 - 从 [T1].0 - linenr 11000002020/07/12 12:13:59 - 从 [T1].0 - Finished reading query, closing connection.2020/07/12 12:13:59 - 从 [T1].0 - 完成处理 (I=1104758, O=0, R=0, W=1104758, U=0, E=0)2020/07/12 12:14:03 - 写到 [T1].0 - linenr 11000002020/07/12 12:14:08 - 写到 [T1].0 - 完成处理 (I=0, O=1104758, R=1104758, W=1104758, U=0, E=0)2020/07/12 12:14:08 - test1111 - 完成作业项[复制数据到 [T1]] (结果=[true])2020/07/12 12:14:08 - test1111 - 完成作业项[创建表 [T1]] (结果=[true])2020/07/12 12:14:08 - test1111 - 任务执行完毕2020/07/12 12:14:08 - Spoon - 任务已经结束.

测试从DB2到DB2的时间

2020/07/12 13:57:10 - Spoon - 另存为...2020/07/12 13:57:16 - Spoon - Save file as...2020/07/12 13:59:19 - Spoon - 正在开始任务...2020/07/12 13:59:19 - t1 - 开始执行任务2020/07/12 13:59:19 - t1 - 开始项[复制数据到 [T1]]2020/07/12 13:59:19 - 复制数据到 [T1] - Running transformation using the Kettle execution engine2020/07/12 13:59:19 - 复制到_source1t1_到_target1 - 为了转换解除补丁开始 [复制到_source1t1_到_target1]2020/07/12 13:59:19 - 写到 [T1].0 - Connected to database [target1] (commit=100)2020/07/12 13:59:30 - 从 [T1].0 - linenr 500002020/07/12 13:59:33 - 写到 [T1].0 - linenr 500002020/07/12 13:59:44 - 从 [T1].0 - linenr 1000002020/07/12 13:59:46 - 写到 [T1].0 - linenr 1000002020/07/12 13:59:56 - 从 [T1].0 - linenr 1500002020/07/12 13:59:58 - 写到 [T1].0 - linenr 1500002020/07/12 14:00:07 - 从 [T1].0 - linenr 2000002020/07/12 14:00:10 - 写到 [T1].0 - linenr 2000002020/07/12 14:00:19 - 从 [T1].0 - linenr 2500002020/07/12 14:00:21 - 写到 [T1].0 - linenr 2500002020/07/12 14:00:32 - 从 [T1].0 - linenr 3000002020/07/12 14:00:35 - 写到 [T1].0 - linenr 3000002020/07/12 14:00:45 - 从 [T1].0 - linenr 3500002020/07/12 14:00:47 - 写到 [T1].0 - linenr 3500002020/07/12 14:00:59 - 从 [T1].0 - linenr 4000002020/07/12 14:01:01 - 写到 [T1].0 - linenr 4000002020/07/12 14:01:10 - 从 [T1].0 - linenr 4500002020/07/12 14:01:13 - 写到 [T1].0 - linenr 4500002020/07/12 14:01:23 - 从 [T1].0 - linenr 5000002020/07/12 14:01:25 - 写到 [T1].0 - linenr 5000002020/07/12 14:01:35 - 从 [T1].0 - linenr 5500002020/07/12 14:01:38 - 写到 [T1].0 - linenr 5500002020/07/12 14:01:51 - 从 [T1].0 - linenr 6000002020/07/12 14:01:54 - 写到 [T1].0 - linenr 6000002020/07/12 14:02:07 - 从 [T1].0 - linenr 6500002020/07/12 14:02:10 - 写到 [T1].0 - linenr 6500002020/07/12 14:02:21 - 从 [T1].0 - linenr 7000002020/07/12 14:02:23 - 写到 [T1].0 - linenr 7000002020/07/12 14:02:32 - 从 [T1].0 - linenr 7500002020/07/12 14:02:35 - 写到 [T1].0 - linenr 7500002020/07/12 14:02:45 - 从 [T1].0 - linenr 8000002020/07/12 14:02:47 - 写到 [T1].0 - linenr 8000002020/07/12 14:02:58 - 从 [T1].0 - linenr 8500002020/07/12 14:03:00 - 写到 [T1].0 - linenr 8500002020/07/12 14:03:10 - 从 [T1].0 - linenr 9000002020/07/12 14:03:13 - 写到 [T1].0 - linenr 9000002020/07/12 14:03:23 - 从 [T1].0 - linenr 9500002020/07/12 14:03:24 - 写到 [T1].0 - linenr 9500002020/07/12 14:03:37 - 从 [T1].0 - linenr 10000002020/07/12 14:03:40 - 写到 [T1].0 - linenr 10000002020/07/12 14:03:52 - 从 [T1].0 - linenr 10500002020/07/12 14:03:54 - 写到 [T1].0 - linenr 10500002020/07/12 14:04:07 - 从 [T1].0 - linenr 11000002020/07/12 14:04:10 - 写到 [T1].0 - linenr 11000002020/07/12 14:04:22 - 从 [T1].0 - linenr 11500002020/07/12 14:04:25 - 写到 [T1].0 - linenr 11500002020/07/12 14:04:26 - 从 [T1].0 - Finished reading query, closing connection.2020/07/12 14:04:26 - 从 [T1].0 - 完成处理 (I=1162570, O=0, R=0, W=1162570, U=0, E=0)2020/07/12 14:04:29 - 写到 [T1].0 - 完成处理 (I=0, O=1162570, R=1162570, W=1162570, U=0, E=0)2020/07/12 14:04:29 - t1 - 完成作业项[复制数据到 [T1]] (结果=[true])2020/07/12 14:04:29 - t1 - 任务执行完毕2020/07/12 14:04:29 - Spoon - 任务已经结束.

kettle

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