View JCL

The ISPF/PDF Edit screen shown in the following figure is displayed when you select Option 13 - View JCL, from the Extract Menu.

ISPF/PDF EDIT Screen—File-AID/RDX-generated JCL

Use this screen to view or edit the extract JCL generated by File-AID/RDX. Use the SUBMIT command to submit the extract request for execution. If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit the panel. If you did not save the extract request with Option 12- Save Extract Request, File-AID/RDX deletes the temporary extract criteria work file after extract execution.

XVJPRINT Execution Log Output

BMC Compuware File-AID Data Privacy jobs now write execution information to XVJPRINT DD (instead of SYSPRINT DD). If XVJPRINT DD does not exist in your JCL, File-AID will dynamically allocate XVJPRINT.

If you want the execution log output sent to a file, point XVJPRINT DD at a file (instead of SYSOUT=*). This file must be allocated with RECFM=FBA, LRECL=133.

Optional Data Privacy Report Output Written to a File

If you want the Data Privacy Report information written to a fixed layout sequential file and/or to a CSV (Comma Separated Values) file, manually add the appropriate DD statement to the BMC Compuware File-AID Data Privacy job.

DPRSTAT1 DD (Fixed Layout Sequential File)

When you add a DPRSTAT1 DD to a BMC Compuware File-AID Data Privacy job and it points at a file defined as RECFM=FB,LRECL=2737, at end of job, the file will have the report information for each column written out as a single record containing all the same report information but in a formatted fixed layout sequential file.

Example:

or for a new file:

Record Layout for Output File

To view the output file in formatted mode you can use BMC Compuware File-AID/MVS Browse or Edit with the following COBOL record layout describing a record in the output file:

DPRSTAT2 DD (CSV)

When you add a DPRSTAT2 DD to a BMC Compuware File-AID Data Privacy job and it points at a CSV (Comma Separated Values) file defined as RECFM=VB,LRECL=2751, at end of job, the file will have the report information for each column written out as a single record containing all the same report information but they will be Comma Separated Value (CSV) records.

Example:

or for a new file:

Optional Source Data Identifiers (SDIs) Override During Execution

File-AID/RDX now allows you to replace, during execution of a DPR project, Source Data Identifiers (SDIs) defined in the BMC Compuware File-AID Data Privacy project.

To override SDIs, manually add the following DD statement to the JCL:

where the existing data set u.data.mysdis contains the definitions of SDIs that will be used for this execution.

If the DPRSDI DD is defined in JCL, all SDIs defined in the project will be ignored and replaced with definitions provided in the override data set.

Override File Format

Replacement SDIs can be defined either in XML or in JSON format. The tags in XML and names in name/value pairs in JSON correspond to SDI properties that can be defined through the Compuware Workbench User Interface. Refer to the Source Data Identifier Overrides topic in the Compuware Workbench File-AID Data Privacy User Guide for more information.

Override Data Privacy Environment Parameters

