If no stored procedure is used, the following formula can be used to obtain the size of the memory that is allocated during SQL preprocessing (KB).
![]() (2539 + Si ![]() ![]() ![]() ![]() ![]() ![]() ![]() + Di ![]() ![]() ![]() ![]() ![]() ![]() ![]() + Ti ![]() ![]() ![]() ![]() + MAX(Ti ![]() ![]() ![]() ![]() + MAX{MAX(Ti, Ori + Gi + Si + Fi), Sli - 1} ![]() } ![]() ![]() ![]() ![]() (KB) |
|
If stored procedures are used, the size of the memory (in KB) to be allocated during SQL preprocessing is the value obtained from the formula shown in (1) above plus the length of the procedure control object for each stored procedure. For the formula for obtaining the length of a procedure control object, see the section on the pd_sql_object_cache_size operand of the system common definition. For details about the length of the procedure control object per stored procedure, see Formula for determining the size of the routine control object of a routine in the manual HiRDB Version 8 System Definition.