2.3.22 Operands related to table or index reservation count

118) pd_assurance_table_no = minimum-guaranteed-tables-count
[Figure]<unsigned integer>((0-4194294500))<<500>>
If you use the free space reusage facility, consider whether to specify this operand. For details about the free space reusage facility, see the HiRDB Version 8 Installation and Design Guide. Specifies the minimum guaranteed value for the table reservation count.
If the current number of tables that have been defined is equal to or less than the table reservation count, the free space reusage facility can be used because the table management information can be made resident in memory. If the current number of tables that have been defined exceeds the table reservation count, the free space reusage facility can no longer be used. Note that, for a HiRDB/Parallel Server, the table reservation count is applied to each back-end server. For example, if the table reservation count is 500, the table reservation count of each back-end server is 500.
Specification guidelines
  • When the pd_sysdef_default_option operand is omitted or when recommendable 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 v6compatible or v7compatible is specified in the pd_sysdef_default_option operand
    When HiRDB is started normally, the table reservation count automatically increases according to the number of tables for which the free space reusage facility is specified. Therefore, normally you need not specify this operand. However, if you add 101 or more tables that use the free space reusage facility between the startup and termination of HiRDB, specify the larger of the following two values as the table reservation count for this operand.
  1. 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
  2. current-number-of-tables-using-free-space-reusage-facility + 100
Notes
  • For a HiRDB/Parallel Server, compute the table reservation counts for the individual back-end servers and specify the largest among them for this operand.
  • For a row partitioned table, count each partitioned table as one table.
  • If the specified value is unnecessarily large, a shared memory shortage may prevent HiRDB (the back-end server for a HiRDB/Parallel Server) from starting. For the formula for computing the size of shared memory, see the HiRDB Version 8 Installation and Design Guide.
  • When v6compatible or v7compatible is specified in the pd_sysdef_default_option operand and the pd_bes_shmpool_size or pd_sds_shmpool_size operand is omitted in order to use the facility for automatically computing the shared memory size, make sure that the value of this operand is at least equal to the number of tables using the free space reusage facility at system startup plus 100.
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
119) pd_assurance_index_no = minimum-guaranteed-indexes-count
[Figure]<unsigned integer>((50-4194294500))<<500>>
Specifies the minimum guaranteed value for the index reservation count. When the index reservation count is equal to or less than this operand's value, 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
If the index reservation count exceeds this operand's value, these benefits may no longer be applicable.
In the case of a HiRDB/Parallel Server, note that this operand's value applies to each back-end server. For example, if this operand is set to 600, the minimum guaranteed index reservation count is 600 for each back-end server.
Specification guidelines
Specify in this operand the value obtained from the following formula:
Current index reservation count + number of indexes to be added before the next HiRDB startup
The following describes how to calculate the index reservation count:
  • Count 1 index reservation for each index.
  • In the case of a row-partitioned index, count 1 index reservation for each partition (for example, 3 partitions results in an index reservation count of 3).
  • For a HiRDB/Parallel Server, compute the index reservation counts for the individual back-end servers and specify the largest among them for this operand.
If v6compatible or v7compatible is specified in the pd_sysdef_default_option operand, the index reservation count is obtained automatically by HiRDB, so normally you will not need to specify this operand in such a case. However, if the number of indexes you define exceeds 1.2 times the number of indexes in existence at the time of HiRDB startup, then at some point between startup and termination of HiRDB you must specify this operand in accordance with the guidelines provided above. For a HiRDB/Single Server, the index reservation count for the data dictionary table (124) must also be included, so you must add 124 to your obtained value.
Notes
  • If the specified value is unnecessarily large, a shared memory shortage may prevent HiRDB (the back-end server for a HiRDB/Parallel Server) from starting.
    For the formula for computing the size of shared memory, see the HiRDB Version 8 Installation and Design Guide.
  • When v6compatible or v7compatible is specified in the pd_sysdef_default_option operand and the pd_bes_shmpool_size or pd_sds_shmpool_size operand is omitted in order to use the facility for automatically computing the shared memory size, make sure that the value of this operand is greater than 1.2 times the number of indexes in existence at the time of system startup.
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 + 50
HiRDB/Parallel Serverrecommendable (default value)500
v6compatible or v7compatible50
  • If you use the facility for automatically computing the shared memory size by omitting the pd_bes_shmpool_size operand in the server common definition, you must specify for the pd_assurance_index_no operand a value that is larger than 1.2 times the index count at the system startup.