Topic
5 replies Latest Post - ‏2012-06-11T10:43:42Z by SystemAdmin
LeoPetraz
LeoPetraz
31 Posts
ACCEPTED ANSWER

Pinned topic Download DB2 Express-C 10.1

‏2012-05-07T14:15:26Z |
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.

Next steps

Updated on 2012-06-11T10:43:42Z at 2012-06-11T10:43:42Z by SystemAdmin
  • BUVA_Tom_Fortmann
    BUVA_Tom_Fortmann
    1 Post
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.1

    ‏2012-05-29T18:23:00Z  in response to LeoPetraz
    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
      LeoPetraz
      31 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.1

      ‏2012-05-29T18:49:13Z  in response to BUVA_Tom_Fortmann
      Hi 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:
      http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp?topic=%2Fcom.ibm.db2.luw.qb.upgrade.doc%2Fdoc%2Ft0007200.html

      You should start by running the db2ckupgrade command:
      http://pic.dhe.ibm.com/infocenter/db2luw/v10r1/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.cmd.doc%2Fdoc%2Fr0002028.html

      Regards,

      Leons
    • DavidWAdler
      DavidWAdler
      14 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.1

      ‏2012-05-29T19:20:05Z  in response to BUVA_Tom_Fortmann
      Are 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
        SystemAdmin
        17917 Posts
        ACCEPTED ANSWER

        Re: Download DB2 Express-C 10.1

        ‏2012-05-29T22:04:25Z  in response to DavidWAdler
        Hi 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:
        http://publib.boulder.ibm.com/infocenter/db2luw/v10r1/topic/com.ibm.db2.luw.admin.nls.doc/doc/t0024033.html

        Hope this helps,
        Amyris.
  • SystemAdmin
    SystemAdmin
    17917 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.1

    ‏2012-06-11T10:43:42Z  in response to LeoPetraz
    Is it available for Ubuntu 10.04 LTS also?