Figure 9 14   Configuration Advisor recommendations

Initial configuration recommendations can also be acquired through the text 

based 

AUTOCONFIGURE

 command. Example 9 38 shows the sample execution of 

the command. 

Example 9 38   Sample AUTOCONFIGURE command

db2 autoconfigure using mem_percent 40 tpm 300 num_local_apps 80 isolation CS apply none

[...]

Current and Recommended Values for Database Configuration

Description                            Parameter  Current Value  Recommended Value

 Max appl. control heap size (4KB)     (APP_CTL_HEAP_SZ) = 4096                128

 Max size of appl. group mem set (4KB) (APPGROUP_MEM_SZ) = 30000               9908

 Default application heap (4KB)             (APPLHEAPSZ) = 256                 256

 Catalog cache size (4KB)              (CATALOGCACHE_SZ) = (MAXAPPLS*4)        404

 Changed pages threshold                (CHNGPGS_THRESH) = 40                  60

 Database heap (4KB)                            (DBHEAP) = 600                 1461

 Degree of parallelism                      (DFT_DEGREE) = 1                   1

 Default tablespace extentsize (pages)   (DFT_EXTENT_SZ) = 32                  32

[...]

 Chapter 9. Testing and tuning 

313