Db2

Db2

Where DBAs and data experts come together to stop operating and start innovating. Connect, share, and shape the AI era with us.


#Data


#Data
#Databases
#Operatingsystems
#Db2
#Databasesolutions
 View Only

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

    Posted 06/19/23 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 06/21/23 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
    ------------------------------



Related Content