Re: Timeseries and ER
Posted in 2006
Topics: High Availability & Replication, Data Types & Schema Design
Ian Michael Gumby wrote: > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > news:44eb4f41$0$12165$afc38c87@... > >>Anyone know for certain whether Enterprise Replication supports Timeseries >>Datablade tables (assuming no non-supported column types in either the >>base table or the timeseries columns)? >> >>Art S. Kagel > > I know that prior to 10, they were not supported. > I doubt that support was added in 10. > > If you're using Financial Foundation (TS,NAG, RTL), then you'll want to tee > the feed to both servers that's running the RTL. > > (Sorry making the assumption that you're using FF.) G, thanks. No using FF. Designing a new custom app/DB and TD looks ideal to save storage and speed processing. Requirements include replication at least 2-way later maybe 4-way. I know that 9.xx does not replicate UDTs, but I thought that 10.00 now supports UDTs in ER, so thought I'd ask. Art S. Kagel
Art S. Kagel wrote: > Ian Michael Gumby wrote: > > "Art S. Kagel" <kagel@bloomberg.net> wrote in message > > news:44eb4f41$0$12165$afc38c87@... > > > >>Anyone know for certain whether Enterprise Replication supports Timeseries > >>Datablade tables (assuming no non-supported column types in either the > >>base table or the timeseries columns)? > >> > >>Art S. Kagel > > > > I know that prior to 10, they were not supported. > > I doubt that support was added in 10. > > > > If you're using Financial Foundation (TS,NAG, RTL), then you'll want to tee > > the feed to both servers that's running the RTL. > > > > (Sorry making the assumption that you're using FF.) > > G, thanks. No using FF. Designing a new custom app/DB and TD looks ideal > to save storage and speed processing. Requirements include replication at > least 2-way later maybe 4-way. I know that 9.xx does not replicate UDTs, > but I thought that 10.00 now supports UDTs in ER, so thought I'd ask. Timeseries is a bit oddball and doesn't have the callback routines which are required to support ER. > > Art S. Kagel
mpruet@comcast.net wrote: > Art S. Kagel wrote: > >>Ian Michael Gumby wrote: >> >>>"Art S. Kagel" <kagel@bloomberg.net> wrote in message >>>news:44eb4f41$0$12165$afc38c87@... >>> >>> >>>>Anyone know for certain whether Enterprise Replication supports Timeseries >>>>Datablade tables (assuming no non-supported column types in either the >>>>base table or the timeseries columns)? >>>> >>>>Art S. Kagel >>> >>>I know that prior to 10, they were not supported. >>>I doubt that support was added in 10. >>> >>>If you're using Financial Foundation (TS,NAG, RTL), then you'll want to tee >>>the feed to both servers that's running the RTL. >>> >>>(Sorry making the assumption that you're using FF.) >> >>G, thanks. No using FF. Designing a new custom app/DB and TD looks ideal >>to save storage and speed processing. Requirements include replication at >>least 2-way later maybe 4-way. I know that 9.xx does not replicate UDTs, >>but I thought that 10.00 now supports UDTs in ER, so thought I'd ask. > > > Timeseries is a bit oddball and doesn't have the callback routines > which are required to support ER. I'll write 'em! Madison? Jerry? What are we talking about a week's worth of work? Art S. Kagel
Not having Timeseries and ER is becoming a sales stopper for us Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 Web: www.oninit.com GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 European Conference. Vienna, Austria. 2-6 October 2006 Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Art S. Kagel [mailto:kagel@bloomberg.net] > Posted At: 29 August 2006 17:29 > Posted To: comp.databases.informix > Conversation: Timeseries and ER > Subject: Re: Timeseries and ER > > > mpruet@comcast.net wrote: > > Art S. Kagel wrote: > > > >>Ian Michael Gumby wrote: > >> > >>>"Art S. Kagel" <kagel@bloomberg.net> wrote in message > >>>news:44eb4f41$0$12165$afc38c87@... > >>> > >>> > >>>>Anyone know for certain whether Enterprise Replication supports > >>>>Timeseries Datablade tables (assuming no non-supported > column types > >>>>in either the base table or the timeseries columns)? > >>>> > >>>>Art S. Kagel > >>> > >>>I know that prior to 10, they were not supported. > >>>I doubt that support was added in 10. > >>> > >>>If you're using Financial Foundation (TS,NAG, RTL), then > you'll want > >>>to tee the feed to both servers that's running the RTL. > >>> > >>>(Sorry making the assumption that you're using FF.) > >> > >>G, thanks. No using FF. Designing a new custom app/DB and > TD looks > >>ideal to save storage and speed processing. Requirements include > >>replication at least 2-way later maybe 4-way. I know that > 9.xx does > >>not replicate UDTs, but I thought that 10.00 now supports > UDTs in ER, so thought I'd ask. > > > > > > Timeseries is a bit oddball and doesn't have the callback routines > > which are required to support ER. > > I'll write 'em! Madison? Jerry? What are we talking about > a week's worth of work? > > Art S. Kagel