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