8.2.18 Operands related to the work table files

59) pdwork -v "HiRDB-file-system-area-name"[,"HiRDB-file-system-area-name"]...
~<path name of up to 141 characters>
Specifies the names of HiRDB file system areas for work table files. Work table files are used for temporary storage of information during execution of SQL statements; they are created automatically by HiRDB. For details about the SQL statements that require work table files, see Overview of the work table file in the HiRDB Version 9 Installation and Design Guide.
You must not omit this operand, because doing so might prevent execution of SQL code that requires work table files.
Notes
  • Specify in this operand the HiRDB file system area that was initialized using the pdfmkfs command.
  • If the size of the work table file is large, specify a large HiRDB file system area. For details about how to estimate the work table file size, see the HiRDB Version 9 Installation and Design Guide.
    When an HiRDB file system area is set up initially with the pdfmkfs -a command, HiRDB will extend the area automatically whenever the amount of space specified in the -n option is used up. For details about the pdfmkfs command, see the manual HiRDB Version 9 Command Reference.
  • The HiRDB file system areas for work table files must be different from the HiRDB file system areas for system files and RDAREAs.
  • If more than one HiRDB file system area is specified in this operand, and one of these HiRDB file system areas generates an error when an attempt is made to create a work table file in it, that file system area will usually not be used thereafter. Instead, only the other specified HiRDB file system areas will be used.
    However, if subsequent attempts to create work table files fail in all of the other specified HiRDB file system areas (due to reasons such as insufficient space or an excessive numbers of files), creation of a work table file will be attempted in the HiRDB file system area that had been taken out of use. If a work table file can be created in it normally, that HiRDB file system area will then be used.
    Note that when a back-end server is shut down and restarted, a HiRDB file system area that was not being used because it had generated an error during work table file creation becomes usable again.
Operand rules
  • At least one HiRDB file system area must be specified.
  • A maximum of 16 HiRDB file system areas can be specified.
  • This operand can be specified only once in the back-end server definition. If it is specified more than once, the first specification is effective.
  • The specified HiRDB file system areas must not be used for other back-end servers.
  • Do not specify a HiRDB file system area that is being used by a dictionary server.
  • When you are specifying multiple HiRDB file system areas, those created in character special files can coexist with those created in regular files.