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 data dictionary RDAREA (bytes) = a b 1.3 + c 125 + 1,600,000 If you are defining an extended system-defined scalar function, add: + 1,933,312

a: Page length of the data dictionary RDAREA^#1

b: Total number of pages in the data dictionary RDAREA^#2

c: Segment size of the data dictionary RDAREA^#3

#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).

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

(a) Formula 1

Dictionary table name	Formula
SQL_TABLES
SQL_COLUMNS
SQL_DIV_TABLE

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)

v: Average length of partitioning key (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 about how to calculate the base length, see the section on data codes and data lengths set in the SQL descriptor area in the HiRDB Version 9 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

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

D: Average length of names of database areas that store tables (bytes)

(b) Formula 2

Dictionary table name	Formula
SQL_INDEXES
SQL_INDEX_COLINF
SQL_DIV_INDEX
SQL_EXCEPT
SQL_INDEX_DATATYPE
SQL_INDEX_FUNCTION
SQL_INDEX_XMLINF

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

u: Average length of substructure path (bytes)

v: Average number of substructure paths constituting a substructure index

w: Average number of binary data items (analysis tree for substructure paths) that have a data length of at least 256 bytes and are branching

For details about the branching conditions of the number of storage pages for binary data, see Table 16-1 List of data lengths.

y: Total number of substructure indexes

A: Substructure path analysis tree length (bytes)

The value found using the following formula:

S 120 + P + L + S 4 + 32

L: Total length of character string expression of local name that specifies the modifier name of a step expression (bytes)^#

P: Total length of character string expression of XML name space URI associated with prefix (bytes)^#

When the prefix is omitted, the default associated XML namespace URI

S: Number of step expression specifications

#: Round up to a power of four.

B: Average length of names of database areas that store indexes (bytes)

(c) Formula 3

Dictionary table name	Formula
SQL_TABLE_ PRIVILEGES
SQL_RDAREA_ PRIVILEGES
SQL_VIEW_ TABLE_USAGE
SQL_VIEWS
SQL_VIEW_DEF#

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

j: Average length of view analysis information (bytes)

For details about the length of view analysis information per table viewed, see Formulas for determining size of view analysis information buffers (pd_view_def_cache_size) in the manual HiRDB Version 9 System Definition.

#: These tables are used by the system.

(d) Formula 4

Data dictionary table name	Formula
SQL_REFERENTIAL_ CONSTRAINTS

E: {e h + 2 h + (h - 1)} + 1

F: {e i + 2 i + (i- 1)} + 1

G: {2 h + (h - 1)} + 1

H: {2 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 name	Formula
SQL_PHYSICAL_FILES
SQL_RDAREAS
SQL_USERS

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 name	Formula
SQL_DIV_TABLE_REGULARSIZE#

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 name	Formula
SQL_TABLE_STATISTICS#1
SQL_COLUMN_STATISTICS#1
SQL_INDEX_STATISTICS#1

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 collected^#2

#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 100, then i = 100.

(h) Formula 8

Dictionary table name	Formula
SQL_DIV_COLUMN

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 name	Formula
SQL_ROUTINES
SQL_ROUTINE_RESOURCES
SQL_ROUTINE_PARAMS

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 names^#1 (bytes)

f: Average length of parameter names (bytes)

g: Average length of authorization identifiers of resource^#2 owners (bytes)

h: Average length of resource^#2 names (bytes)

i: Average number of resources^#2 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 name	Formula
SQL_DATATYPES
SQL_DATATYPE_DESCRIPTORS

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)

(k) Formula 11

Dictionary table name	Formula
SQL_PLUGINS
SQL_PLUGIN_ROUTINES
SQL_PLUGIN_ROUTINE_PARAMS

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.

(l) Formula 12

Dictionary table name	Formula
SQL_INDEX_TYPES
SQL_INDEX_TYPE_FUNCTION

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

(m) Formula 13

Dictionary table name	Formula
SQL_INDEX_RESOURCES
SQL_TYPE_RESOURCES
SQL_TABLE_RESOURCES

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)

(n) Formula 14

Dictionary table name	Formula
SQL_IOS_GENERATIONS

a: Number of files that compose the replica RDAREAs

b: Data dictionary RDAREA page length (bytes)

c: Average length of names of HiRDB files that compose the RDAREAs (bytes)

(o) Formula 15

