Replication methods doubts (one more time)
We want dispose a High available system to prevent system failures (uncontroled Informix, System or mass storage go down). The way to do this that we know is the replication (HDR or ER), but the replication have some limitations over blobspaces, sbspaces and user defined data types. How we can replicate a system without this limitations? Triggers are'nt allowed because some tables have tiggers to do some thing. Some dabalades use UDT and need sbspaces. Unload and load the databases aren't allowed (our database inst bigger but have arround 15Gb of data and haven't 15Gb of free disk and involve tables with more 6, 7, 8 milion of rows) Environment: Sparc + Solaris 2.6 IIF 9.21.UC1 Java UDRs Web Datablade Thanks in advance. PS Sorry for my poor english --------------------------------------- Isidre PONS ROCA BASE - Gesti' d'Ingressos Locals (Diputacio de Tarragona) Servei de Sistemes d'Informacio Av President Lluis Companys 12-C 43005 - Tarragona SPAIN Tel # +34 977 236731 Fax # +34 977 227302 http://www.altanet.org ipons@dtgna.altanet.org ---------------------------------------
Enterprise Replication will support the replication of UDTs and smartblobs in 9.3. This should be going into beta shortly after the first of the year. Isidre PONS ROCA wrote: > We want dispose a High available system to prevent system failures (uncontroled Informix, System or mass storage > go down). > The way to do this that we know is the replication (HDR or ER), but the replication have some limitations over > blobspaces, sbspaces and user defined data types. > > How we can replicate a system without this limitations? Triggers are'nt allowed because some tables have tiggers > to do some thing. Some dabalades use UDT and need sbspaces. Unload and load the databases aren't allowed (our > database inst bigger but have arround 15Gb of data and haven't 15Gb of free disk and involve tables with more 6, 7, > 8 milion of rows) > > Environment: > Sparc + Solaris 2.6 > IIF 9.21.UC1 > Java UDRs > Web Datablade > > > Thanks in advance. > > PS Sorry for my poor english > > --------------------------------------- > Isidre PONS ROCA > BASE - Gestió d'Ingressos Locals > (Diputacio de Tarragona) > Servei de Sistemes d'Informacio > Av President Lluis Companys 12-C > 43005 - Tarragona > SPAIN > Tel # +34 977 236731 > Fax # +34 977 227302 > http://www.altanet.org > ipons@dtgna.altanet.org > --------------------------------------- -- Madison Pruet =========================================== Enterprise Replication Product Developement Dallas, Texas Informix Software ===========================================
You can also use sun's HA solution. In article <8udtfb$6cf$1@news.xmission.com>, "Isidre PONS ROCA" <ipons@dtgna.altanet.org> wrote: > > > We want dispose a High available system to prevent system failures (uncontroled Informix, System or mass storage > go down). > The way to do this that we know is the replication (HDR or ER), but the replication have some limitations over > blobspaces, sbspaces and user defined data types. > > How we can replicate a system without this limitations? Triggers are'nt allowed because some tables have tiggers > to do some thing. Some dabalades use UDT and need sbspaces. Unload and load the databases aren't allowed (our > database inst bigger but have arround 15Gb of data and haven't 15Gb of free disk and involve tables with more 6, 7, > 8 milion of rows) > > Environment: > Sparc + Solaris 2.6 > IIF 9.21.UC1 > Java UDRs > Web Datablade > > Thanks in advance. > > PS Sorry for my poor english > > --------------------------------------- > Isidre PONS ROCA > BASE - GestiधIngressos Locals > (Diputacio de Tarragona) > Servei de Sistemes d'Informacio > Av President Lluis Companys 12-C > 43005 - Tarragona > SPAIN > Tel # +34 977 236731 > Fax # +34 977 227302 > http://www.altanet.org > ipons@dtgna.altanet.org > --------------------------------------- > Sent via Deja.com http://www.deja.com/ Before you buy.