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?
This topic has been locked.
8 replies Latest Post - 2012-04-18T20:43:56Z by SystemAdmin
Pinned topic Page "Max. memory use: 4GB" but db2licm says "2"
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-18T20:43:56Z at 2012-04-18T20:43:56Z by SystemAdmin
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-17T23:36:27Z in response to SystemAdminThe 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.
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-17T23:59:09Z in response to SystemAdminI 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 v18.104.22.168", "special_27924", "IP23292_27924", and
Fix Pack "5".
Product is installed at "/opt/ibm/db2/V9.7".
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-17T23:59:13Z in response to SystemAdminSince 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
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-18T01:40:38Z in response to SystemAdminThat 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.
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-18T19:36:40Z in response to SystemAdminDB2 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
Re: Page "Max. memory use: 4GB" but db2licm says "2"2012-04-18T20:43:56Z in response to SystemAdminOh!
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)