Previous Topic: SYSTEM.CONSTRAINTNext Topic: SYSTEM.DBSEGMENT


SYSTEM.DBNAME

Description

DBNAME contains information about an entry in a database name table.

Column name

Column description

Data type

Null specifi- cation

DBTABLE

Name of database name table.

CHAR(8)

NOT NULL

NAME

Database name entry in the database name table. If this column contains *DEFAULT, the row represents the default subschema mapping for the database name table.

CHAR(8)

NOT NULL

DMCL

Reserved for future use.

CHAR(8)

NOT NULL

NODE

Reserved for future use.

CHAR(8)

NOT NULL

LOADLIST

Reserved for future use.

CHAR(8)

NOT NULL

FLAG

Database name flag:

  • X'80'—Match on subschema name is required
  • X'40'—Mixed Page Groups are allowed
  • X'20'—Mixed Page Groups Verify is ON
  • X'01'—DB Group Name

BINARY(1)

NOT NULL

CTIME

Date and time when the database name was created.

TIMESTAMP

NOT NULL

UTIME

Date and time when the database name was last updated.

TIMESTAMP

NOT NULL

CUSER

ID of the user who created the database name.

CHAR(18)

NOT NULL

UUSER

ID of the user who last updated the database name.

CHAR(18)

NOT NULL

GROUPFLAG

DB Group flag:

  • E—Enabled at startup
  • D—Disabled at startup

CHAR(1)

NOT NULL

NUMSEGMENTS

Number of segments associated with the database name.

SMALLINT

NOT NULL

NUMSUBSCHEMAS

Number of subschemas associated with the database name.

SMALLINT

NOT NULL

USAGEFLAG

Indicates general use or utility use only. x'80' DBName for utility use only.

BINARY(1)

NOT NULL

FILLER

Reserved for future use.

BINARY(17)

NOT NULL