Previous Topic: DATA_CLUSTERNext Topic: DATA_STORE_TBLSP


DATA_STORE_INDEX

The following table details various column names along with their descriptions.

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

DATA_STORE_INDEX

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_SUBPAGES

1

CHAR

Number of subpages per page, 1, 2, 4, 8, S - 16

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

FREE_PAGE_FREQ

4

INTEGER

Free page frequency

14

FREE_SPACE_PCT

4

INTEGER

Free space percentage

15

PRIME_ALLOC

4

INTEGER

Primary allocation quantity

16

SECOND_ALLOC

4

INTEGER

Secondary allocation quantity

17

DATABASE_ID

4

INTEGER

ID of the database. Join with DATA_BASE.

18

STORAGE_GRP_ID

4

INTEGER

ID of the storage group that contains the indexspace.

Join with STORAGE_GROUP.

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