Previous Topic: DB2_MVS_CONSTRNTNext Topic: DB2_MVS_INDEX


DB2_MVS_DATABASE

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

Col

Column Name

Len

Coltype

Description

1

ID

4

INTEGER

ID of DB2 constraint

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_DATABASE

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

CHAR

Name

6

OWNER_IDENTIFIER

8

CHAR

Owner identifier

7

ROSHARE

1

CHAR

None/Owner/Read availability

8

DB_ALLOWS_
TABLES

1

CHAR

Database allows tables in system

9

BUFFERPOOL_NUM

4

INTEGER

Bufferpool number

10

DATABASE_ID

4

INTEGER

Base database this object is extended from.

Join with DATA_BASE.