Topic
  • 8 replies
  • Latest Post - ‏2012-04-18T20:43:56Z by SystemAdmin
SystemAdmin
SystemAdmin
5837 Posts

Pinned topic Page "Max. memory use: 4GB" but db2licm says "2"

‏2012-04-17T21:07:40Z |
In this page http://www-01.ibm.com/software/data/db2/express/support.html says "Max. memory use: 4GB" under "Free (Unwarranted)" column but this is the output of db2licm in a just downloaded and installed server:
sudo ./db2licm -l
Product name: "DB2 Express-C"
License type: "Unwarranted"
Expiry date: "Permanent"
Product identifier: "db2expc"
Version information: "9.7"
Max number of CPUs: "2"
Max amount of memory (GB): "2"
Enforcement policy: "Soft Stop"

So, is 2 or 4?
Updated on 2012-04-18T20:43:56Z at 2012-04-18T20:43:56Z by SystemAdmin
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-17T21:08:56Z  
    BTW is installed on ubuntu server 10.04.3 lts 64bits.
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-17T23:36:27Z  
    BTW is installed on ubuntu server 10.04.3 lts 64bits.
    The ability to use 4GB of memory is new to me. The last time I checked it was 2GB. Because of that my guess is the image you installed was an older one that has the 2GB limit. If you install the newest image, you will probably get the 4GB limit. But this is just a guess.
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-17T23:59:09Z  
    The ability to use 4GB of memory is new to me. The last time I checked it was 2GB. Because of that my guess is the image you installed was an older one that has the 2GB limit. If you install the newest image, you will probably get the 4GB limit. But this is just a guess.
    I downloaded the installation archive today (db2exc_lite_975_LNX_x86_64.tar.gz)

    FWIW, this is what db2level says:

    DB21085I Instance "db2inst1" uses "64" bits and DB2 code release "SQL09075"
    with level identifier "08060107".
    Informational tokens are "DB2 v9.7.0.5", "special_27924", "IP23292_27924", and
    Fix Pack "5".
    Product is installed at "/opt/ibm/db2/V9.7".

    Regards.
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-17T23:59:13Z  
    Since I just finished reading some of the IBM announcement letters, I'll go out on a limb here and suggest they (IBM) have updated that link for DB2 LUW 10.

    For DB2 9.x , Express C (Free) limit was 2GB. In DB2 10 it is 4GB
    For DB2 9.x , Express (Paid versions) limit was 4GB , in DB2 10 it is 8GB

    Search the IBM site for :
    IBM United States Software Announcement 212-074
    April 3, 2012
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-18T01:40:38Z  
    Since I just finished reading some of the IBM announcement letters, I'll go out on a limb here and suggest they (IBM) have updated that link for DB2 LUW 10.

    For DB2 9.x , Express C (Free) limit was 2GB. In DB2 10 it is 4GB
    For DB2 9.x , Express (Paid versions) limit was 4GB , in DB2 10 it is 8GB

    Search the IBM site for :
    IBM United States Software Announcement 212-074
    April 3, 2012
    That cross my mind also...

    Well, lets see when Express-C 10 is available.

    If gives 4GB RAM, is almost the same as Oracle Standard One (a $5800 per core x 2 = $11600) value FOR FREE!

    When HADR is needed, FTL is practially the same as Oracle Standard One support fee with the advantage of replication.

    Regards.
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-18T01:51:03Z  
    That cross my mind also...

    Well, lets see when Express-C 10 is available.

    If gives 4GB RAM, is almost the same as Oracle Standard One (a $5800 per core x 2 = $11600) value FOR FREE!

    When HADR is needed, FTL is practially the same as Oracle Standard One support fee with the advantage of replication.

    Regards.
    Found:

    http://www-01.ibm.com/common/ssi/cgi-bin/ssialias?subtype=ca&infotype=an&appname=iSource&supplier=897&letternum=ENUS212-074
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-18T19:36:40Z  
    That cross my mind also...

    Well, lets see when Express-C 10 is available.

    If gives 4GB RAM, is almost the same as Oracle Standard One (a $5800 per core x 2 = $11600) value FOR FREE!

    When HADR is needed, FTL is practially the same as Oracle Standard One support fee with the advantage of replication.

    Regards.
    DB2 Express paid editions not quite the same as Oracle Standard One.

    DB2 Express 9.x FTL paid edition is limited to 4 cores over 2 sockets(processors) and 4GB memory.

    Oracle Standard One is priced per socket (Processor). No processor core count and no memory RAM limit. Oracle has a link http://www.oracle.com/us/products/database/product-editions-066501.html comparing their editions.

    DB2 Express 9.x , 10 C (Free) editions definitely competitive over Oracle Express
  • SystemAdmin
    SystemAdmin
    5837 Posts

    Re: Page "Max. memory use: 4GB" but db2licm says "2"

    ‏2012-04-18T20:43:56Z  
    DB2 Express paid editions not quite the same as Oracle Standard One.

    DB2 Express 9.x FTL paid edition is limited to 4 cores over 2 sockets(processors) and 4GB memory.

    Oracle Standard One is priced per socket (Processor). No processor core count and no memory RAM limit. Oracle has a link http://www.oracle.com/us/products/database/product-editions-066501.html comparing their editions.

    DB2 Express 9.x , 10 C (Free) editions definitely competitive over Oracle Express
    Oh!

    You right:

    Core != socket

    Anyway, in same hardware, say 2 sockets and 2 cores with 8GB RAM, DB2 Express is cheaper ($2150 per server per year) than Oracle S1 ($2552 for support per year + initial license of cost of $11,600.00)

    Regards.