Create New File

The following figure displays when you specify an extract file (File name) or discard file (File for Discarded Rows) that does not exist. On this panel, File-AID for Db2 allocates SMS-controlled Sequential, PDS, and PDS/E files.

Important

This option is displayed only when SMS is installed at your site.

Create New File

Use this screen to specify allocation values for a new file to be created by File-AID for Db2.

Depending on the type of file, File-AID calculates some of the allocation values and locks those fields from input. For example, when creating a new extract file, the Record format (VB) and Record length (27994) fields are locked and their prefilled values cannot be changed.

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

Important

The message “The file will be allocated during execution of the batch job” appears for files that don’t need to be allocated until execution of the batch job.

File Name

Displays the name of the file to be allocated.

Management Class

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.

Storage Class

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

Generic Unit

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

Volume serial

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

Data Class

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.

Space units

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

TRK - Tracks

CYL - Cylinders

BLK - Blocks

KB - Kilobytes

MB - Megabytes

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.

Directory quantity

For a PDS, specify the number of directory blocks. For a Sequential file, specify zero (0).

Record format

Specify a value with a combination of the following codes (F, V, or U is required):

F - Fixed length

V - Variable length

U - Undefined format

B - Blocked

A - ANSI printer control characters

M - Machine code printer control characters

S - For Sequential files only: Standard for F or spanned for V

T - Track-overflow feature

Record length

Specify a logical record length, in bytes, of the records to be stored in the file. File-AID validates this value with the record format and block size.

Block size

Specify the physical record length, in bytes, of the blocks to be stored in the file. File-AID validates this value with the record format and record length.