Step 1—Specifying profile and extract - Documentation for BMC AMI DevX File-AID/RDX 23.01 (2024)

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

 BMC AMI DevX File-AID/RDX 23.1 Primary Option Menu OPTION ===> 2 USERID - PFHGHG0 0 PROFILE - Select, Create or Change Profiles DATE - 23/03/24 1 RELATIONSHIPS - Relationship Facilitator TIME - 13:19 2 EXTRACT - Extract from Related Objects TERMINAL - 3278 3 LOAD - Load Data Records CCSID - 01047 4 DELETE - Delete Extracted Rows from Db2 Tables and/or MVS Files 5 DATA PRIVACY - Data Privacy Menu 6 UTILITIES - Utility Functions G GLOBAL DEFAULTS - Define User Parms FD FADB2 - Transfer to File-AID for Db2 T TUTORIAL - Information about File-AID/Related Data XPERT X EXIT - Exit File-AID/Related Data XPERT Profile ===> RDXMENU RDXMENU - DISPLAY ALL OF THE MENU OPTIONS Type ===> PFHGHG0 (SITE, USER or prefix) (c) Copyright 1994-2023 BMC Software, Inc. 

Field Names and Descriptions

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

Option 0—Profile

Select and define your File-AID/RDXprofiles 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/RDXrelationship file.
  • Browse, edit, delete, and create application relationships (AR) between Db2, MVS, and/or IMS data in the File-AID/RDXrelationship 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/RDXgenerates 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/RDXcreates a key file that can be used to extract the related IMS data using File-AID for IMS. Optionally, you can execute the File-AID for IMSextract as a step following the File-AID/RDXextract. When you also create a COBOL record layout of the extracted file, you can use File-AID/EXto 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/RDXOption 5, Data Privacy, or the Data Studio’s Data Privacycomponent of the Data Studio.

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/RDXcan create new tables or files automatically before it loads the data. File-AID/RDXgenerates 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/RDXdetermines which records should be deleted based on the contents of a File-AID/RDXextract 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 BMC AMI DevX File-AID/Data Solutions and, optionally, Data Studio’s Data Privacyproducts.

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/RDXcontrol 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/RDXis in use.

Option FD—FADB2

Transfer to File-AID for Db2.

Option T—Tutorial

View an online tutorial for novice users.

Option X—Exit

Terminates your File-AID/RDXsession.

The following list describes the fields on this screen.