Previous Topic: DatabasesNext Topic: Indexspaces


Tablespaces

Consider the following rules:

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

TABLE_SPACE

OBJECT_NAME

Name of the data store tablespace

REF_OBJ_1

Name of database that the tablespace is grouped by.

REF_OBJ_2

Name of storage group that contains the tablespace (Optional)

REF_OBJ_3

Name of VSAM catalog

NUM_PROP_1

Segment size

NUM_PROP_2

Free page frequency

NUM_PROP_3

Free space percentage

NUM_PROP_4

Primary allocation quantity

NUM_PROP_5

Secondary allocation quantity

NUM_PROP_6

Unused

NUM_PROP_7

Unused

NUM_PROP_8

Unused

CHAR_PROP_1

Bufferpool assignment:

  • 0 (BP0)
  • 1 (BP1)
  • 2 (BP2)
  • K (BP32K)

CHAR_PROP_2

Close when not in use?

  • Y (Yes)
  • N (No)

CHAR_PROP_3

Lock size:

  • P (Page)
  • A (Any)
  • T (Table)

CHAR_PROP_4

Erase old data during Create:

  • Y (Yes)
  • N (No)

CHAR_PROP_5

Unit for allocation:

  • C (Cyl)
  • T (Trk)
  • R (Rec)
  • K (Kbytes)

CHAR_PROP_6

Use default data set properties?

  • Y (Yes)
  • N (No)

CHAR_PROP_7

Unused

CHAR_PROP_8

Unused

NAME_1

Password

NAME_2

Unused