The following formula is used to determine the size of the data dictionary LOB RDAREA for storing sources.

Formula

Size of data dictionary LOB RDAREA for source storage (bytes) ={ a [ Si 64,000 96 + 7 + 3 (a - 1)]#1 i=1 + b [ (Cj + 1,024) 8,192]#2 j=1 }#3 8,192#4

a: Number of HiRDB files that constitute the data dictionary LOB RDAREA for storing sources

b: Total number of procedures (CREATE PROCEDURE), functions and procedures in abstract data types (each FUNCTION (excluding plug-in functions) and PROCEDURE), and user-defined functions (CREATE FUNCTION)

S_i: Number of segments for each HiRDB file specified with the create rdarea statement of the database initialization utility or database structure modification utility.

C_j: Length of each procedure (length of each CREATE PROCEDURE), function and procedure in abstract data types (length of each FUNCTION (excluding plug-in functions) and PROCEDURE), and user-defined function (length of CREATE FUNCTION)

#1: Total number of pages in the directory pages part.

#2: Total number of pages in the data pages part.

#3: Indicates the total number of pages in the data dictionary LOB RDAREA for storing sources.

#4: Indicates the page length of the data dictionary LOB RDAREA for storing sources.

The following formula is used to estimate the size of the data dictionary LOB RDAREA for storing objects:

Formula

Size of data dictionary LOB RDAREA for object storage (bytes) ={ a [ Si 64,000 96 + 7 + 3 (a - 1)]#1 i=1 + b [ (Cj + 1,024) 8,192]#2 j=1 }#3 8,192#4 + 500,000#5

a: Number of HiRDB files that constitute the data dictionary LOB RDAREA for storing objects

b: Total number of procedures (CREATE PROCEDURE), functions and procedures in abstract data types (FUNCTION (excluding plug-in functions), PROCEDURE), user-defined functions (CREATE FUNCTION), and trigger definitions (CREATE TRIGGER).

S_i: Number of segments for each HiRDB file specified with the create rdarea statement of the database initialization utility (pdinit) or database structure modification utility (pdmod).

Cj: QO_i + PR (The formula for QO_i is shown in (3), and the formula for PR is shown in (4) The variables used in these formulas are shown in (5)).

#1: Total number of pages in the directory pages part.

#2: Total number of pages in the data pages part.

#3: Indicates the total number of pages in the data dictionary LOB RDAREA for storing objects.

#4: Indicates the page length of the data dictionary LOB RDAREA for storing objects.

#5: This is added when an abstract data type or plug-in function is used.

QOi (bytes) = a { i=1 1,840 + 46 RCN + 298 Si + 20 Pi + 1,138 Ti + 76 Ti Di + 80 Ci + 40 Ii + 534 Wi + 20 Ki + Li + 8 TCi + 656 Di + 48 nFF + 100 nFP + 148 nFC + 696 nPFF + 16 (nAT + nPAT) + 20 nCAT + 28 (nAF + nCAF) + 20 (nAA + nPAA + nCAA) + 1,057 nSPA + 120 nSPP + 287 nSFF + 8 nSFP + 813 nJFC + 20 nJFP [ + 1,057 nTR + 120 (nTSN + nTSO) + 20 (nTCN + nTCO)]#1 [ + 760 + 376 RCC + 1,880 RCT]#2 [ + 32 Si + 16]#3 [ + (42 SiT) + {52 + 152 (SiTA + SiSA + SiNA) (SiT + SiS + SiN)}]#4 }

a: Number of SQL statements in stored procedures

#1: Add this formula if you use triggers.

#2: Add this formula if you use referential constraints.

#3: This is the formula for determining the length of the Column Name Descriptor Area (SQLCNDA). Add it for dynamic SQL statements.

#4: This is the formula for determining the length of the Type Name Descriptor Area (SQLTNDA). Add it for dynamic SQL statements.

(a) When defined by the user

If you have defined a stored procedure, stored function, or trigger, use the following formula to determine the size of the routine control object:

PR (bytes) = a { i=1 600 + 28 sRi + 32 (sRUi + sDi) + 56 sSXi + sCUi + sSi + sPi + sLA + sKi + sL + 80 sWi + 24 sCM + 32 sCCR + 2 sDCR + 60 sCHD + 72 sDHD + 64 sHCN + 8 sCHD sHCN + 48 nRFF + 100 nRFP + 148 nRFC + 200 nPRFF + 8 nPRFP + 196 nPA + 64 nPP + 36 nPPI + 20 nPPO + 200 nPPA + 8 nPPP + 20 nAR + 48 nARA + 16 nRPAT + 20 nCAT + 28 (nRPAF + nRCAF) + 20 (nRPAA + nRCAA) + 287 nRSFF + 8 nRSFP + 813 nPJA + 20 nPJP + 813 nRJFC + 20 nRJFP [ + 28 (nTSN 2 + nTSO)]# }

a: Number of the following SQL statements:

• Procedures (CREATE PROCEDURE)
• Functions and procedures in abstract data types (each FUNCTION (excluding plug-in functions), PROCEDURE)
• User-defined functions (CREATE FUNCTION)
• Trigger definitions (CREATE TRIGGER)

#: Add this formula if you use triggers.

(b) When HiRDB creates automatically

If you specified CASCADE during table definition, use the following formula to determine the size of the routine control object when HiRDB creates triggers for constraint control:

PR (bytes) = a {240 + 608 RCC + (5,120 + 100 RDi + 256 RIi) RCP RCT} i=1

a: Number of the following SQL statements:

• Procedures (CREATE PROCEDURE)
• Functions and procedures in abstract data types (FUNCTION (excluding plug-in functions), PROCEDURE)
• User defined functions (CREATE FUNCTION)
• Trigger definitions (CREATE TRIGGER)

Variable name	Explanation
RCN	Total number of tables and indexes used by SQL objects
Si	Number of retrieval items in SQL statements (if the columns specified by SQL statements are index columns, the number of those columns)
Pi	Number of embedded variables or parameters in SQL statements
Ti	Number of table names in SQL statements
Ci	Number of column names in SQL statements
TCi	Number of table composition columns in SQL statements
Wi	Number of logical operators in SQL statements#
Ki	Number of literals in SQL statements#
Li	Total length of literals in SQL statements# (bytes)
Ii	Number of indexes used during SQL statement execution (of the tables specified by SQL statements, the number of indexes specified in retrieval conditions)
Di	Total number of storage conditions defined by tables used in SQL statements (count matrix partitioning tables twice)
SiT	Number of abstract data types in queries in SQL statements
SiS	Number of supertypes of abstract data types in queries in SQL statements
SiN	Number of subtypes of abstract data types in queries in SQL statements
SiTA	Number of attributes of abstract data types in queries in SQL statements
SiSA	Number of supertype attributes of abstract data types in queries in SQL statements
SiNA	Number of component specifications of abstract data types that are query subtypes in SQL statements
nSPA	Number of procedure calls in SQL statements
nSPP	Total number of procedure call parameters in SQL statements
nFF	Number of function calls in SQL statements#
nFP	Number of function call parameters in SQL statements#
nFC	Total number of function definition candidates among the functions in the SQL statements (to the number of function calls nFF, add the number of function definitions that have subtypes as arguments for which the arguments are abstract data types)
nPFF	Number of plug-in function calls used by SQL objects (number of plug-in function calls in SQL statements + 1 for SELECT and 6 for INSERT, UPDATE, or DELETE)
nSFF	Number of system definition scalar function calls in SQL statements#
nSFP	Total number of system definition scalar function arguments in SQL statements#
nJFC	Number of external Java function calls in SQL statements
nJFP	Total number of external Java functions in SQL statements
nAT	Number of abstract data types used by component specifications in SQL statements (excluding supertypes and abstract data types that emerge depending on the abstract data type attributes)
nAA	Number of abstract data types used by component specifications in SQL statements (including supertypes and abstract data types that emerge depending on the abstract data type attributes)
nAF	Total number of attributes used by component specifications in SQL statements
nPAT	Number of abstract data types of plug-in function arguments used by SQL objects (excluding supertypes and abstract data types that emerge depending on the abstract data type attributes)
nPAA	Number of abstract data types of plug-in function arguments used by SQL objects (including supertypes and subtypes)
nCAT	Number of constructor function calls in SQL statements
nCAA	Number of constructor function abstract data types in SQL statements (including supertypes)
nCAF	Total number of constructor function abstract data type attributes in SQL statements
nTR	Number of triggers activated by the execution of SQL statements
nTSN	Total number of columns modified by new value correlation names in SQL statements that are triggered by the execution of SQL statements
nTSO	Total number of columns modified by old value correlation names in SQL statements that are triggered by the execution of SQL statements
nTCN	Total number of columns modified by new value correlation names in the trigger action conditions of triggers that are activated by the execution of SQL statements
nTCO	Total number of columns modified by old value correlation names in the trigger action conditions of triggers that are activated by the execution of SQL statements
RCC	Total number of foreign key component columns and primary key component columns of the tables that reference update-target tables in SQL statements
RCT	Sum of the number of tables that reference update-target tables and the number of tables that are referenced by update-target tables in SQL statements
RCP	Total number of CASCADEs specified for referencing action when referencing tables are defined
RIi	Total number of indexes defined for referenced tables with reference specified when referencing tables are defined
RDi	Total number of partition storage conditions defined for referenced tables with reference specified when referencing tables are defined (double the value for matrix partitioning tables)
sRi	Number of SQL parameters in procedures and functions (count SQL parameters specified with INOUT twice)
sRUi	Total number of SQL parameters in procedures and functions (or total number of columns modified by new or old value correlation names in the triggered SQL statements defined by triggers)
sDi	Total number of SQL variables (declare) in procedures, functions, and triggered SQL statements
sSXi	Total number of SQLCODE and SQLCOUNT variables in procedures, functions, and triggered SQL statements
sCUi	Total number of CURRENT_TIME and CURRENT_DATE value functions in procedures, functions, and triggered SQL statements
sSi	Number of data manipulation SQL statements in procedures and triggered SQL statements (excluding cursor declarations: OPEN, FETCH, CLOSE, UPDATE, DELETE, INSERT)
sPi	Number of routine control SQL statements in procedures, functions, and triggered SQL statements (BEGIN, SET, IF, ELSEIF, WHILE)
sLA	Number of labels in procedures, functions, and triggered SQL statements
sKi	Number of literals in procedures, functions, and triggered SQL statements (excluding data manipulation SQL literals described in procedures and triggered SQL statements)
sL	Total length of constants in procedures, functions, and triggered SQL statements (excluding data manipulation SQL literals described in procedures and triggered SQL statements)
sWi	Number of conditional predicates in procedures, functions, and triggered SQL statements
sCM	Number of compound statements in procedures, functions, and triggered SQL statements
sCCR	Number of compound statements that describe cursor declarations in procedures and triggered SQL statements
sDCR	Number of cursor declarations in procedures and triggered SQL statements
sCHD	Number of compound statements that specify handler declarations in procedures, functions, and triggered SQL statements
sDHD	Number of handler declarations in procedures, functions, and triggered SQL statements
sHCN	Number of condition values specified in handler declarations in procedures, functions, and triggered SQL statements
nRFF	Number of function calls in routines
nRFP	Total number of function arguments in routines
nRFC	Total number of function definition candidates among the routines in the SQL statements (to the number of function calls nFF, add the number of function definitions that have subtypes as arguments for which the arguments are abstract data types)
nPRFF	Number of plug-in function calls used by routine SQL objects
nPRFP	Total number of plug-in parameters of plug-in function calls used by routine SQL objects
nPA	Number of procedure calls in routines
nPP	Total number of procedure parameters in routines
nPPI	Total number of input parameters in routine procedures (including input/output parameters)
nPPO	Total number of output parameters in routine procedures (including input/output parameters)
nPPA	Number of plug-in procedure calls in routine SQL objects
nPPP	Total number of plug-in parameters of plug-in procedures used by routine SQL objects
nRSFF	Number of system defined scalar function calls in routines
nRSFP	Total number of system defined scalar function call arguments in routines
nPJA	Number of external Java procedure calls in routine
nPJP	Total number of arguments of external Java procedures in routine
nRJFC	Number of external Java function calls in routine
nRJFP	Total number of arguments of external Java functions in routine
nAR	Number of abstract data types used by component specifications in routines (excluding supertypes and abstract data types that emerge depending on the abstract data type attributes)
nARA	Total number of attributes used by component specifications in routines
nRPAT	Total number of abstract data types used as parameters of plug-in routines used by routine SQL objects (excluding abstract data types that are supertypes or abstract data type attributes)
nRPAA	Number of abstract data types used as parameters of plug-in routines used by routine SQL objects (including supertypes)
nRPAF	Total number of attributes of abstract data types used as parameters of plug-in routines used by routine SQL objects
nRCAT	Number of constructor function calls in routines
nRCAA	Number of abstract data types of constructor functions in routines (including supertypes)
nRCAF	Total number of abstract data type attributes of constructor functions in routines

#: When triggers are used, all of the trigger activation conditions of the triggers activated by execution of SQL statements must be counted.