2.2.28 Operands related to table or index reservation count
- 135) pd_assurance_table_no = table-reservation-count
- ~<unsigned integer>((0-4194294500))<<500>>
- Specifies the maximum number of tables that can use the free space reusage facility. For details about the free space reusage facility, see the HiRDB Version 9 Installation and Design Guide. For this operand, make sure that you enter the value described in Specification guidelines.
- The free space reusage facility can be used if the number of target tables is no greater than the value of this operand. If the number of target tables is greater than this operand's value, the free space reusage facility can no longer be used.
- Specification guidelines
- The following explains how to determine this operand's value.
- Count each table as one.
- For a row-partitioned table, count each partition as one.
- If the inner replica facility is used, count any table stored in a replica RDAREA as a separate table.
- For a HiRDB parallel server configuration, the specified value is applied to each back-end server. Obtain the value for each back-end server, and then specify the largest value in this operand.
- Specify the following value.
Current number of tables using free space reusage facility + number of tables using free space reusage facility to be defined between next HiRDB startup and termination
- Notes
- If the specified value is unnecessarily large, a shared memory shortage might prevent HiRDB (the back-end server for a HiRDB parallel server configuration) from starting. For the formula for calculating the size of shared memory, see the HiRDB Version 9 Installation and Design Guide.
- Effects on individual estimation formulas
- If the value of the pd_assurance_table_no operand is changed, the following estimation formulas are affected:
- HiRDB Version 9 Installation and Design Guide:
- Formula 2 under Formulas for shared memory used by a single server
- Formula 2 under Formulas for the size of the shared memory used by a back-end server
- 136) pd_assurance_index_no = index-reservation-count
- ~<unsigned integer>((50-4194294500))<<2500>>
- 0904 compatibility mode: <<500>>
- Specifies the number of indexes that can be used. For this operand, make sure that you enter the value described in Specification guidelines. If the number of indexes is equal to or less than the value of this operand, the index management information can be made resident in memory; this results in the following benefits:
- Performance is improved because index information is made resident in memory
- Statistical information is collected for indexes
- Output of duplicated messages is suppressed
- After free index pages have been released, the unused pages in used segments can be allocated preferentially.
- If the number of indexes exceeds this operand value, these benefits are no longer applicable.
- Specification guidelines
- The following explains how to determine this operand value.
- Count each index as one.
- For a row-partitioned index, count each partition as one. For example, three partitions result in 3.
- If the inner replica facility is used, count any index stored in a replica RDAREA as a separate index.
- For a HiRDB parallel server configuration, the specified value is applied to each back-end server. Obtain the value for each back-end server, and then specify the largest value in this operand.
- Specify the following value:
Current number of indexes + number of indexes to be added between next HiRDB startup and termination
- Notes
- If the specified value is unnecessarily large, a shared memory shortage might prevent HiRDB (the back-end server for a HiRDB parallel server configuration) from starting.
- For the formulas used to calculate the size of shared memory, see the HiRDB Version 9 Installation and Design Guide.