Previous Topic: OS2_UNIX_TB_INDEX (OS/2 UNIX Technical Design Tablespace for Long Columns)Next Topic: OS2_UNIX_TEMP_CAT (OS/2 UNIX Database Temporary Catalog)


OS2_UNIX_TD (Technical Design OS/2 UNIX Extension)

Column Name

Coltype

Description

MODEL_ID

NUMERIC

ID of the containing model

TBNAME

STRING

OS2_UNIX_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?

MANAGED_BY

CHAR

Managed by system/database

TYPE_OS2

STRING

Storage location type for OS/2

SIZE_OS2

NUMERIC

Storage location size for OS/2

TYPE_UNIX

STRING

Storage location type for UNIX

SIZE_UNIX

NUMERIC

Storage location size for UNIX

EXTENT_UNIX

NUMERIC

Extend size

PREFETCH_SIZE

NUMERIC

Prefetch size

OVERHEAD_STRG

STRING

Overhead

TRANSFER_RATE

STRING

Transfer rate

DATA_CAPTURE

CHAR

Data capture?

TECH_DSN_ID

NUMERIC

Base technical design this object is extended from.

Join with TECHNICAL_DESIGN.