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  CACHE DYNAMIC SQL     ===> YES      NO or YES
  2  CACHE DYN STABILITY   ===> BOTH     CAPTURE, LOAD, BOTH, or NONE
  3  OPTIMIZATION HINTS    ===> NO       Enable optimization hints. NO or YES
  4  EVALUATE UNCOMMITTED  ===> NO       Evaluate uncommitted data. NO or YES
  5  SKIP UNCOMM INSERTS   ===> NO       Skip uncommitted inserts. NO or YES
  6  IMMEDIATE WRITE       ===> NO       NO or YES

  7  PLAN MANAGEMENT       ===> EXTENDED OFF, BASIC, EXTENDED
  8  PLAN MANAGEMENT SCOPE ===> STATIC   STATIC
  9  PACKAGE RELEASE COMMIT===> YES      Permit BIND and REBIND at COMMIT time
                                         on packages bound as RELEASE(DEALLOCATE)
  10 RANDOMIZE XML DOCID   ===> NO       NO or YES  
  11 REAL TIME STATS        ===> 30      RTS time interval in minutes. 1-144
  12 DISABLE EDM RTS       ===> NO      Disable EDM real time stats. NO or YES
  13 STATISTICS FEEDBACK    ===> ALL     Scope of statistics feedback: ALL,
                                           DYNAMIC, NONE, or STATIC
  14 STATS PROFILE FEEDBACK ===> YES     Statistics profile feedback: NO or YES



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