DSNTIP81: Performance and optimization panel 2
The DSNTIP81 panel is a continuation of the DSNTIP8 panel. It is used to set application programming default values pertaining to performance and optimization panel.
DSNTIP81 INSTALL DB2 - PERFORMANCE AND OPTIMIZATION (PANEL 2)
===>
Enter data below:
1 CURRENT DEGREE ===> 1 1 or ANY
2 MAX DEGREE ===> 0 Maximum degree of parallelism. 0-254
3 MAX DEGREE FOR DPSI ===> 0 Maximum degree of parallelism for data
partitioned secondary indexes. 0-254
or DISABLE
4 STAR JOIN QUERIES ===> DISABLE DISABLE, ENABLE, 1-32768
5 MAX DATA CACHING ===> 20 0-512
6 MAX AI DATA CACHING ===> 0 0-512
Enter default settings for maintained query special registers:
7 CURRENT REFRESH AGE ===> 0 0 or ANY
8 CURRENT MAINT TYPES ===> SYSTEM NONE, SYSTEM, USER, ALL
PRESS: ENTER to continue RETURN to exit HELP for more information