Previous Topic: DB2_MVS_INDEXNext Topic: DB2_MVS_TABLE


DB2_MVS_INDEXSPC

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

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of DB2 indexspace

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_INDEXSPC

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

CHAR

Name

6

DEFER_BUILD

1

CHAR

Defer index build?

7

INDEX_TYPE

1

CHAR

Index type

8

NOT_NULL_UNIQ

1

CHAR

Unique where not null?

9

BUFFERPOOL_NUM

4

INTEGER

Bufferpool number

10

INDEXSPACE_ID

4

INTEGER

Base indexspace this object is extended from.

Join with DATA_STORE_INDEX.