Executing statements in preview mode

You can execute utility control statements in preview mode. The utility checks for syntax errors in all utility control statements, but normal utility execution does not occur.

About this task

Start of change Statistics profiles can be previewed using the PREVIEW option. Under normal execution, statistics profiles are stored in the SYSIBM.SYSTABLES_PROFILES catalog table. When executing RUNSTATS with the PREVIEW option, DB2® only prints the statistics profile for each table to SYSPRINT and normal utility execution does not take place. End of change

Start of change Please note that the profile text is displayed prior to parsing for syntactical errors. End of change

Start of change The contents of the profile is displayed using DSNU1376I. End of change

Procedure

To execute utility control statements in preview mode:

Specify the PREVIEW option in the OPTIONS control statement. Control statements are previewed for use with LISTDEF lists and TEMPLATE definitions but the specified options are not actually executed.