Previous Topic: DATACOM _TDNext Topic: DATASET_TBLSP


DATASET_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

DATASET_INDEX

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

VSAM_CAT_NAME

8

CHAR

Name of the VSAM catalog

6

FREE_PAGE_FREQ

4

INTEGER

Free page frequency

7

FREE_SPACE_PCT

4

INTEGER

Free space percentage

8

PRIME_ALLOC

4

INTEGER

Primary allocation quantity

9

SECOND_ALLOC

4

INTEGER

Secondary allocation quantity

10

UNIT_ALLOC

1

CHAR

Unit for allocation quantity:

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

11

ERASE_OLD_DATA

1

CHAR

Erase old data during Create?

  • Y (Yes)
  • N (No)

12

USE_DEFAULT_
PROP

1

CHAR

Use default data set properties?

  • Y (Yes)
  • N (No)

13

PART_NUMBER

4

INTEGER

Data set number for DB2 partitioning

14

SEQ

2

SMALLINT

Sequence within data store

15

DATA_STORE_ID

4

INTEGER

ID of the containing data store.

Join with DATA_STORE_INDEX.

16

STORAGE_GRP_ID

4

INTEGER

ID of the storage group that holds this indexspace data set.

Join with STORAGE_GROUP.

Zero if the data set is not held by a storage group.