DSNTIP81: Performance and optimization panel 2

The DSNTIP81 panel is a continuation of the DSNTIP8 panel. It is used to set application programming default values pertaining to performance and optimization panel.

Figure 1. Performance and optimization panel: DSNTIP81

DSNTIP81 INSTALL DB2 - PERFORMANCE AND OPTIMIZATION (PANEL 2)
 ===> _

 Enter data below:

  1 CURRENT DEGREE        ===> 1        1 or ANY                                
  2 MAX DEGREE            ===> 0        Maximum degree of parallelism. 0-254    
  3 MAX DEGREE FOR DPSI   ===> 0        Maximum degree of parallelism for data  
                                        partitioned secondary indexes. 0-254    
                                        or DISABLE                              
  4 PARALLELISM EFFICIENCY===> 50       Efficiency of parallelism. 0-100        
                                                                                
  5 STAR JOIN QUERIES     ===> DISABLE  DISABLE, ENABLE, 1-32768                
  6 MAX DATA CACHING      ===> 20       0-512                                   

                                                                                
 Enter default settings for maintained query special registers:                 
  7 CURRENT REFRESH AGE   ===> 0         0 or ANY                               
  8 CURRENT MAINT TYPES   ===> SYSTEM    NONE, SYSTEM, USER, ALL





 PRESS:   ENTER to continue   RETURN to exit   HELP for more information