db2set ALT_DIAGPATH=/db2data/db2dump2

db2set SECONDARY_DIAGPATH=/db2data/db2dump2

UPDATE DBM CFG USING ALT_DIAGPATH /db2data/db2dump2

UPDATE DBM CFG USING SECONDARY_DIAGPATH /db2data/db2dump2

To limit how many log files a single transaction can span.

To limit the percentage of primary log space a running transaction can consume.

To limit the total number of primary and secondary log files a database can consume.

To limit the total number of secondary log files a transaction can consume before infinite logging is enabled.

CPU cycles

Elapsed time, in milliseconds

Processing instructions performed

Timerons

Job Console

Job Manager

Task Manager

Utilities Console

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STMT_STATS ON;

UPDATE DB CFG FOR sample USING AUTO_TBL_MAINT ON;UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;

UPDATE DB CFG FOR sample USING AUTO_RUNSTATS ON;UPDATE DB CFG FOR sample USING AUTO_STATS_VIEWS ON;