Print Relationship File

The Print Relationships function enables you to generate a formatted report containing the contents of a relationship file. You can print the report or write the report to a file.

Formatted Relationship Report Screen

The Formatted Relationship Report screen shown in the following figure is displayed when you select Option P in the DB2-Relationship-Facilitator or MVS-Relationship-Facilitator menu.

Formatted Relationship Report Screen

Use this screen to specify the relationship file for which you want to generate a report.

The body of the Formatted Relationship Report screen consists of the following field:

File Name

Specify the name of the relationship file for which you want to generate a formatted report.

Print Options Screen

The Print Options screen shown in the following figure is displayed when you complete the Formatted Relationship Report screen and press Enter.

Print Options Screen

Use this screen to specify whether you want to route the report to a printer or a file. If you route the report to a file, use this screen to specify a file and its characteristics.

Maximum lines per page

Specify the maximum number of lines to be printed on each page. The value specified must be in the range 20-99.

If you want to route the report to a printer, specify appropriate values in the following two fields:

Printer Destination

Specify the destination printer.

SYSOUT Class

Specify the SYSOUT class.

If you want to route the report to a file, specify the appropriate values in the following fields:

“TO” Print file

Specify the name of the file to which the report will be written.

Member

If the file you specified in “TO” Print file is partitioned, you can enter a member name.

VOLSER

If the file specified in TO Print file is non-cataloged or new, specify the volume serial number of the file. For non-cataloged files, a volume serial number is required. For new files, a volume serial number is optional.

Disposition

Specify the disposition of the TO Print file. You can write to existing files with a disposition of OLD or MOD. Specify a disposition of NEW to create a new sequential file.

If you specify NEW in the Disposition field, you must specify the following allocation parameters:

Generic Unit

Specify the device type on which the new file will reside. The names of these devices are installation dependent.

Block Size

Specify the block size for the new file.

Space Units

Specify whether space for the new file will be allocated in blocks (BLK), tracks (TRK), or cylinders (CYL).

Primary QTY

Specify the initial number of space units that will be allocated for the new file.

Secondary QTY

Specify the number of space units that will be allocated for each secondary extent.

Edit Print JCL

The ISPF/PDF Edit screen shown in the following figure is displayed when you pressed Enter on the Print Options screen.

ISPF/PDF EDIT Screen — File-AID for Db2-generated JCL

Use this screen to edit and/or submit the print JCL generated by File-AID for Db2. If you want to save this JCL, use the ISPF/PDF CREATE or REPLACE command before you exit the panel. Otherwise, File-AID for Db2 deletes this file.

Submit this JCL to perform the print.

Formatted Relationship Report

The Formatted Relationship Report shown in the following figure is a summary of the relationships contained in the relationship file you specified on the Formatted Relationship Report screen. The report is organized such that for each object involved in a relationship you can see information about the object and its direct relationships.

Relationship File - Related Objects Report

The report groups related objects. In the first part, the groups are made up with the parent object listed first, followed by all of its dependent (child) objects. In the second part, the groups are made up with the dependent object listed first, followed by all of its parent objects. If an object is listed more than once in a group as a parent or child, it reflects the number of relationships that exist between those objects. The groups are listed in alphabetical order.

The Formatted Relationship Report consists of the following fields:

Type

Displays the type of relationship that exists between the parent and dependent object.

RI	Referential Integrity relationship
AR	Application Relationship
AR-C	User-defined conditional (data driven) application relationship. Created and maintained by the user with File-AID/RDX.

Parent

Name of the parent object. Db2 long object names are wrapped within the column.

Dependent

Name of the dependent object. Db2 long object names are wrapped within the column.

The parent and dependent object names are preceded by their object type:

D-	Db2 object
I-	IMS and Output Key file (dependent only)
M-	MVS object

RELNAME or Description

Displays the RELNAME for RI relationships or the defined description for application relationships (AR).

Columns

Displays the related parent and dependent columns with their column type and length.