Previous Topic: DATA_STORE_INDEX (Indexspace)Next Topic: DATA_STORE_TBLSP (Tablespace)


DATA_STORE_TBL_I (Tablespace)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

DATA_STORE_TBL_I

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

DB2_BUFFERPOOL

CHARACTER

Buffer pool assignment:

  • 0-BP0
  • 1-BP1
  • 2-BP2
  • K-BP32K

DB2_CLOSE

CHARACTER

Close when not in use?

  • Y-Yes
  • N-No

DB2_LOCKSIZE

CHARACTER

Lock size:

  • P-Page
  • A-Any
  • T-Table

ERASE_OLD_DATA

CHARACTER

Erase old data during Create?

  • Y-Yes
  • N-No

UNIT_ALLOC

CHARACTER

Unit for allocation quantity:

  • C-Cyl
  • T-Trk
  • R-Rec
  • K-Kbytes

USE_DEFAULT_PROP

CHARACTER

Use default data set properties?

  • Y-Yes
  • N-No

SEGMENT_SIZE

NUMERIC

Segment size

FREE_PAGE_FREQ

NUMERIC

Free page frequency

FREE_SPACE_PCT

NUMERIC

Free space percentage

PRIME_ALLOC

NUMERIC

Primary allocation quantity

SECOND_ALLOC

NUMERIC

Secondary allocation quantity

DATABASE_ID

NUMERIC

ID of the database.

Join with DATA_BASE.