关于复制DB2 UDB [英] Regarding Replication DB2 UDB

查看:93
本文介绍了关于复制DB2 UDB的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我已经看到检查状态然后显示如下:


线程类型状态

HoldL休息

管理员线程休息

工作线程休息


现在我怎么能再次激活它们?


Knut Stolze写道:

i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?

Knut Stolze wrote:


sat写道:
sat wrote:

嗨!

我现在见过jus在目标表(TGDEPTCOPY)中它仍然只显示4条记录。我将复制的时间间隔保持为15

分钟。但仍然无效。我甚至没有遇到任何错误。请

让我知道可能是什么问题。
Hi!
I have seen jus now in the target table (TGDEPTCOPY) it''s still
showing only 4 records.I kept the time interval for replication as 15
minutes.But still its not working.I''m not even facing any errors.Please
do let me know what might be the problem.



很难说。你开始捕捉和申请时是否使用了日志?

你真的开始了吗?日志显示什么?什么是

状态在复制中心显示?


-

Knut Stolze

DB2信息集成开发

IBM德国


Hard to tell. Did you use the logs when you started capture and apply?
Have you actually started both? What do the logs show? What does
the "status" in the Replication Center show?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

推荐答案

sat写道:
sat wrote:

i已经看到了支票状态然后显示如下:


线程类型状态

HoldL休息

管理员线程休息

工人线程休息


现在我怎么能再次激活它们?
i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?



这是捕获或申请的状态吗?你有两个开始吗?什么是

你在每个开始时得到的消息?


日志怎么样 - 你在那里找到哪些条目?你开始捕捉和申请时是否使用了日志




-

Knut Stolze

DB2信息集成开发

IBM德国

Is that the status of capture or apply? Have you started both? What was
the message you got upon starting of each?

How about the logs - which entries do you find there? Did you use the logs
when you started capture and apply?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


以下状态适用于申请,首先我自己启动了

捕获并应用程序。然后我所做的就像定义

在ROW FILTER中设置的订阅我只给出了ENO
The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are

> =应该应用E00。之后我插入了2条E22,E23和最近的记录(意味着今天上午),我又添加了一行E25 ...但它们没有被复制。
>= E00 should be applied.And after that i inserted 2 records which are E22 , E23 and recently ( means today morning) i added one more row E25...but they are not being copied.



Knut Stolze写道:


Knut Stolze wrote:


sat写道:
sat wrote:

i已经看到检查状态然后显示如下:


线程类型状态

HoldL休息

管理员线程休息

工作线程休息


现在我该如何再次激活它们?
i have seen the check status then it is showing like :

Type Of Thread Status
HoldL Resting
Admin Thread Resting
Worker Thread Resting

So now how can i activate them again?



这是捕获或申请的状态吗?你有两个开始吗?什么是

你在每个开始时得到的消息?


日志怎么样 - 你在那里找到哪些条目?你开始捕捉和申请时是否使用了日志




-

Knut Stolze

DB2信息集成开发

IBM德国


Is that the status of capture or apply? Have you started both? What was
the message you got upon starting of each?

How about the logs - which entries do you find there? Did you use the logs
when you started capture and apply?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


sat写道:
sat wrote:

以下状态适用于申请,首先我自己启动了

捕获和应用程序。然后我所做的就像定义

订阅在ROW FILTER中设置我只给出ENO,它们是
The status below is for apply and first itself i have started both the
capture and apply programs.And then what i did is like while defining
the subscription set in the ROW FILTER i have given only ENO which are

= E00应该被应用。然后我插入2条记录,即E22
= E00 should be applied.And after that i inserted 2 records which are E22



,E23和最近(意思是今天上午)我又增加了一行E25 ...但是

它们没有被复制。

, E23 and recently ( means today morning) i added one more row E25...but
they are not being copied.



再次,您在日志中看到了什么?


因为您使用行过滤器,如果省略会发生什么过滤器?


-

Knut Stolze

DB2信息集成开发

IBM德国

Again, what do you see in the logs?

Since you are using row filter, what happens if you omit the filter?

--
Knut Stolze
DB2 Information Integration Development
IBM Germany


这篇关于关于复制DB2 UDB的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