ER send and receive queues in rootdbs 
Author Message
 ER send and receive queues in rootdbs

We have 4 servers participating in ER replication. The first or
primary server was defined with the following cdr statement:

cdr def ser -c csp1grp -s onlinedata1 -r onlinedata1 \
-A /tmp -R /tmp -I csp1grp

The other servers where defined per Informix support using the
following cdr statement(s):

cdr def ser -c csp2grp -I -S csp1grp csp2grp
cdr def ser -c csp3grp -I -S csp1grp csp3grp
cdr def ser -c csp4grp -I -S csp1grp csp4grp

I came to realize recently that ER created the send and receive queues
in the root dbsapce for all of the 'other servers'. On one of the
servers we have a root dbspace filled up. This was discovered using
oncheck -pe!

How can I fix this situation without dropping and re-installing ER. I
have been there too many times. Incidentally this situation also
applies to on of our clients, a 24x7 operation running ER.

1. Can I stop ER on one of the participating servers, one at a time.
The application will not be targeted to this server at this time.

1.1. Use cdr mod ser to modify the dbspace for the receive queue. What
about the send queue? the manual does not mention the send queue?

1.2 How do I free up the root dbspace after these modifications?.

Thanks

Johann van der Schyff



Tue, 22 Jun 2004 02:34:17 GMT
 ER send and receive queues in rootdbs

Are you working with Jon Adam of tech support?  I sent him an email
earlier today on this issue.


Quote:
> We have 4 servers participating in ER replication. The first or
> primary server was defined with the following cdr statement:

> cdr def ser -c csp1grp -s onlinedata1 -r onlinedata1 \
> -A /tmp -R /tmp -I csp1grp

> The other servers where defined per Informix support using the
> following cdr statement(s):

> cdr def ser -c csp2grp -I -S csp1grp csp2grp
> cdr def ser -c csp3grp -I -S csp1grp csp3grp
> cdr def ser -c csp4grp -I -S csp1grp csp4grp

> I came to realize recently that ER created the send and receive queues
> in the root dbsapce for all of the 'other servers'. On one of the
> servers we have a root dbspace filled up. This was discovered using
> oncheck -pe!

> How can I fix this situation without dropping and re-installing ER. I
> have been there too many times. Incidentally this situation also
> applies to on of our clients, a 24x7 operation running ER.

> 1. Can I stop ER on one of the participating servers, one at a time.
> The application will not be targeted to this server at this time.

> 1.1. Use cdr mod ser to modify the dbspace for the receive queue. What
> about the send queue? the manual does not mention the send queue?

> 1.2 How do I free up the root dbspace after these modifications?.

> Thanks

> Johann van der Schyff

--
---------------------------------------------------------
Madison Pruet
Enterprise Replication Product Development
IBM Informix Dynamic Server


Tue, 22 Jun 2004 07:02:41 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ER send and receive queues

2. ER: send queue grows

3. Replication: Flushing Receive Queue

4. Receiving Messages sent though SQL Enterprise Manager

5. how to find how, how much data is send and received by sql-server

6. Can you use SQL to receive emails and send automated reply emails

7. SQLmail queues, but doesn't send (NT4S-SP5 (PDC), SQL65-SP5, Messaging, NTOP/IIS4 (ger))

8. How to send/receive records from Excel97 using VBA 5.x

9. How to measure bytes received and send by SQL Server

10. Cant send/receive information through the ODBC drivers

11. How VB receive message send by trigger ?

12. receive and send data by the parallel port(centronics)


 
Powered by phpBB® Forum Software