1

MODEL_ID

4

INTEGER

ID of the containing model

2

TBNAME

16

CHAR

DATA_BASE

3

ID

4

INTEGER

Unique identifier

4

ORG_ID

4

INTEGER

Original object identifier

5

NAME

32

VARCHAR

Name of the database

6

DBMS

1

CHAR

Database management system:

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

7

TYPE

1

CHAR

Type of database:

• P (Physical)
• L (Logical)

8

DFLT_
BUFFERPOOL

1

CHAR

Default bufferpool

9

DEF_STG_GRP_
ID

4

INTEGER

ID of storage group that is used as default for this database.

Join with STORAGE_GROUP.

Zero if default storage group does not exist.