• United States
IBM?
  • Site map
IBM?
  • Marketplace

  • Close
    Search
  • Sign in
    • Sign in
    • Register
  • IBM Navigation
IBM Developer Answers
  • Spaces
    • Blockchain
    • IBM Cloud platform
    • Internet of Things
    • Predictive Analytics
    • Watson
    • See all spaces
  • Tags
  • Users
  • Badges
  • FAQ
  • Help
Close

Name

Community

  • Learn
  • Develop
  • Connect

Discover IBM

  • ConnectMarketplace
  • Products
  • Services
  • Industries
  • Careers
  • Partners
  • Support
10.190.13.206

Refine your search by using the following advanced search options.

Criteria Usage
Questions with keyword1 or keyword2 keyword1 keyword2
Questions with a mandatory word, e.g. keyword2 keyword1 +keyword2
Questions excluding a word, e.g. keyword2 keyword1 -keyword2
Questions with keyword(s) and a specific tag keyword1 [tag1]
Questions with keyword(s) and either of two or more specific tags keyword1 [tag1] [tag2]
To search for all posts by a user or all posts with a specific tag, start typing and choose from the suggestion list. Do not use a plus or minus sign with a tag, e.g., +[tag1].
  • Ask a question

Is there data loss/conversion issues when using Db2 move command.

27000707GH gravatar image
Question by dakoroni  (1) | Nov 22, 2018 at 04:17 AM db2luwdata conversion

Hello mates,

We have already an implemented DB2 instance with the following specs: - Database territory: el_GR (AIX) - Database code set: UTF-8 - Database codepage: 1208

Our goal is to migrate data to a destination Db2 instance with the following specs: - Database territory: EL_GR (AIX) - Database code set: UTF-8 - Database codepage: 1208

We would like to know whether data loss or any conversion issue might arise (from el_GR to EL_GR)?

Thanks in advance for your time.

People who like this

  0
Comment
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster

1 reply

  • Sort: 
120000PCKD gravatar image

Answer by DH0 (463) | Nov 22, 2018 at 09:14 AM

I would not expect so - EL_GR is UTF-8 which should encompass all of el_GR. But that is probably best asked of AIX (tag the question for AIX). On the database side of things you are not making any changes - so from Db2's perspective it should all be the same.

(The only time the OS locale should come into play is if you are using, say, the CLP or other clients locally; remote clients should not be affected by this at all.)

HTH.

Comment

People who like this

  0   Show 1   Share
10 |3000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
120000PCKD gravatar image DH0 (463)   Nov 22, 2018 at 09:19 AM 0
Share

https://www.ibm.com/support/knowledgecenter/ssw_aix_71/com.ibm.aix.nlsgdrf/support_languages_locales.htm

Follow this question

151 people are following this question.

Answers

Answers & comments

Related questions

I am receiving the error message sql30081n, how do I resolve this? 1 Answer

Do I need to flush the package cache after I alter a table to make it volatile? 1 Answer

When using circular logging when are the secondary log files freed or re-used? 1 Answer

If I drop my instances will I loose my databases and the data with it? 1 Answer

What type of authentication types does DB2 support? 1 Answer

  • Contact
  • Privacy
  • IBM Developer Terms of use
  • Accessibility
  • Report Abuse
  • Cookie Preferences

Powered by AnswerHub

Authentication check. Please ignore.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • API Connect
  • Analytic Hybrid Cloud Core
  • Application Performance Management
  • Appsecdev
  • BPM
  • Blockchain
  • Business Transaction Intelligence
  • CAPI
  • CAPI SNAP
  • CICS
  • Cloud Analytics
  • Cloud Automation
  • Cloud Object Storage
  • Cloud marketplace
  • Collaboration
  • Content Services (ECM)
  • Continuous Testing
  • Courses
  • Customer Experience Analytics
  • DB2 LUW
  • DataPower
  • Decision Optimization
  • DevOps Services
  • Developers IBM MX
  • Digital Commerce
  • Digital Experience
  • Finance
  • Global Entrepreneur Program
  • Hadoop
  • Hybrid Cloud Core
  • IBM Cloud platform
  • IBM Design
  • IBM Forms Experience Builder
  • IBM Maximo Developer
  • IBM StoredIQ
  • IBM StoredIQ-Cartridges
  • IIDR
  • ITOA
  • InformationServer
  • Integration Bus
  • Internet of Things
  • Kenexa
  • Linux on Power
  • LinuxONE
  • MDM
  • Mainframe
  • Messaging
  • Node.js
  • ODM
  • Open
  • PowerAI
  • PowerVC
  • Predictive Analytics
  • Product Insights
  • PureData for Analytics
  • Push
  • QRadar App Development
  • Run Book Automation
  • Search Insights
  • Security Core
  • Storage
  • Storage Core
  • Streamsdev
  • Supply Chain Business Network
  • Supply Chain Insights
  • Swift
  • UBX Capture
  • Universal Behavior Exchange
  • UrbanCode
  • WASdev
  • WSRR
  • Watson
  • Watson Campaign Automation
  • Watson Content Hub
  • Watson Marketing Insights
  • dW Answers Help
  • dW Premium
  • developerWorks Sandbox
  • developerWorks Team
  • Watson Health
  • More
  • Tags
  • Questions
  • Users
  • Badges