db2 -设置修改数据库的基本信息

update db cfg for DATAMGDB using DFT_QUERYOPT 3;

---设置修改数据库 DATAMGDB的基本信息

update db cfg for DATAMGDB using MAXAPPLS 120;

update db cfg for DATAMGDB using PCKCACHESZ 16384;

update db cfg for DATAMGDB using CATALOGCACHE_SZ 4096;

update db cfg for DATAMGDB using LOCKLIST 25600;

update db cfg for DATAMGDB using MAXLOCKS 80;

update db cfg for DATAMGDB using DLCHKTIME 10000;

update db cfg for DATAMGDB using LOCKTIMEOUT 10;

update db cfg for DATAMGDB using DBHEAP 10240;

update db cfg for DATAMGDB using LOGBUFSZ 256;

update db cfg for DATAMGDB using MINCOMMIT 1;

update db cfg for DATAMGDB using SOFTMAX 100;

update db cfg for DATAMGDB using NEWLOGPATH /tmis/mdblog;

update db cfg for DATAMGDB using LOGRETAIN off;

update db cfg for DATAMGDB using LOGARCHMETH1 off;

update db cfg for DATAMGDB using LOGFILSIZ 65536;

update db cfg for DATAMGDB using LOGPRIMARY 100;

update db cfg for DATAMGDB using LOGSECOND 28;

update db cfg for DATAMGDB using TRACKMOD off;

update db cfg for DATAMGDB using SHEAPTHRES_SHR 30720;

update db cfg for DATAMGDB using SORTHEAP 256;

update db cfg for DATAMGDB using STMTHEAP 8192;

update db cfg for DATAMGDB using APPLHEAPSZ 4096;

update db cfg for DATAMGDB using STAT_HEAP_SZ 2048;

update db cfg for DATAMGDB using AUTO_MAINT OFF;

update db cfg for DATAMGDB using AUTO_RUNSTATS OFF;

update db cfg for DATAMGDB using NUM_IOSERVERS 64;

update db cfg for DATAMGDB using NUM_IOCLEANERS 16;

update db cfg for DATAMGDB using CHNGPGS_THRESH 60;

update db cfg for TMISMGDB using APP_CTL_HEAP_SZ 1024;

commit work; S