Creating CSV files from log files in your ad hoc list

You can use Transaction Analysis Workbench to save data from any supported log record type to a comma-separated values (CSV) file. You can use the CSV file with other applications, such as PC-based spreadsheet applications. A CSV file created by Transaction Analysis Workbench contains selected fields from a single log record type and code.

Before you begin

Before using the Transaction Analysis Workbench ISPF dialog to create a CSV file from log files in your ad hoc list, you must define a form for the corresponding log record type and code.

About this task

The procedure described here uses the Transaction Analysis Workbench ISPF dialog to generate JCL that invokes the CSV command of the Transaction Analysis Workbench report and extract utility.

The ISPF dialog generates JCL that uses only a subset of the features of the CSV command. To use other features of the CSV command, edit the generated JCL or write your own JCL.

Procedure

  1. On the Transaction Analysis Workbench Primary Option Menu, select option 4 Process.
    Your personal ad hoc list of log files is displayed.
  2. If the list does not already include the log files that you want to process, insert those log files now.
    For details on inserting log files, including log streams, on this panel, see Browsing logs in your personal ad hoc list.

    You can create a CSV file either from one or more data sets, or from a single log stream. You cannot create a CSV file from a mix of data sets and log streams, or from multiple log streams.

  3. Type SUB next to one or more log files, and then press Enter.
    The Submit Batch Request window opens.
  4. Optionally, specify filtering criteria and an interval to extract only matching records.
  5. Select CSV, and then specify the details of the CSV file, including the name of the form that specifies the type of log record and the fields that you want to save to the CSV file.

    The panel suggests a data set name based on a template that you specify in ISPF dialog option 0.3 Extract Data Set Allocations.

  6. Press Enter to generate the JCL for the request.
    The JCL is displayed in an edit panel.
  7. Submit the job: enter SUB on the command line.
  8. Press the the Exit function key (F3) to exit the edit panel.
  9. Use your site-specific procedures to view the job output.