17.2.1 Determining the size of a normal data dictionary RDAREA

Organization of this subsection
(1) Formula for calculating the size of a data dictionary RDAREA
(2) Calculating the number of table storage pages
(3) Calculating the number of index storage pages

(1) Formula for calculating the size of a data dictionary RDAREA

Use the following formula to determine the size of a data dictionary RDAREA that will be created by the create rdarea statement with datadictionary or datadictionary of routines specified:

Formula
Size of a data dictionary RDAREA (bytes)
= a[Figure] b[Figure] 1.3 + c[Figure] 125 + 1600000​
Size of data dictionary RDAREA = a[Figure] b[Figure] 1.3 + c[Figure] 125 + 1600000​
(bytes)
a: Page length of the data dictionary RDAREA1
b: Total number of pages in the data dictionary RDAREA2
c: Segment size of the data dictionary RDAREA3
1 This is the page length specified in the create rdarea statement of the database initialization utility (pdinit) or database structure modification utility (pdmod).
2 This is the number of table storage pages + number of index storage pages (see (2) and (3) as follows).
3 This is the segment size specified in the create rdarea statement of the database initialization utility (pdinit) or database structure modification utility (pdmod).

(2) Calculating the number of table storage pages

The number of pages required to store tables is the sum of the values obtained from Formulas 1 through 22.

