Database extract function (online conversation)

The Data Base Extract function consists of an online conversation and a batch job stream. The online screens prompt you for the information needed to submit the batch job to do the actual extract.

The online conversation consists of a sequence of screens where you are prompted to do the following:

  1. Specify the PSB containing the PCBs to be used to access the FROM database (for static PSB only).
  2. Specify the DBD for the extract FROM database, the job type of the extract job, and the optional use of an external KEY value.
  3. Specify whether secondary indexing should be used to drive extract processing.
  4. Specify the use of an application relationship to extract records from application-related databases.
  5. Specify the use of selection criteria to limit the extract to certain segment types or occurrences.
  6. Specify the data set names for the extract FROM database.
  7. Specify whether to disguise the extracted data and which disguise option to use.
  8. Specify the data set name of the extract TO file, its attributes, and the extract job JCL information.
  9. Optionally edit the JCL generated by File-AID for IMS/ISPF to perform the extract.

The batch job consists of the following steps:

  1. SRTGEN1 - Allocate and initialize temporary data set to-data set-name.CK.
  2. SRTGEN2 - Allocate and initialize temporary data set to-data set-name.XK.
  3. SRTGEN3 - Allocate and initialize temporary data set to-data set-name.RK.
  4. SRTKEY - (Optional) sort key file used to drive extract.

  5. DBEXTRCT - Data Base Extract (XIXDTFDV)

    Retrieves segments from the extract FROM database, applies selection criteria (if specified), applies application relationships (if specified), and writes the segment data, along with File-AID for IMS/ISPF prefix information, to the extract TO file.

  6. DELETE - Deletes temporary data sets allocated in steps 1-3.
  7. RPTSTATS - Data Base Extract Summary Reporting (XIXRPTDV)
    Writes a report that summarizes the results of the extract.
  8. RFMT - Reformat the extracted data in preparation for disguise.
  9. DISG - Disguise the extracted data.

This section provides information about the following topics:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*