Informix

Informix

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only

  • 1.  Distributed query on databases with differents DB_LOCALE ...

    Posted 06/10/21 09:03 AM

    Hi,

     

    Actually we can't not mix databases created with differents "DB_LOCALE" (error -23197) ...

    What's the best strategy/advice for working (e.g. : synchronize process, ...) with mixed databases  because we want to create an UTF8 database for "web purpose" with "unicode support" but our other ERP database is ISO-819 ...

     

    T.I.A.

     

    Benjamin Garcia Vallejo

    Responsable Service Informatique

    IT Manager

    Z.I. Grasbësch

    L-3370 Leudelange


    #Informix


  • 2.  RE: Distributed query on databases with differents DB_LOCALE ...

    Posted 06/10/21 09:20 AM
    Benjamin:

    You will have to maintain separate connections to each database and perform any join operations in code space in your applications that need data from both or need to move data from one to the other. That's how dbcopy works so that it can copy data between databases with different locales or different logging modes.

    Art

    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------



  • 3.  RE: Distributed query on databases with differents DB_LOCALE ...

    Posted 06/11/21 05:08 AM
    Hi Benjamin,
    if you just need to transfer data from one database to the other on the fly, you might consider using Loopback Replication (https://www.ibm.com/docs/en/informix-servers/12.10?topic=replication-loopback) with the code set conversion enabled in your replicates (https://www.ibm.com/docs/en/informix-servers/12.10?topic=replicate-enabling-code-set-conversion-between-replicates).
    HTH

    ------------------------------
    -tz-
    TOMAS.ZAHRADNIK@DHL.COM
    ------------------------------



Related Content