Thank you guys for reply and details, I know this can't be done through Data Guard so I'm looking for another way and wanted to know your ideas about Oracle Golden Gate or any other solution if you've implemented. Our customer is not going to migrate his production DB's from x86_64 machines and have a Mainframe with z/VM, RHEL and Oracle so they thought they can use it as a Backup/replicat Machine...
Bests, --Mehdi On 2 May 2013 22:22, Alan Altmark <[email protected]> wrote: > On Thursday, 05/02/2013 at 11:29 EDT, Rob van der Heij <[email protected]> > wrote: > > Having the database swap the bytes on the fly for everything would be > > pretty expensive, and probably best done on database load only. And I > would > > assume similar issues for floating point numbers that are kept in > machine > > format (like when you go from DB2 on z/OS to DB2 on zLinux). > > > > Another area potentially is code page for character data. While the > > database may be able to translate the retrieved data based on table code > > page and application needs, I recall that we made some CPU usage > > improvements by doing that at the database load and keeping the tables > in > > the native code page. > > Contact the db vendor. They may have generic utilities that can convert > strings and binary values. > > Alan Altmark > > Senior Managing z/VM and Linux Consultant > IBM System Lab Services and Training > ibm.com/systems/services/labservices > office: 607.429.3323 > mobile; 607.321.7556 > [email protected] > IBM Endicott > > ---------------------------------------------------------------------- > For LINUX-390 subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO LINUX-390 or > visit > http://www.marist.edu/htbin/wlvindex?LINUX-390 > ---------------------------------------------------------------------- > For more information on Linux on System z, visit > http://wiki.linuxvm.org/ > ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/
