Db2

Db2

Connect with Db2, Informix, Netezza, open source, and other data experts to gain value from your data, share insights, and solve problems.

 View Only
Expand all | Collapse all

Does applying the license remove the memory limit?

  • 1.  Does applying the license remove the memory limit?

    Posted Mon June 19, 2023 10:41 PM

    Hello community,

    There is one instance online with no licenses registered.

    Does adding an enterprise or higher license with db2licm remove the memory limit (16 GB) without restarting the instance?

    It's hard to find documentation explaining this. Thanks,



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


  • 2.  RE: Does applying the license remove the memory limit?

    Posted Wed June 21, 2023 05:55 AM

    Adding an enterprise or higher license with the db2licm command does not automatically remove the memory limit for an instance without restarting the instance. Well the license upgrade itself does not directly affect the current memory configuration of the instance.
    To remove the memory limit and utilize more than the default 16 GB of memory, you would typically need to adjust the memory configuration parameters and then restart the Db2 instance. As far as i know it's the DATABASE_MEMORY or INSTANCE_MEMORY that controls the overall memory allocation for the instance or individual databases.



    ------------------------------
    Youssef Sbai Idrissi
    Software Engineer
    ------------------------------