RECTRACE command with FILE subcommand

This section describes the RECTRACE command with the FILE subcommand.

Usage

Use the FILE subcommand to format 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™).

Usage notes

FILE is used to format Record Trace records from IFCID 22, 63, 96, 125, 172, 196, 316, 365, and 401.
Only one file data set can be generated in a job step.

Syntax of the FILE subcommand


>>-FILE--+--------------------------------+--------------------><
         '-+-| FROM/TO block |----------+-'   
           |            .-RTFILDD1-.    |     
           +-DDNAME--(--+-ddname---+--)-+     
           '-| INCLUDE/EXCLUDE block |--'

Subcommand options

The syntax diagram shows the options that are available with this subcommand. See OMEGAMON XE for DB2 PE 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 records included in the data set by date and time.
For details, see FROM/TO subcommand options.
DDNAME: Specifies the ddname where the file data set is written. The default ddname is RTFILDD1.
INCLUDE/EXCLUDE: Includes or excludes data associated with specific OMEGAMON® XE 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 XE for DB2 PE identifiers.

Example using RECTRACE with TRACE and FILE subcommands

This example requests a Record trace that:

Includes records generated between 08:00 and 08:10 on each day included
Includes records with PRIMAUTH:
- UID0001
- UID0002
- UID0003
Excludes records with PLANNAME:
- PLIT2A01
- PLIT2A02
Generates a data set on ddname RTFILDD1 by default. The data set contains detailed information about the IFCIDs generated by the primary authorization ID SYSADM.

Note: If the EXEC statement is omitted, no trace is produced. The syntax of your command stream is checked and is written to the DPMLOG data set together with any error, warning, or information messages produced. All statements after the EXEC are ignored.

⋮
RECTRACE
   TRACE
      FROM    (,08:00:00)
      TO      (,08:10:00)
      INCLUDE (PRIMAUTH(UID0001 UID0002 UID0003))
      EXCLUDE (PLANNAME(PLIT2A01 PLIT2A02))
   FILE
      INCLUDE (PRIMAUTH(SYSADM))
⋮
EXEC

Feedback