论坛 › DB2 › DB2数据库的优化

James 发表于 2016-11-15 06:42:19

DB2数据库的优化

/*命令编辑器中执行的语句格式*/

update database cfg for ycportal using LOGBUFSZ 500;

update db cfg for ycportal using applheapsz 2000;

update db cfg for ycportal using SORTHEAP 2048;

update dbm cfg using SHEAPTHRES 20000;

update dbm cfg using NUM_POOLAGENTS 200;

update dbm cfg using MAXAGENTS 300;

update db cfg for ycportal using DBHEAP 1200;

update db cfg for ycportal using LOCKLIST 3000;

update db cfg for ycportal using MAXLOCKS 50;

update db cfg for ycportal using LOCKTIMEOUT 30;

update db cfg for ycportal using MAXAPPLS 600;

terminate;


//ycportal 为数据库名

查看完整版本: DB2数据库的优化