IDS Upgrade with Enterprise Replication

I had an issue while upgrading IDS 10.00.FC8 to IDS 11.50.FC6 running on AIX 5.3 TL11. I have two servers that participate in ER and I was upgrading just one side, which at the tiem had the app pointed completely away from it. I followed the migration guide, ran cdr stop, brought the engine down, brought the engine up, engine converted successfully, then ran the concdr.sh 10.00 11.50 script and got the 'syscdr conversion completed successfully message' and then ran cdr start, which returned with no errors. I ran the onstat -g ddr and it said it was running fine but when I ran a cdr list server, I kept getting a message stating that the specified table (syscdrrepl) is not in the database. This table is in the sysmaster database, not the syscdr, so I am confused ... is there possibly something else that I forgot? I ended up doing a cdr del serv and blowing it away and rebuilding it and resynching it, since I script it out nightly. Joe Plugge

There is a script which is run when ER is added to the system. - $INFORMIXDIR/etc/syscdrview.sql - Aparently when the server did the conversion, the sysmaster database was rebuilt, but the syscdrview.sql = did not get applied. = From: "Plugge, Joe R." <JRPlugge@west.com> = = To: ids@iiug.org = = Date: 06/04/2010 10:33 AM = = Subject: IDS Upgrade with Enterprise Replication [20293] = = Sent by: ids-bounces@iiug.org = = I had an issue while upgrading IDS 10.00.FC8 to IDS 11.50.FC6 running o= n AIX 5.3 TL11. I have two servers that participate in ER and I was upgrading= just one side, which at the tiem had the app pointed completely away from it= . I followed the migration guide, ran cdr stop, brought the engine down, brought the engine up, engine converted successfully, then ran the concdr.sh 10= .00 11.50 script and got the 'syscdr conversion completed successfully mess= age' and then ran cdr start, which returned with no errors. I ran the onstat= -g ddr and it said it was running fine but when I ran a cdr list server, I kep= t getting a message stating that the specified table (syscdrrepl) is not = in the database. This table is in the sysmaster database, not the syscdr, so I= am confused ... is there possibly something else that I forgot? I ended up doing a cdr del serv and blowing it away and rebuilding it a= nd resynching it, since I script it out nightly. Joe Plugge ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =

Thanks Madison. I will run that one manually next time right before I run cdr start -----Original Message----- From: ids-bounces@iiug.org [mailto:ids-bounces@iiug.org] On Behalf Of Madison Pruet Sent: Friday, June 04, 2010 10:46 AM To: ids@iiug.org Subject: Re: IDS Upgrade with Enterprise Replication [20294] There is a script which is run when ER is added to the system. - $INFORMIXDIR/etc/syscdrview.sql - Aparently when the server did the conversion, the sysmaster database was rebuilt, but the syscdrview.sql = did not get applied. = From: "Plugge, Joe R." <JRPlugge@west.com> = = To: ids@iiug.org = = Date: 06/04/2010 10:33 AM = = Subject: IDS Upgrade with Enterprise Replication [20293] = = Sent by: ids-bounces@iiug.org = = I had an issue while upgrading IDS 10.00.FC8 to IDS 11.50.FC6 running o= n AIX 5.3 TL11. I have two servers that participate in ER and I was upgrading= just one side, which at the tiem had the app pointed completely away from it= .. I followed the migration guide, ran cdr stop, brought the engine down, brought the engine up, engine converted successfully, then ran the concdr.sh 10= ..00 11.50 script and got the 'syscdr conversion completed successfully mess= age' and then ran cdr start, which returned with no errors. I ran the onstat= -g ddr and it said it was running fine but when I ran a cdr list server, I kep= t getting a message stating that the specified table (syscdrrepl) is not = in the database. This table is in the sysmaster database, not the syscdr, so I= am confused ... is there possibly something else that I forgot? I ended up doing a cdr del serv and blowing it away and rebuilding it a= nd resynching it, since I script it out nightly. Joe Plugge ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. = ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.