To use the automatic log unloading facility, the following environment settings are required:
The HiRDB administrator creates directories for unload log files. It is wise to check the availability of disk space before creating a directory. If the amount of available disk space is small, creation of the directory may result in a disk space shortage.
A HiRDB file system area for utilities must be created in order to create a directory for unload log files in an HiRDB file system area.
The required disk space can be determined from the following formula:
|
Although 128 directories for unload log files can be created, creating too many is not advisable. Four directories at the most are recommended so that their management does not become cumbersome. While a single directory is easy to manage, the automatic log unloading facility will stop if the disk becomes full or an error occurs.
When multiple directories are available, the automatic log unloading facility does not stop as long as unload log files can be created in at least one of the directories. For this reason, the directories should be created in different partitions.
To create unload log files in a HiRDB file system area, a HiRDB file system area must be created with the pdfmkfs command. Table 3-8 provides guidelines for the options that are specified in the pdfmkfs command.
Table 3-8 Guidelines for options to be specified in the pdfmkfs command (when unload log files are to be created in a HiRDB file system area)
pdfmkfs command option | Specification guideline |
---|---|
-k | Specify UTL as the usage objective. |
-n | For the HiRDB file system area length, specify the value determined by the following formula: total-number-of-records-in-system-log-files-to-be-unloaded ![]() system-log-file-record-length ![]() number-of-unload-log-files-to-be-created ![]() ![]() |
-l | For the maximum files count, specify the number of unload log files to be created. |
-e | For the maximum increments count, specify the number of unload log files to be created ![]() |
Specify in the pd_log_auto_unload_path operand the directories that have been created for unload log files.
When unload log files are to be created in an HiRDB file system area, specify the name of the HiRDB file system area.