DB2 Database parameter recommendations (AIX)

To modify the maximum number of processes for a user:

Chdev-l sys0-a maxuproc='8192'

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

db2inst1:fsize=-1fsize_hard=-1data=-1data_hard= -1stack=-1stack_hard=-1rss=-1Rss_ hard =-1nofiles=-1nofiles_hard=-1

Add above memory to/etc/security/limtis

DB2 Register variable settings:

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

DB parameter:

 for 1024x768   for (at least 4M)

DB2 Database parameter recommendations (AIX)