A major new release of the free edition of the IBM DB2 database is now available for download. DB2 Express-C 10.1 comes with Time Travel Query for improved historical reporting as well as SPARQL and an RDF triplestore for NoSQL data storage.
At no charge, DB2 Express-C is also 98% compatible with Oracle Database. The database compatibility feature includes support for PL/SQL, CLP+, and much more. Use it for production, test, or development.
You can redistribute DB2 Express-C at no charge as the database solution for your application. Though it will limit itself to only consuming a set amount of your computing resources, DB2 Express-C has no limitations on database size, number of users, or your preferred uses.
This topic has been locked.
5 replies Latest Post - 2012-06-11T10:43:42Z by SystemAdmin
Pinned topic Download DB2 Express-C 10.1
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-11T10:43:42Z at 2012-06-11T10:43:42Z by SystemAdmin
BUVA_Tom_Fortmann 270005BUVA1 PostACCEPTED ANSWER
Re: Download DB2 Express-C 10.12012-05-29T18:23:00Z in response to LeoPetrazI am running an older version (v7.?) of DB2 Personal Edition on one of our production servers. Can I upgrade to the new Express-C v10 edition? If so are there any extra steps I need to take before or after installing v10? A full backup is obvious, but will the v10 install update/migrate (not sure of the correct term) my existing databases and settings?
Thank you in advance for your time and advice.
LeoPetraz 06000188P731 PostsACCEPTED ANSWER
Re: Download DB2 Express-C 10.12012-05-29T18:49:13Z in response to BUVA_Tom_FortmannHi Tom,
This is a bit outside my expertise. v7 is very old and you might encounter some difficulties upgrading.
Per the info center, DB2 v10.1 supports upgrading from v9.5 and v9.7 out of the box:
You should start by running the db2ckupgrade command:
DavidWAdler 1200006AT714 PostsACCEPTED ANSWER
Re: Download DB2 Express-C 10.12012-05-29T19:20:05Z in response to BUVA_Tom_FortmannAre you sure you are running V7? Support for V7 was dropped many years ago as has support for V8.
You can not upgrade a database from V7 to V10. I think you would need to upgrade first to V8, then to V9, then to V10.
If you don't have too many user-defined objects, it might be best to use db2move to unload the data, create a new V10 database and use db2move to re-load the data. You could use db2look to save object definitions in V7 and then recreate them in V10.
SystemAdmin 110000D4XK17917 PostsACCEPTED ANSWER
Re: Download DB2 Express-C 10.12012-05-29T22:04:25Z in response to DavidWAdlerHi there,
I like to clarify from the last posting that it is true that you cannot upgrade from V7.
You need to upgrade to V8 first, then upgrade to V9.5 or V9.7. I would recommend upgrading to V9.7. Then finally upgrade to V10.
If you do not have the V8 software, you might not be able to upgrade as V8 is no longer supported. You might have to use other utilities such as db2move to re-create your database in Version 10. This might be a better idea for small databases rather than going to through 3 upgrades.
There is a topic in the Information Center about re-creating databases to convert them to Unicode databases that you can take as a sample scenario for re-creating databases:
Hope this helps,