DB2 tuning parameters from PoGyö

TSM 6.2 DB2 tunning and sizing,

db2 connect to XXX
db2 "select * from syscat.bufferpools" -
Ennek az eredményével kell FellegZ-t keresni....

db2update db cfg for XXX using softmax 100-200
db2update db cfg for XXX using logprimary 2
db2update db cfg for XXX using logsecond 200-250
db2update db cfg for XXX using logfilsiz 1024 v 4096
db2stop
db2start