Previous Topic: DB2_MVS_TABLENext Topic: DB2_MVS_TD


DB2_MVS_TABLESPC

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

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of DB2 tablespace

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_TABLESPC

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

CHAR

Name

6

COMPRESS

1

CHAR

Compress?

7

LOCKMAX_SYS

1

CHAR

Lockmax by system?

8

LOCKMAX_VALUE

4

INTEGER

Lockmax value

9

SYSTEM_
TABLESPC

1

CHAR

System tablespace?

10

BUFFERPOOL_
NUM

4

INTEGER

Bufferpool number

11

TABLESPACE_ID

4

INTEGER

Base tablespace this object is extended from.

Join with DATA_STORE_TBLSP.