Creating a file with FILEMGMT: Difference between revisions

From m204wiki
Jump to navigation Jump to search
(Automatically generated page update)
Line 142: Line 142:
<th>Disable lock pending updates</th>
<th>Disable lock pending updates</th>
<th>
<th>
<p>Transaction Back Out locks an update until the transaction is committed, allowing an update to be backed out prior to the commit if for any reason the transaction does not finish. By disabling Lock Pending Updates, the feature Transaction Back Out is also disabled (Disable Transaction Backout must also be selected). If Disable lock pending updates is selected, incomplete transactions may be present in the file which may result in a file that is logically inconsistent. (FOPT=X'02')</p>
<p>Transaction back out locks an update until the transaction is committed, allowing an update to be backed out prior to the commit if for any reason the transaction does not finish. By disabling Lock Pending Updates, the feature Transaction back out is also disabled (Disable Transaction Backout must also be selected). If Disable lock pending updates is selected, incomplete transactions may be present in the file which may result in a file that is logically inconsistent. (FOPT=X'02')</p>
<p>The default is null.</p>
<p>The default is null.</p>
</th>
</th>
Line 183: Line 183:
<th>
<th>
<p>File does not use the <var class="product">Model&nbsp;204</var> transaction backout feature. This option is required if Disable Lock Pending Updates is selected.</p>
<p>File does not use the <var class="product">Model&nbsp;204</var> transaction backout feature. This option is required if Disable Lock Pending Updates is selected.</p>
<p>Transaction Back Out is a feature that will back out an update if the update does not complete as intended. This feature maintains the logical integrity of the file by ensuring that if the commit for an update is not executed, the update will not be kept.</p>
<p>Transaction back out is a feature that will back out an update if the update does not complete as intended. This feature maintains the logical integrity of the file by ensuring that if the commit for an update is not executed, the update will not be kept.</p>
<p>(FRCVOPT=X'08')</p>
<p>(FRCVOPT=X'08')</p>
<p>The default is null. See the Transaction Back Out chapter for details.</p>
<p>The default is null. See the Transaction back out chapter for details.</p>
</th>
</th>
</tr>
</tr>
Line 221: Line 221:
<td>
<td>
<p>All updates to the file are applied when the file is rolled forward. The default is null.</p>
<p>All updates to the file are applied when the file is rolled forward. The default is null.</p>
<p>This option will apply all updates during roll forward and not back out any incomplete update transactions. This option can only be used if Transaction Back Out (TBO) is turned off. This can be useful if a large number of updates are made without a commit being issued. It is suggested that after recovery has been run against a file with this option that a REORG be run against this file to ensure that the data and the indexes are in sync. (FRCVOPT=X'09')</p>
<p>This option will apply all updates during roll forward and not back out any incomplete update transactions. This option can only be used if Transaction back out (TBO) is turned off. This can be useful if a large number of updates are made without a commit being issued. It is suggested that after recovery has been run against a file with this option that a REORG be run against this file to ensure that the data and the indexes are in sync. (FRCVOPT=X'09')</p>
</td>
</td>
</tr>
</tr>

Revision as of 18:11, 29 May 2013

Overview of creating files

Prerequisites:

You must have Dictionary/204 and its subsystems running in order to use FILEMGMT.

Before working your way through the File Management Subsystem facility (FILEMGMT) interface to create a file, you should have made decisions about the organization, recovery options, and security for the file you are creating. See the chapters on Planning and File Design for more information.

Adding a file to the database includes the following steps:

  1. Defining the file organization and recovery options (File Definition - Organization screen).
  2. Defining the file security (File Definition - Security screen).
  3. For procedure files, defining the parameters for the procedures contained in the file (File Definition - Procedure screen).
  4. For data files, defining fields, records, and field groups in the following order:

    a. Defining the fields in the file. (Field Name List screen; Field Attributes screen)

    b. Defining the records in the file. (Record Name LIst screen; Record Definitions screen)

    c. Defining the field groups in the file. (Optional. Field Group List screen; Field Group Definition screen. See "Field group maintenance" in the Rocket Model 204 Dictionary/204 and Data Administration Guide for details.)

  5. Sizing the file and its tables. (File Size Definition screen)
  6. Modifying the file's field, record, and field group definitions and the size specifications, as needed.
  7. Executing the CREATE command (Execute Commands screen).

