Operands related to temporary tables

28) 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.

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) +

: If the value specified for pd_max_users is 60 or less, 5; if it is 61 or greater, 0.

Operand default value: If this operand is omitted, the value specified for the same operand in the server common definition or the system common definition is used, in that order. If this same operand is also omitted from the server common definition and 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 formula is affected:

HiRDB Version 9 Installation and Design Guide:

Formula 8 under Formulas for the size of the shared memory used by a back-end server

8.2.10 Operands related to temporary tables