1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

DATA_STORE_TBLSP

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

8

CHAR

Name of the data store

6

DB2_BUFFERPOOL

1

CHAR

Buffer pool assignment:

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

7

VSAM_CAT_NAME

8

CHAR

Name of the VSAM catalog

8

DB2_CLOSE

1

CHAR

Close when not in use?

• Y (Yes)
• N (No)

9

DB2_LOCKSIZE

1

CHAR

Lock size:

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

10

ERASE_OLD_DATA

1

CHAR

Erase old data during Create?

• Y (Yes)
• N (No)

11

UNIT_ALLOC

1

CHAR

Unit for allocation quantity:

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

12

USE_DEFAULT_
PROP

1

CHAR

Use default data set properties:

• Y (Yes)
• N (No)

13

SEGMENT_SIZE

4

INTEGER

Segment size

14

FREE_PAGE_FREQ

4

INTEGER

Free page frequency

15

FREE_SPACE_PCT

4

INTEGER

Free space percentage

16

PRIME_ALLOC

4

INTEGER

Primary allocation quantity

17

SECOND_ALLOC

4

INTEGER

Secondary allocation quantity

18

DATABASE_ID

4

INTEGER

ID of the database. Join with DATA_BASE.

19

STORAGE_GRP_ID

4

INTEGER

ID of the storage group that contains this tablespace.

Join with STORAGE_GROUP.

Zero if the tablespace is not contained by a storage group.