Defining file organization

  1. Log on to FILEMGMT as described in Logging on to FILEMGMT.
  2. Select the FILE Maintenance CREATE function (number 1) from the primary screen.

    FILEMGMT displays the first of the three File Definition screens, the Organization Screen:

File Definition - Organization screen

FILEMGMT File Definition - Organization PAGE 1 OF 3 Filename: VEHICLES FICREATE: 7.1 LANGUAGE: Active/Inactive I FILE ORGANIZATION Optimized Field Extract: N FILEORG X' 0E ' Entry:__ Sorted:_ Hash:X Unordered:_ Reuse Record Numbers:_ Sort/Hash Key: Req Evry Rec:X Enable Skewing:_ Table B Auto Increase Pages: 0 Table D Auto Increase Pages: 0 Table X Auto Increase Pages: File Models: None X 1nf _ Numeric Validation_ FILEMODL X' 00 ' FILE OPTIONS FOPT X' 00 ' Disable Lock Pending Updates: _ Only FM Defines New Fields: _ No Procedure Statement Numbers: _ No Procedure Statement Labels:_ Enable Date Time Stamp: N FILE RECOVERY OPTIONS FRCVOPT X' 00 ' Disable Transaction Back out: _ No Rollforward (RF): _ No RF Logging: _ No Checkpoint (CK) Logging: _ No Updates Without RF Logging: _ No Updates Without CK Logging:_ All Updates Applied During RF: _ No Discontinuities Allowed: _ Format File During CREATE: Y Verify Disk Updates: N ===> 1=HELp 2= 3=QUIt 4=FIElds 5=WIDen 6=COMmands 7= 8=FORward 9=SIZe 10= 11= 12=END

You use the File Definition - Organization screen to name a new file and to specify file organization parameters. When this screen is displayed for a file for the first time, the standard Model 204 default values for the parameters are used.

Model 204 default values are supplied for any parameters for which you do not fill in values.

