Resetting file parameters with FILEMGMT

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 File Parameter Reset screen, the first of the two Reset screens:

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: _ ===> 1=HELp 2= 3=QUIt 4=FIELDs 5= 6=COMmands 7= 8=FORward 9= 10= 11=ATTributes 12=END

You can press F8 (FORward) to display the File Security Reset screen:

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

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 F7 (BACkward) and F8 (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:

F6	COMmands
F12	END

The Input for the File Parameter Reset screen section describes the type of information you enter.

• For more information about parameter settings, select the parameter you want from the list of Model 204 parameters.
• For a discussion about how to select the most appropriate options for your particular file, refer to File design.

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, or preserve the adjacent 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.
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 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	For more information about these, see File model feature and FILEMODL parameter.
TableB Auto Increase Pages	If you want Model 204 to automatically increase Table B when it becomes full, enter the number of pages to add. The parameter BAUTOINC is set to your 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.
TableX Auto Increase Pages	If you want Model 204 to automatically increase Table X when it becomes full, enter the number of pages to add.
BRSV	Specify BRESERVE, the number of bytes reserved for expansion on Table B pages. The maximum value is the value of PAGESZ-40. The default is 17.
DRSV	Specify DRESERVE, 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 DPGSRES, 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.
XRSV	Specify XRESERVE, the number of bytes of space in a Table X page reserved for expansion. Valid values are 0-6140. The default is 17.
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 number of 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.
FILE OPTIONS	Select file characteristics for the specified file. FILEMGMT computes the new value of the Model 204 FOPT parameter from your selections, and it 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.