Db2

 View Only
Expand all | Collapse all

Questions about server specifications when installing db2

  • 1.  Questions about server specifications when installing db2

    Posted Wed December 11, 2019 02:58 AM
    Edited by System Fri January 20, 2023 04:23 PM
    Hi All,

    If I want to install db2luw, do I need to match the machine specifications to the developer edition's limitations even though db2 physically limits the number of cores and shared memory size?

    For example, I understand the db2 license policy as below.


    case 1) Server - 16 core, 128 GB, Db2 11.5 Developer Edition 
    → OK because it is free.

    case 2) Server - 32 core, 128 GB, Db2 11.5 Standard Edition  PVU 16 core
    → Not OK because of number of physical cores, but installation possible.

    case 3) Server - 4 core, 256 GB, Db2 11.5 Standard Edition  PVU 4 core
    → Not OK because of physical memory size, but installation possible.

    case 4) Server - 16 core, 128 GB, Db2 11.5 Standard Edition  PVU 16 core
    → OK


    Please explain if I misunderstand.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------
    #Db2


  • 2.  RE: Questions about server specifications when installing db2

    Posted Wed December 11, 2019 12:20 PM
    Hey,

    It is not mandatory to match the specs. The Specs mentioned means these are the limits and you can't exceed probably.

    Regards,
    RJ

    ------------------------------
    Rizwan Ali
    ------------------------------

    Original Message


  • 3.  RE: Questions about server specifications when installing db2

    Posted Thu December 12, 2019 08:58 AM
    Thank you. Rizwan.
    Db2 installs well even though the physical system resources (CPU, RAM) are more than the limits that Db2 limits.
    So I am confused by the license description.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message


  • 4.  RE: Questions about server specifications when installing db2

    Posted Thu December 12, 2019 05:37 AM
    Hi,

    As I understand the IBM license, that's correct. Except case 1.
    For Db2 11.5 Community Edition (Developer) the server must not have more than 4 cores and 16 GB RAM.

    https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.5.0/com.ibm.db2.luw.licensing.doc/doc/c0058536.html
    https://www.ibm.com/software/passportadvantage/about_software_licensing.html

    ------------------------------
    Dennis
    ------------------------------

    Original Message


  • 5.  RE: Questions about server specifications when installing db2

    Posted Thu December 12, 2019 09:05 AM
    Hi Dennis, Thanks for your reply.
    I understand that Db2 Developer Edition can be used in production for free.

    I also know that Db2 Developer Edition limits the use of resources of 4 cores and 16 GB RAM.
    But do I have to buy a server with exactly 4 cores and 16 GB RAM even though the Db2 process limits resource usage?

    Regards,

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message


  • 6.  RE: Questions about server specifications when installing db2

    Posted Thu December 12, 2019 03:11 PM
    Hi SangGyu,

    Db2 Developer Edition is free. Take a look at this discussion.
    https://community.ibm.com/community/user/hybriddatamanagement/communities/community-home/digestviewer/viewthread?MessageKey=5a9985ea-adf8-4d58-ba97-2927cbac6fc0&CommunityKey=ea909850-39ea-4ac4-9512-8e2eb37ea09a&tab=digestviewer#bmf0361be6-d7ea-4b48-a3dc-5fae7b04c08f

    You can use virtual servers.

    ------------------------------
    Regards, Dennis
    ------------------------------

    Original Message


  • 7.  RE: Questions about server specifications when installing db2

    Posted Fri December 13, 2019 02:09 AM
    Edited by System Fri January 20, 2023 04:49 PM
    All is correct.
    In case 1 : DB2 Developer-C will use only the licensed free resource (4 core / 16 GB ram) limiting also the total dimension of the database (100 GB)
    You can use DB2 on all of these configuration without incurring in licensing problem because is auto-limiting indipendently of the machine configuration (as in accord with the licensed product).

    --
    Saluti,
    Adriano



    Original Message


  • 8.  RE: Questions about server specifications when installing db2

    Posted Fri December 13, 2019 02:14 AM
    Hi Adriano,
    Thank you for the clear explanation! The confusion has been resolved.

    ------------------------------
    SangGyu Jeong
    Software Engineer
    Infrasoft
    Seoul Korea, Republic of
    ------------------------------

    Original Message