2.2.28 Operands related to table or index reservation count

155) 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.
  • For a HiRDB/Parallel Server, 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.
  • When the pd_sysdef_default_option operand is omitted or when recommendable or v6compatible is specified in the pd_sysdef_default_option operand
    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
  • When v7compatible is specified in the pd_sysdef_default_option operand
    Current number of tables using free space reusage facility + MAX(number of tables using free space reusage facility to be defined - between next HiRDB startup and termination, 100)
Note
If the specified value is unnecessarily large, a shared memory shortage might prevent HiRDB (the back-end server for a HiRDB/Parallel Server) from starting. For the formula for calculating the size of shared memory, see the HiRDB Version 9 Installation and Design Guide.
Relationship to other operands
This operand's default value depends on the value specified in the pd_sysdef_default_option operand, as shown below:
  • recommendable (default value): 500
  • v6compatible: 0
  • v7compatible: 100
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
156) pd_assurance_index_no = index-reservation-count
~<unsigned integer>((50-4194294500))<<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.
  • For a HiRDB/Parallel Server, 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.
  • For a HiRDB/Single Server, if v6compatible or v7compatible is specified in the pd_sysdef_default_option operand, the index reservation count (240) for the data dictionary table must also be included. Add 240 to the obtained value.
  • When the pd_sysdef_default_option operand is omitted or when recommendable is specified in the pd_sysdef_default_option operand
    Current number of indexes + number of indexes to be added between next HiRDB startup and termination
  • When v6compatible or v7compatible is specified in the pd_sysdef_default_option operand
    MAX((current number of indexes + number of indexes to be added between next HiRDB startup and termination), (current number of indexes[Figure] 1.2))
Notes
If the specified value is unnecessarily large, a shared memory shortage might prevent HiRDB (the back-end server for a HiRDB/Parallel Server) from starting.
For the formulas used to calculate the size of shared memory, see the HiRDB Version 9 Installation and Design Guide.
Relationship to other operands
This operand's default value depends on the value specified in the pd_sysdef_default_option operand, as shown below:
HiRDB server typepd_sysdef_default_option operand valueDefault value
HiRDB/Single Serverrecommendable (default value)500
v6compatible or v7compatibleNumber of indexes in data dictionary table (240) + 50
HiRDB/Parallel Serverrecommendable (default value)500
v6compatible or v7compatible50