Step 1—Specifying profile and extract

To start an extract, you must also have a current profile selected. For this exercise, select USER profile SAMPMENU that you created in the previous section.

Primary Option Menu

Field Names and Descriptions

The following are options available from the File-AID/RDX Primary Option Menu.

Option 0—Profile

Select and define your File-AID/RDX profiles for extract and load functions. You can modify an existing SITE profile and save it as your own USER profile. SITE profiles may only be modified by authorized administrators.

Option 1—Relationships

The Relationship Facilitator represents an alternate approach to maintaining relationships. Specify a Db2 or MVS object and then perform relationship activities:

• 
  
  • Browse, refresh, load, and remove Db2 referential integrity (RI) relationships in the File-AID/RDX relationship file.
  • Browse, edit, delete, and create application relationships (AR) between Db2, MVS, and/or IMS data in the File-AID/RDX relationship file.
    Create, view, delete, and edit conditional (data-driven) application relationships.
  • Print all defined relationships from the relationship file.

Option 2—Extract

Extract relationally intact sets of data from one or more related or unrelated objects (Db2 tables and MVS files). You can create or modify extract criteria to apply during the extract process. File-AID/RDX generates the JCL to perform the extract. Additionally, you can combine the extract and load steps into a single JCL procedure. For related IMS data, File-AID/RDX creates a key file that can be used to extract the related IMS data using BMC Compuware File-AID for IMS. Optionally, you can execute the BMC Compuware File-AID for IMS extract as a step following the File-AID/RDX extract. When you also create a COBOL record layout of the extracted file, you can use BMC Compuware File-AID/EX to download and convert the extracted data to other client/server or workstation based DBMS.

The extract process can also disguise the extracted data to provide security for sensitive data. The disguise criteria can be defined by either using the File-AID/RDX Option 5, Data Privacy, or the BMC Compuware File-AID Data Privacy component of the BMC Compuware Topaz Workbench.

Option 3—Load

Load relationally intact sets of data into one or more related objects (Db2 tables and MVS files). To load Db2 objects you can use SQL INSERT statements or the Db2 LOAD Utility. Load data into existing objects (Db2 tables and MVS files) that are empty or already contain data. In addition, File-AID/RDX can create new tables or files automatically before it loads the data. File-AID/RDX generates the JCL to perform the load.

Option 4—Delete

Delete records from one or more related Db2 or MVS objects from which you have previously extracted data. File-AID/RDX determines which records should be deleted based on the contents of a File-AID/RDX extract file that you specify.

Option 5—Data Privacy

Disguise extracted data prior to moving it into a test environment. In this context, disguising data means to change the identifying characteristics from the data, such as name and address information, while still maintaining the structure and relationships of the original data. Data Privacy requires installation of Compuware’s BMC Compuware File-AID/Data Solutions and, optionally, BMC Compuware File-AID Data Privacy products.

These Disguise Utilities allow you to:

• 
  
  • Allocate Disguise Control File
  • Allocate Disguise Criteria File
  • Print Disguise Control File
  • Print Audit Trail

Option 6—Utilities

The RDX utilities allow you to:

• 
  
  • Allocate a new relationship file
  • Load and update RI in relationship file
  • Print relationship file
  • Update relationships in saved extract requests
  • Create JCL to Execute Saved Request (ESR) with overrides
  • Compress or Decompress Extract File
  • Generate readable DDL from Extract File.

Option G—Global Defaults

Specify the maximum number of entries in your Extract and Load Reference lists, specify whether or not to delete the File-AID/RDX control card PDSEs at the end of an extract, load, delete, or disguise job, specify a Dynamic Privacy Rules Repository, and enter default job statement information. In addition, this option displays which version of File-AID/RDX is in use.

Option FD—FADB2

Transfer to BMC Compuware File-AID for Db2.

Option T—Tutorial

View an online tutorial for novice users.

Option X—Exit

Terminates your File-AID/RDX session.

The following list describes the fields on this screen.