使用DB2look 重新创建优化器访问计划(3) （1）

OS：Windows 2000

DB2LEVEL：V8.2 Fixpack 8 ESE 单分区

---------------------------------------

-- Database SAMPLE and Database Manager
configuration parameters 

---------------------------------------
UPDATE DBM CFG USING cpuspeed 9.446886e-007; 

UPDATE DBM CFG USING intra_parallel NO; 

UPDATE DBM CFG USING federated NO; 

UPDATE DBM CFG USING fed_noauth NO; 

!db2fopt SAMPLE update opt_buffpage 250; 

!db2fopt SAMPLE update opt_sortheap 256; 

UPDATE DB CFG FOR SAMPLE USING locklist 50; 

UPDATE DB CFG FOR SAMPLE USING dft_degree 1; 

UPDATE DB CFG FOR SAMPLE USING maxlocks 22; 

UPDATE DB CFG FOR SAMPLE USING avg_appls 1; 

UPDATE DB CFG FOR SAMPLE USING stmtheap 2048; 

UPDATE DB CFG FOR SAMPLE USING dft_queryopt 5; 

--------------------------------- 

-- Environment Variables settings 

--------------------------------- 

!db2set DB2_INLIST_TO_NLJN=yes; 

!db2set DB2_HASH_JOIN=yes;