DSNTIP8: Performance and optimization panel

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

Start of change
DSNTIP8         INSTALL DB2 - PERFORMANCE AND OPTIMIZATION
 ===> _

 Enter data below:

  1  CURRENT DEGREE        ===> 1        1 or ANY
  2  CACHE DYNAMIC SQL     ===> YES      NO or YES
  3  OPTIMIZATION HINTS    ===> NO       Enable optimization hints. NO or YES
  4  MAX DEGREE            ===> 0        Maximum degree of parallelism. 0-254
  5  PARALLELISM EFFICIENCY===> 50       Efficiency of parallelism. 0-100
  6  IMMEDIATE WRITE       ===> NO       NO, YES
  7  EVALUATE UNCOMMITTED  ===> NO       Evaluate uncommitted data. NO or YES
  8  SKIP UNCOMM INSERTS   ===> NO       Skip uncommitted inserts. NO or YES
  9  CURRENT REFRESH AGE   ===> 0        0 or ANY
 10  CURRENT MAINT TYPES   ===> SYSTEM   NONE, SYSTEM, USER, ALL
 11  STAR JOIN QUERIES     ===> DISABLE  DISABLE, ENABLE, 1-32768
 12  MAX DATA CACHING      ===> 20       0-512
 13  PLAN MANAGEMENT       ===> EXTENDED OFF, BASIC, EXTENDED
 14  PLAN MANAGEMENT SCOPE ===> STATIC   ALL, STATIC, DYNAMIC
 15  RANDOMIZE XML DOCID   ===> NO       NO or YES



 PRESS:   ENTER to continue   RETURN to exit   HELP for more information
End of change
Figure 1. Performance and optimization panel: DSNTIP8