Dictionary table name	Formula
SQL_TRIGGERS
SQL_TRIGGER_ACTCOND#
SQL_TRIGGER_COLUMNS
SQL_TRIGGER_DEF_SOURCE
SQL_TRIGGER_USAGE

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)

t: Length of analysis tree for trigger action condition (bytes)

To find the value, use the following formula. All variables in this formula are specifications in the WHEN search conditions.

S 36 + T + U 48 + V 128

+ F1 420 + F2 132 + F3 124 + F4 296 + F5 F4 132

+ A 140 + B 200 + 1,000

A: Number of component specification attributes

B: Number of abstract data types that appear in value expressions

F1: Number of system-defined scalar functions

F2: Number of arguments of system-defined scalar functions

F3: Number of user-defined functions

F4: Number of potential user-defined functions

F5: Number of arguments of user-defined functions

S: Total number of Boolean operators, arithmetic operators, constants and system-embedded scalar functions

T: Total length of constants (data types parsed by HiRDB) (bytes)

U: Number of value expressions in scalar function VALUE, CASE expressions, and CAST specifications

V: Number of column specifications

#: This is a table used by the system.

(p) Formula 16

Dictionary table name	Formula
SQL_PARTKEY
SQL_PARTKEY_DIVISION
SQL_DIV_TYPE

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

(q) Formula 17

Dictionary table name	Formula
SQL_AUDITS

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)

h: Average length of event executor name (bytes)

(r) Formula 18

Dictionary table name	Formula
SQL_AUDITS_REGULARIZE#

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)

f: Average length of event executor name (bytes)

#: This is a table used by the system.

(s) Formula 19

Data dictionary table name	Formula
SQL_KEYCOLUMN_USAGE

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)

(t) Formula 20

Data dictionary table name	Formula
SQL_TABLE_CONSTRAINTS
SQL_CHECKS
SQL_CHECK_COLUMNS

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 16.1.2 Calculating the number of table storage pages.

X: Length of analysis tree for check constraint (bytes)

Value obtained from the formula shown below, where all the variables are specified in the check constraint search conditions:

In 32-bit mode: S 36 + T + (U1 + U2 + U3) 48 + V 128 + 1,000

In 64-bit mode: S 72 + T + (U1 + U2 + U3) 96 + V 184 + 1,400

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

(u) Formula 21

Data dictionary table name	Formula
SQL_SYSPARAMS

(v) Formula 22

Data dictionary table name	Formula
SQL_PUBLICVIEW_ SAME_USERS

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

(w) Formula 23

Dictionary table name	Formula
SQL_SEQUENCES

a: Page length of data dictionary RDAREAs (bytes)

b: Total number of sequence generator definitions

c: Average length of sequence generator identifiers (bytes)

d: Average length of authorization identifiers (bytes)

e: Average length of sequence generator start values (bytes)

f: Average length of sequence generator maximum values (bytes)

g: Average length of sequence generator minimum values (bytes)

h: Average length of sequence generator increment values (bytes)

