DSNTIP8: Performance and optimization panel

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

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