关于复制DB2 UDB [英] Regarding Replication 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屋!