i: Average length of RDAREA names (bytes)

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 16.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 16-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 16-6 Variables used in the formulas for obtaining the number of index storage pages

   Table name	Type	Key length#3 (Variable g#1)	Number of key types (Variable c#1)	Average number of key duplicates (Variable d#1)
   SQL_PHYSICAL_FILES	1	8	Number of servers	Average number of HiRDB files in server
   	2	g + 1	Number of RDAREAs	Average number of HiRDB files constituting an RDAREA
   SQL_RDAREAS	3	g + 1	Number of RDAREAs	1
   	4	4
   SQL_TABLES	5	d + e + 2	Total number of tables + 80	1
   	6	4
   SQL_COLUMNS	7	d + e + f + 3	a b	1
   	8	d + e + 6
   	9	4		B
   SQL_INDEXES	10	d + e + 2	a	h a
   	11	d + i + 2	h	1
   	12	4
   SQL_USERS	13	d + 1	Number of authorization identifiers	1
   SQL_RDAREA_ PRIVILEGES	14	d + 1	Number 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
   	15	g + 1	Number of RDAREAs specified in the USER USED BY operand of the database initialization utility (pdinit)	Average number of users for each RDAREA
   SQL_TABLE_PRIVILEGES	16	d + 1	a	y a
   	17	2 d + e + 3	y	1
   SQL_DIV_TABLE	18	d + e + 6	Total number of table partitions	1
   	19	g + 1	Number of unique RDAREAs specified when partitioning table	Average number of tables stored in RDAREAs
   	20	4
   SQL_DIV_TABLE_REGULARSIZE	21	d + e + 6	Total number of table partitions	1
   	22	4	Number of row-partitioned tables	Average number of table partitions
   SQL_INDEX_COLINF	23	d + e + 6	Number of unique tables with index definitions	Average number of columns constituting an index
   	24	d + i + 6	Number of columns constituting an index	1
   SQL_TABLE_STATISTICS	25	d + e + 2	Total number of tables (including dictionary tables)	1
   SQL_COLUMN_STATISTICS	26	d + e + f + 3	h	1
   SQL_INDEX_STATISTICS	27	d + e + 2	Total number of tables for which an index is defined	h a
   	28	d + i + 2	h	1
   SQL_VIEW_TABLE_USAGE	29	d + e + 2	z	1
   	30	d + e + 2	Total number of base tables for which a view is defined	Average number of view definitions for a table
   	31	4	z	1
   SQL_VIEWS	32	d + e + 2	z	1
   	33	4
   SQL_VIEW_DEF	34	d + e + 2	z	1
   	35	10
   SQL_REFERENTIAL_CONSTRAINTS	39	d + e + 2	Total number of referential constraints	1
   	40	d + e + 2	Total number of referencing tables	Average number of referencing tables per table
   	41	d + e + 2	Total number of referenced table	Average number of referenced tables per table
   SQL_EXCEPT	86	d + e + 2	Number of indexes for which an exception value is specified	Number of indexes with an exception value specified for a single table
   	87	d + i + 2		1
   	88	4	Number of unique tables with an index for which an exception value is specified	Number of indexes for which an exception value is specified for a single table
   SQL_DIV_INDEX	36	d + e + 6	Number of row-partitioned indexes number of partitions	Average number of partitions per table
   	37	d + i + 2	Total number of row-partitioned indexes	1
   SQL_DIV_COLUMN	38	d + e + f + 3	Number of LOB column definitions	Average number of partitions per table
   	52	d + e + 9	Number of LOB attribute definitions	1
   SQL_ROUTINES	43	d + MAX (q, 7)	p + 174	1
   	44	d + MAX (t, 18)	u + 65	1
   	45	4	p + 174	1
   	53	d + UDT	Number of abstract data types + 1 (NULL value)	Average number of routines per abstract data type + number of NULL
   SQL_ROUTINE_RESOURCES	46	d + q	p s	Average number of resources used per routine
   	47	d + t
   	48	d + q
   	49	4
   SQL_ROUTINE_PARAMS	50	d + MAX (q, 8)	p r + 347	Average number of parameters per routine
   	51	d + MAX (t, 19)	Number of routines	Average number of parameters per specific name (if less than 3, use 3)
   	106	e + 4 + 2	Number of trigger SQL objects r + 1 (NULL values)	Average number of parameters per specified name (if less that 3, use 3) + number of NULL values
   SQL_DATATYPES	54	d + UDT	Number of abstract data types	1
   	55	4
   	56	d + UDT	Number of abstract data types that have subtypes + 1 (NULL value)	Average number of subtypes per abstract data type + number of NULL values
   SQL_DATATYPE_DESCRIPTORS	57	d + UDT + ATT	NUDT NATT	1
   	58	4	Number of abstract data types	Average number of attributes per abstract data type
   SQL_TABLE_RESOURCES	59	d + e	Total number of tables that use user-defined data types	Average number of user-defined data types used per table
   	60	d + UDT	UDT	Average number of tables used per user-defined data type
   	61	4
   SQL_PLUGINS	62	d + PLG	Number of plug-ins	1
   	63	4
   	64	{(d + UDT) IXT} + 2	Number of data type plug-ins + number of index-type plug-ins
   SQL_PLUGIN_ROUTINES	65	t	NPLG NFPLG	1
   	66	PLG + TMD + 2	Number of operations	Number of plug-ins
   	67	PLG + 4
   	68	POPR + 1
   SQL_PLUGIN_ROUTINE_PARAMS	69	t + PRM	NPLG NPPAR	1
   	70	PLG	NPLG	Average number of parameters per plug-in
   	71	t + 4	NPLG NPPAR	1
   SQL_REGISTRY_CONTEXT	72	CNM + 1	Number of contexts	1
   SQL_REGISTRY_KEY	73	KNM + 6	Number of keys	1
   SQL_INDEX_TYPES	74	d + IXT	Number of index types to be created	1
   	75	4
   SQL_INDEX_RESOURCES	76	d + IXT	Number of plug-in indexes	Average number of index definitions that use index type
   	77	4
   SQL_INDEX_DATATYPE	78	d + e	Number of table definitions for which plug-in index is defined	Average number of plug-in indexes for the same table
   	79	d + i	Number of plug-in indexes	1
   SQL_INDEX_FUNCTION	80	d + e	Number of table definitions for which plug-in index is defined	Average number of plug-in indexes per table average number of functions to which plug-in index is applied
   	81	d + i	Number of plug-in indexes	Average number of functions to be applied per plug-in index
   SQL_TYPE_RESOURCES	82	d + e	Number of user-defined data types that use a user-defined data type	Average number of user-defined data types that are specified as an attribute of a user-defined data type
   	83	d + UDT	Number of user-defined data types	Average number of user-defined data types that use a user-defined data type
   	84	4
   SQL_INDEX_TYPE_FUNCTION	85	d + IXT	Number of index types	Average number of functions to be applied per index
   SQL_TRIGGERS	90	d + e + 2 + 16	Number of triggers	1
   	91	d + TRIG + 2
   	92	d + t + 2
   	93	4
   SQL_TRIGGER_ACTCOND	94	d + TRIG + 2 + 4	Number of triggers with action conditions	1
   	95	d + e + 2	Number of tables that define triggers	Average number of triggers per table
   SQL_TRIGGER_COLUMNS	96	d + TRIG + 2	Number of triggers that use the UPDATE statement as the triggering event	Average column length specified per trigger
   	97	d + e + f + 3	Number of columns specified that use the UPDATE statement as the triggering event	1
   SQL_TRIGGER_DEF_SOURCE	98	d + TRIG + 2 + 4	Number of triggers	1
   	99	d + e + 2	Number of tables defined with triggers	Average number of triggers per table
   SQL_TRIGGER_USAGE	100	d + TRIG + 2	Number of triggers that reference resources while performing the trigger action search condition	Average number of resources referenced per trigger
   	101	d + e + 2	Number of tables that define triggers that reference resources while performing the trigger action search conditions	Average number of resources referenced per table
   	102	d + e + (t or e) + 2	Number of resources used	1
   	103	8
   SQL_PARTKEY	104	d + e + f + 3	Number of matrix partitioning tables number of partitioning keys	1
   SQL_PARTKEY_DIVISION	105	d + e + 6	Number of matrix partitioning tables number of boundary values number of partitioning keys	1
   SQL_AUDITS	107	ETP + EST + 2	Number of monitored events	1
   	108	OTP + OSC + ONM + 3	Number of monitored objects	Average number of events monitored per object
   	109	d	Number of monitored users	Average number of events monitored per user
   SQL_AUDITS_REGULARIZE	110	OTP + OSC + ONM + 3	Number of monitored objects	Average number of events monitored per object
   	111	d	Number of monitored users	Average number of events monitored per user
   SQL_KEYCOLUMN_USAGE	112	d + CNS + 2	Number of constraints	1
   	113	d + e + 2	Number of tables for which constraints have been defined	Average number of constraints per table
   SQL_TABLE_CONSTRAINTS	114	d + CNS + 2	Number of constraints	1
   	115	d + e + 2	Number of tables for which constraints have been defined	Average number of constraints per table
   SQL_CHECKS	116	d + CNS + 2	Number of check constraints	1
   	117	d + e + 2	Number of tables for which check constraints have been defined	Average number of check constraints per table
   SQL_CHECK_COLUMNS	118	d + CNS + 2	Number of check constraints	Average number of columns specified per check constraint
   	119	d + e + f + 3	Number of columns used in the check constraints	Average number of duplicate columns used in check constraints per table
   SQL_SYSPARAMS	121	8	2	1
   SQL_PUBLICVIEW_SAME_USERS	124	d + e + 2	Number of public view tables number of authorization identifiers	1
   SQL_INDEX_XMLINF	125	d + e + 2	NPSIT	Average number of substructure paths making up an index
   	126	d + i + 7	NPSS	1
   SQL_SEQUENCES	127	d + SEQN + 2	Number of sequence generators in system	1
   	128	4	Number of sequence generators in system	1

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 names^#2 (bytes)

u: Total number of specific names^#2

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 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)

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)

NPSIT: Number of tables that define substructure indexes

NPSS: Number of substructure paths making up a substructure index

SEQN: Average length of sequence generator identifiers (bytes)

#1: Variables shown in (2) Variables used in formulas in 16.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:

• key length 4 4