Informix

 View Only
Expand all | Collapse all

CDR_DBSPACE setup on existing ER environment

  • 1.  CDR_DBSPACE setup on existing ER environment

    Posted Fri April 15, 2022 03:43 AM
    Hi, all.
    I already have a running ER without CDR_DBSPACE set.
    As per the documentation and technotes, the only way to set CDR_DBSPACE is setting it to desired dbspace, restart the engine, and create all the data replication definitions.
    My actual environment is very large so I want to avoid the large process of replicates definitons.
    Would it be possible to workaround this exporting the syscdr and importing it, just stopping and starting ER in between? Somebody already did this way?

    Thanks a lot, happy Easter!!!


    ------------------------------
    Alexandre Marini
    ------------------------------


  • 2.  RE: CDR_DBSPACE setup on existing ER environment

    Posted Fri April 15, 2022 10:22 AM

    Not tried that approach but cdr list catalog –a to file, drop syscdr, and use the catalog to rebuild will/did/should work. But that will not avoid the rebuilds

     

    Cheers

    Paul