5.11 Estimating the size of the dictionary DB area

Use the following formula to determine the dictionary DB area size.

Formula (kilobytes)

Explanation of variables

ADBDICSIZE_INIT

Size of the dictionary DB area determined by the database size

Use the following formula to determine this value.

Formula (kilobytes)

USERSCM

Number of user-defined schemas

USERTBL

Number of user-defined base tables

The value of the variable USERTBL includes the number of archivable multi-chunk tables.

USERIDX

Number of user-defined indexes

USERVIEW

Number of user-defined viewed tables

DBAREANUM

Number of DB areas

USERNUM

Number of HADB users created using the CREATE USER statement + 1

1 indicates the HADB user that was created during execution of the adbinit command.

USERFKEYNUM

Number of foreign keys defined by the HADB user

USERARCHIVE

Number of archivable multi-chunk tables

ADBDICSIZE_OPERATION

Size of the dictionary DB area determined according to database operation

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_USER

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_USER = 4 x CREATE_USER_EXEC_NUM

CREATE_USER_EXEC_NUM

Substitute the number of times the CREATE USER statement is executed.

CREATE_SCHEMA

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_SCHEMA = 4 x CREATE_SCHEMA_EXEC_NUM

CREATE_SCHEMA_EXEC_NUM

Substitute the number of times the CREATE SCHEMA statement is executed.

CREATE_TABLE

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_TABLE = 596 x CREATE_TABLE_EXEC_NUM

CREATE_TABLE_EXEC_NUM

Substitute the number of times the CREATE TABLE statement is executed.

CREATE_VIEW

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_VIEW = 742 x CREATE_VIEW_EXEC_NUM

CREATE_VIEW_EXEC_NUM

Substitute the number of times the CREATE VIEW statement is executed.

CREATE_INDEX

Use the following formula to determine this value.

Formula (kilobytes)

CREATE_INDEX = 24 x CREATE_INDEX_EXEC_NUM

CREATE_INDEX_EXEC_NUM

Substitute the number of times the CREATE INDEX statement is executed.

CREATE_AUDIT

Use the following formula to determine the value:

Formula (kilobytes)

CREATE_AUDIT = 472 × CREATE_AUDIT_EXEC_NUM

CREATE_AUDIT_EXEC_NUM

Substitute the number of times the CREATE AUDIT statement is executed.

GRANT

Use the following formula to determine this value.

Formula (kilobytes)

GRANT = 656 x GRANT_EXEC_NUM

GRANT_EXEC_NUM

Substitute the number of times the GRANT statement is executed.

ALTER_USER

Use the following formula to determine this value.

Formula (kilobytes)

ALTER_USER = 4 x ALTER_USER_EXEC_NUM

ALTER_USER_EXEC_NUM

Substitute the number of times the ALTER USER statement is executed.

ALTER_TABLE

Use the following formula to determine this value.

Formula (kilobytes)

ADD_COLUMN

Use the following formula to determine this value.

Formula (kilobytes)

ADD_COLUMN = 36 x ADD_COLUMN_EXEC_NUM

ADD_COLUMN_EXEC_NUM

Substitute the number of times the ALTER TABLE statement is used to add a column to a table.

RENAME_COLUMN

Use the following formula to determine this value.

Formula (kilobytes)

RENAME_COLUMN = 76 x RENAME_COLUMN_EXEC_NUM

RENAME_COLUMN_EXEC_NUM

Substitute the number of times the ALTER TABLE statement is used to rename a table column.

CHANGE_CHUNK_MAX

Use the following formula to determine this value.

Formula (kilobytes)

CHANGE_CHUNK_MAX = 4 x CHANGE_CHUNK_MAX_EXEC_NUM

CHANGE_CHUNK_MAX_EXEC_NUM

Substitute the number of times the ALTER TABLE statement is used to change the maximum number of chunks in a multi-chunk table.

CHANGE_CHUNK_ARCHIVE

Use the following formula to determine this value.

Formula (kilobytes)

CHANGE_CHUNK_ARCHIVE = 84 x CHANGE_CHUNK_ARCHIVE_EXEC_NUM

CHANGE_CHUNK_ARCHIVE_EXEC_NUM

Substitute the number of times the ALTER TABLE statement is used to change a regular multi-chunk table to an archivable multi-chunk table.

CHANGE_CHUNK_UNARCHIVE

Use the following formula to determine this value.

Formula (kilobytes)

CHANGE_CHUNK_UNARCHIVE = 48 x CHANGE_CHUNK_UNARCHIVE_EXEC_NUM

CHANGE_CHUNK_UNARCHIVE_EXEC_NUM

Substitute the number of times the ALTER TABLE statement is used to change an archivable multi-chunk table to a regular multi-chunk table.

ALTER_VIEW

Use the following formula to determine this value.

Formula (kilobytes)

ALTER_VIEW = 678 x ALTER_VIEW_EXEC_NUM

ALTER_VIEW_EXEC_NUM

Substitute the number of times the ALTER VIEW statement is executed.

DROP_USER

Use the following formula to determine this value.

Formula (kilobytes)

DROP_USER = 1,992 x DROP_USER_EXEC_NUM

DROP_USER_EXEC_NUM

Substitute the number of times the DROP USER statement is executed.

DROP_SCHEMA

Use the following formula to determine this value.

Formula (kilobytes)

DROP_SCHEMA = 1,992 x DROP_SCHEMA_EXEC_NUM

DROP_SCHEMA_EXEC_NUM

Substitute the number of times the DROP SCHEMA statement is executed.

DROP_TABLE

Use the following formula to determine this value.

Formula (kilobytes)

DROP_TABLE = 204 x DROP_TABLE_EXEC_NUM

DROP_TABLE_EXEC_NUM

Substitute the number of times the DROP TABLE statement is executed.

DROP_VIEW

Use the following formula to determine this value.

Formula (kilobytes)

DROP_VIEW = 36 x DROP_VIEW_EXEC_NUM

DROP_VIEW_EXEC_NUM

Substitute the number of times the DROP VIEW statement is executed.

DROP_INDEX

Use the following formula to determine this value.

Formula (kilobytes)

DROP_INDEX = 8 x DROP_INDEX_EXEC_NUM

DROP_INDEX_EXEC_NUM

Substitute the number of times the DROP INDEX statement is executed.

REVOKE

Use the following formula to determine this value.

Formula (kilobytes)

REVOKE = 1,992 x REVOKE_EXEC_NUM

REVOKE_EXEC_NUM

Substitute the number of times the REVOKE statement is executed.

A single dictionary DB area file (file name: ADBDIC), which constitutes the dictionary DB area, is created using a regular file under the DB directory. It can also be created using a block special file that is not under the DB directory.

To Page Top