DB2 Server for VSE & VM: Database Services Utility

Appendix B. FILEDEF Command Syntax and Notes

Whenever you run the Database Services Utility under CMS, first identify the files to CMS with the FILEDEF command.
Note:Use the SQLDBSU EXEC, which generates standard FILEDEF statements, to define the control and message files. Create a FILEDEF statement for all additional input and output files.

The FILEDEF command in CMS performs the same functions as the data definition (DD) record in OS job control language (JCL). When you enter a FILEDEF command, specify:

The format of the FILEDEF command is:
Format: 
>>-FIledef--ddname----+-Terminal--------+----------------------->
                      +-PRinter---------+
                      +-Reader----------+
                      +-DISK--fn_ft_fm--+
                      '-TAPn------------'
 
>-----+--------------------+-----------------------------------><
      '-(--Options--+---+--'
                    '-)-'
 

ddname (data definition name)
identifies the name used in your Database Services Utility command that refers to the input or output file.

Terminal
your workstation

PRinter
the spooled printer available to you

Reader
the spooled reader available to you

DISK fn ft fm
virtual direct access storage device (DASD) CMS file

TAPn
magnetic tape drive, where n can be 1, 2, 3, or 4, representing virtual units 181, 182, 183, and 184, respectively.

Options
to avoid error messages, specify only those options that are valid for a particular device. Table 19 shows valid options for each device type.

The following diagram illustrates the FILEDEF options available when the device is a workstation or a tape drive:
Format: 
>>-(------------------------------------------------------------>
 
>----+------+--+----------+---+-----------------+---+--------------+>
     '-PERM-'  +-CHANGE---+   '-RECFM--+-----+--'   '-LRECL--nnnn--'
               '-NOCHANGE-'            +-F---+
                                       +-FB--+
                                       +-V---+
                                       +-VB--+
                                       +-FBS-+
                                       '-VBS-'
 
>----BLOCK--nnnn----+--------------+---+-------------+--+---+--><
                    |        (1)   |   |        (2)  |  '-)-'
                    +-UPCASE-------+   +-7TRACK------+
                    |         (1)  |   |        (2)  |
                    '-LOWCASE------'   '-9TRACK------'

Notes:

  1. Terminal only.

  2. Tape only.
 

The following diagram illustrates the FILEDEF options available when the device specified is DISK:
Format: 
>>-(--+------+----+----------+---+-----------------+------------>
      '-PERM-'    +-CHANGE---+   '-RECFM--+-F---+--'
                  '-NOCHANGE-'            +-FB--+
                                          +-V---+
                                          +-VB--+
                                          +-FBS-+
                                          '-VBS-'
 
>-----+--------------+---+--------------+---+--------------+---->
      '-LRECL--nnnn--'   +-*------------+   +-XTENT50------+
                         '-BLOCK--nnnn--'   '-XTENT--nnnn--'
 
>----+----------+----+------------------+--+--------+----------->
     '-DISP MOD-'    '-MEMBER--mbrname--'  '-CONCAT-'
 
>-----+----------------+--+---+--------------------------------><
      '-DSORG--+-PS-+--'  '-)-'
               +-PO-+
               '-DA-'
 

Table 19. FILEDEF Options and Parameters
OPTION NAME DISK READER/PRINTER TAPn TERMINAL
BLOCK, BLOCKSIZE X X X X
CHANGE, NOCHANGE X X X X
CONCAT X      
DEN     X  
DISP MOD X   X  
DSORG X      
LOWERCASE/ UPCASE       X
LRECL X X X X
MEMBER X      
PERM X X X X
RECFM X X X X
7TRACK/9TRACK     X  

Some guidelines for entering FILEDEF specifications are given below.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]