Resetting file parameters with FILEMGMT: Difference between revisions

From m204wiki
Jump to navigation Jump to search
No edit summary
mNo edit summary
 
Line 81: Line 81:


<p>
<p>
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 <var>[[FOPT parameter|FOPT]]</var>, <var>[[FRCVOPT parameter|FRCVOPT]]</var>, <var>[[OPENCTL parameter|OPENCTL]]</var>, and <var>[[PRIVDEV parameter|PRIVDEF]]</var> parameters.</p>
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 <var>[[FOPT parameter|FOPT]]</var>, <var>[[FRCVOPT parameter|FRCVOPT]]</var>, <var>[[OPENCTL parameter|OPENCTL]]</var>, and <var>[[PRIVDEF parameter|PRIVDEF]]</var> parameters.</p>
<p>
<p>
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.</p>
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.</p>

Latest revision as of 19:47, 12 August 2014

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.