4.2.10 Operands related to temporary tables

39) pd_max_temporary_object_no = maximum-number-of-temporary-tables-and-temporary-table-indexes-used-at-any-one-time
~<unsigned integer> ((0-131072))
Specifies the maximum number of temporary tables and temporary table indexes that can be used at any one time for each server.
Specification guidelines
Use the formula shown below to determine the value of this operand. For a HiRDB parallel server configuration, obtain the value for each back-end server.
Maximum value of (the number of transaction-specific temporary tables
+ total number of temporary table indexes for those temporary tables) [Figure] number of activities#
+ (number of SQL session-specific temporary tables used in the SQL session
+ total number of temporary table indexes for those temporary tables) [Figure] number of connected users
#
number of activities:
((value of pd_max_users + 3) [Figure] 2 + 1) + [Figure]
[Figure]: If the value specified for pd_max_users is 60 or less, 5; if it is 61 or greater, 0.
For a HiRDB parallel server configuration, this operand value is applied to each back-end server. Therefore, as a guideline, specify the largest value used among all back-end servers in this operand.
Operand default value
If this operand is omitted, the value specified for the same operand in the system common definition takes effect. If the same operand is also omitted from the system common definition, 600 is assumed. However, if 0904 compatibility mode is applied, 0 is assumed.
Relationship to other operands
This operand is related to the pd_max_tmp_table_rdarea_no operand.
Effects on individual estimation formulas
If the value of the pd_max_temporary_object_no operand is changed, the following estimation formulas are affected:
HiRDB Version 9 Installation and Design Guide:
  • Formula 8 under Formulas for shared memory used by a single server
  • Formula 8 under Formulas for the size of the shared memory used by a back-end server