1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

TECHNICAL_DESIGN

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the technical design

6

OWNER_NAME

8

CHAR

DB2 owner identifier

7

VSAM_CAT_NAME

8

CHAR

Name of the VSAM catalog

8

DBMS

1

CHAR

Database management system:

• 2 (DB2 z/OS)
• A (Datacom)
• B (ODBC/ADO.NET)
• C (MS/SQL)
• E (DB2 UDB)
• H (NONE)
• J (JDBC)
• O (Oracle)

9

RESERVED_WORD

1

CHAR

Reserved word check?

• Y (Yes)
• N (No)

10

REF_INTEGRITY

1

CHAR

Referential Integrity Default enforcement:

• D (DB2)
• I (System)

11

STG_VSAM_DEF

1

CHAR

Storage group/VSAM default:

• S (Storage group)
• V (VSAM)

12

DEF_STG_DB_ID

4

INTEGER

ID of the default storage group for databases.

Join with STORAGE_GROUP (zero if ID does not exist).

13

DEF_STG_TBLSP_
ID

4

INTEGER

ID of the default storage group for tablespaces (zero if ID does not exist).

14

DEF_STG_INDEX_
ID

4

INTEGER

ID of the default storage group for indexspaces (zero if ID does not exist).