(a) Formula 1
Dictionary table nameFormula
SQL_TABLES[Figure]
SQL_COLUMNS[Figure]
SQL_DIV_TABLE[Figure]
a: Total number of tables
b: Page length of data dictionary RDAREA (bytes)
c: Average length of column names (bytes)
d: Average length of the names of the RDAREAs for storing the tables
e: Average length of the comments in the tables (bytes)
f: Average length of the names of the columns for which table partitioning conditions are specified (bytes)
g: Average number of table columns
h: Average length of the authorization identifiers (bytes)
i: Average length of the table identifiers (bytes)
j: Average length of the comments on the columns (bytes)
k: Average length of the authorization identifiers of the base tables used to create view tables (bytes)
m: Average length of the column names in the base tables used to create view tables (bytes)
n: Average length of the table identifiers of the base tables used to create view tables (bytes)
p: Average length of the names of user-defined data types (bytes)
q: Average number of table row partitioning conditions
t: Average length of PLUGIN clauses (bytes)
u: Average length of foreign server name (bytes)
w: Average value for the name of the insert history maintenance column (bytes)
y: Average base length of constants specified in the DEFAULT clause (bytes)
For details on how to calculate the base length, see the section on data codes and data lengths set in the SQL descriptor area in the manual HiRDB Version 8 UAP Development Guide.
A: Average length of constants specified in the DEFAULT clause (bytes)
If the specified constant is a literal, this is the apparent length of the literal. If there is a possibility that the length of the constant will increase, keep the post-update length in mind when making the calculation. Character literals are indicated by notations, such as N for National character column literals, M for mixed character column literals, X for hexadecimal character literals, and single quotation marks ('). Constant specification is in bytes.
Example:
'HiRDB': 7 bytes
[Figure]
X'4869524442': 13 bytes
CURRENT_TIME: 12 bytes
100: 3 bytes
B: Average length of table row partitioning conditions (bytes)
C: Specified number of table storage RDAREAs
(b) Formula 2
Dictionary table nameFormula
SQL_INDEXES[Figure]
SQL_INDEX_COLINF[Figure]
SQL_DIV_INDEX[Figure]
SQL_EXCEPT[Figure]
SQL_INDEX_DATATYPE[Figure]
SQL_INDEX_FUNCTION[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Average length of table identifiers (bytes)
c: Total number of indexes
d: Average length of index identifiers (bytes)
e: Average number of index exception key values per index
f: Average length of index identifiers (bytes)
g: Average length of column names (bytes)
i: Average number of table row partitioning conditions
j: Average length of the names of the RDAREAs for storing indexes (bytes)
k: Average number of columns constituting indexes
m: Average length of the index type names (bytes)
n: Average length of PLUGIN clause specifications (bytes)
p: Average length of plug-in index application function names (bytes)
q: Average length of abstract data type names (bytes)
r: Average length of attribute names (bytes)
s: Number of application functions per plug-in index
t: Total number of plug-in indexes
(c) Formula 3
Dictionary table nameFormula
SQL_TABLE_ PRIVILEGES[Figure]
SQL_RDAREA_ PRIVILEGES[Figure]
SQL_VIEW_ TABLE_USAGE[Figure]
SQL_VIEWS[Figure]
SQL_VIEW_DEF*[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Average length of authorization identifiers (bytes)
c: Average length of table identifiers (bytes)
d: Number of access privileges defined
  • If you have granted the privilege to n users per table, the value is the number of tables for which the privilege is granted times n.
  • If you have granted the privilege to PUBLIC, the value is one (user).
  • If you have granted the privilege to a group, one group ID is treated as one (user).
e: Total number of RDAREAs
f: Average length of the names of RDAREAs for storing tables (bytes)
g: Average length of SQL statements for defining view tables (bytes)
h: Total number of view definitions
i: Average number of columns for a view table
* These tables are used by the system.
(d) Formula 4
Data dictionary table nameFormula
SQL_REFERENTIAL_
CONSTRAINTS
[Figure]
E: {e[Figure] h + 2 [Figure] h + (h - 1)} + 1
F: {e[Figure] i + 2 [Figure] i + (i- 1)} + 1
G: {2 [Figure] h + (h - 1)} + 1
H: {2 [Figure] i + (i - 1)} + 1
a: Page length of the data dictionary RDAREA (bytes)
b: Average length of the constraint names (bytes)
c: Average length of the authorization identifiers (bytes)
d: Average length of the table identifiers (bytes)
e: Average length of the column names for which a foreign key has been defined (bytes)
f: Average length of the column names for which a primary key has been defined (bytes)
h: Average number of columns constituting the foreign keys
i: Average number of columns constituting the primary keys
(e) Formula 5
Dictionary table nameFormula
SQL_PHYSICAL_FILES[Figure]
SQL_RDAREAS[Figure]
SQL_USERS[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Total number of RDAREAs
c: Average length of RDAREA names (bytes)
d: Average length of schema authorization identifiers (bytes)
e: Total number of schemas
f: Total number of HiRDB files constituting all RDAREAs
g: Average length of the names of HiRDB files constituting all RDAREAs (bytes)
h: Average length of a password (bytes)
(f) Formula 6
Dictionary table nameFormula
SQL_DIV_TABLE_REGULARSIZE*[Figure]
a: Total number of row-partitioned tables
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of the names of the RDAREAs for storing tables (bytes)
d: Average number of table row partitioning conditions
e: Average length of authorization identifiers (bytes)
f: Average length of table identifiers (bytes)
g: Average length of the condition values for character-string columns for which table partitioning conditions are specified (bytes)
h: Average length of the condition values for numeric columns for which table partitioning conditions are specified (bytes)
* These tables are used by the system.
(g) Formula 7
Dictionary table nameFormula
SQL_TABLE_STATISTICS1[Figure]
SQL_COLUMN_STATISTICS1[Figure]
SQL_INDEX_STATISTICS1[Figure]
a: Total number of tables for which optimizing information is to be collected
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of column names (bytes)
e: Average length of authorization identifiers (bytes)
f: Average length of table identifiers (bytes)
g: Total number of indexes defined for tables for which optimizing information is collected
h: Average length of index identifiers (bytes)
i: Number of index key column values for tables for which optimizing information is collected2
1 These tables are used by the system.
2 If the number of key column values < 100, then i = number of key column values.
If the number of key column values [Figure] 100, then i = 100.
(h) Formula 8
Dictionary table nameFormula
SQL_DIV_COLUMN[Figure]
a: Total number of BLOB column storage RDAREAs
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of column names (bytes)
d: Average length of the names of the RDAREAs for storing tables (bytes)
e: Average length of authorization identifiers (bytes)
f: Average length of table identifiers (bytes)
h: Average length of component names (bytes)
(i) Formula 9
Dictionary table nameFormula
SQL_ROUTINES[Figure]
SQL_ROUTINE_RESOURCES[Figure]
SQL_ROUTINE_PARAMS[Figure]
a: Total number of routines
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of routine names (bytes)
d: Average length of authorization identifiers (bytes)
e: Average length of specified names1 (bytes)
f: Average length of parameter names (bytes)
g: Average length of authorization identifiers of resource2 owners (bytes)
h: Average length of resource2 names (bytes)
i: Average number of resources2 per routine
j: Average number of parameters per routine
k: Average length of abstract data type names (bytes)
m: Average length of user-defined data type names (bytes)
n: Average length of external routine names (bytes)
p: Average length of Java class name (bytes)
q: Average length of Java archive name (bytes)
r: Average length of data type name for Java return value (bytes)
s: Average length of name with Java parameter data type (bytes)
t: Average length of column names specified by old or new value correlation names (bytes)
1 Indicates authorization-identifier.routine-identifier.
2 Resources include tables and indexes.
(j) Formula 10
Dictionary table nameFormula
SQL_ALIASES[Figure]
a: Total number of tables for which aliases are defined
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of authorization identifiers of tables for which aliases are defined (bytes)
d: Average length of table aliases (bytes)
e: Average length of RD-node names (bytes)
f: Average length of base table names (bytes)
(k) Formula 11
Dictionary table nameFormula
SQL_DATATYPES[Figure]
SQL_DATATYPE_DESCRIPTORS[Figure]
a: Total number of user-defined data types
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of attribute or field names (bytes)
d: Average length of user-defined data type comments (bytes)
e: Average number of attributes per data type
f: Average length of authorization identifiers (bytes)
g: Average length of data type identifiers (bytes)
h: Average length of authorization identifiers for supertype abstract data types (bytes)
i: Average length of data identifiers for supertype abstract data types (bytes)
j: Number of attributes defined for user-defined data types
k: Average length of authorization identifiers of abstract data types for attributes defined for user-defined data types (bytes)
m: Average length of data identifiers of abstract data types for attributes defined for user data types (bytes)
(l) Formula 12
Dictionary table nameFormula
SQL_PLUGINS[Figure]
SQL_PLUGIN_ROUTINES[Figure]
SQL_PLUGIN_ROUTINE_PARAMS[Figure]
a: Average number of plug-in routines per plug-in
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of routine names (bytes)
d: Average length of authorization identifiers (bytes)
e: Average length of specified names* (bytes)
f: Average length of parameter names per plug-in (bytes)
i: Average number of resources per routine
k: Total number of plug-ins
m: Average length of plug-in names (bytes)
n: Average length of abstract data type/index type names (bytes)
o: Average length of plug-in library path names (bytes)
p: Average length of plug-in comments (bytes)
q: Average length of timing indicators (bytes)
r: Average length of operation qualifiers (bytes)
s: Average length of operation qualifier code (bytes)
t: Average length of parameter qualifier information (bytes)
u: Average length of bind operation name (bytes)
v: Average length of parameter modifier information code (bytes)
* This means the authorization-identifier.routine-identifier.
(m) Formula 13
Dictionary table nameFormula
SQL_INDEX_TYPES[Figure]
SQL_INDEX_TYPE_FUNCTION[Figure]
a: Total number of index types
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of authorization identifiers (bytes)
d: Average length of index type identifiers (bytes)
e: Average length of abstract data type names (bytes)
f: Number of application functions per index type
(n) Formula 14
Dictionary table nameFormula
SQL_INDEX_RESOURCES[Figure]
SQL_TYPE_RESOURCES[Figure]
SQL_TABLE_RESOURCES[Figure]
a: Total number of plug-in indexes
b: Page length of the data dictionary RDAREA (bytes)
c: Average length of authorization identifiers (bytes)
d: Average length of index type identifiers (bytes)
e: Average length of abstract data type names (bytes)
g: Total number of attributes defined for abstract data types
h: Total number of abstract data types defined as subtypes
i: Total number of abstract data types
j: Average length of table identifier (bytes)
(o) Formula 15
Dictionary table nameFormula
SQL_IOS_GENERATIONS[Figure]
a: Data dictionary RDAREA page length (bytes)
b: Number of files that compose the replica RDAREAs
c: Average length of names of HiRDB files that compose the RDAREAs (bytes)
(p) Formula 16
Dictionary table nameFormula
SQL_TRIGGERS[Figure]
SQL_TRIGGER_COLUMNS[Figure]
SQL_TRIGGER_DEF_SOURCE[Figure]
SQL_TRIGGER_USAGE[Figure]
a: Data dictionary RDAREA page length (bytes)
b: Total number of trigger definitions
c: Average length of trigger authorization identifiers (bytes)
d: Average length of trigger names (bytes)
e: Average length of authorization identifiers of tables defined by triggers (bytes)
f: Average length of names of tables defined by triggers (bytes)
g: Average length of old value correlation names (bytes)
h: Average length of new value correlation names (bytes)
i: Average length of specified names of trigger action procedures (bytes)
j: Average length of SQL statements when triggers were defined (bytes)
k: Number of triggers defined with UPDATE statement as the triggering event
m: Average length of column names specified in trigger events (bytes)
n: Average number of columns specified as trigger events
p: Number of resources in trigger action retrieval conditions
q: Average length of authorization identifiers of resources in trigger action retrieval conditions (bytes)
r: Average length of resource table names used in trigger retrieval action conditions (bytes)
s: Average length of specified names used in trigger action retrieval conditions (bytes)
(q) Formula 17
Dictionary table nameFormula
SQL_PARTKEY[Figure]
SQL_PARTKEY_DIVISION[Figure]
SQL_DIV_TYPE[Figure]
a: Number of matrix partitions created
b: Data dictionary RDAREA page length (bytes)
c: Average number of table row partitioning conditions
d: Average length of column names specified in table row partitioning conditions (bytes)
f: Average length of authorization identifiers (bytes)
g: Average length of table identifiers (bytes)
h: Average length of table row partitioning conditions (bytes)
n: Number of matrix partitioning tables that combine hash partitioning and key range partitioning with boundary values specified
(r) Formula 18
Dictionary table nameFormula
SQL_AUDITS[Figure]
a: Data dictionary RDAREA page length (bytes)
b: Number of HiRDB files that compose duplicated RDAREAs
c: Average length of event type names (bytes)
d: Average length of event subtype names (bytes)
e: Average length of object type name (bytes)
f: Average length of object owner name (bytes)
g: Average length of object name (bytes)
(s) Formula 19
Dictionary table nameFormula
SQL_AUDITS_REGULARIZE[Figure]
a: Data dictionary RDAREA page length (bytes)
b: Number of HiRDB files that compose duplicated RDAREAs
c: Average length of object type name (bytes)
d: Average length of object owner name (bytes)
e: Average length of object name (bytes)
(t) Formula 20
Data dictionary table nameFormula
SQL_KEYCOLUMN_USAGE[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Total number of constraint definitions
c: Average length of the constraint authorization identifiers (bytes)
d: Average length of the constraint names (bytes)
e: Average length of the authorization identifiers for a table for which constraints have been defined (bytes)
f: Average length of the names of tables for which constraints have been defined (bytes)
g: Average length of the constraint type names (bytes)
(u) Formula 21
Data dictionary table nameFormula
SQL_TABLE_CONSTRAINTS[Figure]
SQL_CHECKS[Figure]
SQL_CHECK_COLUMNS[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Total number of constraint definitions
c: Average length of the constraint authorization identifiers (bytes)
d: Average length of the constraint names (bytes)
e: Average length of the authorization identifiers for tables for which constraints have been defined (bytes)
f: Average length of the names of tables for which constraints have been defined (bytes)
g: Average length of the constraint type names (bytes)
h: Average length of SQL statements during check constraint definition (bytes)
i: Number of check constraint definitions
j: Average length of the column names specified for the columns for which check constraints have been defined (bytes)
k: Average number of columns specified for the columns for which check constraints have been defined
m: Average number of binary data items (check constraint search conditions and analysis tree for check constraints) whose length is 256 or greater and that are subject to branching.
For details about the conditions for branching the number of binary storage pages, see 17.1.2 Calculating the number of table storage pages.
X: Value obtained from the formula shown below, where all the variables are specified in the check constraint search conditions:
In 32-bit mode: S[Figure] 36 + T + (U1 + U2 + U3) [Figure] 48 + V[Figure] 128 + 1000
In 64-bit mode: S[Figure] 72 + T + (U1 + U2 + U3) [Figure] 96 + V[Figure] 184 + 1400
S: Total number of Boolean operators, arithmetic operators ( + , -,*, /, and ||), and system built-in scalar functions
T: Total length of literals (data type handled by HiRDB) (bytes)
U1: Number of CASE expressions and value expressions in CAST specification
U2: Number of value expressions in scalar functions (VALUE, SUBSTR, BIT_AND_TEST, POSITION, TIMESTAMP, VARCHAR_FORMAT, TIMESTAMP_FORMAT)
U3: Number of datetime formats
V: Number of column specifications
(v) Formula 22
Data dictionary table nameFormula
SQL_SYSPARAMS[Figure]
(w) Formula 23
Data dictionary table nameFormula
SQL_PUBLICVIEW_
SAME_USERS
[Figure]
a: Page length of the data dictionary RDAREA (bytes)
b: Total number of public view table definitions
c: Average number of duplicate names for each public view table* (bytes)
d: Average length of the table identifiers of public view tables (bytes)
e: Average length of the authorization identifiers (bytes)
* Average number of rows with the same TABLE_NAME column value in the SQL_TABLES table per public view table identifier
(x) Formula 24
Dictionary table nameFormula
SQL_FOREIGN_SERVERS[Figure]
SQL_USER_MAPPINGS[Figure]
SQL_USAGE_PRIVILEGES*[Figure]
a: Number of foreign servers
b: Data dictionary RDAREA page length (bytes)
c: Average length of authorization identifiers (bytes)
d: Average length of foreign server names (bytes)
e: Average length of DBMS names used in foreign servers (bytes)
f: Average length of version identifiers of DBMSs used in foreign servers (bytes)
g: Total number of user mappings
h: Average length of user passwords used by foreign servers (bytes)
k: Number of USAGE privilege definitions
If n people are granted this privilege for a foreign server, this would be the number of foreign servers [Figure] n.
* These are tables used by the system.

(3) Calculating the number of index storage pages

The following formula is used to calculate the number of pages required to store indexes.

Formula
Number of pages needed to store indexes
= number of index storage pages for dictionary tables* + 12
* See 17.1.3 Calculating the number of index storage pages to calculate the number of index storage pages for dictionary tables; the following conditions apply:
  1. The variables listed in Table 17-6 Variables used in the formulas for obtaining the number of index storage pages must be used.
  2. 30 must be used as the value for variable b (percentage of unused space specified with CREATE INDEX).
  3. 12 must be used as the value of variables e (number of keys with at least dx + 1 duplicated key values) and f (average number of key duplicates).

    Table 17-6 Variables used in the formulas for obtaining the number of index storage pages

    Table nameTypeKey length3
    (Variable g1)
    Number of key types (Variable c1)Average number of key duplicates (Variable d1)
    SQL_PHYSICAL_FILES18Number of serversAverage number of HiRDB files in server
    2g + 1Number of RDAREAsAverage number of HiRDB files constituting an RDAREA
    SQL_RDAREAS3g + 1Number of RDAREAs1
    44
    SQL_TABLES5d + e + 2Total number of tables + 801
    64
    SQL_COLUMNS7d + e + f + 3a[Figure] b1
    8d + e + 6
    94b
    SQL_INDEXES10d + e + 2a[Figure]h[Figure] a[Figure]
    11d + i + 2h1
    124
    SQL_USERS13d + 1Number of authorization identifiers1
    SQL_RDAREA_ PRIVILEGES14d + 1Number of unique authorization identifiers specified in the USER USED BY operand of the database initialization utility (pdinit)Average number of RDAREA access privileges used per user
    15g + 1Number of RDAREAs specified in the USER USED BY operand of the database initialization utility (pdinit)Average number of users for each RDAREA
    SQL_TABLE_PRIVILEGES16d + 1a[Figure]y[Figure] a[Figure]
    172 [Figure] d + e + 3y1
    SQL_DIV_TABLE18d + e + 6Total number of table partitions1
    19g + 1Number of unique RDAREAs specified when partitioning tableAverage number of tables stored in RDAREAs
    204
    SQL_DIV_TABLE_REGULARSIZE21d + e + 6Total number of table partitions1
    224Number of row-partitioned tablesAverage number of table partitions
    SQL_INDEX_COLINF23d + e + 6Number of unique tables with index definitionsAverage number of columns constituting an index
    24d + i + 6Number of columns constituting an index1
    SQL_TABLE_STATISTICS25d + e + 2Total number of tables (including dictionary tables)1
    SQL_COLUMN_STATISTICS26d + e + f + 3h1
    SQL_INDEX_STATISTICS27d + e + 2Total number of tables for which an index is defined[Figure]h[Figure] a[Figure]
    28d + i + 2h1
    SQL_VIEW_TABLE_USAGE29d + e + 2z1
    30d + e + 2Total number of base tables for which a view is definedAverage number of view definitions for a table
    314z1
    SQL_VIEWS32d + e + 2z1
    334
    SQL_VIEW_DEF34d + e + 2z1
    3510
    SQL_REFERENTIAL_CONSTRAINTS39d + e + 2Total number of referential constraints1
    40d + e + 2Total number of referencing tablesAverage number of referencing tables per table
    41d + e + 2Total number of referenced tableAverage number of referenced tables per table
    SQL_EXCEPT86d + e + 2Number of indexes for which an exception value is specifiedNumber of indexes with an exception value specified for a single table
    87d + i + 21
    884Number of unique tables with an index for which an exception value is specifiedNumber of indexes for which an exception value is specified for a single table
    SQL_DIV_INDEX36d + e + 6Number of row-partitioned indexes [Figure] number of partitionsAverage number of partitions per table
    37d + i + 2Total number of row-partitioned indexes1
    SQL_DIV_COLUMN38d + e + f + 3Number of LOB column definitionsAverage number of partitions per table
    52d + e + 9Number of LOB attribute definitions1
    SQL_ALIASES42d + v + 4Total number of table aliases to be created1
    SQL_ROUTINES43d + MAX (q, 7)p + 1741
    44d + MAX (t, 18)u + 651
    454p + 1741
    53d + UDTNumber of abstract data types + 1 (NULL value)Average number of routines per abstract data type + number of NULL
    SQL_ROUTINE_RESOURCES46d + qp[Figure] sAverage number of resources used per routine
    47d + t
    48d + q
    494
    SQL_ROUTINE_PARAMS50d + MAX (q, 8)p[Figure] r + 347Average number of parameters per routine
    51d + MAX (t, 19)Number of routinesAverage number of parameters per specific name (if less than 3, use 3)
    106e + 4 + 2Number of trigger SQL objects [Figure] r + 1 (NULL values)Average number of parameters per specified name (if less that 3, use 3) + number of NULL values
    SQL_DATATYPES54d + UDTNumber of abstract data types1
    554
    56d + UDTNumber of abstract data types that have subtypes + 1 (NULL value)Average number of subtypes per abstract data type + number of NULL values
    SQL_DATATYPE_DESCRIPTORS57d + UDT + ATTNUDT[Figure] NATT1
    584Number of abstract data typesAverage number of attributes per abstract data type
    SQL_TABLE_RESOURCES59d + eTotal number of tables that use user-defined data typesAverage number of user-defined data types used per table
    60d + UDTUDTAverage number of tables used per user-defined data type
    614
    SQL_PLUGINS62d + PLGNumber of plug-ins1
    634
    64{(d + UDT) [Figure]IXT} + 2Number of data type plug-ins + number of index-type plug-ins
    SQL_PLUGIN_ROUTINES65tNPLG[Figure] NFPLG1
    66PLG + TMD + 2Number of operationsNumber of plug-ins
    67PLG + 4
    68POPR + 1
    SQL_PLUGIN_ROUTINE_PARAMS69t + PRMNPLG[Figure] NPPAR1
    70PLGNPLGAverage number of parameters per plug-in
    71t + 4NPLG[Figure] NPPAR1
    SQL_REGISTRY_CONTEXT72CNM + 1Number of contexts1
    SQL_REGISTRY_KEY73KNM + 6Number of keys1
    SQL_INDEX_TYPES74d + IXTNumber of index types to be created1
    754
    SQL_INDEX_RESOURCES76d + IXTNumber of plug-in indexesAverage number of index definitions that use index type
    774
    SQL_INDEX_DATATYPE78d + eNumber of table definitions for which plug-in index is definedAverage number of plug-in indexes for the same table
    79d + iNumber of plug-in indexes1
    SQL_INDEX_FUNCTION80d + eNumber of table definitions for which plug-in index is definedAverage number of plug-in indexes per table [Figure] average number of functions to which plug-in index is applied
    81d + iNumber of plug-in indexesAverage number of functions to be applied per plug-in index
    SQL_TYPE_RESOURCES82d + eNumber of user-defined data types that use a user-defined data typeAverage number of user-defined data types that are specified as an attribute of a user-defined data type
    83d + UDTNumber of user-defined data typesAverage number of user-defined data types that use a user-defined data type
    844
    SQL_INDEX_TYPE_FUNCTION85d + IXTNumber of index typesAverage number of functions to be applied per index
    SQL_UER_MAPPINGS89d + FSRVNumber of user mappings1
    SQL_TRIGGERS90d + e + 2 + 16Number of triggers1
    91d + TRIG + 2
    92d + t + 2
    934
    SQL_TRIGGER_COLUMNS96d + TRIG + 2Number of triggers that use the UPDATE statement as the triggering eventAverage column length specified per trigger
    97d + e + f + 3Number of columns specified that use the UPDATE statement as the triggering event1
    SQL_TRIGGER_DEF_SOURCE98d + TRIG + 2 + 4Number of triggers1
    99d + e + 2Number of tables defined with triggersAverage number of triggers per table
    SQL_TRIGGER_USAGE100d + TRIG + 2Number of triggers that reference resources while performing the trigger action search conditionAverage number of resources referenced per trigger
    101d + e + 2Number of tables that define triggers that reference resources while performing the trigger action search conditionsAverage number of resources referenced per table
    102d + e + (t or e) + 2Number of resources used1
    1038
    SQL_PARTKEY104d + e + f + 3Number of matrix partitioning tables [Figure] number of partitioning keys1
    SQL_PARTKEY_DIVISION105d + e + 6Number of matrix partitioning tables [Figure] number of boundary values [Figure] number of partitioning keys1
    SQL_AUDITS107ETP + EST + 2Number of monitored events1
    108OTP + OSC + ONM + 3Number of monitored objectsAverage number of events monitored per object
    109dNumber of monitored usersAverage number of events monitored per user
    SQL_AUDITS_REGULARIZE110OTP + OSC + ONM + 3Number of monitored objectsAverage number of events monitored per object
    111dNumber of monitored usersAverage number of events monitored per user
    SQL_KEYCOLUMN_USAGE112d + CNS + 2Number of constraints1
    113d + e + 2Number of tables for which constraints have been definedAverage number of constraints per table
    SQL_TABLE_CONSTRAINTS114d + CNS + 2Number of constraints1
    115d + e + 2Number of tables for which constraints have been definedAverage number of constraints per table
    SQL_CHECKS116d + CNS + 2Number of check constraints1
    117d + e + 2Number of tables for which check constraints have been definedAverage number of check constraints per table
    SQL_CHECK_COLUMNS118d + CNS + 2Number of check constraintsAverage number of columns specified per check constraint
    119d + e + f + 3Number of columns used in the check constraintsAverage number of duplicate columns used in check constraints per table
    SQL_SYSPARAMS121821
    SQL_PUBLICVIEW_SAME_USERS124d + e + 2Number of public view tables [Figure] number of authorization identifiers1
a: Total number of tables
b: Average number of table columns
c: Page length of the data dictionary RDAREA (bytes)
d: Average length of authorization identifiers (bytes)
e: Average length of table identifiers (bytes)
f: Average length of column names (bytes)
g: Average length of RDAREA names (bytes)
h: Total number of indexes
i: Average length of index identifiers (bytes)
n: Average length of HiRDB file names constituting RDAREAs (bytes)
p: Number of routines to be created
q: Average length of routine names (bytes)
r: Average number of parameters per routine
s: Average number of resources used per routine
t: Average length of specific names2 (bytes)
u: Total number of specific names2
v: Average length of table aliases (bytes)
y: Number of access privileges defined
If the privilege is granted to n users per table, then the value of this variable would be the number of tables [Figure] n.
z: Total number of view definitions
NUDT: Number of user-defined data types to be created
UDT: Average length of user-defined data type names (bytes)
NATT: Average number of attributes per user-defined data type
ATT: Average length of attributes with user-defined data type (bytes)
PLG: Average length of plug-in names (bytes)
NPLG: Number of plug-ins to be created
IXT: Average length of index type names (bytes)
NFPLG: Average number of plug-in functions
POPR: Average length of plug-in function names (bytes)
NPPAR: Average number of parameters per plug-in function
PRM: Average length of parameter names per plug-in function (bytes)
TMD: Average length of timing description (bytes)
CNM: Average length of context name (bytes)
KNM: Average length of key name (bytes)
FSRV: Average length of foreign server names (bytes)
TRIG: Average length of trigger names (byte)
ETP: Average length of event type names (bytes)
EST: Average length of event subtype names (bytes)
OTP: Average length of object type names (bytes)
OSC: Average length of object owner names (bytes)
ONM: Average length of object names (bytes)
CNS: Average length of constraint names (bytes)
1 Variables shown in (2) Variables used in formulas in 17.1.3 Calculating the number of index storage pages.
2 Indicates authorization-identifier.routine-identifier.
3 The key length is rounded up in units of four bytes. Use the following formula to obtain the key length:
  • [Figure]key-length [Figure] 4 [Figure][Figure] 4