| Nome da coluna |
Tipo do dado |
Descrição |
Uso |
| NAME |
CHAR(8) NOT NULL |
Database name. |
G |
| CREATOR |
CHAR(8) NOT NULL |
Authorization ID of the owner of the database. |
G |
| STGROUP |
CHAR(8) NOT NULL |
Name of the default storage group of the database; blank for a system database. |
G |
| BPOOL |
CHAR(8) NOT NULL |
Name of the default buffer pool of the database; blank for a system database. |
G |
| DBID |
SMALLINT NOT NULL |
Internal identifier of the database. |
G |
| IBMREQD |
CHAR(1) NOT NULL |
Whether the row came from the basic machine-readable material (MRM) tape:
N No
Y Yes
E V2R3 dependency indicator; not from MRM tape
G V4 dependency indicator; not from MRM tape |
G |
| CREATEDBY |
CHAR(8) NOT NULL
WITH DEFAULT |
Primary authorization ID of the user who created the database. |
G |
| ROSHARE |
CHAR(1) NOT NULL
WITH DEFAULT |
Whether this database is shared, through shared read-only data,
with other DB2 subsystems. Value can be:
blank Not shared
O Shared. Local DB2 subsystem is the owner.
R Shared. Local DB2 subsystem is a read-only user. |
G |
| TIMESTAMP |
TIMESTAMP NOT NULL
WITH DEFAULT |
The time the database became shared on the owning system the database is not
shared, the value is 0001-01-01-00.00.00.000000 |
G |
| TYPE |
CHAR(1) NOT NULL
WITH DEFAULT |
Type of database.
blank Database is not a work file database.
W
Database is a work file database. The database is DSNDB07 or it was created
with the WORKFILE clause and used as a work file database by a member of a
DB2 data sharing group. |
G |
| GROUP_MEMBER |
CHAR(8) NOT NULL
WITH DEFAULT |
The DB2 data sharing member name of the DB2 subsystem that uses this work file
database. This column is blank if the work file database was not created in a DB2 data
sharing environment, or if The database is not a work file database as indicated by the
TYPE COLUMN. |
G |
| CREATEDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the CREATE statement was executed for the database. For DSNDB04 and
DSNDB06, the value is '1985-04-01.00.00.00.000000'. |
G |
| ALTEREDTS |
TIMESTAMP NOT NULL
WITH DEFAULT |
Time when the most recent ALTER DATABASE statement was applied. If no ALTER
DATABASE statement has been applied, ALTEREDTS has the value of CREATEDTS. |
G |
| ENCODING_SCHEME |
CHAR(1) NOT NULL
WITH DEFAULT 'E' |
Default encoding scheme for the database.
E EBCDIC
A ASCII
blank For DSNDB04 and work file databases. |
G |
| SBCS_CCSID |
INTEGER NOT NULL
WITH DEFAULT |
Default SBCS CCSID for the database. For databases created in a DB2 release prior to
Version 5, the value is 0. |
G |
| DBCS_CCSID |
INTEGER NOT NULL
WITH DEFAULT |
Default DBCS CCSID for the database. For databases created in a DB2 release prior to
Version 5, the value is 0. |
G |
| MIXED_CCSID |
INTEGER NOT NULL
WITH DEFAULT |
Default mixed CCSID for the database. For databases created in a DB2 release prior to
Version 5, the value is 0.
|
G |
