Allocate Relationship File

The Allocate Relationship File screen shown in the following figure is displayed when you Select Option A, Allocate, from the DB2 Relationship Facilitator screen (see DB2 Relationship Facilitator), or from the MVS Relationship Facilitator screen (see MVS Relationship Facilitator). Menu. Use this screen to create a new Relationship file in addition to the ones created during the installation of File-AID for Db2.

Allocate Relationship File

Use this screen to allocate the new Relationship file that File-AID for Db2 uses as a repository to store the RI and AR relationship definition so you can extract related data.

Press END (PF3) to allocate the SMS file, or use the CANCEL command to cancel the allocation. When allocation is complete, File-AID for Db2 displays a message: FILE ALLOCATED in the upper-right corner of the screen.

After allocating a new Relationship file, you can use Option 5, Load RI, from the DB2 Relationship Facilitator to load Db2 RI information from a Db2 subsystem (see 5 - Load RI).

New VSAM Component Names

Cluster

Specify the name of the VSAM cluster for the Relationship file to be allocated. If you don’t use quotes around the name, File-AID for Db2 will add your TSO ID as the prefix.

Data component LLQ

Low level qualifier for the data component. You may overtype this field, if your installation uses a different data component LLQ.

Index component LLQ

Low level qualifier for the index component. You may overtype this field, if your installation uses a different index component LLQ.

Data component

Displays the name of the data component as it will be allocated. It reflects the new cluster name and low level qualifier after you press Enter.

Index component

Displays the name of the index component as it will be allocated. It reflects the new cluster name and low level qualifier after you press Enter.

Important

If a long cluster name results in data and index component names longer than 44 characters, the cluster name portion in front of the component LLQ is truncated.

Specify SMS Class Information

Storage

Specify the SMS storage class to use for the allocation of the file. The storage class describes the hardware requirements of the file.

Data

Specify the SMS data class to use for the allocation of the file. The data class describes the attributes of the file such as RECORG, KEYLEN, KEYOFF, SPACE, etc.

Management

Specify the SMS management class to use for the allocation of the file. The management class describes the migration, backup, and retention for the file.

Space Allocation

Specify the space allocation values for the data and index components. Leave fields blank for defaults.

Volume serial

Specify the volume serial of the direct access device that contains the file.

Space units

Specify one of the following storage unit types depending on how the file size is expressed:

TRK - Tracks
CYL - Cylinders
K - Kilobytes
M - Megabytes
REC - Records

Primary quantity

Specify the primary allocation quantity as specified in the space units field.

Secondary quantity

Specify the secondary allocation quantity as specified in the space units field.