STATISTICS command with FILE subcommand

Usage

• Use the FILE subcommand to format unreduced DB2® data and store it in sequential data sets suitable for use by the DB2 load utility. The records can be placed in DB2 tables, and you can produce reports by using a reporting facility such as Query Management Facility (QMF).
• You can also use the FILE data sets to generate CSV (comma-separated value) input-data. This CSV data can then be transferred to workstations and imported into spreadsheets to improve DB2 performance analysis using graphical representations or pivot tables. For more information refer to Reporting User's Guide.

Usage notes

• The data is stored in delta records in a sequential data set.

Syntax of the FILE subcommand

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See Subcommand options for comprehensive descriptions of these options. The following list gives additional or specific descriptions of selected options, where appropriate.

FROM/TO

Limits the range of delta records included in the data set by date and time.

Combinations of FROM date and time, and TO date and time can be specified. Delta records are included from the first with an ending timestamp greater than or equal to the FROM date and time, to the last with an ending timestamp less than the TO date and time.

Any FROM/TO dates and times specified in GLOBAL can restrict the range of delta records included in the file data set. GLOBAL FROM/TO filters the raw DB2 statistics records used to make up the delta records. Therefore, all records with begin or end times outside the GLOBAL dates and times are discarded. If the date and time is not specified in GLOBAL, all records in the input data are available.

You can specify a time adjustment for a DB2 location using the TIMEZONE option of the GLOBAL command. The time adjustment is applied to the record timestamp before FROM/TO processing.

If you are reducing data, the FROM/TO times specified in REDUCE can affect the data available for filing.

Refer to GLOBAL command for more information.

For details on how to use the FROM/TO option, see FROM/TO subcommand options.

EXCEPTION

NOEXCEPTION

Specifies EXCEPTION to include only those file entries containing fields with values outside user-specified limits. Otherwise, all records are included.

If you use this subcommand option, your JCL must contain a valid DD definition for the ddname EXCPTDD. For more information about required ddnames, see EXCPTDD statement.

DDNAME

Specifies the ddname where the file data set is written. The default ddname is STFILDD1.

INCLUDE/EXCLUDE

Includes or excludes data associated with specific OMEGAMON® for DB2 PE identifiers.

For details, see INCLUDE and EXCLUDE subcommand options, which lists other identifiers allowed with this command and subcommand combination, and OMEGAMON for Db2 PE identifiers.

DSETSTAT

Includes buffer pool data set statistics.