The following formula is used to determine the size of the data dictionary LOB RDAREA for storing sources.
Size of data dictionary LOB RDAREA for source storage (bytes) ={ a [ ![]() ![]() ![]() ![]() ![]() ![]() i=1 + b [ ![]() ![]() ![]() ![]() j=1 }3 ![]() |
The following formula is used to estimate the size of the data dictionary LOB RDAREA for storing objects:
Size of data dictionary LOB RDAREA for object storage (bytes) ={ a [ ![]() ![]() ![]() ![]() ![]() ![]() i=1 + b [ ![]() ![]() ![]() ![]() j=1 }3 ![]() |
QOi (bytes) = a ![]() i=1 1840 + 46 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 20 ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 16 ![]() ![]() ![]() ![]() + 1057 ![]() ![]() ![]() ![]() ![]() ![]() [ + 60 ![]() ![]() [ + 1057 ![]() ![]() ![]() [ + 760 + 376 ![]() ![]() [ + 32 ![]() [ + ![]() ![]() ![]() ![]() ![]() } |
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 ![]() ![]() ![]() + sKi + sL + 80 ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 8 ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 196 ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() + 16 ![]() ![]() ![]() ![]() ![]() + 8 ![]() ![]() ![]() ![]() ![]() [ + 28 ![]() ![]() } |
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 ![]() ![]() ![]() ![]() ![]() ![]() i=1 |
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 statements1 |
Ki | Number of literals in SQL statements1 |
Li | Total length of literals in SQL statements1 (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 statements1 |
nFP | Number of function call parameters in SQL statements1 |
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 statements1 |
nSFP | Total number of system definition scalar function arguments in SQL statements1 |
nJFC | Number of Java function calls in SQL statements |
nJFP | Total number of Java function arguments 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 |
nFT | Number of foreign tables in SQL statements |
nFTS | Length of SQL statements that retrieve from foreign tables2 |
nFTQ | Number of embedded variables or ? parameters in SQL statements that retrieve from foreign tables2 |
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 variables in procedures, functions, and triggered SQL statements |
sSi | Number of data manipulation SQLs in procedures and triggered SQL statements (excluding cursor declarations: OPEN, FETCH, CLOSE, UPDATE, DELETE, INSERT, etc.) |
sPi | Number of routine control SQL statements in procedures, functions, and triggered SQL statements (BEGIN, SET, IF, ELSEIF, WHILE, etc.) |
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 Java procedure calls in routines |
nPJP | Total number of Java procedure call arguments in routines |
nRJFC | Number of Java function calls in routines |
nRJFP | Total number of Java function call arguments in routines |
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 |