Changes the options for subsequent RECOVER or REFRESH runs
Scope of validity
DBH administration
See also
DBH option RECOVER-OPTIONS on "RECOVER-OPTIONS"
Function
You use the MODIFY-RECOVER-OPTIONS statement to change the following for subsequent RECOVER or REFRESH runs:
The size of the buffer for system-access data
The size of the buffer for user data
The storage information for the transaction log files (TA-LOG files)
The storage information for the restart log file (WA-LOG file)
If you change the storage information for the transaction log files or the restart log file, SESAM/SQL causes all service tasks to delete their TA-LOG or WA-LOG files. The new storage information for the TA-LOG or WA-LOG files then becomes effective upon the next request to the service task.
MODIFY-RECOVER-OPTIONS | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Operands
RECOVER-OPTIONS = *STD
The default values are used for all options (see the description of the operands below).
RECOVER-OPTIONS = *PARAMETERS(...)
Changes the settings for the options concerned.
SYSTEM-DATA-BUFFER = *UNCHANGED / *STD / <integer 80..1000000>
Size of the buffer for system-access data in a RECOVER or REFRESH run in units of 1 Kbyte.
USER-DATA-BUFFER = *UNCHANGED / *STD / <integer 80..1000000>
Size of the buffer for user data in a RECOVER or REFRESH run in units of 1 Kbyte.
MEDIA-CATALOG = *STD
The TA-LOG and WA-LOG files are created with default values on a public disk.
MEDIA-CATALOG = *PARAMETERS(...)
Changes the settings for the TA-LOG and WA-LOG files.
TALOG-SUPPORT =
Defines the volume for the TA-LOG files.
There are a total of two TA-LOG files (TA-LOG1, TA-LOG2) that are written to one after the other in rotation.
TALOG-SUPPORT = *PUBLIC-DISK(...)
Causes the TA-LOG files to be created on a public disk.
CAT-ID = *STD / <cat-id>
Catalog ID of the pubset on which the files are to be stored. The default is the DBH catalog ID.
PRIMARY-ALLOCATION = *STD / <integer 1..16777215>
Number of PAM pages for the initial allocation of memory space.
The specified number of PAM pages is reserved immediately. It should correspond to the expected file size.
The DBH calculates the default value internally. If you enter a value lower than the calculated default, the DBH uses the default.
SECONDARY-ALLOCATION = *STD / <integer 1..32767>
Number of PAM pages for subsequent extensions to files
The DBH calculates the default value internally. If you enter a value lower than the calculated default, the DBH uses the default.
TALOG-SUPPORT = *PRIVATE-DISK(...)
The TA-LOG files are to be created on a private disk. To do this, you must make an entry for DEVICE-TYPE.
CAT-ID = *STD / <cat-id>
Catalog ID of the pubset on which the files are to be stored. The default is the DBH catalog ID.
PRIMARY-ALLOCATION = *STD / <integer 1..16777215>
Number of PAM pages for the initial allocation of memory space.
The specified number of PAM pages is reserved immediately. It should correspond to the expected file size.
The DBH calculates the default value internally. If you enter a value lower than the calculated default, the DBH uses the default.
SECONDARY ALLOCATION = *STD / <integer 1..32767>
Number of PAM pages for subsequent extensions to files
The DBH calculates the default value internally. If you enter a value lower than the calculated default, the DBH uses the default.
DEVICE-TYPE = <structured-name 1..8>
BS2000 device type to which the required disks are assigned.
If you make an incorrect entry, the DBH aborts the start procedure.
VOLUME = list-poss(6): <alphanum-name 1..6>
VSNs of the disks on which the files are to be created.
Up to 6 VSNs are permitted, each of which can be specified only once.
VOLUME is not evaluated unless the DEVICE-TYPE parameter is specified.
WALOG-SUPPORT =
Defines the volume for the WA-LOG file.
The operands are identical to those in the operand descriptions for TALOG-SUPPORT.
Administration command in ISP format and at the CALL DML interface
The OPT,RECOVER administration command corresponds to the MODIFY-RECOVER-OPTIONS administration statement here.
OPT,RECOVER[,S[YSTEM-DATA]-B[UFFER]=m][,U[SER-DATA]-B[UFFER]=n]
[,{T[ALOG]-STD | talog-spec}][,{W[ALOG]-STD | walog-spec}]
talog-spec ::= T[ALOG]-V[OL]=(vsn)[,T[ALOG]-D[EV]=device]
[,T[ALOG]-S[PACE]-P[RIMARY]=space]
[,T[ALOG]-S[PACE]-S[ECONDARY]=space]
[,{T[ALOG]-C[ATID]-STD | T[ALOG]-C[ATID]=cat-id}]
walog-spec ::= W[ALOG]-V[OL]=(vsn)[,W[ALOG]-D[EV]=device]
[,W[ALOG]-S[PACE]-P[RIMARY]=space]
[,W[ALOG]-S[PACE]-S[ECONDARY]=space]
[,{W[ALOG]-C[ATID]-STD | W[ALOG]-C[ATID]=cat-id}]
If a parameter is not specified, its setting remains unchanged.
The value 0 or <integer 80..1000000> may be entered for m and n.
When 0 is entered the default value of the DBH option is used, i.e. SYSTEM-DATA-BUFFER=*STD or USER-DATA-BUFFER=*STD.
The values defined beforehand for the relevant operands may be entered for vsn, device, space and cat-id.
When TALOG-STD or WALOG-STD is entered, the default values defined beforehand for the relevant operands are used for the file.
Multiple volumes vsn are specified separated by commas.
If a file is to reside on a public volume, the word PUBLIC (with or without parentheses) is specified in place of (vsn).
space is used to specify the values for PRIMARY- and SECONDARY-ALLOCATION. If 0 is specified, the default value is set for these parameters, as it is forTALOG-STD and WALOG-STD.
The default catalog ID of the DBH is selected with TALOG-CATID-STD or WALOG-CATID-STD.
In INFORM-PROGRAM administration you must adhere to the permissible length for talogspec and walog-spec (see section “Administration using INFORM-PROGRAM”).