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