To determine the table definition information buffer size per table, use the following approximation formulas. Note that for a view table, also determine the size of the base table or foreign table that becomes the base for the view table.
Table type | Formula for determining the table definition information buffer size per table (in kilobytes) |
---|---|
Table definition information buffer size per base table | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Table definition information buffer size per view table | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Table definition information buffer size for reflection status management table (HiRDB Staticizer Option) | ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
If any of the following conditions is applicable, the value of DEFINITION_CACHE_SIZE cannot be determined, even if a dictionary table is retrieved:
#1: In this case, the value in DEFINITION_CACHE_SIZE is not the correct value.
#2: Whether a table has been converted from 32-bit-mode HiRDB to 64-bit-mode HiRDB can be determined by looking at the time of execution of the pdvrup command and the time of table creation. If the table's creation time is earlier, the table has been converted from the 32-bit mode to the 64-bit mode. The pdvrup command's execution time can be determined from CHANGE_TIME of MASTER.SQL_TABLES in the SQL_TABLES dictionary table. A table's creation time can be determined from CREATE_TIME for the created table in the SQL_TABLES dictionary table. These columns can be retrieved with the following SQL statements:
select CHANGE_TIME from MASTER.SQL_TABLES
where TABLE_SCHEMA='MASTER'
and TABLE_NAME='SQL_TABLES'
select CREATE_TIME from MASTER.SQL_TABLES
where TABLE_SCHEMA='authorization-identifier'
and TABLE_NAME='table-name'
Use the following formulas to determine the table definition cache size.
Formula type | Formula |
---|---|
Formula 1 | ![]() 0.6 + 0.13 ![]() ![]() ![]() ![]() ![]() 0.9 + 0.19 ![]() ![]() ![]() ![]() |
Formula 2 | ![]() (0.02 + 0.01 ![]() ![]() ![]() 0.02 ![]() ![]() ![]() ![]() 0.3 ![]() ![]() ![]() 0.3 ![]() ![]() 0.01 ![]() ![]() 0.01 ![]() ![]() ![]() ![]() ![]() 0.3 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 1.3 ![]() ![]() 0.2 + 0.1 ![]() ![]() 0.1 ![]() ![]() ![]() ![]() ![]() 0.1 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() 0.08 ![]() |
Formula 3 | ![]() 0.1 + (0.1 ![]() ![]() 0.3 ![]() |