MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

DB2_MVS_TD

ID

NUMERIC

Unique identifier

ORG_ENCY_ID

NUMERIC

Original encyclopedia identifier

ORG_ID

NUMERIC

Original object identifier

OWNER_ID

STRING

Owner identifier

DFLT_DBNAME

STRING

Default DB Name

RI_ENFRCMNT

CHAR

Referential integrity enforcement

RES_WORD_CHK

CHAR

Reserved word check?

DBMS_REL_VER

CHAR

DBMS release version

PV_READ_ENF

CHAR

Permitted value READ enforcement

PV_DBMS_ENF

CHAR

Permitted value DBMS enforcement

DEF_VALUE_ENF

CHAR

Default value enforced?

NULL_OR_DEF

CHAR

Create NULL or default value?

GEN_ODBC_INT

CHAR

Generate ODBC interface?

AVAILABILITY

CHAR

None/Owner/Read availability

COMPRESS

CHAR

Compress tablespace?

LOCKMAX_VAL

NUMERIC

Lockmax value

LOCKMAX_SYS

CHAR

Lockmax by system?

DATA_CAPTURE

CHAR

Data capture?

RESTRICT_DROP

CHAR

With restrict on drop?

DEFER_IDX_BLD

CHAR

Defer index build?

INDEX_TYPE

CHAR

Index Type

QUALIFY_TABLE

CHAR

Qualify table references?

ASIS_FLAG

CHAR

ASIS naming flag on TD properties

ALLOWS_TABLES

CHAR

Database allows tables in system

BUFFERPOOL_DB

NUMERIC

Bufferpool number database default

BUFFERPOOL_IN

NUMERIC

Bufferpool number indexspace default

BUFFERPOOL_TB

NUMERIC

Bufferpool number tablespace default

REC_DEF_TSPC

CHAR

Record default tablespace

TECH_DSN_ID

NUMERIC

Base technical design this object is extended from.

Join with TECHNICAL_DESIGN.