表空间分配表(Tbl.sql)

update db cfg for TMISMGDB using DFT_QUERYOPT 5;
update db cfg for TMISMGDB using MAXAPPLS 720;
update db cfg for TMISMGDB using PCKCACHESZ 16384;
update db cfg for TMISMGDB using CATALOGCACHE_SZ 4096;
update db cfg for TMISMGDB using LOCKLIST 65536;
update db cfg for TMISMGDB using MAXLOCKS 80;
update db cfg for TMISMGDB using DLCHKTIME 10000;
update db cfg for TMISMGDB using LOCKTIMEOUT 30;
update db cfg for TMISMGDB using DBHEAP 16384;
update db cfg for TMISMGDB using LOGBUFSZ 256;
update db cfg for TMISMGDB using MINCOMMIT 1;
update db cfg for TMISMGDB using SOFTMAX 100;
update db cfg for TMISMGDB using NEWLOGPATH /tmis/mdblog;
update db cfg for TMISMGDB using LOGRETAIN on;
update db cfg for TMISMGDB using LOGARCHMETH1 disk:/tmis/mdbarchlog;
update db cfg for TMISMGDB using LOGFILSIZ 65536;
update db cfg for TMISMGDB using LOGPRIMARY 100;
update db cfg for TMISMGDB using LOGSECOND 28;
update db cfg for TMISMGDB using TRACKMOD off;
update db cfg for TMISMGDB using SHEAPTHRES_SHR 256;
update db cfg for TMISMGDB using SORTHEAP 1024;
update db cfg for TMISMGDB using STMTHEAP 8192;
update db cfg for TMISMGDB using APPLHEAPSZ 4096;
update db cfg for TMISMGDB using STAT_HEAP_SZ 2048;
update db cfg for TMISMGDB using AUTO_MAINT OFF;
update db cfg for TMISMGDB using AUTO_RUNSTATS OFF;
update db cfg for TMISMGDB using NUM_IOSERVERS 8;
update db cfg for TMISMGDB using NUM_IOCLEANERS 4;
update db cfg for TMISMGDB using CHNGPGS_THRESH 20;
commit work;