This statement creates a media catalog.
Definition
A lower-level DBH option of FILE-RESOURCES
Function
The media catalog contains storage information for certain DBH-specific files: the transaction log files (TA-LOG files), the restart log file (WA-LOG), the temporary work files and the cursor files. The media catalog defines the volumes on which these files are to be stored. The media catalog does not exist in the form of a file. It is kept in the DBH's memory and is only valid for one DBH session.
The DBH option MEDIA-CATALOG allows you to specify the storage information in the media catalog.
The DBH does not store this information on the files of the media catalog in the transaction log file. The information is therefore not failproof. In the event of an external restart, you can, if required, specify other volumes for media-catalog files.
There are 2 transaction log files (TA-LOG files). The operand TALOG-SUPPORT applies to both of these files.
These specifications only have an effect if the corresponding file does not yet exist.
MEDIA-CATALOG | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Operands
MEDIA-CATALOG = *STD
All the files in the media catalog are created on a public disk.
MEDIA-CATALOG = *PARAMETERS(...)
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 0..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 0..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 operand 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.
CURSOR-MEDIA =
Defines the volume for cursor files.
Files that have been created are reused when they are unlocked. This applies both to internal cursor files and CALL DML-specific cursor files.
CURSOR-MEDIA = *STD
The DBH creates the cursor files on a public disk.
CURSOR-MEDIA = *PARAMETERS(...)
SUPPORT-n =
n = 1...5
You can define the volumes for the two cursor files SESAM cn.CURSOR.0001 and SESAM cn.CURSOR.0002 (or for the linked-in DBHs SESLK cn.CURSOR.0001 and SESLK cn.CURSOR.0002) yourself, up to five different specifications being permitted (SUPPORT-1... SUPPORT-5). SESAM/SQL creates a maximum of two cursor files. The values entered for SUPPORT-1 determine which medium the first required cursor file with the suffix “0001” or “0002” will be created on. The values entered for SUPPORT-2 determine which medium the second required cursor file with the suffix “0001” or “0002” will be created on. The values entered for SUPPORT-3 to SUPPORT-5 are evaluated only if the media specified for SUPPORT-1 or SUPPORT-2 are not available or if there is insufficient space. The media are used in the specified order. The operands are identical with those in the operand description for TA-LOG-SUPPORT. After the entry with number 5 has been used, the cycle begins again with 1 if 1 has not yet been attempted for this file.