cdr command slow

Posted in 2007

Topics: Versions, Editions & End-of-Life

Heinz Weitkamp — Tue, 06 Feb 2007 18:25:44 +0100 — source: Usenet: comp.databases.informix

Hi all, Environment: IDS 7.31 UD4 SCO 3.2 9 Server with update anywhere. My Problem: The command : "cdr change group -d groupname replname" (to drop a replicate from a group) takes 50-60 sec to complete on definite server. Very, very slow :-( On the other servers with the same numbers of replicates and groups it takes only 1-3 sec to complete. The command: "cdr change group -a groupname replname" needs only 1-2 sec on all servers to complete. Any experiences, comments, hints are very appreciated. (Excuse my poor school english) Heinz

↪ replying to Heinz Weitkamp

Madison Pruet — Tue, 06 Feb 2007 12:17:16 -0600 — source: Usenet: comp.databases.informix

Heinz Weitkamp wrote: > Hi all, > > Environment: > > IDS 7.31 UD4 > SCO 3.2 > > 9 Server with update anywhere. > > My Problem: > > The command : "cdr change group -d groupname replname" (to drop a replicate from a group) > takes 50-60 sec to complete on definite server. Very, very slow :-( The old group was a physical entity. That means that in order to remove a replicate from the group, you have to modify things which are currently in the queue. We replaced the group with the replicate set (replset) in 9.3. The replset is a logical entity and not a physical - and thus can handle these types of changes much quicker. > > On the other servers with the same numbers of replicates and groups it takes only 1-3 sec to complete. > > The command: "cdr change group -a groupname replname" needs only 1-2 sec on all servers to complete. > > Any experiences, comments, hints are very appreciated. > > (Excuse my poor school english) > > Heinz >

↪ replying to Madison Pruet

Heinz Weitkamp — Wed, 07 Feb 2007 10:45:49 +0100 — source: Usenet: comp.databases.informix

Thanks Medison for your quick answer. What do you means with "things which are currently in the queue" Which things ? which queue ? The command always needs 50-60 sec to complete on the server. Why are the other servers not so slow ? How can I recognize the differences between the servers at the time when i start the command. Can i check the queue? or: is there no possibility to speed up to command ? Thanks in advance. Heinz >>> Madison Pruet <mpruet@tx.rr.com> 06.02.2007 19:17 >>> Heinz Weitkamp wrote: > Hi all, > > Environment: > > IDS 7.31 UD4 > SCO 3.2 > > 9 Server with update anywhere. > > My Problem: > > The command : "cdr change group -d groupname replname" (to drop a replicate from a group) > takes 50-60 sec to complete on definite server. Very, very slow :-( The old group was a physical entity. That means that in order to remove a replicate from the group, you have to modify things which are currently in the queue. We replaced the group with the replicate set (replset) in 9.3. The replset is a logical entity and not a physical - and thus can handle these types of changes much quicker. > > On the other servers with the same numbers of replicates and groups it takes only 1-3 sec to complete. > > The command: "cdr change group -a groupname replname" needs only 1-2 sec on all servers to complete. > > Any experiences, comments, hints are very appreciated. > > (Excuse my poor school english) > > Heinz > _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list