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