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

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

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.