Resetting file parameters with FILEMGMT

From m204wiki
Jump to navigation Jump to search

You use the Reset screens to change the values of Model 204 file parameters that you 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.

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 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 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

For some of the file parameters shown on the Reset 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.

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.