Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have not done such migration before and I want to know if I am going to face such issues when moving my database (tables,views,table-spaces,functions,procedures,etc.) to other DB2 distribution.

If there will be some problems, will it be better to download the trial version of "Enterprise Edition" for example and to develop my project on it?

share|improve this question
up vote 4 down vote accepted

If I understand you right, you are going from DB2 10.1 Express-C edition to DB2 10.1 Work Group Server Edition or Enterprise Edition.

If that is case then you shouldn't have any issues. The binaries for DB2 are basically the same across editions. It is just a matter of a license file that enables or disables certain features and enables/disables use of more/less CPU and memory. (The only exception to this I have seen is the DB2 Spatial Extender-for GIS type storage-which normally would be in Express-C, but somehow isn't. So that one you have to download (for free) from IBM's site. But if you did a regular Enterprise Edition install, it is installed.)

Anyway, if you are "migrating" the entire instance, I take that to mean you just need to apply the Work Group Server edition license file or the Enterprise Edition license file to the database instance and Express-C will automatically turn into one of the other editions. If you are talking about moving data from an Express-C environment to another environment, there should be even less issues (pending the database version is the same). If that is the case you could do a backup from one and a restore to the other.

share|improve this answer
Thank you very much for the answer. – gotqn Aug 27 '12 at 13:39

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.