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.
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