If you need to, you can override the Data Privacy Environment parameters listed in the following table (established with your site’s File-AID Data Privacy Environment parameters. For more information, see File-AID Data Privacy Environment.

Data Privacy Environment Parameter Overrides

To do so, insert any of these FAJPATH, FAJOPTS, FAIPADDR, and FAEXPATH DD statements as needed. For example:

It is also possible to specify more than one debug parameter inline. For example:

Override Execution Parameter in a Data Privacy Project

In order to override an execution parameter (public variable or translate table) in a Data Privacy Project, add a DPRPARMS DD statement to your JCL. This DD can point to a file or a PDS member containing the override values (maximum record length is 512 bytes). The override values can also be specified inline. Specify override values in the following way:

The execution parameter must have been defined in the BMC Compuware Topaz Workbench user interface for the project.

Example:

Your DPR project ‘project1’ includes:

• 2 translate tables, ‘Title table’ and ‘Titles for HR dept’ (Manage Translate Tables) 
  • The source table for ‘Title table’ is file ‘ABC.TRANS’.
• 2 public variables, ‘scramvar’ and ‘altscram‘ (Process Variables) 
  
  • The initial value for ‘scramvar’ is string ‘123abc’.
• 2 execution parameters, ‘Parameter1’ identifies the translate table ‘Title table’ and ‘Param2Variable’ identifies variable ‘scramvar’ (Manage Execution Parameters).

At execution time, however, you want to override the defined execution parameters for translate table ‘Title table’ with the new translate table ‘ABC.NEWTRANS’ and the initial value of variable ‘altscram‘ with the new string ‘789xyz’. The new translate table must have the same characteristics as the original one.

To do so, insert the following DPRPARMS DD statement in the JCL (inline example):

Manage Translate Tables

Process Variables

Manage Execution Parameters

Execution Parameter List of Values

If the execution parameter variable type is either a String List or Numeric List, you can also override the list of values.

Specify a list of values in the following way:

The X variable inside the =LIST( )= parentheses defines the delimiter for the list of values. The delimiter can be any character. Connect each overridevalue with the defined delimiter.

For example, insert the following DPRPARMS DD statement in the JCL (inline example) to override the values of the String List named STATE (* is the defined delimiter):

Multiple Origins for a Data Privacy Rule

Normally, when a Data Privacy Rule is applied to a related field, one object¹ in the relationship thread is chosen as the “origin”. For every record in the origin, the Data Privacy Rule is applied to the related field and the BEFORE and AFTER values are saved. For every record in a “non-origin”, the Data Privacy Rule is not applied. Rather, the appropriate AFTER value is retrieved from where it was saved. This guarantees relationship integrity.

This methodology is efficient and sufficient in most scenarios, but there are some scenarios where no single origin contains all of the values required by the non-origins. When this occurs, it is possible to direct File-AID to use all objects that contain the necessary fields referenced by the Data Privacy Rule as origins. This directive is specified by adding to your JCL:

Special Instructions for Oracle Translate Table

If your Data Privacy job uses Data Translation with an Oracle Translate Table and your File-AID Data Privacy Environment parameters do not include the following JAVA options (for more information, see File-AID Data Privacy Environment), insert the following FAJOPTS DD statement after the FARULES DD statement:

If the JAVA options in the File-AID Data Privacy Environment parameters include other site specific JAVA options, also add them to the FAJOPTS DD statement before submitting the job.

Adding the above FAJOPTS DD statement will override the JAVA options in the File-AID Data Privacy Environment parameters and make it possible to run an Oracle translation while the log will be generated in EBCDIC.

An indicator that you need to make this JCL change is when the Data Privacy job ended with the following error:

However, this general message is not conclusive. Your error log file should have something like the following:

If you see the above, then you need to insert the FAJOPTS DD statement.

Redirect File-AID/Data Solutions Report (Data Disguise with DCF only)

When using a Disguise Control File (DCF) to disguise extracted data, you can choose to redirect the disguise report output produced by BMC Compuware File-AID/Data Solutions to FADSPRNT DD by simply adding it to the JCL in the disguise step. The FADSPRNT DD can point at a file or at SYSOUT. When it points at a file and multiple objects are being disguised, use DISP=MOD.

Since the use of FADSPRNT splits the BMC Compuware File-AID/Data Solutions report output away from the File-AID/RDX report output, FADSPRNT and SYSPRINT must be looked at together to get a complete picture of the job.

Control Card Cleanup

The last step, CLEANEXT, in the extract jobs deletes the File-AID/RDX EXTPARMS parameter file. Whether step CLEANEXT is commented out or executed is determined by the global job option Delete in-stream data data sets at EOJ in Option-G-global-user-defaults. If the job option is set to NO, File-AID/RDX EXTPARMS parameter files created in the extract jobs will NOT be deleted. Keeping the data sets until all steps run successfully allows for the restarting of the JCL at any step.

Periodically, you may want to manually delete the EXTPARMS parameter files that are no longer needed for saved jobs to be resubmitted.

View REXX

The ISPF/PDF Edit screen shown in the following figure is displayed when you select Option 12, from the Extract Menu and the Execute Extract online status has been set to ON with the MODE primary command.

ISPF/PDF EDIT Screen—File-AID/RDX Generated REXX

Use this screen to view or edit the extract REXX statements generated by File-AID/RDX. If you want to save these Rexx statements, use the ISPF/PDF CREATE or REPLACE command before exiting this panel. Otherwise, File-AID/RDX deletes this file after extract execution.