DB2 Database parameter recommendations (LINUX)

Kernel parameter configuration:

kernel.shmall=< Physical Memory 90%, page >kernel.shmax=< actual physical memory >Kernel.shmmni=16384 Kernel.msgmax=192000kernel.msgmnb=192000kernel.msgmni=65536  Kernel.sem=256000*<ram size, in GB >  Kernel.randomize_va_space=0vm.swappiness=0

As above content added to/etc/sysctl.conf
Executive Sysctl-a

User Resource configuration:
For instance users, fence users, the application user adds the following restrictions:

Db2inst1 Soft Nproc10240Db2inst1 Hard Nproc10240Db2inst1 Soft Nofile65000Db2inst1 Hard Nofile65000Db2inst1 Soft Stack-1db2inst1 Hard Stack-1Db2inst1 Soft Data-1db2inst1 Hard Data-1Db2inst1 Soft Fsize-1Db2inst1 Hard Fsize-1Db2inst1 Soft RSS-1Db2inst1 Hard RSS-1

Add above memory to/etc/security/limtis.conf

DB2 Register variable settings:

Db2set db2_laod_copy_no_override=nonrecoverabledb2set db2_use_fast_preallocation=ONdb2set DB2_MEM_ Tuning_range=+,

DB parameter:

 for 1024x768 (at least 4M)

DB2 Database parameter recommendations (LINUX)