You select options from the choices on the screen, and FILEMGMT uses your selections to compute appropriate values for the Model 204 FILEMODL, FILEORG, FOPT, and FRCVOPT parameters.

  1. In the Filename input field, enter the name of the file that you are creating.

    The name can be up to 8 characters long. The filename cannot be FILE or GROUP and cannot start with CCA, SYS, OUT, TAPE, or a number. It must start with a letter, and can contain only letters, numbers, and the following special characters:

    At sign (@)

    Pound sign (#)

    Dollar sign ($)

  2. The FICREATE input field displays the Model 204 version number for the file that you are creating. FILEMGMT uses FICREATE to calculate the file size and validate certain Model 204 file features. Enter a different version number if needed.
  3. The LANGUAGE input field displays the language of the file that you are creating (set by the LANGFILE parameter). The default is U.S. English. Enter a different language if needed.
  4. Change the Active/Inactive default value as needed.

    The Active/Inactive input field specifies how the commands in your file will be processed when you execute commands from the Execute Commands screen.

    Active or inactive indicates the mode you selected on the Organization screen or last used to execute commands against the file. The file itself is referred to as active or inactive, depending on the mode in which commands for the file were last executed.

    If you have permissions to change the value, and your system supports the alternative option you choose, your entry will override the system default set by the system administrator.

  • Type A to create an Active file. The commands will be executed immediately (upon verifying your permissions) or later in a batch file. Select the active execution mode if you choose to transform the file to current release format. Set FICREATE to the current release number.
  • Type I to create an Inactive file. The commands will be generated and stored in separate files for later execution.

    Active and inactive options are described in "Execution options" on page 219 and "Execute Commands screen" on page 305.

  1. In the Optimized Field Extract input field, enter Y to add a length byte to every non-preallocated (or non-OCCURS) field, which could result in faster field extraction. The improvement is most noticeable when you have built records with a large number of fields. Entering Y sets FILEORG to X'80'.

    The default is N: non-preallocated (or non-OCCURS) fields that are type FLOAT, CODED, and BINARY are not stored with a preceding length byte. See Preallocated fields for more information on preallocated and non-preallocated fields.

  2. In the FILE ORGANIZATION section, select file organization characteristics for the specified file. FILEMGMT computes the Model 204 FILEORG parameter from your selections and displays the computed value. See the Planning and File Design chapters for details on the advantages and disadvantages of each file organization type.

    Select one of the following options:

Option Parameter value Description
Entry (FILEORG=x'00') Records are stored in the file in the order in which they are entered. You cannot reorder records or reuse the record numbers of deleted records. Entry is the default file organization.
Sorted (FILEORG=x'01') Records are stored in the file in order by the sort key that you specify. Sorted is less efficient than the other options and is not recommended.
Hash (FILEORG=x'08') Records are stored in the file in order by the hash key that you specify.
Unordered (FILEORG=x'20') Records are stored in the file in the order in which they are entered. You can reorder records and reuse the record numbers of deleted records.

A record is stored on a page if there is sufficient space (as determined by the BREUSE parameter) and if there is an unused record number.

  1. In the Reuse Record Numbers input field, enter Y or N.

    Available with Unordered, Hashed, or Sorted file organization. Select Reuse Record Numbers if you want the record numbers of deleted records to be reused for new records added, provided that the record number is available on the Table B page to which the new record is being added. Selecting Reuse Record Numbers sets FILEORG=x'04'.

  2. Enter a Sort or Hash key, if applicable.

    If you have selected Hashed or Sorted as the file organization, enter the name of the sort or hash key field. The entry must be a valid Model 204 field name (1-70 characters). The requirements for a valid field name are described in Field name rules. The sort or hash key field must exist in every record in the file.

    If you have selected the Entry or Unordered file organization option, leave Sort/Hash Key blank.

  3. In the Req Every Rec input field:
  4. If you have selected Hashed or Sorted as the file organization, enter X to place a hash key (for hashed files) or a sort key (for sorted files) on every record. This option is required for Hashed or Sorted files because a key on every record is needed to process the file correctly. This option sets FILEORG=x'02'.
  5. If you have selected the Entry or Unordered file organization option, leave Req Evry Rec blank.
  6. Leave the Enable Skewing input field blank. Skewing is an obsolete method of physical storage that was designed to improve efficiency during sequential searches. An X would indicate that blocks within a track were stored in a skewed order. (For details, see the section "File skewing".)
  7. Select the following Auto Increase options as needed. See the chapter on File Table Size Management for details.
  8. TableB Auto Inc: If you want Model 204 to automatically increase Table B when it is opened or becomes full, enter an x beside one of the following options:
  9. Full: Table B will be automatically increased when it fills up by the amount specified in the parameter BAUTOINC.
  10. At Open: Table B will be automatically increased at file open time. [!!!is it increased when the table opens or the file opens?]
  11. Table B Auto Increase Pages: If you have selected a TableB Auto Inc option, enter the number of pages to increase Table B by. This sets the parameter BAUTOINC to the specified value.
  12. Table D Auto Increase Pages: If you want Model 204 to automatically increase Table D when it is opened or becomes full, enter the number of pages to increase Table D by. This sets the parameter DAUTOINC to the specified value.
  13. Table X Auto Increase Pages: If you want Model 204 to automatically increase Table X when it is opened or becomes full, enter the number of pages to increase Table X by. This sets the parameter XAUTOINC to the specified value. To use Table X:
  14. The file must have been created in Model 204 version 7.1.0 or later.
  15. The file must have an organization type of Entry or Unordered.
  16. File Models: A file model is a set of default file and field attributes. Rocket Software recommends that you use the default setting.
  17. In the FILE OPTIONS section, select the characteristics of the file you are creating. FILEMGMT computes the Model 204 FOPT parameter from your selections and displays the computed value.
    Disable lock pending updates

    Transaction back out locks an update until the transaction is committed, allowing an update to be backed out prior to the commit if for any reason the transaction does not finish. By disabling Lock Pending Updates, the feature Transaction back out is also disabled (Disable Transaction Backout must also be selected). If Disable lock pending updates is selected, incomplete transactions may be present in the file which may result in a file that is logically inconsistent. (FOPT=X'02')

    The default is null.

    Only FM Defines New Fields

    This option prevents the DEFINE FIELD command from being issued without using the FILEMGMT facility. The purpose of this option is to maintain the integrity of the dictionary. By using the FILEMGMT facility to define fields, the relationship between a file, the records in the file and the fields and their relationship to the file and the records within the file is automatically maintained in the Dictionary. (FOPT=X'01')

    The default is that new fields can be defined outside of FILEMGMT on the command line.

    No Procedure Statement Numbers Selecting this option prevents any procedures from being stored in the file which use statement numbers. Using statement numbers is an obsolete way of coding a User Language procedure which is difficult to understand. If this file is being used to store procedures, select this option in order to enforce proper coding standards. (FOPT=X'80')
    No Procedure Statement Labels Selecting this option prevents any procedures from being stored in the file which use statement labels. Statement labels are the proper way to code a User Language procedure. If this file will be used for storing procedures, enter N or leave the input field blank. Otherwise, enter Y if you want to prohibit procedure statement labels from being assigned to procedure lines. (FOPT=X'40')
    Enable Date Time Stamp

    The Date Time Stamp is an additional field within the file which tracks changes to a file at the record level and records the date and time of each update to a record. (FOPT=X'10') For details, see Overview of the date-time stamp feature.

    To use the date-time stamp:

    . The file must be an LPU file

    . The date/time stamp field specified in the DTSFN= system parameter must have already been defined to the file. For details, see Enabling date-time stamp updates.

  18. In the FILE RECOVERY OPTIONS section, select file recovery options for the file. FILEMGMT computes the Model 204 FRCVOPT parameter from your selections and displays the computed value.

    By default, recovery features are enabled. In an online environment, using the default options is recommended so that the file can participate in recovery if the system crashes.

    You might want to turn off recovery options if you are running a batch job that does not need to incur the overhead of recording information for recovery. FILEMGMT provides options to turn off specific recovery features, as described below.

    See the File Recovery chapter for details on these options.

Disable Transaction Backout

File does not use the Model 204 transaction backout feature. This option is required if Disable Lock Pending Updates is selected.

Transaction back out is a feature that will back out an update if the update does not complete as intended. This feature maintains the logical integrity of the file by ensuring that if the commit for an update is not executed, the update will not be kept.

(FRCVOPT=X'08')

The default is null. See the Transaction back out chapter for details.

No Rollforward (RF) File does not use the roll forward facility of the RESTART command. The default is null. This option prevents the updates from the file from being processed during roll forward. If this option is selected, the file will not participate in roll forward when the system performs recovery. (FRCVOPT=X'02')
No RF Logging Model 204 does not log changes to the journal file. The default is null. Roll Forward logging is the recording of updates from a file that are then used to apply updates when recovery is run. Selecting this option prevents the file from being able to use recovery. (FRCVOPT=X'04')
No Checkpoint (CK) Logging

Model 204 does not log checkpoint information to the checkpoint data set. The default is null.

Checkpoint logging is the process of capturing the contents of a record before an update is made. If checkpoint logging is not active, the file cannot participate in recovery. (FRCVOPT=X'20')

No Updates without RF Logging

File is not updated unless roll forward logging is active. The default is null.

Selecting this option requires that a journal be defined in the environment in which updates are made to the file. If a journal is not available, updates will not be allowed. If updates are made using a batch job, selecting this option will require that the batch job have a journal defined to it that will allow roll forward logging to be performed. (FRCVOPT=X'80')

No Updates without CK Logging

File is not updated unless checkpoint logging is active.The default is null.

This option requires that a checkpoint data set be defined to the run. Updates will not be allowed unless a checkpoint data set is present. If updates are made using a batch job, the job must have a checkpoint data set. (FRCVOPT=X'40')

All Updates Applied During RF

All updates to the file are applied when the file is rolled forward. The default is null.

This option will apply all updates during roll forward and not back out any incomplete update transactions. This option can only be used if Transaction back out (TBO) is turned off. This can be useful if a large number of updates are made without a commit being issued. It is suggested that after recovery has been run against a file with this option that a REORG be run against this file to ensure that the data and the indexes are in sync. (FRCVOPT=X'09')

No Discontinuities Allowed

Only updates that do not result in discontinuities are applied to the file. The default is null.

A discontinuity is an event that cannot be rolled back past during recovery. It will process the file using the discontinuity as a checkpoint for roll back and roll forward recovery. Essentially, a discontinuity creates a checkpoint for the file in question at the point in time when the discontinuity occurs. There is really no reason not to allow discontinuities. (FRCVOPT=X'10')

  1. Format File During CREATE: FILEMGMT formats the file during file creation. Valid values are Y and N. Rocket Software recommends that you use the default value, Y, in order to maintain file integrity.
  2. Verify Disk Updates: FILEMGMT verifies all updates made to the file during file creation. Valid values are Y and N. Rocket Software recommends that you use the default value, N. The computer does its own verification of disk updates, so this option is no longer necessary and likely to cause overhead.

Resetting file parameters

Select the FILE Maintenance RESET function (number 2) from the primary screen. FILEMGMT displays the first of the two Reset screens, the File Parameter Reset screen:

  • File Parameter Reset screen:

    FILEMGMT File Parameter Reset Screen Page 1 of 2 Filename: METADATA FICREATE: 7.1 LANGUAGE: US Inactive FILE MODEL OPTIONS FILEMODL X' 00 ' None:X 1nf:_ Numeric Validation:_ TABLE B AND D AND X AUTOMATIC INCREASE OPTIONS: Table B Auto Increase: Pages: __ Table D Auto Increase: Pages: __ Table X Auto Increase: Pages: __ BRSV: 200 DRSV: 15 % DPGSRES: 2 XRSV: BREUSE: FILE OPTIONS: FOPT X' 00 ' Disable Lock Pending Updates: _ Only FM Defines New Fields: _ No Procedure Statement Labels:_ No Procedure Statement Numbers: _ Enable Date Time Stamp: N FILE RECOVERY OPTIONS FRCVOPT X' 00 ' Disable Transaction Backout: _ No Rollforward (RF): _ No RF Logging: _ No Checkpoint (CK) Logging: _ No Updates Without RF Logging:_ No Updates Without CK Logging: _ All Updates Applied During RF:_ No Discontinuities Allowed: _ ===> < FIM314 You have selected Datetime Stamp, hit PF11 to define attributes 1=HELp 2= 3=QUIt 4=FIELDs 5= 6=COMmands 7= 8=FORward 9= 10= 11=ATTributes 12=END

  • File Security Reset screen

    Press PF8 (FORward) to display the File Security Reset screen:

FILEMGMT File Security Reset Screen Page 2 of 2 Filename: ABC Inactive FILE ACCESS OPENCTL X' 80 ' Public: X Semipublic: _ Private: _ Record Security: REMOTE FILE ACCESS PRIVILEGES NO/INV PWD: _ VALID PWD: _ GROUP MEMBER: _ DEFAULT FILE PRIVILEGES PRIVDEF X' BFFF ' File Manager: X Record Security Override: _ View File Parms: X RETRIEVE DATA WITH PROCEDURES Adhoc: X Internal: X External: X UPDATE DATA WITH PROCEDURES Adhoc: X Internal: X External: X INTERNAL PROCEDURES Display/Copy: X Define: X Change: X Delete: X Include: X DEFAULT FIELD LEVEL SECURITY SELLVL: 0 READLVL: 0 UPDTLVL: 0 ADDLVL: 0 DEFAULT PROCEDURE CLASS PRCLDEF: 0 ===> 1=HELp 2= 3=QUIt 4= 5= 6=COMmands 7=BACkward 8= 9= 10= 11= 12=END

You use the Reset screens to change the values of Model 204 file parameters that were originally set on the File Definition screens or the File Size Definition screen. FILEMGMT stages the file for a RESET command in response to your input.

The Reset screens display the file parameters that can be reset. File parameters not displayed on the Reset screens can be changed only by recreating the file.

For some of the file parameters shown on these screens, you specify an actual parameter value. For others, you select options, and FILEMGMT uses your selections to compute appropriate values for the FOPT, FRCVOPT, OPENCTL, and PRIVDEF parameters.

You need not fill in all values on all screens. Current parameter values are preserved for any parameters for which you do not enter values.

You can move freely between the two Reset screens by pressing the PF7 (BACkward) and PF8 (FORward) keys. FILEMGMT does not save any of the information you enter until you press one of the following function keys from either of the screens:

PF6 COMmands
PF12 END

The section Input for the File Parameter Reset screen describes the type of information you enter. For more information about parameter settings, refer to the Model 204 Parameter and Command Reference. For a discussion of how to select the most appropriate options for your particular file, refer to the Rocket Model 204 File Manager's Guide.

The cursor is initially positioned at the first input prompt on the first screen.

Input for the File Parameter Reset screen

You can select more than one option from an option category.

To select an option, type X or a numeric value.

To enter a null: type a space, press the ERASE EOF key, or preserve the default underscore character (_). Null indicates that you do not want to select the option.

Typing a character other than these is invalid, and produces an error message.

FILEMGMT displays and/or prompts you for the following information.

Prompt Response
Filename FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive.
Screen 1: File Parameter Reset screen
FICREATE Model 204 version number for the file you are creating. FILEMGMT uses this value to calculate the file size and validate certain Model 204 file features.
RDFS Reuse direct file space file. Prompted when the file has a pre-9.0 FICREATE and is an RDFS file (that is, entry-order reuse record numbers).
Reuse First For an RDFS file only. Record numbers are reused whenever possible by records as they are added.
Append First For an RDFS file only. Record numbers are reused only when no remaining space is at the end of the table.
FILE MODEL OPTIONS These and the FILEMODL parameter are explained in the Rocket Model 204 File Manager's Guide.
TableB Auto Inc Enter an x to select an option for automatic Table B increase. The default is None.
Full Table B will be automatically increased when Table B fills up by the amount specified in the parameter BAUTOINC.
At Open Table B will be automatically increased at file open time, if the increase using BAUTOINC pages would allow the last segment in the file to contain more than 25 percent of the number of records in one segment.
Pgs Enter the number of pages to increase Table B when the Full and/or At Open option is selected. BAUTOTYP is filled based on your selections. This sets the parameter BAUTOINC to the specified value.
TableD Auto Increase Pages If you want Model 204 to automatically increase Table D when it becomes full, enter the number of pages to add.
FILE OPTIONS Select file characteristics for the specified file. FILEMGMT computes the new value of the Model 204 FOPT parameter from your selections and displays the computed value.
Disable Lock Pending Updates Lock pending updates feature is disabled. If this option is selected, Disable Transaction Backout must also be selected. The default is null.
Only FM Defines New Fields New fields in the Model 204 file can be defined only by a user with file manager privileges. The default is null.
No Procedure Statement Numbers Statement numbers cannot be assigned to procedure lines. The default is null.
No Procedure Statement Labels Statement labels cannot be assigned to procedure lines. The default is null.
FILE RECOVERY OPTIONS Select file recovery characteristics for the specified file. FILEMGMT computes a new value for the Model 204 FRCVOPT parameter from your selections and displays the computed value.
Disable Transaction Backout File does not use the Model 204 transaction backout feature. This option is required if Disable Lock Pending Updates is selected. The default is null.
No Rollforward (RF) File does not use the roll forward facility of the RESTART command. The default is null.
No RF Logging Model 204 does not log changes to the journal file. The default is null.
No Checkpoint (CK) Logging Model 204 does not log checkpoint information to the checkpoint data set. The default is null.
No Updates Without RF Logging File is not updated unless roll forward logging is active. The default is null.
No Updates Without CK Logging File is not updated unless checkpoint logging is active. The default is null.
All Updates Applied During RF All updates to the file are applied when the file is rolled forward. The default is null.
No Discontinuities Allowed Only updates that do not result in discontinuities are applied to the file. The default is null.
BRESERVE Specify the number of bytes reserved for expansion on Table B pages. The maximum value is the value of PAGESZ-40. The default is 17.
DRESERVE Specify the percentage of space in a Table D page reserved for expansion. DRESERVE applies only to inversion pages. Valid values are 0-100. The default is 15.
DPGSRES

Specify the number of pages in Table D held in reserve. The file is marked full when the first of the DPGSRES pages is used, but transaction backout processing is allowed to continue.

Valid values are 1-32767. DPGSRES must be less than the value of DSIZE. The default is DSIZE/50 + 2; if DSIZE/50 + 2 is greater than 40, the default is 40.

BREUSE

For an unordered file only. Specified as a percentage of space on a page; it determines which pages can hold another record. To be reused for storing another record, the page must have the following minimum bytes of free space:

(usable page size - BRESERVE)*BREUSE + BRESERVE

Usable page size is the size of the page minus overhead. The default is 20.

Copying files

Select the File Management Copy function (number 5) from the primary screen. FILEMGMT displays the Copy screen:

FILEMGMT Copy Screen Filename: ABC Active Copy to FILE: WITH: _ 1. Records, Fields and Sizes 2. Records and Fields 3. Fields Only 4. No Records or Fields ===> 1=HELp 2= 3=QUIt 4= 5= 6= 7= 8= 9= 10= 11= 12=END

You use the Copy screen to copy an existing Model 204 file definition to a new file. You can optionally copy the file's record and field definitions when you copy the file.

A Copy operation is performed as soon as you leave the Copy screen. The copied files are staged for the CREATE command, and record and field definitions are staged for the DEFINE command. You must size the copied file before you can execute the CREATE command. The sizing links the file to a data set name.

The cursor is initially positioned at the Copy to FILE prompt.

Copy screen input

FILEMGMT displays or prompts you for the following information.

Prompt Response
Filename FILEMGMT displays the name of the file that you entered on the primary screen, and indicates whether the file is Active or Inactive.
Copy to FILE

Type the name of the new file to which FILEMGMT is to copy the existing file. The name must:

  • Have 1-8 characters (letters and/or numbers) and not contain any special characters.
  • Begin with a letter.
  • Not begin with the characters SYS, CCA, OUT, or TAPE.
Enter Number

Type one of the following numbers to indicate the scope of the copy operation:

  1. Records, Fields and Sizes-Copies size parameters as well as record and field data as in Selection #2.
  2. Records and Fields-Copies all field and corresponding record type definitions from the existing file to the new file.
  3. Fields Only- Copies field definitions but not the corresponding record type definitions from the existing file to the new file. Creates one record, which is staged for a DEFINE command and has a *REC DEFN REQD status.
  4. No Records or Fields-Copies neither record type nor field definitions to the new file. You can subsequently use the new file as a procedure file, or add different fields to the file.

If the source file is a Sorted, Hash and/or Record Security file, the sort, hash, and/or record security key fields are copied to the new file. One record is created; the record is staged for the DEFINE command and has a *REC DEFN REQD status.

Recreating files

A file recreate is necessary if, for example, you want to increase a table size that cannot be increased in the existing file. Recreating a file deletes all the data and procedures in the file, but leaves the field, record, and field group definitions intact. To preserve the data and procedures, you must dump or display the files and procedures. You cannot recreate a file from the primary screen, which has entities staged with commands.

To recreate a file:

Select the File Maintenance Recreate function from one of the following:

  • Primary screen if the file is an existing file.
  • File Size Definition screen if the file is existing or staged, and if the sizing calculations show some tables are so large that the file needs to be recreated. (See Sizing an existing file.)

When you select the Recreate function, FILEMGMT creates a version of all field, record, and field group definitions and stages them for DEFINE. The steps for recreating a file are thereafter similar to the steps for creating a file described in Overview of creating files.

The Recreate function uses the same Definition screens as the CREATE function.

You can select the Size function to resize the file after you redefine the file on the Definition screens.

Deleting files

To stage a file for deletion from the dictionary:

  1. Enter the file name on the primary screen.
  2. Select the Delete function.
  3. Press Enter.

The File Delete screen is displayed.

FILEMGMT File Delete Screen FILENAME: ABC Inactive FICREATE: 6.1 FILEORG: Entry Order PAGESZ: 6184 ASIZE: 3 BSIZE: 15 DSIZE: 4 ESIZE: 0 PROCS ------------ ------------ ------------ ------------ ---------- ASTRPPG: 614 BRECPPG: 256 DRESERVE: 15 % EHIGHPG: CUR: 0 ATRPG: 1 BRESERVE: 17 PDSIZE: 1 EXP: 0 FVFPG: 1 RECS: 1000 PDSTRPPG: 128 AVPG: 1 MVFPG: 1 DPGSRES: 2 CSIZE: 1 FREESIZE: Total Space Pages: 5049 DDname Dataset Name ( 1 of 1 ) Device Trks/Blks ABC M204.ABC 3390 632 ===> 1=HELp 2= 3=QUIt 4= 5= 6=COMmands 7= 8= 9= 10= 11= 12=END

The File Delete Screen duplicates the information on the File Size Definition screen.

The screen does not accept input from you. However, you can select any of the following commands.

Note

The File Management DELETE command is staged on this screen and executed on the Execute Commands screen. FILEMGMT removes all file, field, record, and field group entries from the dictionary when it executes the DELETE. References to the deleted entries are also deleted. No Model 204 command is executed, except for the OPEN command required to perform deletions. To release the disk space, you must use the IBM operating system commands.

File Delete screen commands

To issue a command, press a PF key or type a command name at the prompt (===>) and press Enter.

Key Command Meaning
PF1 HELp Displays HELP text for the File Delete screen.
PF3 QUIt Exits from the File Delete screen and returns to the primary screen without making any changes.
PF6 COMmands Stages the file for DELETE. Proceeds to the Execute Commands screen. This screen displays the staged commands that were generated for the file and allows you to select the commands you want to execute.
PF12 END Stages the file for DELETE. Exits from the File Delete screen and returns to the primary screen. You can proceed to the Execute Commands screen by pressing PF6 on the primary screen.