10.3.6 Operands related to temporary tables
- 7) pd_max_tmp_table_rdarea_no = maximum-number-of-temporary-table-RDAREAs
- ~<unsigned integer>((0-131088))
- Operand default value
- Default value in recommended mode: The value calculated by the following formula is assumed:
default value = min (131088, pd_max_rdarea_no-3)
- Default value in 0904 compatibility mode: 0
- Specifies the maximum number of temporary table RDAREAs. If the total number of temporary table RDAREAs exceeds this operand value, HiRDB cannot start.
- Specification guidelines
- Specify the total number of temporary table RDAREAs including those that will be added in the future.
- For a HiRDB parallel server configuration, this operand value is applied for each back-end server. Therefore, as a guideline, specify this operand value based on the back-end server that uses the largest number of temporary table RDAREAs.
- Notes
- This operand value affects the size of shared memory used by HiRDB; therefore, do not specify a value that is greater than the value described in Specification guidelines. If the specified value is greater than the value described in Specification guidelines, HiRDB might not be able to start due to a shortage of shared memory.
- Make sure that this operand's value is less than the pd_max_rdarea_no operand's value.
- If the pd_max_temporary_object_no operand's value is 1 or greater, this operand must also specify a value of 1 or a greater.
- Relationship to other operands
- This operand is related to the following operands:
- pd_max_rdarea_no
- pd_max_temporary_object_no
- Effects on individual estimation formulas
- If the value of the pd_max_tmp_table_rdarea_no operand is changed, the following estimation formulas are affected:
- HiRDB Version 9 Installation and Design Guide:
- Formula 9 under Formulas for shared memory used by a single server
- Formula for the shared memory used by a front-end server