Topic
22 replies Latest Post - ‏2015-02-20T09:34:52Z by S_h_e_a
LeoPetraz
LeoPetraz
228 Posts
ACCEPTED ANSWER

Pinned topic Download DB2 Express-C 10.5

‏2013-06-17T19:26:09Z |


DB2 Express-C 10.5 is now available for download. Express-C is the free edition of the DB2 database.

Unlike the competitor express offerings, DB2 Express-C does not impose any additional low limits on the size of your databases over other editions of DB2. The new DB2 Express-C 10.5 release also relaxes its memory restriction by 400%. It will now use up to 16GB of memory.

DB2 Express-C can handle database of any size, it can be used in production, and it can be redistributed with your applications.

Next steps
 

Updated on 2013-07-04T15:50:17Z at 2013-07-04T15:50:17Z by LeoPetraz
  • ada4ko
    ada4ko
    12 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2013-06-18T09:19:14Z  in response to LeoPetraz

    Are you sure that this version can handle database of any size?

    According to this doc:

    Program charges: DB2 10.5 Express-C can be used for development and deployment at no charge. It can be installed on x64-based physical or virtual systems and may use up to a maximum of 2 processor cores and 16 GB of memory with no more than 15 terabytes of user data per database

    • Vili01
      Vili01
      5 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5

      ‏2013-06-27T19:53:04Z  in response to ada4ko

      I am interested in this question too. Is there upper limit in 10.5 in database size ?

    • LeoPetraz
      LeoPetraz
      228 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5

      ‏2013-07-04T15:49:57Z  in response to ada4ko

      @ada4ko: You're right, aside from DB2 Enterprise and Advanced Enterprise, there is a general DB2 for LUW limit of 15,000 GB. I was referring to the much lower database size limits (e.g. 4 GB) imposed by some competitor products. I have edited the original post.

       

  • dattark
    dattark
    17 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2013-06-20T18:22:33Z  in response to LeoPetraz

    This is good news. Lets hope these changes allow for more projects to consider DB2.

     

  • LeoPetraz
    LeoPetraz
    228 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2013-07-04T16:05:46Z  in response to LeoPetraz

    There is a known issue with installing DB2 10.5 on Windows XP 32-bit. You will receive a "setup.exe is not a valid win32 application" error. It is caused by a change in Visual Studio 2012 which is used to build DB2 10.5. Microsoft dropped support for older 32-bit operating systems in Visual Studio 2012.

    Windows XP is not a supported platform at this time:

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/index.jsp?topic=%2Fcom.ibm.db2.luw.qb.server.doc%2Fdoc%2Fr0006867.html

     

    • dattark
      dattark
      17 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5

      ‏2013-07-05T17:49:12Z  in response to LeoPetraz

      If I am not mistaken, Microsoft resolved the issue with support for targeting XP in VS 2012 Update 1 (late 2012) .

      See vsupdate_KB2707250.exe

    • X5DN_Stefan_Svetsky
      X5DN_Stefan_Svetsky
      4 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5 - but what should I do? DOes exist an older DB2 Express version?

      ‏2013-09-07T09:25:51Z  in response to LeoPetraz

      I installed db2express (I think 10.1) on December 2012 on an 8-year old computer  Win XP (in school), on Thinkpad(Win7) without problem, but on "older" home computer WIn XP It was not possible. But it is my main Home computer (e.g. 22'' PC screen, 750 GB additional hard-disk, however older means that mother board and processor  are maybe 10 years old).  Thus, I started work with DB2 occasionally, I work only with DDL - files.  

      Now, I had to reinstal it on ThinkPad 10.5 and tried onec more to install it on my Home computer. Only accidentally I found after a half year that a setup file with allert:  "setup.exe is not a valid win32 application".

      What should I do? Or in another word. As a beginner with DB2 I need  any simple version. Which lower version would work, i.e. would be  installable on my WinXP computer?

      P.S.:  I have also problems after re-installation DB2express on ThinkPad, because  ddl-codes which worked now did not function, e.g. it shows that I have database TEST and Sample, even connect to sample works, however connect to test shows that test does not exists, etc. But I have not time to search which paths etc. (I am aware, that DB2 remembered older paths/directories). By first re-installation it was aller SAMPLE already exist and it was cancelleld. After sesond re-installation I accidentaly  install SAMPE, but sure it is not correct. Thus, I do not know, which old directories I have  to delete. I am very confusing how complicated is all with the IBM DB2. 

      Note: you need not to comment P.S. becass I will re-install all ThinkPpad on the  facory level

       

       

  • joeymacao
    joeymacao
    1 Post
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2013-07-19T21:05:14Z  in response to LeoPetraz

    DB2 Text Search (db2ts) seems to have been omitted

    (not available to select and apparently is not included by default either)

    from both the Linux and Windows DB2 10.5 Express-C install. 

    I can't find this mentioned as a conscious choice in the DB2 10.5 docs.

    Any ideas what might have happened?

    ~~~~~~~~~

    Windows log file:

    Property(C): CONFIGURE_TEXT_SEARCH = 1
    Property(C): p_enableTextSearch = 0
    Property(C): p_textSearchBackFlag = HealthMonitor_noEx

    Property(C): p_TextSearchPortNumber = ___NotSet___

    Property(C): PROP_RSP_DB2.TEXT_SEARCH_HTTP_PORT_NUMBER = ___NotSet___
    Property(C): p_TextSearchServiceName = ___NotSet___

    Property(C): PROP_RSP_DB2.TEXT_SEARCH_HTTP_SERVICE_NAME = ___NotSet___

    Property(C): DEFAULT_TEXT_SEARCH_SERVICE_NAME = db2j_DB2
    Property(C): DEFAULT_TEXT_SEARCH_SERVICE_PORT = 55000

    ~~~~~~~~~

    Linux log does not mention anything at all

    • LeoPetraz
      LeoPetraz
      228 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5

      ‏2013-08-15T15:23:57Z  in response to joeymacao

      Text Search is meant to be included with DB2 Express-C. It appears to be omitted in DB2 Express-C 10.5 GA release. We're looking to resolve this.

      Regards,

      Leons

  • cleaner7777
    cleaner7777
    1 Post
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2013-11-21T17:47:16Z  in response to LeoPetraz

    Is it possible for IBM to provide the 32 bit 10.1 version of Express-C since the 10.5 version doesn't install on XP?   I understand that there will no longer be support for XP, but is there any reason not to have previous versions available for download?

  • deak6nt
    deak6nt
    14 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2014-03-06T03:53:10Z  in response to LeoPetraz

    Piggybacking off this comment, I am looking for a Windows Version of v10.1 that can be used with RAD v9.0?

    There seems to be no support in v10.5 for JPA.  At least  the Wizards fore Managed Beans fail to work on DB2 Express-C v10.5 or v10.5 fp1.

    Thanks in advance for your reply.

  • a.damnjan
    a.damnjan
    2 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2014-04-28T18:50:03Z  in response to LeoPetraz

    According to the license terms:

    Licensee's use of the Program is subject to the following resource limitations:

    - The Program may use up to a maximum of 4 GB of memory across all instances of the Program in each physical or virtual server.

    - A maximum of 2 processor cores may be made available to the Program across all instances of the Program in each physical or virtual server.

    so we are not actually allowed to use the 16 GB capability.

    Is there a way to tell DB2 not to use more than 2 cores, or are we supposed to set up virtual machines on quad-core laptops in order to comply with the license terms?

  • This reply was deleted by SystemAdmin 2014-10-16T18:28:08Z.
  • Benny_Hardjono
    Benny_Hardjono
    2 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5 then problems with data studio 4.1.1

    ‏2014-11-21T04:12:25Z  in response to LeoPetraz

    Dear Leo,

    Hi I have been a fan of IBM DB2. Got certified up to 730, and have been teaching IBM DB2 since 2011 (students use win 32 or 64 bit up to win 8.1 and Mac), everything fine.

    I even could install a web based php with IBM DB2 10.5.1 (on win 8.1 as server) with data studio 3.2 in a friend's small school - never have any problems.

    BUT recently I tried using data studio 4.1.1 - I have problems - in students' laptop the data studio icon did not come up - with new installs.

    I use win 7 enterprise,  IBM DB2 xpress C 10.5.1 64 bit,  and data studio 3.2 - but am afraid in upgrading to 4.1.1.  Anyone can share their success stories ?

    Much appreciate your inputs

  • WF09_Libor_Charvat
    WF09_Libor_Charvat
    1 Post
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2014-12-03T12:44:48Z  in response to LeoPetraz
    Hi Leo,

    Today I downloaded version 10.5, the current build, which is formed by 19 August 2014. Previous downloadable version was 10.5fp1 of September 17, 2013. Means that is FP2? is anyone release report for view?

    Thanks

    Libor

     

     

  • AbhishekDanej
    AbhishekDanej
    2 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5 - unable to install -

    ‏2015-02-13T05:04:44Z  in response to LeoPetraz

    Hi,

    I'm trying to install 32bit db2 express c 10.5 on my laptop (win 7 enterprise, 32 bit). When I open setup.exe I get the launchpad window with the summary and all, but the Buttons in navigation pane are missing.

    Attached my computers properties and db2 launchpad screen snapshot.

    Anyone faced this issue and has any ideas? Thanks in advance.

    Regards,

    Abhishek

    • AbhishekDanej
      AbhishekDanej
      2 Posts
      ACCEPTED ANSWER

      Re: Download DB2 Express-C 10.5 - unable to install -

      ‏2015-02-13T09:40:50Z  in response to AbhishekDanej

      Hi, just to update ..it is working now. It seems there cannot be a space in the name of any directory where setup.exe is present. For me it was My Stuff, which i renamed to MyStuff. All ok now!

  • S_h_e_a
    S_h_e_a
    20 Posts
    ACCEPTED ANSWER

    Re: Download DB2 Express-C 10.5

    ‏2015-02-20T09:34:52Z  in response to LeoPetraz

    Hi,

    i am download today for windows and see

    VERSION=10, RELEASE=5, MODIFICATION=500, SERVICE_LEVEL=IP23628

    So Fixpack 5 is available.

    Thats fine, because in FP 4 we have problems