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.
BUVA_Tom_Fortmann 270005BUVA1 Post
Re: Download DB2 Express-C 10.12012-05-29T18:23:00ZThis is the accepted answer. This is the accepted answer.I 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 Posts
Re: Download DB2 Express-C 10.12012-05-29T18:49:13ZThis is the accepted answer. This is the accepted answer.
- BUVA_Tom_Fortmann 270005BUVA
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 Posts
Re: Download DB2 Express-C 10.12012-05-29T19:20:05ZThis is the accepted answer. This is the accepted answer.
- BUVA_Tom_Fortmann 270005BUVA
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 Posts
Re: Download DB2 Express-C 10.12012-05-29T22:04:25ZThis is the accepted answer. This is the accepted answer.
- DavidWAdler 1200006AT7
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,