Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / Informix Topics / November 2005

Tip: Looking for answers? Try searching our database.

syscdr not dropped - ER

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
hariog@yahoo.com - 30 Nov 2005 07:03 GMT
Hi All,

IDS 10.00.UC3
ELAS3.0

In one of the test instance, I setup ER which involves setting up
servers on primary & secondary, setup database with no rows in tables
on secondary, defined replicates, started replicates,  suspended
primary server so that data can be unloaded from those table which have
been defined for replication. For some reason, I need to rebuild ER
again in this test env., so on primary and then on secondary server, I
deleted the servers. Secondary, syscdr has been dropped successfully
but on primary syscdr still exist. Online log shows:

CDR GC: operation catalog purge (drop) failed (error -425).
CDR shutdown failed

I tried again to delete server on primary but got message as "Command
failed - ER not active (62).

I am pretty sure if I try to define server again I will get "command
failed - fatal server error 100

I am hoping sysmaster database has got some pointer back to syscdr. In
normal situation
syscdr get dropped by itself when we delete server but may be server
was in suspend mode and  there were some transaction in the queue (for
sure) or some thing else has gone wrong.

Can some one pl. advise how to drop syscdr cleanly without rebuilding
sysmaster ?

If rebuilding sysmaster is the only way, will I loose any thing for the
other databases under that instance ?

TIA
Hari
hariog@yahoo.com - 30 Nov 2005 07:11 GMT
Sorry about the post. I restarted the instance and did notice that
syscdr database has gone now.

Thanks again.
Madison Pruet - 30 Nov 2005 17:55 GMT
> Sorry about the post. I restarted the instance and did notice that
> syscdr database has gone now.
>
> Thanks again.

Whew  ;-)
tarod35 - 30 Nov 2005 13:03 GMT
Drop the smartblob and create anything.

> Hi All,
>
[quoted text clipped - 33 lines]
> TIA
> Hari
tarod35 - 30 Nov 2005 13:04 GMT
drop the smartblob and create anything.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.