Previous Topic: DB2_DDL_TABLENext Topic: DB2_DEF_CLUSTER


DB2_DDL_TBLSP

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

Col

Column Name

Len

Coltype

Description

1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

DB2_DDL_TBLSP

3

ID

4

CHAR

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

MEMBER_NAME

8

CHAR

Name of member containing generated DDL for DB2 tablespace definition

6

DATE_GENERATED

4

INTEGER

Generation date

7

TIME_GENERATED

4

INTEGER

Generation time

8

GEN_BY_USER

8

CHAR

Generated by user ID

9

DATA_STR_TBSP_
ID

4

INTEGER

ID of the data storage tablespace with which this DB2 tablespace is built.

Join with DATA_STORE_TBLSP.