Running the Export Utility

Edit online

The Export Utility, FABGXEXP program, exports data from the HISTORY data set to a flat file.

Procedure

To run the Export Utility, complete the following steps:

  1. Allocate and initialize a VSAM KSDS for the HISTORY data set.
    DB Historical Data Analyzer, FABGHIST program, provides a function to initialize the HISTORY data set.

    Run the FABGHIST program specifying TYPE=UPDATE OPTION EXPORTABLE=YES to activate the EXPORTABLE option.

    For descriptions about creating HISTORY data sets and changing the attributes, see PROC control statement.

  2. Make sure that HD Pointer Checker is run in advance to create entries in the HISTORY data set.
  3. If you want to create the flat records in the user-defined format, prepare the flat record definition statements.

    The statements can reside in a member of a data set called FABGRECI. For the description of the flat record definitions, see FABGRECI data set. For an example for using flat record definitions, see Example 6: Creating user-defined flat records.

    If you want to create the flat records in the predefined format provided by IMS HP Pointer Checker, you do not need to prepare the FABGRECI data set. For an example for using the predefined format, see Example 5: Creating predefined flat records.

  4. Specify control statements to describe the functions to be run.

    The control statements can reside in the input stream, or in a data set called HISTIN. See HISTIN data set for the description of control statement specifications.

    If you want to do syntax checking for the flat record definitions, run the Export Utility with specifying TYPE=CHECK in the HISTIN data set. The flat records are not created, but the syntax checking is done.

  5. Code the JCL as described in FABGXEXP JCL. Then run the Export Utility job.

    You can also refer to the JCL examples in JCL examples for DB Historical Data Analyzer to code the JCL statements.