1

ID

4

INTEGER

ID of DB2 technical design

2

MODEL_ID

4

INTEGER

ID of the containing model

3

TBNAME

16

CHAR

DB2_MVS_TD

4

ORG_ID

4

INTEGER

Original object identifier

5

OWNER_ID

8

CHAR

Owner identifier

6

DFLT_DBNAME

32

CHAR

Default DB name

7

RI_
ENFORCEMENT

1

CHAR

Referential integrity enforcement

8

RES_WORD_CHK

1

CHAR

Reserved work check?

9

DBMS_REL_VER

1

CHAR

DBMS release version

10

PV_READ_ENF

1

CHAR

Permitted value READ enforcement

11

PV_DBMS_ENF

1

CHAR

Permitted value DBMS enforcement

12

DEF_VALUE_ENF

1

CHAR

Default value enforced?

13

NULL_OR_DEF

1

CHAR

Create NULL or default value?

14

GEN_ODBC_INT

1

CHAR

Generate ODBC interface?

15

AVAILABILITY

1

CHAR

None/Owner/Read availability

16

COMPRESS_TBS

1

CHAR

Compress tablespace?

17

LOCKMAX_VAL

4

INTEGER

Lockmax value

18

LOCKMAX_SYS

1

CHAR

Lockmax by systerm?

19

DATA_CAPTURE

1

CHAR

Data capture?

20

RESTRICT_DROP

1

CHAR

With restrict on drop?

21

DEFER_IDX_BLD

1

CHAR

Defer index build?

22

INDEX_TYPE

1

CHAR

Index type

23

QUALIFY_TABLE

1

CHAR

Qualify table references?

24

ASIS_FLAG

1

CHAR

ASIS naming flag on TD properties

25

ALLOWS_TABLES

1

CHAR

Database allows tables in system

26

BUFFERPOOL_DB

4

INTEGER

Bufferpool number database default

27

BUFFERPOOL_IN

4

INTEGER

Bufferpool number indexspace default

28

BUFFERPOOL_TB

4

INTEGER

Bufferpool number tablespace default

29

REC_DEF_TSPC

8

CHAR

Record default tablespace

30

TECH_DSN_ID

4

INTEGER

Base technical design this object is extended from. Join with TECHNICAL_DESIGN.