Previous Topic: Storage GroupsNext Topic: Tablespaces


Databases

The database name must be unique within the model. The following table describes the content of each field type:

Field Name

Content

MODEL_NAME

Host Encyclopedia name of the model

RECORD_TYPE

O (Object Record)

OBJECT_TYPE

DATA_BASE

OBJECT_NAME

Name of the database

REF_OBJ_1

Name of the storage group that is used as a default for the database (Optional)

REF_OBJ_2

Unused

REF_OBJ_3

Unused

NUM_PROP_1

Unused

NUM_PROP_2

Unused

NUM_PROP_3

Unused

NUM_PROP_4

Unused

NUM_PROP_5

Unused

NUM_PROP_6

Unused

NUM_PROP_7

Unused

NUM_PROP_8

Unused

CHAR_PROP_1

Default bufferpool:

0 (BP0)

1 (BP1)

2 (BP2)

K (BP32K)

CHAR_PROP_2

Unused

CHAR_PROP_3

Unused

CHAR_PROP_4

Unused

CHAR_PROP_5

Unused

CHAR_PROP_6

Unused

CHAR_PROP_7

Unused

CHAR_PROP_8

Unused

NAME_1

Unused

NAME_2

Unused