On Thursday, 05/02/2013 at 11:29 EDT, Rob van der Heij <rvdh...@gmail.com> 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 alan_altm...@us.ibm.com IBM Endicott ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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/