DSNTIP6: Db2 utilities parameters panel 1

The fields on the DSNTIP6 panel configure the default behavior of enhancements to the BACKUP SYSTEM, RESTORE SYSTEM, RECOVER, and other utilities.

Figure 1. Db2 utilities parameters panel 1: DSNTIP6
Start of change
 DSNTIP6        UPDATE DB2 - DB2 UTILITIES PARAMETERS 1                    
 ===>                                                                      
                                                                           
 Enter general options for DB2 Utilities:                                  
     1 TEMP DS UNIT NAME    ===> SYSDA     Device for temporary utility data sets
     2 UTIL TEMP STORCLAS   ===>           For temporary shadow data sets   
                                           by utilities                     
     3 STATISTICS HISTORY   ===> NONE      Default for collection of statistics
                                           history                          
     4 STATISTICS ROLLUP    ===> YES       Allow statistics aggregation: NO, YES
     5 UTILITY TIMEOUT      ===> 6         Utility wait time multiplier     
     6 IGNORE SORTNUM STMT  ===> NO        Ignore SORTNUM keyword in UT stmt
     7 TEMPLATE TIME        ===> UTC       For TEMPLATE TIME default: UTC, LOCAL
     8 MAX UTILS PARALLELISM===> 99        Maximum degree of parallelism for
                                           Utilities : 0 - 32767            
     9 STATISTICS COLGROUP  ===> 10        Storage limit in MB for sorting single
       DATA SORT STG LIMIT                 column COLGROUPs: 0 - 4096       
    10 PAGE-LEVEL SAMPLING  ===> SYSTEM    Collect RUNSTATS using page-level
                                           sampling by default (YES, NO, SYSTEM)    
    11 UTILS BLOCK FOR CDC ===> NO         Block utilities for CDC tables or
                                           table spaces: NO, YES            
    12 LOAD RO OBJECTS     ===> NO         Allow  LOAD  into  read-only obj: NO, YES
 PRESS:  ENTER to continue   RETURN to exit   HELP for more information
End of change